Posted on: 05/24/10 04:13pm
By: rg1
This may not be the appropriate place to ask this question, however since it is affected my GL install, it may. I just build a brand new FC12 server.
Im trying to copy over my GL 1.3 config to it. The mysql is running on a separate server. I am able to hit the mysql server form the command line with mysql -h, however I keep getting cant connect to db on website. I dont think the issue is specific to GL, because my test mysql_connect() script is failing too. Im not sure what is going on. PHP itself is working, I see that the mysql.ini is being parsed, but I dont see mysql in list of loaded modules.
Not sure where to go from here...
apache2.2.14
PHP 5.3.2
GL 1.3
Thanks..
-Rob
Re: mysql_connect() failed. PHP / MYSQL issue?
Posted on: 05/27/10 09:23am
By: rg1
I blew away the server...reinstalled FC12. removed all RPMs for httpd* mysql* php* and compiled everything from source. I have tested that I can now connect to remote sql server. Prior to this, I did try to install all RPMs for httpd* mysql* php*, however this did not resolve mysql_connect() issue.
Re: mysql_connect() failed. PHP / MYSQL issue?
Posted on: 05/27/10 02:41pm
By: justrage
Can you access the server from another site? I would suggest making a quick sql query / db connection string in a test file and see if that can connect to confirm if its the DB, webserver or geeklog.
Re: mysql_connect() failed. PHP / MYSQL issue?
Posted on: 05/28/10 01:57am
By: Habitual
Quote by: justrageCan you access the server from another site? I would suggest making a quick sql query / db connection string in a test file and see if that can connect to confirm if its the DB, webserver or geeklog.
<?php
$link = mysql_connect('hostname.com', 'username', 'password'
;
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully' ;
mysql_close($link);
?>
save and exit
php -f file.php (enter)
Re: mysql_connect() failed. PHP / MYSQL issue?
Posted on: 05/28/10 01:58am
By: Habitual
Quote by: justrageCan you access the server from another site? I would suggest making a quick sql query / db connection string in a test file and see if that can connect to confirm if its the DB, webserver or geeklog.
<?php
$link = mysql_connect('hosname.com', 'username', 'password'
;
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully' ;
mysql_close($link);
?>
save and exit
php -f file.php (enter)