Newbie Installation Problems - Step 3

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Malingo
    New Member
    • Oct 2002
    • 7

    Newbie Installation Problems - Step 3

    VERY NEW TO MYSQL and VB.

    I am getting an error after I try to go to step 3 (after it shows
    the config) and it says


    code:--------------------------------------------------------------------------------Attempting to attach to database...--------------------------------------------------------------------------------


    code:--------------------------------------------------------------------------------The database has failed to connect because you do not
    have permission to connect to the server. Please go back to the
    last step and ensure that you have entered all your login details
    correctly.--------------------------------------------------------------------------------

    I can login to the database from mysql on the server with the same username and password.

    I'm the one that setup the MySQL for the first time on RedHat 7.3 - (made sure to do all the fixes) (used the MYSQL RPM from MySQLs site)- I'm pretty sure this is a permissions problem, but would like ANY clues of what permissions to check. I've created a new database with new users and have the same problem. Any ideas would be greatly appreciated.
  • Malingo
    New Member
    • Oct 2002
    • 7

    #2
    hmm

    I realize this is close to another question, but I am following all the instructions I can find to the T. I just can't understand why I can connect through the mysql client, but not the vbulletin install.php .... ?!?! do you have setup instructions for the host??

    Comment

    • filburt1
      Senior Member
      • Feb 2002
      • 6606

      #3
      Make sure that you have entered the proper values in config.php; one of them is wrong (don't know which from the error).
      --filburt1, vBulletin.org/vBulletinTemplates.com moderator
      Web Design Forums.net: vB Board of the Month
      vBulletin Mail System (vBMS): webmail for your forum users

      Comment

      • Malingo
        New Member
        • Oct 2002
        • 7

        #4
        hm

        there isn't a whole lot to change in the config.php

        I am using the same username and password to connect to the
        database as i use when logging in directly from the server.
        Its pretty quick to respond with the error.

        I've even tried the root username and password just hoping to get anything to work??!!?!?!

        Comment

        • Malingo
          New Member
          • Oct 2002
          • 7

          #5
          OK MORE INFO...

          Ok, here is what I've done -
          In Red Hat 7.3 with the latest MySQL,
          [root@web3]#mysql -u root -p mysql
          Enter Password: ******** (password is password)

          mysql>CREATE DATABASE vbulletin;

          mysql>GRANT ALL ON vbulletin.* TO bb;
          (user bb already created with password of password)

          mysql>QUIT

          [root@web3]#mysql -u bb -p vbulletin
          Enter Password:******** (password is password)

          mysql>

          (so at this point i assume i've logged in to the database okay)

          here is my config.php file:

          <?php
          /////////////////////////////////////////////////////////////
          // Please note that if you get any errors when connecting, //
          // that you will need to email your host as we cannot tell //
          // you what your specific values are supposed to be //
          /////////////////////////////////////////////////////////////

          // type of database running
          // (only mysql is supported at the moment)
          $dbservertype="mysql";

          // hostname or ip of server
          $servername="localhost";

          // username and password to log onto db server
          $dbusername="bb";
          $dbpassword="password";

          // name of database
          $dbname="vbulletin";

          // technical email address - any error messages will be emailed here
          $technicalemail = "[email protected]";

          // use persistant connections to the database
          // 0 = don't use
          // 1 = use
          $usepconnect = 0;

          // which users are allowed to view the admin log
          // separate each userid with a comma
          $canviewadminlog = "1";

          // which users are allowed to prune the admin log
          // separate each userid with a comma
          $canpruneadminlog = "";

          ?>

          When I run the install.php on step 3 I receive:

          Attempting to attach to database...

          The database has failed to connect because you do not have permission to connect to the server. Please go back to the last step and ensure that you have entered all your login details correctly.

          Click to go to the vBulletin website

          Any suggestions, I granted all permissions to the user bb with that command correct??

          Comment

          • Steve Machol
            Former Customer Support Manager
            • Jul 2000
            • 154488

            #6
            To tell you the truth I've always just created the database via CPanel. I've never done it thorugh the mysql command line so I really don't know if this is correct or not.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment

            • Malingo
              New Member
              • Oct 2002
              • 7

              #7
              expensive

              it seems rather expensive to buy a license for CPanel, there are no other alternatives??

              There has to be instructions somewhere for command line....

              Comment

              • Steve Machol
                Former Customer Support Manager
                • Jul 2000
                • 154488

                #8
                As I said I don't know if the procedures you posted are correct or not. Obviously something is wrong somewhere otherwise you wouldn't be getting this error.

                Have you checked the MySQL site for help?

                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment

                • Malingo
                  New Member
                  • Oct 2002
                  • 7

                  #9
                  Got It!

                  For detailed instructions on how to setup vBulletin with Red Hat 7.3 <b>WITHOUT</b> cPanel. Email me @ [email protected]

                  have fun!

                  Comment

                  • f-a_org
                    Senior Member
                    • Nov 2002
                    • 870
                    • 3.0.3

                    #10
                    you should of put
                    Code:
                    dbname="(domain username me it used to be f-a_org so it would be)faorg_vbulletin">

                    Comment

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