Author Topic: Installing Etano locally on Windows XP  (Read 482 times)

utah

  • Active Member
  • **
  • Posts: 38
  • Karma: +1/-0
Installing Etano locally on Windows XP
« on: December 05, 2011, 01:30:39 AM »
Hello

I just made my self a user guide on how to install and run a forum locally on my PC.
Then I thought maybe someone else here wants to know how to do this, so I decided to share it.

------------------------
LOCAL ETANO INSTALLATION
------------------------
 * * * by Utah * * *
------------------------

1. Download and install xampp.

(http://sourceforge.net/projects/xampp/files/latest/download)
2. Start xampp Control Panel.
3. Make sure the Apache and Mysql services are started and running.

------------------------
CREATE DATABASE AND USER
------------------------

1. Go to this URL: http://localhost/xampp/splash.php
2. Choose your language
3. From the "Tools" menu choose "PhpMyAdmin"
4. Click on the "Databases" tab and then locate the field; "Create new database".
5. Type your new database name and click on "Create". 
6. Click on the "Privileges" tab and then click on "Add a new user".
7. Type your new database user name (can be the same as your database name).
8. Choose localhost and type a password (then re-type password).
9. Look down on the same page under "Global privileges", and click on "Check All".
10. Click on "Go".

----------------------------
COPY FILES AND INSTALL ETANO
----------------------------

1. Copy all the Etano folder contents to "c:\xampp\htdocs\etano".
2. Install Etano : http://localhost/etano/install.
3. Follow the Etano documentation from this step.

-------------------------------------
If you get a HTTP 500 error in Step 3
-------------------------------------
Try this:

1. Open c:\xampp\htdocs\etano\install\sql\db.sql with Wordpad.
2. From the Wordpad menu choose "Edit" and "Replace".
3. In the "Find what" box, type this: TYPE=MyISAM
4. In the "Replace with" box, type this: ENGINE=MyISAM
5. Click on "Replace All".
6. Close the replace dialogue box
7. From the wordpad menu choose "File" and "Save".
8. Close Wordpad
9. Go back again and retry the Etano installation step 3.

----------
Final step
----------

1. Etano should be up and running now (http://localhost/etano/index.php)

--------------------------------------------
Setting up scheduled tasks for the cron jobs
--------------------------------------------

1. Open Notepad and type this: (if different path, then replace with the actual path to your cron.php file)
   start C:\xampp\php\php.exe -f "C:\xampp\htdocs\etano\tools\cron\cron.php"
2. Save as "cron.bat". (For instance C:\cron.bat)
3. From the Start menu choose: "All Programs", "Accessories", "System tools",  "Scheduled tasks".
4. Doubleclick "Add Scheduled Task", click on "Next".
5. Browse to your cron.bat file.
6. Choose a name for you task and click on "Daily" and then "Next".
7. Next, you'll see a window asking you to "select the time and day that you want this task to start". Just click "Next".
8. Type your windows user name and password and then click on "Next".
   (you need to set a passord or else the scheduled task may not run)
9. Ok, we're almost done. You are now presented with the option to "Open advanced properties for this task when you click Finish". Make sure you select that option, prior to clicking "Finish".
10. Click the "Schedule" tab, and then click the "Advanced" button.
11. You'll want to make sure the "Repeat Task" check box is selected. Once you do that, then you'll need to set it to repeat task every 5 minutes, for a  duration of 24 hours, every day.
12. Make sure your new schedule is correct, and then click OK.


Good luck

Hope everything works as it did here :)


Utah
« Last Edit: December 05, 2011, 01:46:09 AM by utah »

maverick

  • Active Member
  • **
  • Posts: 1382
  • Karma: +93/-1
    • Etano Templates
Re: Installing Etano locally on Windows XP
« Reply #1 on: December 06, 2011, 12:54:34 PM »
Thanks for taking the time to write and share this tutorial for those who want to install Etano on their PC for development and testing purposes.
Etano Templates and Mods

http://www.maverickwebworks.com

Marble

  • Active Member
  • **
  • Posts: 135
  • Karma: +4/-0
Re: Installing Etano locally on Windows XP
« Reply #2 on: December 13, 2011, 12:51:57 AM »
Ah! I've been wanting to figure this out several months ago, but had problems. When I get a chance I'll follow your instructions and see how it goes.
Tom

Marble

  • Active Member
  • **
  • Posts: 135
  • Karma: +4/-0
Re: Installing Etano locally on Windows XP
« Reply #3 on: January 11, 2012, 11:27:42 PM »
good tutorial. I tried it out and had success.
Tom

AF

  • Active Member
  • **
  • Posts: 27
  • Karma: +1/-0
Re: Installing Etano locally on Windows XP
« Reply #4 on: February 02, 2012, 07:53:51 PM »
Brilliant! Thanks Utah, It works perfectly.

I didn't get any HTTP error, but a page hang instead on step 3 - which the word replace fixed.

I downloaded a fresh copy of etano and used that. However I want to use my actual website also, so do I just download and copy all the main files from my site server into a new local folder - the same as a fresh install? Does it actually need to be installed so to speak?

..and how would one go about using the existing website database? (not referring to the one created on install, but instead the one from my live site)

Cheers
« Last Edit: February 02, 2012, 07:56:43 PM by AF »

Marble

  • Active Member
  • **
  • Posts: 135
  • Karma: +4/-0
Re: Installing Etano locally on Windows XP
« Reply #5 on: February 02, 2012, 10:13:32 PM »
I think I can answer some of these questions.

I downloaded a fresh copy of etano and used that. However I want to use my actual website also, so do I just download and copy all the main files from my site server into a new local folder - the same as a fresh install? Does it actually need to be installed so to speak?

Open:
C:\xampp\htdocs\etano

Treat it as though this was your site root directory where you have etano installed onto your server.
You can just move all of the default skin files from your server into the default folder inside the etano directory on your hard drive. eg: C:\xampp\htdocs\etano\skins_site\def
And then move any relevant php files into the etano root directory that you may have altered or created on your server.

I decided to be a little more complicated than just that. I used Maverick's free Template Skin Clone Tool.

..and how would one go about using the existing website database? (not referring to the one created on install, but instead the one from my live site)


What I did in the beginning when I installed etano onto my pc was that I created a database with the same exact name, username and password that I have on my server. That way, I wouldn't run into any problems if any problems could occur. Although I don't know if it would cause a problem if your database on the pc had a different name. If you made a different name and want to change it inside phpMyAdmin to the name of the one that is on your server, you'll need to edit your defines.inc.php file, or just copy the one on your server into your C:\xampp\htdocs\etano\includes  directory
Take a look inside this file and you'll see everything you need to know.

Does that help answer some questions?
« Last Edit: February 02, 2012, 10:17:53 PM by Marble »
Tom

AF

  • Active Member
  • **
  • Posts: 27
  • Karma: +1/-0
Re: Installing Etano locally on Windows XP
« Reply #6 on: February 03, 2012, 02:45:51 AM »
Yes that is definitely helping point me in the right direction, I thought it would be best to get an opinion before I tried it.

I gather from what you said no actual install procedure is required and I should be able to just copy original site files.
I'm guessing I can run multiple sites if I just copy files to a different directory name eg. C:\xampp\htdocs\etano2. I am going to attempt to NOT copy over the cache folder contents because they are huge and hope that it will work and recreate it's sub-folders automatically. I will try duplicate the database name/password as you said and see if I have any luck. - No biggie if I break it :)

