mysql06

[fairclb]

I have a db on server mysql06, when I log into it the database I set up does not show, when I try to log into the server mysql06 is not in the server list. From the web side, it logs into the server, sometimes other times it says it can't connect.

[B&T]

I didn't know there was a mysql06. It is not listed in the phpmyadmin options for server. You better talk with support about this one. Maybe it is a new server and you are the first user?

[mjp]

mysql06 has been added to http://phpmyadmin.powweb.com. Yes, it is brand new. There are only a few users on it at the moment.

[genevievemarie]

I have a problem with mysql06 also:

"Warning: mysql_connect(): Unknown MySQL Server Host 'mysql06.powweb.com ' (1) in /www/g/genevievemarie1/htdocs/osCommerce/catalog/includes/functions/database.php on line 19
Unable to connect to database server!"

I have contacted support....just waiting to hear back......

BTW- I just installed Oscommerce today.....and I AM FRUSTRATED!!!!

Jennifer

[B&T]

Host 'mysql06.powweb.com '
Jennifer -

Looks like you have a space after the server name. That would be a problem.

[genevievemarie]

D'oh! (smacking head)
Thanks for your reply!!!
I see it now!
Next problem.......how do I change it?
I set up oscommerce through the "auto install" in ops......

Jennifer

[mjp]

The error message tells you which file is causing the error and even which line has to be fixed:

/www/g/genevievemarie1/htdocs/osCommerce/catalog/includes/functions/database.php on line 19

Just download database.php from the /osCommerce/catalog/includes/functions directory in your account, open it in a text editor, remove the space and upload the file.

[genevievemarie]

Thanks for the reply...
I did not find the problem in my database file.

[B&T]

The problem is the config file that stores the server variable. That is where you will need to make the change. I don't use OSCommerce, so I do not know where that is. But look for something like config.php.

There you will find the server variable being defined.

The script getting the error is just using the variable, so it gets the error.

[genevievemarie]

Thank you for your help, B&T

I have been able to get the catalog/admin to work by changing the config.php file....still working on the catalog itself.
I did change the config file...still not working...

Thanks again!
Jennifer

[B&T]

Not working with the same error? Then that would imply the server name is stored in more than one place? Bad software design.

Maybe someone who knows OSCommerce can pitch in.