Need an XAMPP expert

[jhande]

I had removed XAMPP awhile ago along with some other database programs my college professor had me install (that was a nightmare in itself).

 

Now that I'm getting ready for some serious site makeovers I figured re-install XAMPP so I don't break my live site.

 

Well this time around XAMPP didn't play so nice after the install.

Went to XAMPP's site (English for Windows forum) and searched & searched but that forum is, well, at best difficult to get any clear answers.

Before I progress any further and copy my osC site to the XAMPP folder, I thought it best to try and get things running smoothly.

 

I have Windows XP Pro SP/2, XAMPP 1.6.1.

 

After I installed XAMPP I typed http://localhost in my browser. IE7 displayed a can not find message with a whole page of IIS stuff. So I went to Windows Add & Remove and removed IIS.

 

Tried again, typed http://localhost in my browser. Again, page can't be found.

Opened XAMPP control panel, AHHH Apache was not started but MySql was. Windows Explorer and fired up c:\xampp\apache\apache_installservice.bat.

 

Typed http://localhost in my browser, yeah, XAMPP Welcome screen. Checked the Status and all was activated except SMTP and FTP.

Checked the Demos and all went fine.

So now for phpMyAdmin to create an empty database so I can import mine from online.

Click on phpMyAdmin and IE7 returns = service not available. Hit refresh and I'm ok.

Type in a new name under Create new database. Received error #1064 stating check my version and syntax error in line 1. Arg...

Created the database from SQL querry.

Shut down computer and called it a night.

 

Started up computer, opened XAMPP control panel, Apache & Mysql not running, clicked on Start Apache and received error. Checked SCM and found two listings for Apache, started one. Found one listing for Mysql, it would not start. Had to go to C:\xampp\mysql\mysql_installservice.bat to get it running.

 

I checked my Firewall and both Apache & Mysql are fine. I checked my services and both Apache & Mysql are set to Startup type: Automatic and Logon: Allow service to interact with desktop.

 

Any idea how I can get Apache & Mysql to start as they should, from the XAMPP control panel?

[lindsayanng]

Did you run the mkdir command in terminal?

 

You need to tell xampp which folders will server as your localhost folders.. That was the think that I missed in the installation and it drove me absolutely NUTS!!!

[jhande]

Hey Lindsay,

 

I haven't even gotten to the part of adding my files to C:\xampp\htdocs yet.

I've done that before and even setup Dreamweaver for editing and then previewing in my browser (can't remember how now).

 

I used the same XAMPP download that I used awhile ago, a self extracting/installing version (1.6.1) for Windows.

It self installed and ran without a hickup in the past. But from what I've read on the XAMPP forum, the self installing Windows version actually does make changes to Windows Registry. If not properly uninstalled then you get all sorts of errors upon next installation. I thought I cleaned my system ok of the previous install, guess not since I'm having related problems and 2 versions of Apache listed in my Services, which I don't know how to remove.

 

I figured it might be best getting XAMPP to work properly before moving on to intergrating my site?

 

 

 

 

[GemRock]

xampp is the easiest thing to install and should not take more than several minutes. Apache & Mysql are both run as services so could take a look at (windows) control panel - administrative tools - services, locate the two service to see if they are running or not, and you could also set it as Automatic meaning whenever windows start it loads the two services.

you should be aware though that the current (newest) version of xampp comes with MySQL 5.1.37 and php 5.3.0, none of which is used by most hosts that knows what they are doing. so the thing may come a bit a complicated/difficult when you try to replace the two with the correct versions that you could download separately from mysql and php websites. if you dont replace the two then you may get into problems running oscommerce.

 

Ken

[GemRock]

2 versions of Apache listed in my Services

this is normal if you are talking about what you see in the task manager and should not worry about it.

Ken

[lindsayanng]

Did you run an uninstall script?

 

The Uninstallation

* Method A: with the uninstall script

 

uninstall skript If you want uninstall XAMPP, you can use the uninstall script:

\xampp\unstall_xampp.bat

 

This script:

 

1. deinstalls the Windows services

2. delete the startmenu/desktop icons

3. delete the XAMPP directory

 

If selected, the directories "\xampp\htdocs" and "\xampp\mysql\data" are not deleted. But you should really thinl about, if need something from your stuff, like configuration files, before you start the uninstall process..

[jhande]

xampp is the easiest thing to install and should not take more than several minutes. Apache & Mysql are both run as services so could take a look at (windows) control panel - administrative tools - services, locate the two service to see if they are running or not, and you could also set it as Automatic meaning whenever windows start it loads the two services.

