Should I give on Linux and go back to Microsoft???
I knew that would get your attention. But it may become reality because I don't seem to have the skill to solve this problem as I'm a Linux novice and my Win2K install works perfect. It would be a shame to give up on Linux in favor of Microsoft but it works on Microsoft. I have run out of ideas and need some help. I'm now well into my 4th day working on this problem and letting you know that I have done my research before posting and wasting your time hashing over ideas that have already been posted. I've tried implementing all the solutions outlined throughout this site and nothing works yet. I'm running RedHat 7.1. I installed the latest release of MySQL and have run every test in the manuals, the readme's and the conversation threads. Everything works perfectly. When I try to connect with either MySQLGUI or PHP I get the error: Can't connect to local MySQL server though socket (111) I telnet in and it tells me that MySQL is running MySQL shows up in my active processes so it is definately running I can manage the database from MySQLAdmin I've ensured that the mysql.sock exists in var/lib/mysql. I've created the link in the /tmp/ folder. I've updated the my.cnf file I've reset all permissions on those files to chmod 777 I've allowed group nobody in permission to database directory and files as well as my.cfg and both mysql.sock files (in tmp and var/lib) I've tried setting my.cfg, and mysql.sock permissions in various configurations including user:mysql and group:mysql and made sure that apache user was a member of group mysql and vice versa. I also used chmod 777 on both (although I'm not exactly sure I used it correctly). I also modified the PHP ini file although I also can't connect from MySQLGUI and I don't believe it uses PHP (it looks like Java, but I can't be sure). Just in case I tried the PHP.ini file anyway. No luck. etc. etc. etc... As I stated, the MySQL is running and everything tests fine from MySQLAdmin. Yes, I checked the socket entry and tried both /tmp/mysql.sock as well as /var/lib/mysql/mysql.sock (both exist so I thought I'de try both). Since most threaded conversations on this board deal with this issue I have spent most of my time here. But I really starting to think this is a permissions problem but I'm not good enough on Linux to figure it out. I think Apache can't get access to the socket or mysql.optons file. I can't even get MySQLGUI to connect yet everything works from MySQLAdmin without any problems. I'm targeting the permissions just because both MySQLGUI and PHP fail. When I connect with the MySQLGUI client is first gives me the can't connect to 111 error. Then if I choose options and change localhost to 127.0.0.1 and add mysql in the default database, it then tells me that I don't have permissions to change /root/.mysqlgui/mysql.options. Then when I try to connect and it requests my password, it then tell me Apache does not have permission to access the MySQL database. I don't see any of these problems from PHP, I actually get absolutely no response at all. I can't even get a failure on die for a failed connection attempt. Anyone run into permission problems before? Any help would be appreciated - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connection Problem - We're almost there...
I recently wrote in that I've tried everything in the book to connect to MySQL but I'm still getting the infamous socket (111) error. I've had a few good suggestions and I think we are almost there. Here's where I am. With MySQLGUI trying to connect, I changed the host from localhost to 127.0.0.1 in my.cnf. Now I get Host apache is not allowed to connect to this MySQL database. (I call my server apache) Any ideas now? Seems to me to definately relate to a permissions problem. Thanks everyone, for all your help. I need it. Cheers, Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: configure with mysql
I have the exact problem. If anyone has a step by step for a newbie I'd appreciate it as well. Cheers, Randy - Original Message - From: Jason Radley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 14, 2001 9:06 AM Subject: configure with mysql I have installed redhat linux 7.1 with apache, php and mysql but when installed redhat it didn't add the configure --with-mysql it added --without-mysql is there any way to change this to configure --with-mysql. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: configure with mysql
I've tried that to no avail. Everything on my system works perfectly except for this. The MySQL website indicates the following: --- Error: Fatal error: Call to unsupported or undefined function mysql_connect() in .. This means that your PHP version isn't compiled with MySQL support. You can either compile a dynamic MySQL module and load it into PHP or recompile PHP with built-in MySQL support. This is described in detail in the PHP manual. --- Yet I can't find those instructions. Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: configure with mysql
You're a good man Charlie Brown!!!. You were right on the money. I found the module on CD2, loaded it, rebooted the server and I was off to the races. Works perfectly. Life is good when you get good advice. Thanks. - Original Message - From: Trond Eivind Glomsrød [EMAIL PROTECTED] To: Dr. Randy Frid [EMAIL PROTECTED] Cc: Jason Radley [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, September 14, 2001 10:54 AM Subject: Re: configure with mysql Dr. Randy Frid [EMAIL PROTECTED] writes: I've tried that to no avail. Everything on my system works perfectly except for this. The MySQL website indicates the following: Tried what? There is a specific php-mysql module. When you install that (restart of apache may also be necesarry), it works. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Same Sockets problem for MySQLGUI but with a different twist.
First - I read the Readme file several times. Second - I went though your listserv where you very politely redirect everyone to the Readme file Third - I'm a newbe to linux and MySQL (Microsoft'er looking for the other world) and I don't know what a socket file would be called or where I would find it. I've searched the drive using whereis and looking for sock or socket but I don't find anything. Could anyone take mercy on a Win2K geek and give me step by step instructions on finding or building this sockets file. Maybe I'll convert completely one day :-) Cheers, Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
