MySQL Database Errors - db_mysql line 37

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • freaky
    Senior Member
    • Jul 2000
    • 329
    • 3.5.x

    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 ?
  • Mike Sullivan
    Former vBulletin Developer
    • Apr 2000
    • 13327
    • 3.6.x

    #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

    • freaky
      Senior Member
      • Jul 2000
      • 329
      • 3.5.x

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

      Comment

      • RiffMaster
        Member
        • Apr 2001
        • 37

        #4
        you have to activate the database

        Comment

        • SeAsTaR
          New Member
          • May 2001
          • 4

          #5
          hey

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

          Comment

          • bira
            Senior Member
            • May 2000
            • 1498

            #6
            1,000?!?!?

            Comment

            • SeAsTaR
              New Member
              • May 2001
              • 4

              #7
              hehe

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

              Comment

              • EXCHANGE
                Senior Member
                • Feb 2001
                • 129

                #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

                • dunefreak
                  Senior Member
                  • Oct 2000
                  • 221

                  #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

                  • dunefreak
                    Senior Member
                    • Oct 2000
                    • 221

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

                    Comment

                    • dunefreak
                      Senior Member
                      • Oct 2000
                      • 221

                      #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

                      • Mike Sullivan
                        Former vBulletin Developer
                        • Apr 2000
                        • 13327
                        • 3.6.x

                        #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

                        • dunefreak
                          Senior Member
                          • Oct 2000
                          • 221

                          #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...