you should be aware though that the current (newest) version of xampp comes with MySQL 5.1.37 and php 5.3.0, none of which is used by most hosts that knows what they are doing. so the thing may come a bit a complicated/difficult when you try to replace the two with the correct versions that you could download separately from mysql and php websites. if you dont replace the two then you may get into problems running oscommerce.

 

Ken

 

Thanks Ken,

 

That was my problem, although I had Apache & Mysql set to start automatically they weren't.

 

My XAMPP version 1.6.1 comes with:

Apache 2.2.4

MySQL 5.0.37

PHP 5.2.1 + PHP 4.4.6 + PEAR (using 5.2.1)

 

My host is using:

Apache 2.2.13

Mysql 5.0.81

PHP 5.2.9

 

So I hope I'll be alright.

 

this is normal if you are talking about what you see in the task manager and should not worry about it.

They were listed in Control Panel\Administrative Tools\Services

NOTE: See post below

 

 

[jhande]

Did you run an uninstall script?

 

Thanks Lindsay

 

I just ran the unistall script again and then ran Register Easy to clean up my system.

 

I double checked my Services and still found Apache 2, Apache2.2 and Mysql pointing to the now deleted C:\xampp folder, I ignored it.

 

Re-installed XAMPP and rebooted. Guess what? Hurray, Apache & Mysql are showing as running when I open the XAMPP control panel.

 

Guess all I needed was to unistall, clean my registry and try again!

 

Thanks for waking me up Lindsay.

 

Now for creating and importing my database again, copying my osC files to C:\xampp\htdocs\shop and trying to get them to work.

If I remember correctly I had to do something tricky or different than what is explained with xampp.

[lindsayanng]

YAY!!! I figured it was an issue with it seeing that there migth two of the same thing

[GemRock]

xampp pre-1.7 versions does not have this unstall_xampp.bat.

uninstalling xampp should be as easy as installing it. to my knowledge, no windows registry editing is needed. just first stop all the related services (that xampp installs), then delete the xampp director.

for the two instances of apache service you could try to disable one of them, test to see which one is the correct one.

i am referring to the zip file which is what i always use, not the exe package.

Ken

[jhande]

Well, even though I got XAMPP working, I jumped the gun getting excited.

 

All works fine if I "install" a "fresh" copy of osCommerce.

Once I start swapping files from my online version it breaks with all kinds of error message (I made the necessary changes to the configure.php files), even just my header.php or application_top.php.

 

If I use all my online files I receive this:

 

Server error!

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there was an error in a CGI script.

 

If you think this is a server error, please contact the webmaster.

 

 

Error 500

localhost

10/20/09 01:16:21

Apache/2.2.4 (Win32) DAV/2 mod_ssl/2.2.4 OpenSSL/0.9.8e mod_autoindex_color PHP/5.2.1

 

 

 

I don't remember having such problems the last time I set it all up.

I'm setting it up as before - C:\xampp\htdocs\handesho\all my site files.

 

[BryceJr]

You may want to disable htaccess(watch you SEO contributions) for a while and recheck your read/write permissions on files and folders.

 

Additional info: XAMPP has a SSL cert for localhost. If you want to enbale SSL, you may do so. A browser window will pop up asking you to accept or reject the localhost certificate.

[jhande]

Thanks Bryce,

 

How would I disable htaccess?

 

Just comment out all the lines?

[jhande]

Well I commented everything out of the catalog and admin htaccess files.

 

The site now loads but with a few problems still.

 

My background image along with a few in my footer.

The background is called for in my stylesheet like = background-image: url (images/CarbonFiber_BKG.gif) repeat;

The images in my footer are called like = <img src="/images/Images/mystateplate.gif" alt="NHplate" width="150" height="71">

Both work fine on my live site. I even tried using the complete path and different versions of it, nothing.

 

Here's the biggy...

All of my category links are broken - ERROR 404

Sitemap link is broke - Fatal error: Call to undefined function curl_init() in C:\xampp\htdocs\handesho\includes\functions\sitemap.php on line 97

Contact Us, Conditions of Use, Privacy Notice, Shipping and Returns and View All Products pages work.

I can go from search page to search page while staying on the all-products.php page, but once I click on an item - ERROR 404.

 

Obviously I'm missing a setting or two somewhere.

 

Any ideas?

[Peper]

sort of same problem here though if you put on web server

