Announcement

Collapse
No announcement yet.

MySQL Database Errors - db_mysql line 37

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL Database Errors - db_mysql line 37

    I am running VB 2.0 RC2, and randomly getting that error....when i do a view source, it tells me

    Database error in vBulletin: Link-ID == false, connect failed
    mysql error:
    mysql error number:
    Date: Monday 30th of April 2001 08:02:17 PM


    Any ideas ?

  • #2
    Usually means MySQL's used all it's connections. Up the max_connections setting in MySQL and/or turn off persistant connections in your config.php

    Comment


    • #3
      How do I up the max connection in Mysql ? I am running FreeBSD

      Comment


      • #4
        you have to activate the database

        Comment


        • #5
          hey

          go edit your my.ini file and put set-variable=max_connections=1000

          Comment


          • #6
            1,000?!?!?

            Comment


            • #7
              hehe

              i use that amount and mysql people said u can :P

              Comment


              • #8
                What´s the advantage/disadvantage of turning off persisant connections? I got this error once, but don´t have a dedicated server. That´s why I can´t up max_connections.

                Comment


                • #9
                  I am seeing a smiliar error
                  Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in <b>/home/theriver/public_html/forum/admin/db_mysql.php</b> on line <b>38</b><br>

                  <!-- Database error in vBulletin: Link-ID == false, connect failed
                  mysql error:
                  mysql error number:
                  Date: Sunday 24th of June 2001 09:44:21 PM
                  Script: /forum/index.php
                  Referer: http://128.241.204.148/
                  max connections in my.cnf is set at 500
                  Off-Road Forum

                  Comment


                  • #10
                    Anyone have any other ideas?
                    Off-Road Forum

                    Comment


                    • #11
                      My cpanel has this in it (new version)

                      Connection string for PHP

                      $dbh=mysql_connect ("localhost", "discussa_discuss", "<PASSWORD HERE>") or die ('I cannot connect to the database.');
                      mysql_select_db ("discussa_forum");

                      Would this have anything to do with it.
                      Off-Road Forum

                      Comment


                      • #12
                        That has nothing to do with max_connections -- it most likely means your MySQL server is down. Alternatively, it's possible the socket got wiped out -- if you enter the IP instead of localhost and you can connect, that is what happened.

                        Comment


                        • #13
                          My host resolved it. They had to go into /tmp under the root telnet and enter the following command:

                          ln -s /var/lib/mysql/mysql.sock mysql.sock

                          I don't know what it does, but it worked. They said it created a symlink to mysql.
                          Off-Road Forum

                          Comment

                          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                          Working...
                          X