Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

drupal issues

wmmk

wmmk

macrumors 68020
Original poster
Mar 28, 2006
2,414
0
The Library.
i'm trying to install drupal on my server, and it keeps saying that it can't connect to my database. This is what I get:
Unable to connect to database server

This either means that the username and password information in your settings.php file is incorrect or we can't contact the MySQL database server. This could mean your hosting provider's database server is down.

The MySQL error was: Access denied for user 'root'@'localhost' (using password: YES).

Currently, the username is root and the database server is localhost.

Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.


The weird thing is that I never told it to use the password YES in the config file. This is really odd. Please help.
 
It's not actually using the password as "YES" it's saying that the script *sent* it a password but that it failed.

Check the config and make sure you are using the correct password in it.
 
Squareball said:
It's not actually using the password as "YES" it's saying that the script *sent* it a password but that it failed.

Check the config and make sure you are using the correct password in it.
Click to expand...
thanks, i actually did have the password wrong. still, i am getting errors.
 
Warning: Table 'mysql.drupalsessions' doesn't exist query: SELECT sid FROM drupalsessions WHERE sid = '9d2f042596df3f5f016bcc0eec9deb51' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalusers' doesn't exist query: SELECT u.* FROM drupalusers u WHERE u.uid = 0 in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /Library/WebServer/Documents/includes/database.mysql.inc:120) in /Library/WebServer/Documents/includes/bootstrap.inc on line 750

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /Library/WebServer/Documents/includes/database.mysql.inc:120) in /Library/WebServer/Documents/includes/bootstrap.inc on line 750

Warning: Table 'mysql.drupalaccess' doesn't exist query: SELECT * FROM drupalaccess WHERE status = 1 AND type = 'host' AND LOWER('::1') LIKE LOWER(mask) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalaccess' doesn't exist query: SELECT * FROM drupalaccess WHERE status = 0 AND type = 'host' AND LOWER('::1') LIKE LOWER(mask) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalcache' doesn't exist query: SELECT data, created, headers, expire FROM drupalcache WHERE cid = 'variables' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalvariable' doesn't exist query: SELECT * FROM drupalvariable in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalcache' doesn't exist query: LOCK TABLES drupalcache WRITE in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalcache' doesn't exist query: UPDATE drupalcache SET data = 'N;', created = 1152648000, expire = 0, headers = '' WHERE cid = 'variables' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalurl_alias' doesn't exist query: SELECT COUNT(pid) FROM drupalurl_alias in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Cannot modify header information - headers already sent by (output started at /Library/WebServer/Documents/includes/database.mysql.inc:120) in /Library/WebServer/Documents/includes/common.inc on line 139.', 2, '', 'http://localhost/', '', '::1', 1152648001) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT name, filename, throttle, bootstrap FROM drupalsystem WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648001) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT filename FROM drupalsystem WHERE name = 'filter' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648001) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT filename FROM drupalsystem WHERE name = 'node' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648001) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT filename FROM drupalsystem WHERE name = 'system' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648001) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT filename FROM drupalsystem WHERE name = 'user' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648001) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT filename FROM drupalsystem WHERE name = 'watchdog' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648002) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalcache' doesn't exist\nquery: SELECT data, created, headers, expire FROM drupalcache WHERE cid = 'menu::en' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalrole' doesn't exist\nquery: SELECT DISTINCT(p.perm) FROM drupalrole r INNER JOIN drupalpermission p ON p.rid = r.rid WHERE r.rid IN (1) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT * FROM drupalsystem WHERE type = 'theme' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120
 
Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalcache' doesn't exist\nquery: LOCK TABLES drupalcache WRITE in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalcache' doesn't exist\nquery: UPDATE drupalcache SET data = 'a:4:{s:10:\\"path index\\";a:44:{s:13:\\"admin/filters\\";i:-1;s:18:\\"admin/filters/list\\";i:-2;s:17:\\"admin/filters/add\\";i:-3;s:20:\\"admin/filters/delete\\";i:-4;s:11:\\"filter/tips\\";i:-5;s:10:\\"admin/node\\";i:-6;s:19:\\"admin/node/overview\\";i:-7;s:19:\\"admin/settings/node\\";i:-8;s:28:\\"admin/settings/content-types\\";i:-9;s:4:\\"node\\";i:-10;s:8:\\"node/add\\";i:-11;s:7:\\"rss.xml\\";i:-12;s:12:\\"system/files\\";i:-13;s:5:\\&qu in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Cannot modify header information - headers already sent by (output started at /Library/WebServer/Documents/includes/database.mysql.inc:120) in /Library/WebServer/Documents/includes/common.inc on line 139.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalsystem' doesn't exist\nquery: SELECT * FROM drupalsystem WHERE type = 'theme' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table 'mysql.drupalurl_alias' doesn't exist\nquery: SELECT COUNT(pid) FROM drupalurl_alias in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table &#039;mysql.drupalwatchdog&#039; doesn&#039;t exist\nquery: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, &#039;access denied&#039;, &#039;<em>node</em> denied access.&#039;, 1, &#039;<a href=\\"/?q=node\\" class=\\"active\\">view</a>&#039;, &#039;http://localhost/&#039;, &#039;&#039;, &#039;::1&#039;, 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table &#039;mysql.drupalurl_alias&#039; doesn&#039;t exist\nquery: SELECT COUNT(pid) FROM drupalurl_alias in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120
 
