I have installed phPay 2.02 on a Redhat 8.0 server with MySQL 3.23, Apache (httpd) 2.0.40 and php 4.2.2. I had to run the .sql script to set up the tables, and created config_db.inc.php manually. After that the admin part works fine. However, when I try to access the shop I get a MySQL error:
Warning: Access denied for user: 'webshop@localhost' (Using password: YES) in /var/www/html/webshop/db_func.inc.php on line 9
Warning: MySQL Connection Failed: Access denied for user: 'webshop@localhost' (Using password: YES) in /var/www/html/webshop/db_func.inc.php on line 9
No Database Selected
I have verified that the webshop ID and password is correct. What is wrong?
Initially I also got an error about a missing config_system.inc.php, and as I couldn't find a reference to this file anywhere I just created an empty file with the same name. Possibly this is connected to the first problem I described.... ?
Thanks for any help!
Jon Ole
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Do you created both config_db.inc.php (phpay/-dir and in phpay//admin/-dir). Maybe only one area has problems to access database?
Otherwise as the error message tells: username and password for database access are wrong. Do you tried to access database with this account data from concole?
mysql -u webshop -p -U databasename
Greetings,
Andreas.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2003-02-06
Thanks for your reply, Andreas, there was a problem with the mysql user - fixed now.
Now that I'm able to get to the shop I found another problem. There is no "Login" link displayed in the navigator on the left side, do I have to configure this somewhere?
Also, I cannot see the itemlist unless I specify that it sould be on the right side of the screen.
Probably just stupid newbie problems, but still, I will be very happy for a reply!
BR,
Jon Ole
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Normally the word 'login' is rplaced with username, if you are logged in. If nothing is visible, you are logged in and firstname and name is empty.
You can check 'user public's password ...
Or perhaps only color of word 'Login' is same as background? Look into generated HTML-Code ...
No other idea yet ...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2003-02-07
If I make a link to reguser.php I get the login screen, and after a successful login the name is displayed in the left frame as you said. I have not changed anything after installation and I have checked that it is not a problem with the background color...
I'm not sure if this helps you understand what the problem might be....
Jon Ole
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have installed phPay 2.02 on a Redhat 8.0 server with MySQL 3.23, Apache (httpd) 2.0.40 and php 4.2.2. I had to run the .sql script to set up the tables, and created config_db.inc.php manually. After that the admin part works fine. However, when I try to access the shop I get a MySQL error:
Warning: Access denied for user: 'webshop@localhost' (Using password: YES) in /var/www/html/webshop/db_func.inc.php on line 9
Warning: MySQL Connection Failed: Access denied for user: 'webshop@localhost' (Using password: YES) in /var/www/html/webshop/db_func.inc.php on line 9
No Database Selected
I have verified that the webshop ID and password is correct. What is wrong?
Initially I also got an error about a missing config_system.inc.php, and as I couldn't find a reference to this file anywhere I just created an empty file with the same name. Possibly this is connected to the first problem I described.... ?
Thanks for any help!
Jon Ole
Do you created both config_db.inc.php (phpay/-dir and in phpay//admin/-dir). Maybe only one area has problems to access database?
Otherwise as the error message tells: username and password for database access are wrong. Do you tried to access database with this account data from concole?
mysql -u webshop -p -U databasename
Greetings,
Andreas.
Thanks for your reply, Andreas, there was a problem with the mysql user - fixed now.
Now that I'm able to get to the shop I found another problem. There is no "Login" link displayed in the navigator on the left side, do I have to configure this somewhere?
Also, I cannot see the itemlist unless I specify that it sould be on the right side of the screen.
Probably just stupid newbie problems, but still, I will be very happy for a reply!
BR,
Jon Ole
Do you have removed 'user public' (ID and kdnr = 2) ? You should not do this ...
Also don't remove usergroup 'public'. It must have also ID 2.
Both can be installed only directly on database (using phpMyAdmin or similar)
INSERT INTO user set ID=2, kdnr=2, groupID=2, name='public', firstname='user'
INSERT INTO usrgroup set ID=2, name='public area'
Password for user can be set via phPay's admin.
Or look into admin/doc/*.sql for complete SQL-command.
Greetings,
Andreas.
I wish it was as simple as that, both user public (id 2) and usergroup 'public area' with id 2 is in the database. Any other things I should check?
Regards,
Jon Ole
Normally the word 'login' is rplaced with username, if you are logged in. If nothing is visible, you are logged in and firstname and name is empty.
You can check 'user public's password ...
Or perhaps only color of word 'Login' is same as background? Look into generated HTML-Code ...
No other idea yet ...
If I make a link to reguser.php I get the login screen, and after a successful login the name is displayed in the left frame as you said. I have not changed anything after installation and I have checked that it is not a problem with the background color...
I'm not sure if this helps you understand what the problem might be....
Jon Ole