background-image: url (../images/CarbonFiber_BKG.gif) repeat;

in front of the image path in style sheet it works,

On my xampp server i need to remove ../ again

[Xpajun]

Most of the problems I had setting up my site on xampp revolved around the configure files

 

I wonder if you have osC in the same directory level as you have on your site?

 

things like this:

background-image: url (../images/CarbonFiber_BKG.gif) repeat;

should be set in your configure.php not in stylesheet.css and if your image directory is one level above your catalog directory on line, then that is where you should position it on your localhost

 

 

Jim - have you tried looking at the properties for your images to see where they are being called from and seeing if it corresponds with your image directory

- also does your image directory have the right permissions set?

[jhande]

Thanks for the replies guys

 

I fixed my missing images problem. Changed this /images/ to this images/ on the pages where I used regular HTML to insert them.

 

Now if I can only figure out why I can't load any of my category, product listing and product info pages.

[jhande]

Just found out I can't access my localhost admin either.

 

The admin index page loads with a bunch of session error and all links lead to - "Object Not Found".

 

What the hell could have broke my site since the last time I used XAMPP?

 

Ultimate URL's SEO?

 

I've Googled and found others with the same problem, just no replies how to fix it.

 

This is getting really fustrating to say the least.

[Guest]

Here are my configure.php files. They work for me on XAMPP and I have never had a problem. The url would be http://localhost/web-site/

 

catalog side;

 

  define('HTTP_SERVER', 'http://localhost');
 define('HTTPS_SERVER', 'http://localhost');
 define('ENABLE_SSL', false);
 define('HTTP_COOKIE_DOMAIN', 'localhost');
 define('HTTPS_COOKIE_DOMAIN', 'localhost');
 define('HTTP_COOKIE_PATH', '/web-site/');
 define('HTTPS_COOKIE_PATH', '/web-site/');
 define('DIR_WS_HTTP_CATALOG', '/web-site/');
 define('DIR_WS_HTTPS_CATALOG', '/web-site/');
 define('DIR_WS_IMAGES', 'images/');
 define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
 define('DIR_WS_INCLUDES', 'includes/');
 define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
 define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
 define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
 define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
 define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

 define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
 define('DIR_FS_CATALOG', 'C:/xampp/htdocs/web-site/');
 define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
 define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

 

And for the admin

  define('HTTP_SERVER', 'http://localhost');
 define('HTTP_CATALOG_SERVER', 'http://localhost');
 define('HTTPS_CATALOG_SERVER', 'http://localhost');
 define('ENABLE_SSL_CATALOG', 'false');
 define('DIR_FS_DOCUMENT_ROOT', 'C:/xampp/htdocs/web-site/');
 define('DIR_WS_ADMIN', '/web-site/admin/');
 define('DIR_FS_ADMIN', 'C:/xampp/htdocs/web-site/admin/');
 define('DIR_WS_CATALOG', '/web-site/');
 define('DIR_FS_CATALOG', 'C:/xampp/htdocs/web-site/');
 define('DIR_WS_IMAGES', 'images/');
 define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
 define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
 define('DIR_WS_INCLUDES', 'includes/');
 define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
 define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
 define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
 define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
 define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
 define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
 define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
 define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
 define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
 define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

[jhande]

Thanks Peter

 

My configure.php files match just fine.

 

Everything works fine with the fresh install of osC.

 

I can even swap my live site files & database for the XAMPP version once I turn register globals off.

 

Have you tried XAMPP while using - Ultimate SEO URLs v2.1d ORIGINAL updated?

 

The reason I think it's that contribution is because none of my categories or product links work.

 

Well I'm off to read through the support thread again and double check things there.

[Guest]

I had to turn off ALL the SEO URL switches in the admin and remove almost all the .htaccess file for it to work on a standard XAMPP install.

[jhande]

Bloody hell... I found the problem!!!

 

After turning register globals On, swapping my live site files to the C:\xampp\htdocs\hobbies\ folder, turning them back off...

Searching for how to set up XAMPP to use rewrite...

Double checking the install of Ultimate SEO URLs...

Pulling my hair out and beating my head on a wall...

Double checking my php.ini & htaccess files, again...

 

Changed this line:

RewriteBase /

To this:

RewriteBase /hobbies/

 

Freakin little bugger!

 

While you're laughing at me, I'm going to take a break.

 

Coffee, camera... off to chase the Bald Eagles.

[jhande]

Thanks Peter, finally got it straighten out. Whew...