#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    3
    Rep Power
    0
    I have php4/mysql/apache installed and working together in solaris 2.7.

    When ever I try to send a query to the MySql database it gives the following error
    "Lost connection to MySQL server during query"

    I can do other stuff like create tables and databases and but sending a query is giving me problems.

    I searched through a forum and found someone else who encountered the same problem. he said that it was caused by the gcc version that was used to compile Php4. he said that gcc 2.8.1 is causing this error and the solution is to use gcc 2.91.x

    Before I ask my sysadmin to update gcc I want make sure that this the solution to the problem. If you know of any other way that the above error can be resolved i appreciate you insight

    Shabbir

    [This message has been edited by patels24 (edited June 22, 2000).]
  2. #2
  3. No Profile Picture
    Dave Bryant
    Guest
    Devshed Newbie (0 - 499 posts)
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by patels24:
    [b]I have php4/mysql/apache installed and working together in solaris 2.7.

    When ever I try to send a query to the MySql database it gives the following error
    "Lost connection to MySQL server during query"
    [/quote]

    Try using persistant connections or if already doing this try the other type.

    ------------------


    [This message has been edited by Dave Bryant (edited June 22, 2000).]
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    3
    Rep Power
    0
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by Dave Bryant:
    Try using persistant connections or if already doing this try the other type.
    [/quote]


    I tried what you suggested by changing the setting in the php.ini file and then shutdown and restarted my apache server but the changes dont take effect. I looked at phpinfo() and still shows that persistent connections are allowed.

    could tell what i am doing wrong. thank you

    I appreciate your help

    SHabbir


    [This message has been edited by patels24 (edited June 22, 2000).]
  6. #4
  7. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493
    I had this same exact problem with apache, php, and solaris. for us, it was solved by re-compiling php and specifing the path to mysql when doing so (giving the path in the command line, i assume. i'm not sure what flag that is...)

    I didn't actually do the compiling, as you can probably tell...but this solved our problem..

    ---John Holmes

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 07:02 PM
  2. Custom error message for MySQL connection
    By dbr1066 in forum PHP Development
    Replies: 6
    Last Post: February 12th, 2004, 12:25 PM
  3. java / mysql connection
    By johann8401 in forum Java Help
    Replies: 2
    Last Post: February 9th, 2004, 01:27 PM
  4. MySQL Select query
    By MrTee1 in forum MySQL Help
    Replies: 0
    Last Post: January 30th, 2004, 12:16 PM
  5. mysql server looses connection
    By Webbgroup in forum MySQL Help
    Replies: 1
    Last Post: January 29th, 2004, 12:19 PM

IMN logo majestic logo threadwatch logo seochat tools logo