Drupal 5 and mysql 4.0.16
jeanmichel - September 25, 2007 - 11:29
Hi,
I'm trying to install drupal on a vdeck host.
Seems like my drupal installation isn't able to connect with the mysql server on the first step of the configuration process.
That is, when i first run the install script, drupal is sending me the "Unable to connect to database server" page.
But my mysql server is running, my username and password are valid (i can connect to it with phpmyadmin) and my settings.php file has been configured with the right data.
So i was wondering if there was any known issue concerning drupal 5 trying to connect with a mysql version server 4.0.16?
thanks
You have mentioned that your
Don't know for MySQL 4.0.16, but drupal works just fine with MySQL 4.0.15 and MySQL 4.0.17.
You have mentioned that your username and password are valid, but what's with host.
In order to connect to mysql database, you have to define username, password and host (where mysql server is running).
Usually, it's localhost (if both web server and database server are on the same host)
---
Drupal Theme Garden
Drupal Hosting Article
thanks, as you were
thanks,
as you were suggesting, the host was wrong.
I'm use to dreamhost where your database server is another one than the domain host so i had to change the database server to "localhost" for this one.
But when i visited the site, right after that, a bunch of errors appeared.
Warning: Table 'mydb_db.access' doesn't exist query: SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND LOWER('72.0.212.221') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1 in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/mydb/public_html/includes/database.mysql.inc:172) in /home/mydb/public_html/includes/bootstrap.inc on line 862
Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/mydb/public_html/includes/database.mysql.inc:172) in /home/mydb/public_html/includes/bootstrap.inc on line 862
Warning: Table 'mydb_db.cache' doesn't exist query: SELECT data, created, headers, expire FROM cache WHERE cid = 'variables' in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Table 'mydb_db.variable' doesn't exist query: SELECT * FROM variable in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Access denied for user: 'mydb_user1@localhost' to database 'mydb_db' query: LOCK TABLES cache WRITE in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Table 'mydb_db.cache' doesn't exist query: UPDATE cache SET data = 'N;', created = 1190758382, expire = 0, headers = '' WHERE cid = 'variables' in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Table 'mydb_db.cache_page' doesn't exist query: SELECT data, created, headers, expire FROM cache_page WHERE cid = 'http://www.mydbnan.ca/' in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Cannot modify header information - headers already sent by (output started at /home/mydb/public_html/includes/database.mysql.inc:172) in /home/mydb/public_html/includes/bootstrap.inc on line 531
Warning: Cannot modify header information - headers already sent by (output started at /home/mydb/public_html/includes/database.mysql.inc:172) in /home/mydb/public_html/includes/bootstrap.inc on line 532
Warning: Cannot modify header information - headers already sent by (output started at /home/mydb/public_html/includes/database.mysql.inc:172) in /home/mydb/public_html/includes/bootstrap.inc on line 533
Warning: Cannot modify header information - headers already sent by (output started at /home/mydb/public_html/includes/database.mysql.inc:172) in /home/mydb/public_html/includes/bootstrap.inc on line 534
Warning: Table 'mydb_db.url_alias' doesn't exist query: SELECT COUNT(pid) FROM url_alias in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Table 'mydb_db.system' doesn't exist query: SELECT * FROM system WHERE type = 'theme' in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Table 'mydb_db.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Cannot modify header information - headers already sent by (output started at /home/mydb/public_html/includes/database.mysql.inc:172)</em> in <em>/home/mydb/public_html/includes/common.inc</em> on line <em>141</em>.', 2, '', 'http://www.mydbnan.ca/', '', '72.0.212.221', 1190758382) in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Table 'mydb_db.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &#039;mydb_db.system&#039; doesn&#039;t exist\nquery: SELECT name, filename, throttle FROM system WHERE type = &#039;module&#039; AND status = 1 ORDER BY weight ASC, filename ASC</em> in <em>/home/mydb/public_html/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.mydbnan.ca/', '', '72.0.212.221', 1190758382) in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Table 'mydb_db.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &#039;mydb_db.cache_menu&#039; doesn&#039;t exist\nquery: SELECT data, created, headers, expire FROM cache_menu WHERE cid = &#039;0:en&#039;</em> in <em>/home/mydb/public_html/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.mydbnan.ca/', '', '72.0.212.221', 1190758382) in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Table 'mydb_db.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Access denied for user: &#039;mydb_user1@localhost&#039; to database &#039;mydb_db&#039;\nquery: LOCK TABLES cache_menu WRITE</em> in <em>/home/mydb/public_html/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.mydbnan.ca/', '', '72.0.212.221', 1190758382) in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Table 'mydb_db.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &#039;mydb_db.cache_menu&#039; doesn&#039;t exist\nquery: UPDATE cache_menu SET data = &#039;a:4:{s:10:\\&quot;path index\\&quot;;a:0:{}s:5:\\&quot;items\\&quot;;a:2:{i:0;a:5:{s:4:\\&quot;path\\&quot;;s:0:\\&quot;\\&quot;;s:5:\\&quot;title\\&quot;;s:0:\\&quot;\\&quot;;s:4:\\&quot;type\\&quot;;i:1;s:3:\\&quot;pid\\&quot;;i:1;s:8:\\&quot;children\\&quot;;a:1:{i:0;i:1;}}i:1;a:6:{s:3:\\&quot;pid\\&quot;;i:0;s:4:\\&quot;path\\&quot;;s:0:\\&quot;\\&quot;;s:5:\\&quot;title\\&quot;;s:10:\\&quot;Navigation\\&quot;;s:6:\\&quot;weight\\&quo in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Table 'mydb_db.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Cannot modify header information - headers already sent by (output started at /home/mydb/public_html/includes/database.mysql.inc:172)</em> in <em>/home/mydb/public_html/includes/common.inc</em> on line <em>141</em>.', 2, '', 'http://www.mydbnan.ca/', '', '72.0.212.221', 1190758382) in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Table 'mydb_db.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &#039;mydb_db.watchdog&#039; doesn&#039;t exist\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, &#039;page not found&#039;, &#039;node&#039;, 1, &#039;&#039;, &#039;http://www.mydbnan.ca/&#039;, &#039;&#039;, &#039;72.0.212.221&#039;, 1190758382)</em> in <em>/home/mydb/public_html/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.mydbnan.ca/', '', '72.0.212.221', 1190758382) in /home/mydb/public_html/includes/database.mysql.inc on line 172
Fatal error: Call to undefined function: block_list() in /home/mydb/public_html/includes/theme.inc on line 1018
Warning: Table 'mydb_db.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &#039;mydb_db.sessions&#039; doesn&#039;t exist\nquery: SELECT sid FROM sessions WHERE sid = &#039;f809dd6f74be64ec64f443a6db2dc14e&#039;</em> in <em>/home/mydb/public_html/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.mydbnan.ca/', '', '72.0.212.221', 1190758382) in /home/mydb/public_html/includes/database.mysql.inc on line 172
Warning: Table 'mydb_db.watchdog' doesn't exist query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>Table &#039;mydb_db.sessions&#039; doesn&#039;t exist\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&#039;f809dd6f74be64ec64f443a6db2dc14e&#039;, 0, 0, &#039;72.0.212.221&#039;, &#039;messages|a:1:{s:5:\\&quot;error\\&quot;;a:7:{i:0;s:209:\\&quot;warning: Cannot modify header information - headers already sent by (output started at /home/mydb/public_html/includes/database.mysql.inc:172) in /home/mydb/public_html/includes/common.inc on line 141.\\&quot;;i:1;s:272:\\&quot;user warning: Table &amp;#039;mydb_db.system&amp;#039; doesn&amp;#039;t exist\\nquery: SELECT name, filename, throttle FROM system WHERE type = &amp;#0 in /home/mydb/public_html/includes/database.mysql.inc on line 172
Its my 5th drupal installation and it is the first time it happends to me.
Do you have any idea what the problem is?