Hey everyone ..
I decided to give a local installation of phpwcms a try, but I'm running into problems. After I open setup.php and press the 'i agree to license' button I am asked to fill in some info about the DB, USER etc...
I am using ;
- PHP 4.3.11
- Mysql 4.1
- Apache 2.0
I've made a database called 'db_phpwcms' and user-'user_phpwcms' and given this user ALL PRIVILEGES. Then ofcourse I flushed the privs.
In the setup screen I pressed 'create all tables' and left persistent connections off. Send DB DATA gives me the following errors :
Warning: mysql_connect(): Access denied for user 'user_phpwcms'@'localhost' (using password: YES) in C:\Program Files\Apache Group\Apache2\htdocs\phpwcms\setup\setup.php on line 55
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\Program Files\Apache Group\Apache2\htdocs\phpwcms\setup\setup.php on line 57
Next thing I decide to do is just insert my ROOT user data instead of user_phpwcms. Note: My root account locally is set to NO PASSWORD. What can be easier than that ? (Hey, this is just a test install, nothing important )
The Mysql Warnings are gone but still no cigar ... I am left with the message : Please proof your database settings. There might be some mistakes!
Can anyone help me out here ? What can I possibly be doing wrong ?
Thanks
Gdev..
Can't get past first step / screen ...
You should simply use whatever username/pass combo "actually" allows you to log in to the database. You have tried it after creating the MySQL account and password... CORRECT? Login and see if any tables have been created by the script (with a prepend, if you specified one)?
If 'user_phpwcms' and associated password does allow login... then you should be specifying them in setup and looking at the other settings.
not a valid MySQL-Link resource could be you have the path to the DB entered wrong, maybe?
If 'user_phpwcms' and associated password does allow login... then you should be specifying them in setup and looking at the other settings.
not a valid MySQL-Link resource could be you have the path to the DB entered wrong, maybe?
Yes, ofcourse... after creating the account, and after reloading the priviliges.You should simply use whatever username/pass combo "actually" allows you to log in to the database. You have tried it after creating the MySQL account and password... CORRECT? Login and see if any tables have been created by the script (with a prepend, if you specified one)?
The accounts *(and especially the root account) should log in .. I used the root account for multiple open source packages during install and after installation (osc, mambo / joomla to name a few...) wich all gave me no problem. So I don't really understand why phpwcms denying acces...
I've tried clicking persistent connections and that does let me go to screen 2 ... but why should I be obliged to use persistent connections ?
Gdev
Well gdev,
if you do not work local,if you do not have php as cgi on a normal webserver, you will not cry about this method ... less connections may be more
Only once in my life I saw my own phpwcms site with about 100 pple online.. working like a rocket.. as others had blank critical error pages...
if you do not work local,if you do not have php as cgi on a normal webserver, you will not cry about this method ... less connections may be more
Only once in my life I saw my own phpwcms site with about 100 pple online.. working like a rocket.. as others had blank critical error pages...
None of the above has ANYTHING to do with phpWCMS preventing you. All it does is call your database (at the address you gave it) and query it (with the user/pass that you gave it). It does not do any denying of access... it simply reports that it has been denied.gdev wrote:So I don't really understand why phpwcms denying acces...
I've tried clicking persistent connections and that does let me go to screen 2 ... but why should I be obliged to use persistent connections ?
Gdev