By amsterdamcraig on

Hi, I've uploaded the directory (and accompanying sub directories and files) 'as is' into my public html folder but keep receiving the following errors:-

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

Warning: conf_init(./sites/default/settings.php): failed to open stream: Permission denied in /home/dategene/public_html/includes/bootstrap.inc on line 243

Warning: conf_init(): Failed opening './sites/default/settings.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/dategene/public_html/includes/bootstrap.inc on line 243

Warning: Cannot modify header information - headers already sent by (output started at /home/dategene/public_html/includes/bootstrap.inc:243) in /home/dategene/public_html/includes/bootstrap.inc on line 531

Warning: Cannot modify header information - headers already sent by (output started at /home/dategene/public_html/includes/bootstrap.inc:243) in /home/dategene/public_html/includes/bootstrap.inc on line 532

Warning: Cannot modify header information - headers already sent by (output started at /home/dategene/public_html/includes/bootstrap.inc:243) in /home/dategene/public_html/includes/bootstrap.inc on line 533

Warning: Cannot modify header information - headers already sent by (output started at /home/dategene/public_html/includes/bootstrap.inc:243) in /home/dategene/public_html/includes/bootstrap.inc on line 534

Warning: Cannot modify header information - headers already sent by (output started at /home/dategene/public_html/includes/bootstrap.inc:243) in /home/dategene/public_html/includes/common.inc on line 141

"In your ./sites/default/settings.php file you have configured Drupal to use a server, however your PHP installation currently does not support this database type.

The Drupal installer requires write permissions to ./sites/default/settings.php during the installation process. "

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

I've set full permissions on the settings.php file (421 - the permissions format my host uses) but still I cannot get past these errors :-(

My host is running the latest php and phpMyAdmin 2.7.0-pl2 which shows that some fields have been created in the database.

Maybe I picked a bad week to stop smoking.....

Can anyone help me out or should I give up now?

thanks!

Craig

Comments

cog.rusty’s picture

cog.rusty commented

421 means 7, but it doesn't say much.
Did you apply it to the owner, to the group, and to the world?

amsterdamcraig’s picture

amsterdamcraig commented

Hi Cog.rusty,

I did not realise that about the permissions - a change to 777 has got me further, thank-you.

Alas now, I see the message:

"We were unable to lock a test table on your MySQL database server. We tried locking a table with the command LOCK TABLES drupal_install_test WRITE and MySQL reported the following error: Access denied for user: 'dategene_admin@localhost' to database 'dategene_thanks'."

Should I have edited something do you think?

Craig

cog.rusty’s picture

cog.rusty commented

According to INSTALL.mysql.txt you need to grant LOCK TABLES permission to your database user:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE
TEMPORARY TABLES, LOCK TABLES
ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';

and if you are doing it on the command line and not in a cpanel, also FLUSH PRIVILEGES; after that.

Some host don't allow LOCK TABLES and CREATE TEMPORARY TABLES.
With some other hosts, you need to ask.
If it is not a community site where many users edit stuff, it is possible that it won't cause any problems.

amsterdamcraig’s picture

amsterdamcraig commented

I contacted my host (ipowerwebs) for information and they thought it might be the drupal install script at first (they also offered to unlock tables for me which I agreed....so I'm guessing they do not allow LOCK TABLES command by default - a warning for any other newbies out there!)

After flushing the tables from within MySQLAmin and then deleting them (duplicate error displayed post database connection) Drupal set-up loaded!

Hoorah!

Thanks again for your help Cog.rusty!

Craig