Re: MySQL is not working on PHP with Fedora 16

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello

By command line I am able to connect normally, so the problem is not MySQL... I use "mysql -u root -h localhost -p" and it works... Note that the application also uses root since it must create the database and a user for the application...

I have tried to restart MySQL and the whole system, but it still does not connect from PHP

The error is:
[error] [client ::1] PHP Warning:  mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /var/www/html/install2.php on line 22, referer: http://localhost/install.php

So I guess the problem is in the PHP, Apache or on the interface between MySQL and Apache/PHP...

Any other suggestion?

Regards

On Sun, Jan 22, 2012 at 12:04 PM, bruce <badouglas@xxxxxxxxx> wrote:
hi...

ok.. basic debug stuff.. skip if you've already done..
-using the user/passwd.. can you access mysql from the cmdline..
   [i assume you can]
-what are the permissions on the mysql db/tbls? have they changed?
--did you stop/restart mysql?
-what do the mysql logs say?

let us know..


On Sun, Jan 22, 2012 at 12:28 PM, Mike Wright <mike.wright@xxxxxxxxxxxxxx> wrote:
On 01/22/2012 07:02 AM, Fedora Linux wrote:
Hello

I have a web application but it is not working on my Fedora 16 with PHP,
for some reason it is unable to connect to the MySQL server, it returns
the error:

[Sun Jan 22 08:40:24 2012] [error] [client ::1] PHP Warning:
 mysql_connect(): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13) in /var/www/html/install2.php on line
22, referer: http://localhost/install.php

Notice that the user/password is correct, the PHP is installed and
working and MySQL is up and running...

Even the socket is there

# ls -l /var/lib/mysql/mysql.sock
srwxrwxrwx. 1 mysql mysql 0 Jan 22 08:37 /var/lib/mysql/mysql.sock

What can be the problem? The application is okay, I am using it in a
production server and it is running in 2 other local computers (with
slackware) for testing purposes...

This is the first time that I can't connect to MySQL via PHP... I don't
know if it requires an extra configuration or there is a missing package
that I should install... the httpd log does not give more details...

Thanks for any help!

Do you have port 3306 open on your firewall?




--
users mailing list
users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Have a question? Ask away: http://ask.fedoraproject.org


--
users mailing list
users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Have a question? Ask away: http://ask.fedoraproject.org


-- 
users mailing list
users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Have a question? Ask away: http://ask.fedoraproject.org
[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [EPEL Devel]     [Fedora Magazine]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Desktop]     [Fedora Fonts]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Fedora Sparc]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux