1. New to Christmas lighting? Get started with the AusChristmasLighting 101 Manual:
    auschristmaslighting.com/wiki/AusChristmasLighting-101

Nutcracker (web version): Local Install

Discussion in 'xLights (Nutcracker)' started by smeighan, Sep 7, 2012.

  1. smeighan

    smeighan Dedicated Elf

    Joined:
    Jan 19, 2012
    Messages:
    1,065
    Likes Received:
    9
    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
     
  2. lithgowlights

    lithgowlights Senior Elf

    Joined:
    May 6, 2010
    Messages:
    750
    Likes Received:
    20
    Location:
    Lithgow, NSW
    Find Me On:
  3. OP
    OP
    smeighan

    smeighan Dedicated Elf

    Joined:
    Jan 19, 2012
    Messages:
    1,065
    Likes Received:
    9
    Location:
    4217 Greenfinch Dr CO 80126
    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
     
  4. twinkleclaus

    twinkleclaus New Elf

    Joined:
    Jan 6, 2011
    Messages:
    44
    Likes Received:
    0
    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.
     
  5. OP
    OP
    smeighan

    smeighan Dedicated Elf

    Joined:
    Jan 19, 2012
    Messages:
    1,065
    Likes Received:
    9
    Location:
    4217 Greenfinch Dr CO 80126

    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"/.
     
  6. OP
    OP
    smeighan

    smeighan Dedicated Elf

    Joined:
    Jan 19, 2012
    Messages:
    1,065
    Likes Received:
    9
    Location:
    4217 Greenfinch Dr CO 80126

    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


    [​IMG]


    Modify nothing and just click submit.


    You should then see this




    [​IMG]


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


    thanks

    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


    [​IMG]


    Modify nothing and just click submit.


    You should then see this




    [​IMG]


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


    thanks
     
  7. OP
    OP
    smeighan

    smeighan Dedicated Elf

    Joined:
    Jan 19, 2012
    Messages:
    1,065
    Likes Received:
    9
    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.
     
  8. joeengler

    joeengler Apprentice Elf

    Joined:
    May 20, 2010
    Messages:
    90
    Likes Received:
    0
    Location:
    Garden City, MI 48135
    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'
     
  9. OP
    OP
    smeighan

    smeighan Dedicated Elf

    Joined:
    Jan 19, 2012
    Messages:
    1,065
    Likes Received:
    9
    Location:
    4217 Greenfinch Dr CO 80126

    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
     
  10. Bridgette

    Bridgette Apprentice Elf

    Joined:
    Dec 19, 2010
    Messages:
    72
    Likes Received:
    0
    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
     
  11. jcmarksafb

    jcmarksafb Hello from Christopher Creek Arizona

    Joined:
    Mar 11, 2012
    Messages:
    300
    Likes Received:
    0
    Location:
    Christopher Creek Arizona
  12. Bridgette

    Bridgette Apprentice Elf

    Joined:
    Dec 19, 2010
    Messages:
    72
    Likes Received:
    0
    Location:
    Newcastle NSW Australia
    Sorry I meant wampserver, :)
     
  13. OP
    OP
    smeighan

    smeighan Dedicated Elf

    Joined:
    Jan 19, 2012
    Messages:
    1,065
    Likes Received:
    9
    Location:
    4217 Greenfinch Dr CO 80126
  14. Bridgette

    Bridgette Apprentice Elf

    Joined:
    Dec 19, 2010
    Messages:
    72
    Likes Received:
    0
    Location:
    Newcastle NSW Australia
    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
     
  15. OP
    OP
    smeighan

    smeighan Dedicated Elf

    Joined:
    Jan 19, 2012
    Messages:
    1,065
    Likes Received:
    9
    Location:
    4217 Greenfinch Dr CO 80126

    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
     

Share This Page