Announcement

Collapse
No announcement yet.

Database error issues / wrong email

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

  • Database error issues / wrong email

    I have a couple of issues I cannot seem to get to the bottom of. When attempting to backup one of my VB databases I get the error for to many connections. For some reason it lists the wrong IP address and it emails to the wrong address and for the life of me I cannot find where to change the email address notification. I've went through vb options numerous times.

    Somewhere I must have typed in .chm instead of .com ...but I cannot find where. VB is using that address to send me database errors. Here is the email error:
    ----- The following addresses had permanent fatal errors -----
    <[email protected]>
    (reason: 550 Host unknown)


    Here is the database error: (Note the IP address is wrong, and at 4:19 am I can't imagine to many users on to use up what VB is calling to many connections.)

    Database error in vBulletin :

    mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too
    many connections
    /home/forumsforums/public_html/3_9/includes/class_core.php on line 311

    MySQL Error :
    Error Number :
    Request Date : Friday, December 4th 2009 @ 04:19:52 AM
    Error Date : Friday, December 4th 2009 @ 04:19:52 AM
    Script : http://www.forumsforums.com/3_9/misc...posted&t=11327
    Referrer :
    IP Address : 67.195.115.223
    Username :
    Classname : vB_Database
    MySQL Version :
    http://www.netcookingtalk.com/forums/


  • #2
    67.195.115.223 - this belongs to Yahoo Slurp Spider so is a valid IP address

    Too Many Connections - The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off by ensuring this is set in your config.php:

    Code:
     // ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
     // This option allows you to turn persistent connections to MySQL on or off.
     // The difference in performance is negligible for all but the largest boards.
     // If you are unsure what this should be, leave it off. (0 = off; 1 = on)
    $config['MasterServer']['usepconnect'] = 0;
    But if you still have problems after that, you will need ask your host to raise the maximum number of connections they allow.

    Here is more info on that error: http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html

    Email Address - Check the settings in AdminCP > vBulletin Options > Site Name / URL / Contact Details
    Last edited by Trevor Hannant; Fri 4 Dec '09, 4:03am.
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...

    Comment


    • #3
      I have a little more info that might help ...or confuse the issue.
      I have a backup script that backs up all the VB databases at 4am. It backs up one DB, sleeps for 15 seconds thens starts backup up the next DB in line. During the backup of Forums Forums, the VB database listed in the 1st post, I got an email saying one of the other databases had the exact same too many connections error and it referenced the same line of code as mentioned in the error message in the 1st post (line 311). I thought the backup was at issue, but perhaps that is not the case.
      http://www.netcookingtalk.com/forums/

      Comment


      • #4
        Thanks Trevster. I didn't see your reply until after I had posted my above reply with more info. Your reply confirms my fear that it is partially a system issue. I am my own host ... so I'll have to find that particular setting on how to up the connections. I have plenty of resourse available. No other performance issues.

        The other forum that I got the to many connections on is not busy in the least, and it was not being backed up. So, does backing up the DB normally open a lot of connections to the database?
        What would be the affect of turning off persistent connections?
        http://www.netcookingtalk.com/forums/

        Comment


        • #5
          All persistant connections do is take up system resources when they aren't needed. With persistant connections off, the database connection is released once a forum page is finished loading. With persistant connections on, the connection is maintained.
          Vote for:

          - *Admin Settable Paid Subscription Reminder Timeframe*
          -
          *PM - Add ability to reply to originator only*
          - Add Admin ability to auto-subscribe users to specific channel(s)
          - "Quick Route" Interface...

          Comment


          • #6
            Thanks Trevor. Sounds like an easy fix with no down side.

            Any clue on how I might track down where I typo'd the email address to be notifed of database errors?
            http://www.netcookingtalk.com/forums/

            Comment


            • #7
              From my first post:

              AdminCP > vBulletin Options > Site Name / URL / Contact Details
              Vote for:

              - *Admin Settable Paid Subscription Reminder Timeframe*
              -
              *PM - Add ability to reply to originator only*
              - Add Admin ability to auto-subscribe users to specific channel(s)
              - "Quick Route" Interface...

              Comment


              • #8
                Thanks again Trevor but the site contact in that area is correct. Still I get these messges sent to webmaster .....chm instead of com.

                That section of VB options does also mention sendmessage.php and I checked that for having the wrong address inside of it (per chance) and it is not there.
                I've grep'd all files in my forums and have not found any that have the [email protected] address. So it has be baffled.
                Any other ideas?

                (note: I hate where the previous thread /next thread buttons are, as they are where submit post/post reply used to be in 3.x ...VB 4.0 is going to take some getting used to)
                http://www.netcookingtalk.com/forums/

                Comment


                • #9
                  Doh!! Stupid me...

                  What's in the config.php file:

                  $config['Database']['technicalemail']
                  Vote for:

                  - *Admin Settable Paid Subscription Reminder Timeframe*
                  -
                  *PM - Add ability to reply to originator only*
                  - Add Admin ability to auto-subscribe users to specific channel(s)
                  - "Quick Route" Interface...

                  Comment


                  • #10
                    No, DUH, Stupid me. THAT WAS IT!!!! Thank You sir!!!!! It had been driving me bonkers.
                    I appreciate all your help!!!!!!!!

                    I would give you more reps but they want me to spread it around more first.
                    http://www.netcookingtalk.com/forums/

                    Comment


                    • #11
                      I finally found the persistent connections setting (in my config.php file DUH) and it is already turned off.
                      Any pointers on where to find the setting for up'ing mysql connections?

                      edit to add:
                      max connections should be in the mysql.conf file ....right?
                      http://www.netcookingtalk.com/forums/

                      Comment


                      • #12
                        Followup. Guess there is no mysql.conf or mysqld.conf file.
                        From the link trevor provided in the 2nd post I found the following info and tried adding that to my OS (centOS):

                        /etc/sysctl.conf: # Increase some values for MySQL
                        fs.file-max = 65536
                        fs.dquot-max = 8192
                        fs.super-max = 1024
                        NOTE: after editing the sysctl.conf file you must run sysctl -p to have the new values read in.

                        You should also add the following to /etc/my.cnf:
                        [mysqld_safe]
                        open-files-limit=8192

                        Two of the values would not take. Both
                        fs.dquot-max = 8192 and
                        fs.super-max = 1024
                        were not recognized by the kernel. I left the other settings in place and am hoping for the best.
                        Will update this ticket if this does not fix my problem of running out of DB connections.
                        http://www.netcookingtalk.com/forums/

                        Comment


                        • #13
                          After making the changes shown in the previous post I'm still gettting the Database error message saying:

                          mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too
                          many connections
                          ...../includes/class_core.php on line 311

                          I only get these errors at 4am when I am backing up the database. No other time.
                          Every day during the db backup I get these errors.
                          Any ideas on why I get the errors during the backup only, and what I can do to fix it?
                          http://www.netcookingtalk.com/forums/

                          Comment


                          • #14
                            What do you use for the backup? Is it 3rd party software?
                            Vote for:

                            - *Admin Settable Paid Subscription Reminder Timeframe*
                            -
                            *PM - Add ability to reply to originator only*
                            - Add Admin ability to auto-subscribe users to specific channel(s)
                            - "Quick Route" Interface...

                            Comment


                            • #15
                              No 3rd party stuff. Here is the command I use:

                              /usr/bin/mysqldump --opt -Q -u ******* -p****** forumsforums > /home/*******/bkup_1.sql

                              **'s replace site specific stuff, otherwise this is how the mysqldump runs.
                              http://www.netcookingtalk.com/forums/

                              Comment

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