mysql_pconnect() after installation and admin login not working

[crizza2000]

Hi all

First of all i'm a complete N00b when it comes to PHP, MySQL etc, but am an experienced HTML, CSS web designer so please be kind.

After a successful installation, though steps 1-5 (or 6?)  i try to log into the CMS using the login information inputted at one of the steps and get the following error(s) appear at the top of the login page:

----------------

Warning: mysql_pconnect(): Access denied for user: 'cms@localhost' (Using password: YES) in E:\webroot\cms\lib\adodb\drivers\adodb-mysql.inc.php on line 356

Warning: Cannot modify header information - headers already sent by (output started at E:\webroot\cms\lib\adodb\drivers\adodb-mysql.inc.php:356) in E:\webroot\cms\admin\lang.php on line 67

Warning: Cannot modify header information - headers already sent by (output started at E:\webroot\cms\lib\adodb\drivers\adodb-mysql.inc.php:356) in E:\webroot\cms\admin\login.php on line 129

Warning: Cannot modify header information - headers already sent by (output started at E:\webroot\cms\lib\adodb\drivers\adodb-mysql.inc.php:356) in E:\webroot\cms\admin\login.php on line 130

--------------------------

can't seem to login, have tried re-installing the CMS with different details but the same denial of access to the user called "CMS" is displayed as part of the error.. Any help would be greatly appreciated.

I'm Using MySQL 4 & PHP 4 & Apache

thanks in advance

[Ted]

Set persistent_db_conn to false in your config.php.  Your host must not allow peristant database connections.

[iNSiPiD]

I don't have a persistent_db_conn setting in my config.php file.

I added it though and there was no change.

This happens every time my ISP upgrades or patches mySQL. I now have 4 sites down on the same domain due to this problem. Eek!

[Ted]

This setting only work on 0.10, I believe.  You have to modify include.php if still on 0.9.2...

[Crizza2000]

OK thanks for fast feedback.

I'm going to try and see if that fixes the problem tonight.

What modification are you referring to in the include.php WISHY ?

[Ted]

Change pconnect to connect in include.php and it won't use persistent connections.

[crizza2000]

Still no joy, got the exact same error message.

I changed the value in the include.php from pConnect to connect

This is what my config.php looks like:

root_path = "E:/webroot/cms/";
persistent_db_conn = false;


?>

Seems a little short to me, is it supposed to be this concise ?? This is the only config.php file in the directory i am using (e:\webroot\cms).

Any more ideas ?

[Ted]

Yeah, install must've failed also.  When install starts, it puts one line into it.  After it's finished, it puts the rest.  Though, if install fails because it couldn't connect to the database, it should've given you a decent error message.

I would try a reinstall with a clean config.php.

[crizza2000]

Well i tried a clean install and i get the same errors as above when logging in. On STEP 5 of the installation i get a long list of 'creating this and creating that' with the value [done] next to it. At the bottom however i get the following:

Creating version table...[done]

Importing initial data...Invalid query: INSERT INTO cms_content ( CONTENT_ID, CONTENT_NAME, TYPE, OWNER_ID, PARENT_ID, TEMPLATE_ID, ITEM_ORDER, HIERARCHY, DEFAULT_CONTENT, MENU_TEXT, CONTENT_ALIAS, SHOW_IN_MENU, MARKUP, ACTIVE, CACHABLE, LAST_MODIFIED_BY, CREATE_DATE, MODIFIED_DATE ) VALUES ( 1, 'CMS Install Successful!', 'content', 1, -1, 1, 1, '00001', '1', 'Home Page', 'cms-install-successful-', '1', 'html', '1', '1', 1, '2005-05-17 08:10:45', '2005-05-17 08:10:45' );

is this anything to do with the problems i am getting ?

Deleted my config.php but the new one created is just the same 1 line of code as mentioned above.

I'm slowly going bald with frustration !!!!!!

[Ted]

I think I'm going to have to add some code to the install routine to check the database connection before moving on.  Something is definatly not right, and I have no idea what it is.  The query itself looks right, which makes me think it never created the cms_content in the first place...