Access denied

warning: Cannot modify header information - headers already sent by (output started at /Library/WebServer/Documents/includes/database.mysql.inc:120) in /Library/WebServer/Documents/includes/common.inc on line 139.
user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT name, filename, throttle, bootstrap FROM drupalsystem WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT filename FROM drupalsystem WHERE name = 'filter' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT filename FROM drupalsystem WHERE name = 'node' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT filename FROM drupalsystem WHERE name = 'system' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT filename FROM drupalsystem WHERE name = 'user' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT filename FROM drupalsystem WHERE name = 'watchdog' AND type = 'module' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
user warning: Table 'mysql.drupalcache' doesn't exist query: SELECT data, created, headers, expire FROM drupalcache WHERE cid = 'menu::en' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
user warning: Table 'mysql.drupalrole' doesn't exist query: SELECT DISTINCT(p.perm) FROM drupalrole r INNER JOIN drupalpermission p ON p.rid = r.rid WHERE r.rid IN (1) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT * FROM drupalsystem WHERE type = 'theme' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
user warning: Table 'mysql.drupalcache' doesn't exist query: LOCK TABLES drupalcache WRITE in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
 
user warning: Table 'mysql.drupalcache' doesn't exist query: UPDATE drupalcache SET data = 'a:4:{s:10:\"path index\";a:44:{s:13:\"admin/filters\";i:-1;s:18:\"admin/filters/list\";i:-2;s:17:\"admin/filters/add\";i:-3;s:20:\"admin/filters/delete\";i:-4;s:11:\"filter/tips\";i:-5;s:10:\"admin/node\";i:-6;s:19:\"admin/node/overview\";i:-7;s:19:\"admin/settings/node\";i:-8;s:28:\"admin/settings/content-types\";i:-9;s:4:\"node\";i:-10;s:8:\"node/add\";i:-11;s:7:\"rss.xml\";i:-12;s:12:\"system/files\";i:-13;s:5:\"admin\";i:-14;s:12:\"admin/themes\";i:-15;s:19:\"admin/themes/select\";i:-16;s:21:\"admin/themes/settings\";i:-17;s:28:\"admin/themes/settings/global\";i:-18;s:14:\"admin/settings\";i:-19;s:13:\"admin/modules\";i:-20;s:4:\"user\";i:-21;s:17:\"user/autocomplete\";i:-22;s:10:\"user/login\";i:-23;s:13:\"user/register\";i:-24;s:13:\"user/password\";i:-25;s:10:\"user/reset\";i:-26;s:9:\"user/help\";i:-27;s:10:\"admin/user\";i:-28;s:15:\"admin/user/list\";i:-29;s:17:\"admin/user/create\";i:-30;s:19:\"admin/settings/user\";i:-31;s:12:\"admin/access\";i:-32;s:24:\"admin/access/permissions\";i:-33;s:18:\"admin/access/roles\";i:-34;s:23:\"admin/access/roles/edit\";i:-35;s:18:\"admin/access/rules\";i:-36;s:23:\"admin/access/rules/list\";i:-37;s:22:\"admin/access/rules/add\";i:-38;s:24:\"admin/access/rules/check\";i:-39;s:23:\"admin/access/rules/edit\";i:-40;s:25:\"admin/access/rules/delete\";i:-41;s:6:\"logout\";i:-42;s:10:\"admin/logs\";i:-43;s:16:\"admin/logs/event\";i:-44;}s:5:\"items\";a:46:{i:0;a:5:{s:4:\"path\";s:0:\"\";s:5:\"title\";s:0:\"\";s:4:\"type\";i:1;s:3:\"pid\";i:1;s:8:\"children\";a:1:{i:0;i:1;}}i:1;a:7:{s:3:\"pid\";i:0;s:4:\"path\";s:0:\"\";s:5:\"title\";s:10:\"Navigation\";s:6:\"weight\";i:-50;s:6:\"access\";b:1;s:4:\"type\";i:3;s:8:\"children\";a:7:{i:0;i:-5;i:1;i:-10;i:2;i:-12;i:3;i:-13;i:4;i:-14;i:5;i:-21;i:6;i:-42;}}i:-1;a:7:{s:4:\"path\";s:13:\"admin/filters\";s:5:\"title\";s:13:\"input formats\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;s:8:\"children\";a:3:{i:0;i:-2;i:1;i:-3;i:2;i:-4;}}i:-2;a:6:{s:4:\"path\";s:18:\"admin/filters/list\";s:5:\"title\";s:4:\"list\";s:4:\"type\";i:640;s:6:\"access\";b:0;s:6:\"weight\";i:0;s:3:\"pid\";i:-1;}i:-3;a:6:{s:4:\"path\";s:17:\"admin/filters/add\";s:5:\"title\";s:16:\"add input format\";s:4:\"type\";i:128;s:6:\"weight\";i:1;s:6:\"access\";b:0;s:3:\"pid\";i:-1;}i:-4;a:6:{s:4:\"path\";s:20:\"admin/filters/delete\";s:5:\"title\";s:19:\"delete input format\";s:4:\"type\";i:4;s:6:\"access\";b:0;s:6:\"weight\";i:0;s:3:\"pid\";i:-1;}i:-5;a:6:{s:4:\"path\";s:11:\"filter/tips\";s:5:\"title\";s:12:\"compose tips\";s:6:\"access\";b:1;s:4:\"type\";i:20;s:6:\"weight\";i:0;s:3:\"pid\";i:1;}i:-6;a:7:{s:4:\"path\";s:10:\"admin/node\";s:5:\"title\";s:7:\"content\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;s:8:\"children\";a:1:{i:0;i:-7;}}i:-7;a:5:{s:4:\"path\";s:19:\"admin/node/overview\";s:5:\"title\";s:4:\"list\";s:4:\"type\";i:640;s:6:\"weight\";i:-10;s:3:\"pid\";i:-6;}i:-8;a:6:{s:4:\"path\";s:19:\"admin/settings/node\";s:5:\"title\";s:5:\"posts\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-19;}i:-9;a:6:{s:4:\"path\";s:28:\"admin/settings/content-types\";s:5:\"title\";s:13:\"content types\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-19;}i:-10;a:7:{s:4:\"path\";s:4:\"node\";s:5:\"title\";s:7:\"content\";s:6:\"access\";b:0;s:4:\"type\";i:16;s:6:\"weight\";i:0;s:3:\"pid\";i:1;s:8:\"children\";a:1:{i:0;i:-11;}}i:-11;a:6:{s:4:\"path\";s:8:\"node/add\";s:5:\"title\";s:14:\"create content\";s:6:\"access\";b:0;s:4:\"type\";i:28;s:6:\"weight\";i:1;s:3:\"pid\";i:-10;}i:-12;a:6:{s:4:\"path\";s:7:\"rss.xml\";s:5:\"title\";s:8:\"rss feed\";s:6:\"access\";b:0;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:1;}i:-13;a:6:{s:4:\"path\";s:12:\"system/files\";s:5:\"title\";s:13:\"file download\";s:6:\"access\";b:1;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:1;}i:-14;a:7:{s:4:\"path\";s:5:\"admin\";s:5:\"title\";s:10:\"administer\";s:6:\"access\";b:0;s:6:\"weight\";i:9;s:4:\"type\";i:22;s:8:\"children\";a:8:{i:0;i:-1;i:1;i:-6;i:2;i:-15;i:3;i:-19;i:4;i:-20;i:5;i:-28;i:6;i:-32;i:7;i:-43;}s:3:\"pid\";i:1;}i:-15;a:7:{s:4:\"path\";s:12:\"admin/themes\";s:5:\"title\";s:6:\"themes\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;s:8:\"children\";a:2:{i:0;i:-16;i:1;i:-17;}}i:-16;a:6:{s:4:\"path\";s:19:\"admin/themes/select\";s:5:\"title\";s:4:\"list\";s:6:\"access\";b:0;s:4:\"type\";i:640;s:6:\"weight\";i:-1;s:3:\"pid\";i:-15;}i:-17;a:7:{s:4:\"path\";s:21:\"admin/themes/settings\";s:5:\"title\";s:9:\"configure\";s:6:\"access\";b:0;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-15;s:8:\"children\";a:1:{i:0;i:-18;}}i:-18;a:6:{s:4:\"path\";s:28:\"admin/themes/settings/global\";s:5:\"title\";s:15:\"global settings\";s:6:\"access\";b:0;s:4:\"type\";i:640;s:6:\"weight\";i:-1;s:3:\"pid\";i:-17;}i:-19;a:7:{s:4:\"path\";s:14:\"admin/settings\";s:5:\"title\";s:8:\"settings\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:8:\"children\";a:3:{i:0;i:-8;i:1;i:-9;i:2;i:-31;}s:3:\"pid\";i:-14;}i:-20;a:6:{s:4:\"path\";s:13:\"admin/modules\";s:5:\"title\";s:7:\"modules\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;}i:-21;a:7:{s:4:\"path\";s:4:\"user\";s:5:\"title\";s:12:\"user account\";s:6:\"access\";b:1;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:1;s:8:\"children\";a:6:{i:0;i:-22;i:1;i:-23;i:2;i:-24;i:3;i:-25;i:4;i:-26;i:5;i:-27;}}i:-22;a:6:{s:4:\"path\";s:17:\"user/autocomplete\";s:5:\"title\";s:17:\"user autocomplete\";s:6:\"access\";b:0;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-21;}i:-23;a:5:{s:4:\"path\";s:10:\"user/login\";s:5:\"title\";s:6:\"log in\";s:4:\"type\";i:640;s:6:\"weight\";i:0;s:3:\"pid\";i:-21;}i:-24;a:6:{s:4:\"path\";s:13:\"user/register\";s:5:\"title\";s:8:\"register\";s:6:\"access\";b:1;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-21;}i:-25;a:6:{s:4:\"path\";s:13:\"user/password\";s:5:\"title\";s:20:\"request new password\";s:6:\"access\";b:1;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-21;}i:-26;a:6:{s:4:\"path\";s:10:\"user/reset\";s:5:\"title\";s:14:\"reset password\";s:6:\"access\";b:1;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-21;}i:-27;a:5:{s:4:\"path\";s:9:\"user/help\";s:5:\"title\";s:4:\"help\";s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-21;}i:-28;a:7:{s:4:\"path\";s:10:\"admin/user\";s:5:\"title\";s:5:\"users\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;s:8:\"children\";a:2:{i:0;i:-29;i:1;i:-30;}}i:-29;a:5:{s:4:\"path\";s:15:\"admin/user/list\";s:5:\"title\";s:4:\"list\";s:4:\"type\";i:640;s:6:\"weight\";i:-10;s:3:\"pid\";i:-28;}i:-30;a:6:{s:4:\"path\";s:17:\"admin/user/create\";s:5:\"title\";s:8:\"add user\";s:6:\"access\";b:0;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-28;}i:-31;a:5:{s:4:\"path\";s:19:\"admin/settings/user\";s:5:\"title\";s:5:\"users\";s:4:\"type\";i:22;s:6:
 
\"weight\";i:0;s:3:\"pid\";i:-19;}i:-32;a:7:{s:4:\"path\";s:12:\"admin/access\";s:5:\"title\";s:14:\"access control\";s:6:\"access\";b:0;s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;s:8:\"children\";a:3:{i:0;i:-33;i:1;i:-34;i:2;i:-36;}}i:-33;a:6:{s:4:\"path\";s:24:\"admin/access/permissions\";s:5:\"title\";s:11:\"permissions\";s:6:\"access\";b:0;s:4:\"type\";i:640;s:6:\"weight\";i:-10;s:3:\"pid\";i:-32;}i:-34;a:7:{s:4:\"path\";s:18:\"admin/access/roles\";s:5:\"title\";s:5:\"roles\";s:6:\"access\";b:0;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-32;s:8:\"children\";a:1:{i:0;i:-35;}}i:-35;a:6:{s:4:\"path\";s:23:\"admin/access/roles/edit\";s:5:\"title\";s:9:\"edit role\";s:6:\"access\";b:0;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-34;}i:-36;a:7:{s:4:\"path\";s:18:\"admin/access/rules\";s:5:\"title\";s:12:\"access rules\";s:6:\"access\";b:0;s:4:\"type\";i:128;s:6:\"weight\";i:10;s:3:\"pid\";i:-32;s:8:\"children\";a:5:{i:0;i:-37;i:1;i:-38;i:2;i:-39;i:3;i:-40;i:4;i:-41;}}i:-37;a:6:{s:4:\"path\";s:23:\"admin/access/rules/list\";s:5:\"title\";s:4:\"list\";s:6:\"access\";b:0;s:4:\"type\";i:640;s:6:\"weight\";i:-10;s:3:\"pid\";i:-36;}i:-38;a:6:{s:4:\"path\";s:22:\"admin/access/rules/add\";s:5:\"title\";s:8:\"add rule\";s:6:\"access\";b:0;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-36;}i:-39;a:6:{s:4:\"path\";s:24:\"admin/access/rules/check\";s:5:\"title\";s:11:\"check rules\";s:6:\"access\";b:0;s:4:\"type\";i:128;s:6:\"weight\";i:0;s:3:\"pid\";i:-36;}i:-40;a:6:{s:4:\"path\";s:23:\"admin/access/rules/edit\";s:5:\"title\";s:9:\"edit rule\";s:6:\"access\";b:0;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-36;}i:-41;a:6:{s:4:\"path\";s:25:\"admin/access/rules/delete\";s:5:\"title\";s:11:\"delete rule\";s:6:\"access\";b:0;s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-36;}i:-42;a:6:{s:4:\"path\";s:6:\"logout\";s:5:\"title\";s:7:\"log out\";s:6:\"access\";b:0;s:6:\"weight\";i:10;s:4:\"type\";i:22;s:3:\"pid\";i:1;}i:-43;a:6:{s:4:\"path\";s:10:\"admin/logs\";s:5:\"title\";s:4:\"logs\";s:4:\"type\";i:22;s:6:\"weight\";i:0;s:3:\"pid\";i:-14;s:8:\"children\";a:1:{i:0;i:-44;}}i:-44;a:5:{s:4:\"path\";s:16:\"admin/logs/event\";s:5:\"title\";s:7:\"details\";s:4:\"type\";i:4;s:6:\"weight\";i:0;s:3:\"pid\";i:-43;}}s:9:\"callbacks\";a:41:{s:13:\"admin/filters\";a:1:{s:8:\"callback\";s:21:\"filter_admin_overview\";}s:18:\"admin/filters/list\";a:1:{s:8:\"callback\";s:21:\"filter_admin_overview\";}s:17:\"admin/filters/add\";a:1:{s:8:\"callback\";s:24:\"filter_admin_format_form\";}s:20:\"admin/filters/delete\";a:1:{s:8:\"callback\";s:19:\"filter_admin_delete\";}s:11:\"filter/tips\";a:1:{s:8:\"callback\";s:16:\"filter_tips_long\";}s:10:\"admin/node\";a:1:{s:8:\"callback\";s:16:\"node_admin_nodes\";}s:19:\"admin/settings/node\";a:1:{s:8:\"callback\";s:14:\"node_configure\";}s:28:\"admin/settings/content-types\";a:1:{s:8:\"callback\";s:20:\"node_types_configure\";}s:4:\"node\";a:1:{s:8:\"callback\";s:9:\"node_page\";}s:8:\"node/add\";a:1:{s:8:\"callback\";s:9:\"node_page\";}s:7:\"rss.xml\";a:1:{s:8:\"callback\";s:9:\"node_feed\";}s:12:\"system/files\";a:1:{s:8:\"callback\";s:13:\"file_download\";}s:5:\"admin\";a:1:{s:8:\"callback\";s:17:\"watchdog_overview\";}s:12:\"admin/themes\";a:1:{s:8:\"callback\";s:13:\"system_themes\";}s:19:\"admin/themes/select\";a:1:{s:8:\"callback\";s:13:\"system_themes\";}s:21:\"admin/themes/settings\";a:1:{s:8:\"callback\";s:21:\"system_theme_settings\";}s:28:\"admin/themes/settings/global\";a:1:{s:8:\"callback\";s:21:\"system_theme_settings\";}s:14:\"admin/settings\";a:1:{s:8:\"callback\";s:20:\"system_site_settings\";}s:13:\"admin/modules\";a:1:{s:8:\"callback\";s:14:\"system_modules\";}s:4:\"user\";a:1:{s:8:\"callback\";s:10:\"user_login\";}s:17:\"user/autocomplete\";a:1:{s:8:\"callback\";s:17:\"user_autocomplete\";}s:10:\"user/login\";a:1:{s:8:\"callback\";s:10:\"user_login\";}s:13:\"user/register\";a:1:{s:8:\"callback\";s:13:\"user_register\";}s:13:\"user/password\";a:1:{s:8:\"callback\";s:9:\"user_pass\";}s:10:\"user/reset\";a:1:{s:8:\"callback\";s:15:\"user_pass_reset\";}s:9:\"user/help\";a:1:{s:8:\"callback\";s:14:\"user_help_page\";}s:10:\"admin/user\";a:1:{s:8:\"callback\";s:10:\"user_admin\";}s:17:\"admin/user/create\";a:1:{s:8:\"callback\";s:10:\"user_admin\";}s:19:\"admin/settings/user\";a:1:{s:8:\"callback\";s:14:\"user_configure\";}s:12:\"admin/access\";a:1:{s:8:\"callback\";s:15:\"user_admin_perm\";}s:24:\"admin/access/permissions\";a:1:{s:8:\"callback\";s:15:\"user_admin_perm\";}s:18:\"admin/access/roles\";a:1:{s:8:\"callback\";s:15:\"user_admin_role\";}s:23:\"admin/access/roles/edit\";a:1:{s:8:\"callback\";s:15:\"user_admin_role\";}s:18:\"admin/access/rules\";a:1:{s:8:\"callback\";s:17:\"user_admin_access\";}s:22:\"admin/access/rules/add\";a:1:{s:8:\"callback\";s:21:\"user_admin_access_add\";}s:24:\"admin/access/rules/check\";a:1:{s:8:\"callback\";s:23:\"user_admin_access_check\";}s:23:\"admin/access/rules/edit\";a:1:{s:8:\"callback\";s:22:\"user_admin_access_edit\";}s:25:\"admin/access/rules/delete\";a:1:{s:8:\"callback\";s:24:\"user_admin_access_delete\";}s:6:\"logout\";a:1:{s:8:\"callback\";s:11:\"user_logout\";}s:10:\"admin/logs\";a:1:{s:8:\"callback\";s:17:\"watchdog_overview\";}s:16:\"admin/logs/event\";a:1:{s:8:\"callback\";s:14:\"watchdog_event\";}}s:7:\"visible\";a:2:{i:1;a:5:{s:5:\"title\";s:10:\"Navigation\";s:4:\"path\";s:0:\"\";s:8:\"children\";a:0:{}s:4:\"type\";i:3;s:3:\"pid\";i:0;}i:0;a:4:{s:5:\"title\";s:0:\"\";s:4:\"path\";s:0:\"\";s:8:\"children\";a:1:{i:0;i:1;}s:4:\"type\";i:1;}}}', created = 1152648003, expire = 1152734403, headers = '' WHERE cid = 'menu::en' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
warning: Cannot modify header information - headers already sent by (output started at /Library/WebServer/Documents/includes/database.mysql.inc:120) in /Library/WebServer/Documents/includes/common.inc on line 139.
user warning: Table 'mysql.drupalsystem' doesn't exist query: SELECT * FROM drupalsystem WHERE type = 'theme' in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
user warning: Table 'mysql.drupalurl_alias' doesn't exist query: SELECT COUNT(pid) FROM drupalurl_alias in /Library/WebServer/Documents/includes/database.mysql.inc on line 120. user warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'access denied', '<em>node</em> denied access.', 1, '<a href=\"/?q=node\" class=\"active\">view</a>', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
user warning: Table 'mysql.drupalurl_alias' doesn't exist query: SELECT COUNT(pid) FROM drupalurl_alias in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.
 
You are not authorized to access this page.

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table &#039;mysql.drupalsessions&#039; doesn&#039;t exist\nquery: SELECT sid FROM drupalsessions WHERE sid = &#039;9d2f042596df3f5f016bcc0eec9deb51&#039; in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120

Warning: Table 'mysql.drupalwatchdog' doesn't exist query: INSERT INTO drupalwatchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Table &#039;mysql.drupalsessions&#039; doesn&#039;t exist\nquery: INSERT INTO drupalsessions (sid, uid, cache, hostname, session, timestamp) VALUES (&#039;9d2f042596df3f5f016bcc0eec9deb51&#039;, 0, 0, &#039;::1&#039;, &#039;&#039;, 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120.', 2, '', 'http://localhost/', '', '::1', 1152648003) in /Library/WebServer/Documents/includes/database.mysql.inc on line 120
 
