Nutcracker (web version): Local Install

smeighan

Dedicated elf
Joined
Jan 19, 2012
Messages
1,109
Location
4217 Greenfinch Dr CO 80126
Here are the steps to install Nutcracker on your local Windows 7 or Windows XP box
1) Download Wampp. http://www.wampserver.com/en/
2) Take all defaults for installation
3) Start Wamp. Click on the Pink W icon.
4) Test Wamp by setting your browser to http://localhost

if it is working, you will see the WAMP home page.Apache server uses port 80. If you have Skype or microsoft HTTP/2.0 they also use port 80.Here is a web page that describes how to fix this conflict. http://blog.techsoft...ions.net/?p=315For Wamp; the httpd.conf file is located in c:\wamp\bin\apache\apache2.2.22\conf directory

5) You now need to get a copy of the current Nutcracker code tree. Go tohttp://smeighan.github.com/nutcracker/ and download the zip file. This file is updated daily with the latest Nutcracker code tree and with the latest export from meighan.net/nutcracker database

Unzip this file into c:\wamp\www\nutcracker
This zip file also now contains gnuplot so you dont need to install it separately.

6) Add gnuplot into Windows PATH environment variable.I found a much better tool to do this and i have included the tool in the nutcracker zip fileRun c:\wamp\www\nutcracker\gnuplot\bin\PathEditor.exe as administrator
Add c:\wamp\www\nutcracker\gnuplot\bin

7) When you get Localhost working, install the database.Http://localhost/nutcracker/install.php in a browser window
This command will do the following
a) Drop all the tables from your existing nutcracker database
b) create the nutcracker database if it is missing
c) create the nutcracker user: nc_user
d) execute sql/nutcrackertables.sql to create all nutcracker tablese) execute sql/nutcrackerdata.sql to create 50,000 rows of data

MaterDaddy wrote this script for me, Thanks!!

Your local nutcracker should be ready
login in as http://localhost/nutcracker
same login and password as you have always used.
For future code releases, you just do step (5) above. Just unzip the file on top of your local nutcracker directory. This step is only a few seconds.

In the future, we will make a button to download and install the zip file for you. This prob wont happen this season as we work on the real guts of Nutcracker

a) Projects , soon a single button that generates and entire 3 minute song and creates the sequencer file for you
b) Single strand effects (eaves, windows, arches). Model generator released yesteday, effects coming this week
c) Local Install, released yesterday
d) Horizontal matrix. It is Next up after single strand effects
e) 20 open bugs/enhancements


thanks
 

smeighan

Dedicated elf
Joined
Jan 19, 2012
Messages
1,109
Location
4217 Greenfinch Dr CO 80126
lithgowlights said:
Step 6 - Make sure you run as administrator as otherwise you may not be able to save the registry entry.
Step 7 - I think http://localhost/install.php should be http://localhost/nutcracker/install.php
Otherwise I think its worked so far :)
You are correct on both accounts.


I would be curious of people's experience in timing.


Meighan.net takes 33 secs


Local host take 23 secs


For example
 

twinkleclaus

New elf
Joined
Jan 6, 2011
Messages
44
Might I suggest removing the entries from the 'members' table and instead resort to people creating their own local account? I randomly picked about a dozen users from the local install 'members' table and easily found a reserve of the MD5 hash for the passwords. Some of the passwords may be likely to be re-used elsewhere for other accounts (like email, banks, forums, etc). Distributing a database containing usernames and passwords is what gets others excited in the news.
 

smeighan

Dedicated elf
Joined
Jan 19, 2012
Messages
1,109
Location
4217 Greenfinch Dr CO 80126
twinkleclaus said:
Might I suggest removing the entries from the 'members' table and instead resort to people creating their own local account? I randomly picked about a dozen users from the local install 'members' table and easily found a reserve of the MD5 hash for the passwords. Some of the passwords may be likely to be re-used elsewhere for other accounts (like email, banks, forums, etc). Distributing a database containing usernames and passwords is what gets others excited in the news.


I need the member id to be the same between meighan.net and the local host so that things like the gallery will work.,


What i can do is set all of the md5 passwords to "welcome" before i export the members table. and just tell local host users you log in to your account with "welcome"/.
 

smeighan

Dedicated elf
Joined
Jan 19, 2012
Messages
1,109
Location
4217 Greenfinch Dr CO 80126
mokeefe said:
Sean,


If we already have a local install of Nutcracker working and download the latest zip (1.0-124) can we just copy over the new files? Do we have to do anything to update the DB with your new tables?


-Mike


Hi Mike, excellent question


After you have wamp installed, you never need to repeat steps 1-4.


For these massive changes please do steps (5) and (7).




5) You now need to get a copy of the current Nutcracker code tree. Go to
http://smeighan.github.com/nutcracker/ and download the zip file. This file is updated daily with the latest Nutcracker code tree and with the latest export from meighan.net/nutcracker database
Unzip this file into c:\wamp\www\nutcracker. If you already have a nutcracker directory, just overwrite everything there.
This zip file also now contains gnuplot so you dont need to install it separately.