Thanks Tom
« Last Edit: February 03, 2012, 02:47:43 AM by AF »

AF

  • Active Member
  • **
  • Posts: 27
  • Karma: +1/-0
Re: Installing Etano locally on Windows XP
« Reply #7 on: February 13, 2012, 06:28:47 AM »
Ok for anyone interested - Thanks to Marble for some input, with a little fiddling around with the database i managed to install two working sites locally on my pc, one a fresh new site, and the other a complete mirror/clone of my live site.

So to do it I created a new blank database for the new site in phpMyAdmin  -  and for the duplicate of my 'live site' i used my cpanel to create a full backup of tables and data and exported the sql file.
"I don't recommend using the etano admin panel to duplicate the database". Although it downloaded - It failed to import later.

I created two different etano folders in the htdocs folder of xampp, and installed a fresh copy of etano to each folder. eg "etano" and "etano2". (use the same blank database for both sites) just so you can get them both initially installed.

Once both installed I then copied my entire live site file to one of the folders which obviously overwrites the fresh install.

You will need to edit the properties of a particular .ini file somewhere in xampp to allow database imports of larger than 8mb (I'm sorry i cannot remember the exact file location but if you try import a large db it will give you the error and you will be able to figure out where the file is with a bit if digging and by reading the help) editing this file is easy. once done "restart xampp and services".

Next in phpMyadmin I created a new database, named it the same as the original and made sure the password was also the same, then I used the import option to import the tables and data from the original db from my live site which I exported earlier using cpanel.

As long as the defines.inc details match that of your database name, user name and password then all should work. Then just setup crons and regenerate your skins.

You can effectively run as many local sites as you want, as long as they're in different folders.
 



« Last Edit: February 13, 2012, 06:32:16 AM by AF »

aakshat

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
Re: Installing Etano locally on Windows XP
« Reply #8 on: March 10, 2012, 04:14:08 PM »
Hi Every one I need Help to get back admin panel password. actually i install etano in my local pc and it's done but i didn't get any option to create admin acount or like that thing so i can control all the script and after installation it is go to the admin panel and ask for admin name and pass word. anyone can help me to sortout this issue.

maverick

  • Active Member
  • **
  • Posts: 1382
  • Karma: +93/-1
    • Etano Templates
Re: Installing Etano locally on Windows XP
« Reply #9 on: March 10, 2012, 05:49:42 PM »
The default admin login can be found in the online installation manual
http://www.datemill.com/etano/wiki/doku.php?id=installation
Username: admin
Password: demo
Etano Templates and Mods

http://www.maverickwebworks.com