white_2kgt
Thu 30th Oct '03, 4:45pm
We are upgrading from phpBB2 to vB. Since Beta 7 needs XML support in php I had to
recompile php with xml support. I have gotten php and apache running on new versions
but left MySQL untouched. Now my problem is on Step 3 I get this error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in
/var/www/html/forums/includes/db_mysql.php on line 333
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/var/www/html/forums/includes/db_mysql.php on line 334
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/var/www/html/forums/includes/db_mysql.php on line 133
The Source is:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>vBulletin 3 Install Script Step 2) Connect to the database</title>
<link rel="stylesheet" href="../cpstyles/vBulletin_3_Default/controlpanel.css" />
<style type="text/css">
#all {
margin: 10px;
}
#all p, #all td, #all li, #all div {
font-size: 11px;
font-family: verdana, arial, helvetica, sans-serif;
}
</style>
</head>
<body style="margin:0px">
<table cellpadding="4" cellspacing="0" border="0" width="100%" class="navbody"
style="border:outset 2px">
<tr>
<td width="160">
<img src="../cpstyles/vBulletin_3_Default/cp_logo.gif"
alt="" title="vBulletin 3 ©2003 Jelsoft Enterprises Ltd." /></td>
<td style="padding-left:100px">
<b>vBulletin 3 Install Script</b><br />
(Please be patient as some parts may take some time)<br />
<br />
<b style="font-size:10pt;">Step 2) Connect to the database</b> (Step 2 of 13)</td>
</tr>
</table>
<div id="all">
<p style="font-size:10pt;"><b><u>Step 2) Connect to the database</u></b></p>
<p>Attempting to attach to database</p><br />
<b>Warning</b>: mysql_error(): supplied argument is not a
valid MySQL-Link resource in <b>/var/www/html/forums/includes/db_mysql.php</b> on
line <b>333</b><br />
<br />
<b>Warning</b>: mysql_errno(): supplied argument is not a
valid MySQL-Link resource in <b>/var/www/html/forums/includes/db_mysql.php</b> on
line <b>334</b><br />
<br />
<b>Warning</b>: mysql_errno(): supplied argument is not a
valid MySQL-Link resource in <b>/var/www/html/forums/includes/db_mysql.php</b> on
line <b>133</b><br />
<p><font size="+1" color="red"><b>The database has failed to connect because you do
not have permission to connect to the server.
Please confirm
the values entered in the 'includes/config.php' file.</b>
</font></p> </div>
<form action="install.php" method="get" name="nextStep">
<input type="hidden" name="step" value="3" />
<table cellpadding="4" cellspacing="0" border="0" width="100%" class="navbody"
style="padding:4px; border:outset 2px;">
<tr align="center">
<td>vBulletin ©2000-2003 Jelsoft Enterprises Ltd.</td>
<td></td>
</tr>
</table>
</form>
</div>
<!-- START CONTROL PANEL FOOTER -->
<p align="center"><a href="http://www.vbulletin.com/" target="_blank" class="copyright"></a></p>
</div>
</body>
</html>
The connection info in config.php is correct, the source of that file is
<?php
/*================================================= =====================*\
|| ################################################## ################## ||
|| # vBulletin 3.0.0 Beta 7 - Licence Number L10700b2
|| # ---------------------------------------------------------------- # ||
|| # All PHP code in this file is ©2000-2003 Jelsoft Enterprises Ltd. # ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||
|| # http://www.vbulletin.com (http://www.vbulletin.com/) | http://www.vbulletin.com/license.html # ||
|| ################################################## ################## ||
\*================================================ ======================*/
/*-------------------------------------------------------*\
| ****** NOTE REGARDING THE VARIABLES IN THIS FILE ****** |
+---------------------------------------------------------+
| If you get any errors while attempting to connect to |
| MySQL, you will need to email your webhost because we |
| cannot tell you the correct values for the variables |
| in this file. |
\*-------------------------------------------------------*/
// ****** DATABASE SERVER NAME ******
// This is the hostname or IP address of the database server.
// It is in the format HOST:PORT. If no PORT is specified, 3306 is used.
// If you are unsure of what to put here, leave it at the default value.
$servername = 'localhost';
// ****** DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$dbusername = 'user';
$dbpassword = 'name';
// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$dbname = 'phpbb_db';
// ****** TECHNICAL EMAIL ADDRESS ******
// If any database errors occur, they will be emailed to the address specified here.
// Leave this blank to not send any emails when there is a database error.
$technicalemail = 'chad@2kgt.com';
// ****** PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off.
// 0 = Off; 1 = On
$usepconnect = 0;
// ****** PATH TO ADMIN & MODERATOR CONTROL PANELS ******
// This setting allows you to change the name of the folders that the admin and
// moderator control panels reside in. You may wish to do this for security purposes.
// Please note that if you change the name of the directory here, you will still need
// to manually change the name of the directory on the server.
$admincpdir = 'admincp';
$modcpdir = 'modcp';
// ****** USERS WITH ADMIN LOG VIEWING PERMISSIONS ******
// The users specified here will be allowed to view the admin log in the control panel.
// Users must be specified by *ID number* here. To obtain a user's ID number,
// view their profile via the control panel. If this is a new installation, leave
// the first user created will have a user ID of 1. Seperate each userid with a comma.
$canviewadminlog = '1';
// ****** USERS WITH ADMIN LOG PRUNING PERMISSIONS ******
// The users specified here will be allowed to remove ("prune") entries from the admin
// log. See the above entry for more information on the format.
$canpruneadminlog = '1';
// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = '';
// ****** UNDELETABLE / UNALTERABLE USERS ******
// The users specified here will not be deletable or alterable from the control panel by any users.
// To specify more than one user, separate userids with commas.
$undeletableusers = '1';
// ****** SUPER ADMINISTRATORS ******
// The users specified below will have permission to access the administrator permissions
// page, which controls the permissions of other administrators
$superadministrators = '';
// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix = 'vb3_';
/*================================================= =====================*\
|| ################################################## ##################
|| # Downloaded: 08:51, Tue Oct 28th 2003
|| # CVS: $RCSfile: config.php.new,v $ - $Revision: 1.18 $
|| ################################################## ##################
\*================================================ ======================*/
?>
I can connect to the database via the command line and our old board is still working
just fine so I know mySQL does not have a problem and my login info is correct. Also
when I shutdown the new apache server I can get to step 6?, where it dies on xml support
but when I switch to the new apache server the install dies on this step. Also I get
this error on vB 2.something where it use to work on the old version of my apache server.
Warning: mysql_connect():
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in
/var/www/html/forum/admin/db_mysql.php on line 40
I'm sure the error lies in the configuration of php or apache but I can't seem to
figure out what I did different/wrong on the new version of apache.
Please help,
--chad
recompile php with xml support. I have gotten php and apache running on new versions
but left MySQL untouched. Now my problem is on Step 3 I get this error.
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in
/var/www/html/forums/includes/db_mysql.php on line 333
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/var/www/html/forums/includes/db_mysql.php on line 334
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in
/var/www/html/forums/includes/db_mysql.php on line 133
The Source is:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>vBulletin 3 Install Script Step 2) Connect to the database</title>
<link rel="stylesheet" href="../cpstyles/vBulletin_3_Default/controlpanel.css" />
<style type="text/css">
#all {
margin: 10px;
}
#all p, #all td, #all li, #all div {
font-size: 11px;
font-family: verdana, arial, helvetica, sans-serif;
}
</style>
</head>
<body style="margin:0px">
<table cellpadding="4" cellspacing="0" border="0" width="100%" class="navbody"
style="border:outset 2px">
<tr>
<td width="160">
<img src="../cpstyles/vBulletin_3_Default/cp_logo.gif"
alt="" title="vBulletin 3 ©2003 Jelsoft Enterprises Ltd." /></td>
<td style="padding-left:100px">
<b>vBulletin 3 Install Script</b><br />
(Please be patient as some parts may take some time)<br />
<br />
<b style="font-size:10pt;">Step 2) Connect to the database</b> (Step 2 of 13)</td>
</tr>
</table>
<div id="all">
<p style="font-size:10pt;"><b><u>Step 2) Connect to the database</u></b></p>
<p>Attempting to attach to database</p><br />
<b>Warning</b>: mysql_error(): supplied argument is not a
valid MySQL-Link resource in <b>/var/www/html/forums/includes/db_mysql.php</b> on
line <b>333</b><br />
<br />
<b>Warning</b>: mysql_errno(): supplied argument is not a
valid MySQL-Link resource in <b>/var/www/html/forums/includes/db_mysql.php</b> on
line <b>334</b><br />
<br />
<b>Warning</b>: mysql_errno(): supplied argument is not a
valid MySQL-Link resource in <b>/var/www/html/forums/includes/db_mysql.php</b> on
line <b>133</b><br />
<p><font size="+1" color="red"><b>The database has failed to connect because you do
not have permission to connect to the server.
Please confirm
the values entered in the 'includes/config.php' file.</b>
</font></p> </div>
<form action="install.php" method="get" name="nextStep">
<input type="hidden" name="step" value="3" />
<table cellpadding="4" cellspacing="0" border="0" width="100%" class="navbody"
style="padding:4px; border:outset 2px;">
<tr align="center">
<td>vBulletin ©2000-2003 Jelsoft Enterprises Ltd.</td>
<td></td>
</tr>
</table>
</form>
</div>
<!-- START CONTROL PANEL FOOTER -->
<p align="center"><a href="http://www.vbulletin.com/" target="_blank" class="copyright"></a></p>
</div>
</body>
</html>
The connection info in config.php is correct, the source of that file is
<?php
/*================================================= =====================*\
|| ################################################## ################## ||
|| # vBulletin 3.0.0 Beta 7 - Licence Number L10700b2
|| # ---------------------------------------------------------------- # ||
|| # All PHP code in this file is ©2000-2003 Jelsoft Enterprises Ltd. # ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||
|| # http://www.vbulletin.com (http://www.vbulletin.com/) | http://www.vbulletin.com/license.html # ||
|| ################################################## ################## ||
\*================================================ ======================*/
/*-------------------------------------------------------*\
| ****** NOTE REGARDING THE VARIABLES IN THIS FILE ****** |
+---------------------------------------------------------+
| If you get any errors while attempting to connect to |
| MySQL, you will need to email your webhost because we |
| cannot tell you the correct values for the variables |
| in this file. |
\*-------------------------------------------------------*/
// ****** DATABASE SERVER NAME ******
// This is the hostname or IP address of the database server.
// It is in the format HOST:PORT. If no PORT is specified, 3306 is used.
// If you are unsure of what to put here, leave it at the default value.
$servername = 'localhost';
// ****** DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$dbusername = 'user';
$dbpassword = 'name';
// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$dbname = 'phpbb_db';
// ****** TECHNICAL EMAIL ADDRESS ******
// If any database errors occur, they will be emailed to the address specified here.
// Leave this blank to not send any emails when there is a database error.
$technicalemail = 'chad@2kgt.com';
// ****** PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off.
// 0 = Off; 1 = On
$usepconnect = 0;
// ****** PATH TO ADMIN & MODERATOR CONTROL PANELS ******
// This setting allows you to change the name of the folders that the admin and
// moderator control panels reside in. You may wish to do this for security purposes.
// Please note that if you change the name of the directory here, you will still need
// to manually change the name of the directory on the server.
$admincpdir = 'admincp';
$modcpdir = 'modcp';
// ****** USERS WITH ADMIN LOG VIEWING PERMISSIONS ******
// The users specified here will be allowed to view the admin log in the control panel.
// Users must be specified by *ID number* here. To obtain a user's ID number,
// view their profile via the control panel. If this is a new installation, leave
// the first user created will have a user ID of 1. Seperate each userid with a comma.
$canviewadminlog = '1';
// ****** USERS WITH ADMIN LOG PRUNING PERMISSIONS ******
// The users specified here will be allowed to remove ("prune") entries from the admin
// log. See the above entry for more information on the format.
$canpruneadminlog = '1';
// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$canrunqueries = '';
// ****** UNDELETABLE / UNALTERABLE USERS ******
// The users specified here will not be deletable or alterable from the control panel by any users.
// To specify more than one user, separate userids with commas.
$undeletableusers = '1';
// ****** SUPER ADMINISTRATORS ******
// The users specified below will have permission to access the administrator permissions
// page, which controls the permissions of other administrators
$superadministrators = '';
// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix = 'vb3_';
/*================================================= =====================*\
|| ################################################## ##################
|| # Downloaded: 08:51, Tue Oct 28th 2003
|| # CVS: $RCSfile: config.php.new,v $ - $Revision: 1.18 $
|| ################################################## ##################
\*================================================ ======================*/
?>
I can connect to the database via the command line and our old board is still working
just fine so I know mySQL does not have a problem and my login info is correct. Also
when I shutdown the new apache server I can get to step 6?, where it dies on xml support
but when I switch to the new apache server the install dies on this step. Also I get
this error on vB 2.something where it use to work on the old version of my apache server.
Warning: mysql_connect():
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in
/var/www/html/forum/admin/db_mysql.php on line 40
I'm sure the error lies in the configuration of php or apache but I can't seem to
figure out what I did different/wrong on the new version of apache.
Please help,
--chad