7) When you get Localhost working, install the database.
http://Http://localhost/nutcracker/install.php in a browser window
This command will do the following
a) Drop all the tables from your existing nutcracker database
b) create the nutcracker database if it is missing
c) create the nutcracker user: nc_user
d) execute sql/nutcrackertables.sql to create all nutcracker tables
e) execute sql/nutcrackerdata.sql to create 50,000 rows of data
MaterDaddy wrote this script for me, Thanks!!



So for step 7, you will see this


2012-09-13_0843.png



Modify nothing and just click submit.


You should then see this




2012-09-13_0857.png



Be sure to get a fresh zip file as i just added some more stuff.


thanks
mokeefe said:
Sean,


If we already have a local install of Nutcracker working and download the latest zip (1.0-124) can we just copy over the new files? Do we have to do anything to update the DB with your new tables?


-Mike


Hi Mike, excellent question


After you have wamp installed, you never need to repeat steps 1-4.


For these massive changes please dp steps (5) amd ((7).




5) You now need to get a copy of the current Nutcracker code tree. Go to
http://smeighan.github.com/nutcracker/ and download the zip file. This file is updated daily with the latest Nutcracker code tree and with the latest export from meighan.net/nutcracker database
Unzip this file into c:\wamp\www\nutcracker. If you already have a nutcracker directory, just overwrite everything there.
This zip file also now contains gnuplot so you dont need to install it separately.




7) When you get Localhost working, install the database.
http://Http://localhost/nutcracker/install.php in a browser window
This command will do the following
a) Drop all the tables from your existing nutcracker database
b) create the nutcracker database if it is missing
c) create the nutcracker user: nc_user
d) execute sql/nutcrackertables.sql to create all nutcracker tables
e) execute sql/nutcrackerdata.sql to create 50,000 rows of data
MaterDaddy wrote this script for me, Thanks!!



So for step 7, you will see this


2012-09-13_0843.png



Modify nothing and just click submit.


You should then see this




2012-09-13_0857.png



Be sure to get a fresh zip file as i just added some more stuff.


thanks
 

smeighan

Dedicated elf
Joined
Jan 19, 2012
Messages
1,109
Location
4217 Greenfinch Dr CO 80126
corrected bug that would not export data to the sequencers.


download a new zip file and redo step (5). This is what you do anytime i release new code. You DO NOT need to delete your database (Step #7).




5) You now need to get a copy of the current Nutcracker code tree. Go to
http://smeighan.github.com/nutcracker/ and download the zip file. This file is updated daily with the latest Nutcracker code tree and with the latest export from meighan.net/nutcracker database
Unzip this file , open it and copy the contents of the nutcracker directory. Next go to your c:\wamp\www\nutcracker and paste over it with a ctl-v. In other words replace the c existing code tree with what you just downloaded.
 

joeengler

Apprentice elf
Joined
May 20, 2010
Messages
90
Location
Garden City, MI 48135
smeighan said:
Here are the steps to install Nutcracker on your local Windows 7 or Windows XP box
1) Download Wampp. http://www.wampserver.com/en/
2) Take all defaults for installation
3) Start Wamp. Click on the Pink W icon.
4) Test Wamp by setting your browser to http://localhost

if it is working, you will see the WAMP home page.Apache server uses port 80. If you have Skype or microsoft HTTP/2.0 they also use port 80.Here is a web page that describes how to fix this conflict. http://blog.techsoft...ions.net/?p=315For Wamp; the httpd.conf file is located in c:\wamp\bin\apache\apache2.2.22\conf directory

5) You now need to get a copy of the current Nutcracker code tree. Go tohttp://smeighan.github.com/nutcracker/ and download the zip file. This file is updated daily with the latest Nutcracker code tree and with the latest export from meighan.net/nutcracker database

Unzip this file into c:\wamp\www\nutcracker
This zip file also now contains gnuplot so you dont need to install it separately.

6) Add gnuplot into Windows PATH environment variable.I found a much better tool to do this and i have included the tool in the nutcracker zip fileRun c:\wamp\www\nutcracker\gnuplot\bin\PathEditor.exe as administrator
Add c:\wamp\www\nutcracker\gnuplot\bin

7) When you get Localhost working, install the database.http://localhost/nutcracker/install.php in a browser window
This command will do the following
a) Drop all the tables from your existing nutcracker database
b) create the nutcracker database if it is missing
c) create the nutcracker user: nc_user
d) execute sql/nutcrackertables.sql to create all nutcracker tablese) execute sql/nutcrackerdata.sql to create 50,000 rows of data

MaterDaddy wrote this script for me, Thanks!!

Your local nutcracker should be ready
login in as http://localhost/nutcracker
same login and password as you have always used.
For future code releases, you just do step (5) above. Just unzip the file on top of your local nutcracker directory. This step is only a few seconds.

In the future, we will make a button to download and install the zip file for you. This prob wont happen this season as we work on the real guts of Nutcracker