Every one of those errors stems from this

You don't have a database table named "mysql.drupalsessions" which is what Drupal is looking for. So maybe you missed a step where drupal creates this or maybe you have to create it yourself? I've never actually setup drual before
 
Squareball said:
Every one of those errors stems from this

You don't have a database table named "mysql.drupalsessions" which is what Drupal is looking for. So maybe you missed a step where drupal creates this or maybe you have to create it yourself? I've never actually setup drual before
Click to expand...
ah, yes. you're right again. I'm supposed to do this:

// $Id: INSTALL.mysql.txt,v 1.6 2006/04/17 20:48:25 dries Exp $

CONTENTS OF THIS FILE
---------------------

* Introduction
* Installation and configuration:
- Database and user creation
- Drupal schema loading

INTRODUCTION
------------

This file describes how to create a MySQL database for Drupal.

If you control your databases through a web-based control panel,
check its documentation, as the following instructions are for the
command line only.

INSTALLATION AND CONFIGURATION
------------------------------

1. CREATE THE DRUPAL DATABASE

This step is only necessary if you don't already have a database
set-up (e.g. by your host). In the following examples, 'dba_user' is
an example MySQL user which has the CREATE and GRANT privileges. Use
the appropriate user name for your system.

First, you must create a new database for your Drupal site
(here, 'databasename' is the name of the new database):

