katman1971 Posted June 4, 2010 Posted June 4, 2010 Hi The first thing I did with my vanilla os commerce site was try to install a contrib. I made a mess of it so I decided to start again, so rather than go back and find all the files I uploaded and changed I decided to simply upload a fresh catalog folder from the installation pack. When I go to my admin area, I get this error message: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mysql'@'localhost' (using password: NO) in /home/buildawe/public_html/store/catalog/admin/includes/functions/database.php on line 19Unable to connect to database server! This is line 19 of catalog/admin/includes/functions/database.php: $$link = mysql_connect($server, $username, $password); I tried putting in my username/password but I must be putting it in the wrong format. Thanks
Guest Posted June 4, 2010 Posted June 4, 2010 Jim, Ensure the database user name and password are correct in the catalog>includes>configure.php If that fails, use myphpadmin and find the administrators table. Delete your name from that table. Then, log in again to the admin area, it will tell you that you have no admin set up. Set up a new user name and password. Chris
katman1971 Posted June 4, 2010 Author Posted June 4, 2010 Jim, Ensure the database user name and password are correct in the catalog>includes>configure.php If that fails, use myphpadmin and find the administrators table. Delete your name from that table. Then, log in again to the admin area, it will tell you that you have no admin set up. Set up a new user name and password. Chris I checked the catalog>includes>configure.php. The username / password was correct. I deleted my name from the administrators table in myphpadmin. I went back in to login to my admin area. Still getting the same error message: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mysql'@'localhost' (using password: NO) in /home/buildawe/public_html/store/catalog/admin/includes/functions/database.php on line 19Unable to connect to database server!
♥FWR Media Posted June 4, 2010 Posted June 4, 2010 I checked the catalog>includes>configure.php. The username / password was correct. I deleted my name from the administrators table in myphpadmin. I went back in to login to my admin area. Still getting the same error message: catalog/includes/configure.php has nothing to do with admin. Look in admin/includes/configure.php Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work.
Guest Posted June 4, 2010 Posted June 4, 2010 Hi The first thing I did with my vanilla os commerce site was try to install a contrib. I made a mess of it so I decided to start again, so rather than go back and find all the files I uploaded and changed I decided to simply upload a fresh catalog folder from the installation pack. When I go to my admin area, I get this error message: This is line 19 of catalog/admin/includes/functions/database.php: $$link = mysql_connect($server, $username, $password); I tried putting in my username/password but I must be putting it in the wrong format. Thanks do you have a backup of your config file? this is showing an incorrect username or password, most likely a user name. if you are hosted on a linux system with cpanel your db usually starts with serverloginname_databasename
katman1971 Posted June 4, 2010 Author Posted June 4, 2010 catalog/includes/configure.php has nothing to do with admin. Look in admin/includes/configure.php I looked in admin/includes/configure.php and I made the username / password / database name the same as catalog/includes/configure.php. Now I'm getting Not Found The requested URL /admin/login.php was not found on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Apache/2.2.14 (Unix) mod_ssl/2.2.14 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at buildawebsite.ie Port 80
♥FWR Media Posted June 4, 2010 Posted June 4, 2010 I looked in admin/includes/configure.php and I made the username / password / database name the same as catalog/includes/configure.php. Now I'm getting Well is there a file admin/login.php? because there should be. Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work.
katman1971 Posted June 5, 2010 Author Posted June 5, 2010 Well is there a file admin/login.php? because there should be. Yes, admin/login.php is there. It might be easier for me to delete the entire site, delete the database, create a new one and upload a new site....since it was a new site in the first place.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.