warminspirations Posted May 16, 2004 Posted May 16, 2004 I just installed OSC and tried to click on the admin tool, and I got this message on an otherwise blank page... Unable to connect to database server! How can I resolve this problem? I need to get this store up ASAP! Thanks for any help. Tameka
warminspirations Posted May 16, 2004 Author Posted May 16, 2004 I checked the password it is correct.
OceanRanch Posted May 16, 2004 Posted May 16, 2004 There are two config files, the one for your catalog..... catalog/includes/configure.php and the one for your Admin page catalog/admin/includes/configure.php If this is ok, is mysql running? Tom
warminspirations Posted May 16, 2004 Author Posted May 16, 2004 I am not familiar with mySQL at all. I winged my way through the entire process. I am computer literate, but the programming end is not as easy to me, so I need laymans terms if possible. Thanks for all the help. Tameka
OceanRanch Posted May 16, 2004 Posted May 16, 2004 No programming involved. You said you checked your DB, User, and password. Did you check them in both of your configure.php files? Tom
warminspirations Posted May 16, 2004 Author Posted May 16, 2004 THIS IS WHAT THE SCREEN SAID: New Installation Database Import A test connection made to the database was successful. Please continue the installation process to execute the database import procedure. It is important this procedure is not interrupted, otherwise the database may end up corrupt. The file to import must be located and named at: /home/content/t/a/m/tamekalawrence/html/catalog/install/oscommerce.sql NEXT SCREEN: New Installation Database Import The database import was successful! NEXT SCREEN: New Installation osCommerce Configuration Please enter the web server information: WWW Address: http://www.warminspirations.com/catalog/ Webserver Root Directory: /home/content/t/a/m/tamekalawrence/html/catalog/ <SEE REFERENCE TO THIS DIRECTORY BELOW> HTTP Cookie Domain: www.warminspirations.com HTTP Cookie Path: /catalog/ Enable SSL Connections: NEXT SCREEN: New Installation osCommerce Configuration Database Server: <CHECKED CORRECT INFO> Username: <CHECKED CORRECT INFO> Database username: <CHECKED CORRECT INFO> Password: <CHECKED CORRECT INFO> Database password: <CHECKED CORRECT INFO> Database Name: <CHECKED CORRECT INFO> Database Name: <CHECKED CORRECT INFO> Persistent Connections: <NOT CHECKED> Session Storage: Files Database <DATABASE CHECKED> THIS IS THE NEXT SCREEN I GET IF I DON'T CHANGE THE ROOT DIRECTORY TO ABOVE REFERENCED FILE: "The configuration files do not exist, or permission levels are not set. Please perform the following actions: cd /home/content/t/a/m/tamekalawrence/html/catalog/includes/ touch configure.php chmod 706 configure.php cd /home/content/t/a/m/tamekalawrence/html/catalog/admin/includes/ touch configure.php chmod 706 configure.php: THIS IS THE SCREEN THAT I GET IF I CHANGE THE ROOT DIRECTORY TO /home/content/t/a/m/tamekalawrence/html/catalog/install/oscommerce.sql FINALLY! New Installation osCommerce Configuration The configuration was successful! Catalog Administration Tools Then I click Admin Tools and a window pops and says, "Unable to connect to server database" HELP!!
warminspirations Posted May 16, 2004 Author Posted May 16, 2004 Sorry, your messages are posting while I am typing my replies, so they may seem a little out of sync. This is to reply to No programming involved. You said you checked your DB, User, and password. Did you check them in both of your configure.php files? Tom
warminspirations Posted May 16, 2004 Author Posted May 16, 2004 I don't know how to check in the configure.php files. Tameka
241 Posted May 16, 2004 Posted May 16, 2004 Warning: mysql_connect(): Host '******' is not allowed to connect to this MySQL server in *:\******\www\*****\******\includes\functions\database.php on line 19 Unable to connect to database server! This indicates the wrong server DB_SERVER information in the configure.php files Warning: mysql_connect(): Access denied for user: '****@*****' (Using password: *****) in *:\******\www\*****\******\includes\functions\database.php on line 19 Unable to connect to database server! This indicates the wrong username DB_SERVER_USERNAME or password DB_SERVER_PASSWORD information in the configure.php files 1046 - No Database Selected select configuration_key as cfgKey, configuration_value as cfgValue from configuration This indicates that either no database has been created or the wrong database name DB_DATABASE exists in the configure.php files You posted whilst I was getting this lot together for you from your latest post it would indeed seem that you have issues in the configure.php files. Can you enter your catalog side of things No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
warminspirations Posted May 17, 2004 Author Posted May 17, 2004 OK I feel very stupid. I had to have a friend tell me to open the configure.php file in Dreamweaver. I had no idea what you all were talking about. I got past the db problem, but now it won't go past the action page. Tameka
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.