Re: MySQL is not working on PHP with Fedora 16

2012-01-25 Thread Paul W. Frields
On Tue, Jan 24, 2012 at 08:03:00PM -0600, Fedora Linux wrote: Yes... it appeared a popup with SELinux errors, I opened it and shows: SELinux is preventing /usr/sbin/httpd from connectto access on the unix_stream_socket /var/lib/mysql/mysql.sock. * Plugin catchall (100. confidence)

Re: MySQL is not working on PHP with Fedora 16

2012-01-24 Thread Fedora Linux
Hello $ ps -eZ | grep mysql unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 5859 pts/1 00:00:00 mysqld_safe unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 5985 pts/1 00:00:00 mysqld I have installed these MySQL packages (Fedora 16 x64): mysql-connector-odbc-5.1.8-3.fc16.x86_64

Re: MySQL is not working on PHP with Fedora 16

2012-01-24 Thread Fedora Linux
Yes... it appeared a popup with SELinux errors, I opened it and shows: SELinux is preventing /usr/sbin/httpd from connectto access on the unix_stream_socket /var/lib/mysql/mysql.sock. * Plugin catchall (100. confidence) suggests *** If you believe that httpd should

Re: MySQL is not working on PHP with Fedora 16

2012-01-24 Thread Joe Zeff
On 01/24/2012 06:03 PM, Fedora Linux wrote: So I guess it has blocked the access, I tried a command to allow access that posted another user on my thread, but didn't work... How can I unlock it? I've never used SELinux... The SELinux error message you quoted tells you exactly how to correct

Re: MySQL is not working on PHP with Fedora 16

2012-01-24 Thread bruce
umm jeff... i think he was looking for reassurance (not condescension) as to the actions he has to take, or exactly what he has to type to resolve the issue. he simply doesn't want to f up his box... --- for the mysql issue.. it appears that selinux is blocking the

Re: MySQL is not working on PHP with Fedora 16

2012-01-24 Thread Joe Zeff
On 01/24/2012 07:25 PM, bruce wrote: umm jeff... First off, my name is not, never has been and never will be Jeff. Please don't do that again. i think he was looking for reassurance (not condescension) as to the actions he has to take, or exactly what he has to type to resolve the issue.

Re: MySQL is not working on PHP with Fedora 16

2012-01-24 Thread bruce
ok jeff.. no.. now that i've stopped laughing... my bad,, multiple email threads.. On Tue, Jan 24, 2012 at 10:34 PM, Joe Zeff j...@zeff.us wrote: On 01/24/2012 07:25 PM, bruce wrote: umm jeff... First off, my name is not, never has been and never will be Jeff. Please don't do that

Re: MySQL is not working on PHP with Fedora 16

2012-01-24 Thread Joe Zeff
On 01/24/2012 08:22 PM, bruce wrote: ok jeff.. Well, one thing's sure: you don't want any help from me and you're not going to get it. *Plonk!* -- users mailing list users@lists.fedoraproject.org To unsubscribe or change subscription options:

Re: MySQL is not working on PHP with Fedora 16

2012-01-24 Thread Frank Murphy
On 25/01/12 02:03, Fedora Linux wrote: grep /usr/sbin/httpd /var/log/audit/audit.log | audit2allow -M mypol Comments are mine. Do the following in a terminal: grep /usr/sbin/httpd /var/log/audit/audit.log | audit2allow -M mypol ## it's better to change mypol to something more related like

Re: MySQL is not working on PHP with Fedora 16

2012-01-24 Thread Pete Travis
For cases where I can't (be bothered to take the time to) find the proper context and end up using this method, I make a habit of moving/flushing audit.log then recreating the specific issue. This way, nothing unexpected slips by. I probably should be paying more attention to what's in there,

Re: MySQL is not working on PHP with Fedora 16

2012-01-24 Thread Frank Murphy
On 25/01/12 06:36, Pete Travis wrote: For cases where I can't (be bothered to take the time to) find the proper context and end up using this method, I make a habit of moving/flushing audit.log then recreating the specific issue. This way, nothing unexpected slips by. I probably should be

Re: MySQL is not working on PHP with Fedora 16

2012-01-23 Thread Fedora Linux
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,

Re: MySQL is not working on PHP with Fedora 16

2012-01-23 Thread Fedora Linux
# setsebool httpd_can_network_connect_db on I have just tried, but still does not work: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) Any other idea? Connecting manually it works $ mysql -u root -h localhost -p Enter password: Welcome to the MySQL

Re: MySQL is not working on PHP with Fedora 16

2012-01-23 Thread Daniel J Walsh
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/23/2012 01:22 PM, Fedora Linux wrote: # setsebool httpd_can_network_connect_db on I have just tried, but still does not work: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) Any other idea?

Re: MySQL is not working on PHP with Fedora 16

2012-01-23 Thread bruce
umm... exactly what/how do you attempt to access mysql through the php app? are you sure you used to exact same attributes when you access mysql from the cli? what do the mysql log files say? On Mon, Jan 23, 2012 at 1:05 PM, Fedora Linux fedorali...@toursbymexico.com wrote: Hello By

Re: MySQL is not working on PHP with Fedora 16

2012-01-23 Thread bruce
are you running selinux? On Mon, Jan 23, 2012 at 1:05 PM, Fedora Linux fedorali...@toursbymexico.com wrote: 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

Re: MySQL is not working on PHP with Fedora 16

2012-01-22 Thread Mike Wright
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

Re: MySQL is not working on PHP with Fedora 16

2012-01-22 Thread Reindl Harald
Am 22.01.2012 18:28, schrieb Mike Wright: 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]

Re: MySQL is not working on PHP with Fedora 16

2012-01-22 Thread bruce
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

Re: MySQL is not working on PHP with Fedora 16

2012-01-22 Thread Kernel Guardian
by default apache can't make a connection to DB. setsebool httpd_can_network_connect_db on for permanent change add -P as param to setsebool for all selinux apache attributes: getsebool -a | grep httpd or man page man httpd_selinux /var/lib/mysql/mysql.sock is a valid TCP socket with domain