mysqladmin -u dba_user -p create databasename

MySQL will prompt for the 'dba_user' database password and then create
the initial database files. Next you must login and set the access
database rights:

mysql -u dba_user -p

Again, you will be asked for the 'dba_user' database password.
At the MySQL prompt, enter following command:

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

where

'databasename' is the name of your database
'username@localhost' is the username of your MySQL account
'password' is the password required for that username

Note: Unless your database user has all of the privileges listed
above, you will not be able to run Drupal.

If successful, MySQL will reply with:

Query OK, 0 rows affected

To activate the new permissions, enter the following command:

FLUSH PRIVILEGES;

2. LOAD THE DRUPAL DATABASE SCHEMA

Once you have a database, you must load the required tables into it.
Depending on the version of MySQL you are using, you must use the
file 'database.4.0.mysql' (for MySQL 4.0 or lower) or
'database.4.1.mysql' (for MySQL 4.1 or higher). Both files are
located in Drupal's database directory.

If you use a web-based control panel, you should be able to upload
the appropriate file and run it directly as SQL commands.

From the command line, use (again, replacing 'username' and
'databasename' with your MySQL username and database name):

for MySQL 4.0 or lower:
mysql -u username -p databasename < database/database.4.0.mysql

for MySQL 4.1 or higher:
mysql -u username -p databasename < database/database.4.1.mysql


So, how do I do this? In english? I feel like such a n00b today:eek:
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back