a) Projects , soon a single button that generates and entire 3 minute song and creates the sequencer file for you
b) Single strand effects (eaves, windows, arches). Model generator released yesteday, effects coming this week
c) Local Install, released yesterday
d) Horizontal matrix. It is Next up after single strand effects
e) 20 open bugs/enhancements


thanks
Well I had a major computer crash and had to rebuild my PC, after reinstalling the local I get this error when running the install scriptNutcracker Install Script Installing NutcrackerConnecting to MySQL...OK
Creating nutcracker database...OK
Giving nutcracker database user permissions...OK
Selecting our new database to populate...OK
Creating nutcracker database schema...OK
OK
Populating nutcracker database data...FAILED!
Could not populate database.
MySQL Error: -- -- Dumping data for table `project` -- -- -- Dumping data for table `project_model` -- -- -- Dumping data for table `song` -- INSERT INTO `song` (`song_id`, `active_set`, `song_name`, `artist`, `song_url`, `last_updated`, `audacity_aup`, `music_mo_file`) VALUES (1, 'N', 'Chistmas Sarajevo', 'TSO ', 'http://www.amazon.com/Christmas-Sarajevo-12-24-Instrumental/dp/B001237DT0/ref=pd_sim_dmusic_t_2', '2012-09-03 01:14:07', NULL, 'Christmas_Sarajevo.mo'), (2, 'N', 'Wizards of Winter', 'TSO', 'http://www.amazon.com/gp/product/B00123B3S2/ref=dm_mu_dp_trk4', '2012-09-03 01:14:07', 'C:\\Users\\sean\\Music\\Amazon MP3\\Trans-Siberian Orchestra\\The Lost Christmas Eve\\04 - Wizards In Winter (Instrumental).aup', 'Wizards_In_Winter.mo'), (3, 'N', 'Mad Russian Christmas', 'TSO ', 'http://www.amazon.com/gp/product/B00123D0CE/ref=dm_mu_dp_trk6', '2012-09-03 01:14:07', NULL, 'Mad_Russian_Christmas.mo') (1062) Duplicate entry '1' for key 'PRIMARY'
 

smeighan

Dedicated elf
Joined
Jan 19, 2012
Messages
1,109
Location
4217 Greenfinch Dr CO 80126
joeengler said:
Well I had a major computer crash and had to rebuild my PC, after reinstalling the local I get this error when running the install scriptNutcracker Install Script Installing NutcrackerConnecting to MySQL...OK
Creating nutcracker database...OK
Giving nutcracker database user permissions...OK
Selecting our new database to populate...OK
Creating nutcracker database schema...OK
OK
Populating nutcracker database data...FAILED!
Could not populate database.
MySQL Error: -- -- Dumping data for table `project` -- -- -- Dumping data for table `project_model` -- -- -- Dumping data for table `song` -- INSERT INTO `song` (`song_id`, `active_set`, `song_name`, `artist`, `song_url`, `last_updated`, `audacity_aup`, `music_mo_file`) VALUES (1, 'N', 'Chistmas Sarajevo', 'TSO ', 'http://www.amazon.com/Christmas-Sarajevo-12-24-Instrumental/dp/B001237DT0/ref=pd_sim_dmusic_t_2', '2012-09-03 01:14:07', NULL, 'Christmas_Sarajevo.mo'), (2, 'N', 'Wizards of Winter', 'TSO', 'http://www.amazon.com/gp/product/B00123B3S2/ref=dm_mu_dp_trk4', '2012-09-03 01:14:07', 'C:\\Users\\sean\\Music\\Amazon MP3\\Trans-Siberian Orchestra\\The Lost Christmas Eve\\04 - Wizards In Winter (Instrumental).aup', 'Wizards_In_Winter.mo'), (3, 'N', 'Mad Russian Christmas', 'TSO ', 'http://www.amazon.com/gp/product/B00123D0CE/ref=dm_mu_dp_trk6', '2012-09-03 01:14:07', NULL, 'Mad_Russian_Christmas.mo') (1062) Duplicate entry '1' for key 'PRIMARY'


i think i would uninstall all of wamp, and re-install it.


maybe there are links on google about cleaning up a partial wamp installation.


i got the same error as you a few months back and that is what i did to clean it.


thanks
 

Bridgette

Apprentice elf
Joined
Dec 19, 2010
Messages
73
Location
Newcastle NSW Australia
Hi All

Just got a new (my first) laptop, touch screen with windows 8, thought Id ask is there anything I should know about doing a local install under windows 8 ?, also when I go to the winamp page which is the one IO download, there are about 5 different varieties there, thanks
 

smeighan

Dedicated elf
Joined
Jan 19, 2012
Messages
1,109
Location
4217 Greenfinch Dr CO 80126
Bridgette said:
Hi
since im new at this, where abouts in the path in the file do I put this text, at the start, middle etc
thanks
Bree


When i clicked on this link http://sourceforge.net/projects/xampp/files/latest/download
i then let it save to my downloads directory. I then double clicked the downloaded file. I took all defaults. This means it will install to c:\xampp


thanks
 
Top