Announcement

Collapse
No announcement yet.

Having trouble installing and connecting to database

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

  • Having trouble installing and connecting to database

    I've created my database, added a database user (and connected the user to the database), and edited around my config.php, but it doesn't seem to connect to the database.

    What am I doing wrong?

    And yes, I've made sure I edited all these spots:

    $config['Database']['dbname']
    $config['Database']['technicalemail']
    $config['MasterServer']['servername']
    $config['MasterServer']['username']
    $config['MasterServer']['password']

  • #2
    Originally posted by Fratal View Post
    I've created my database, added a database user (and connected the user to the database), and edited around my config.php, but it doesn't seem to connect to the database.

    What am I doing wrong?

    And yes, I've made sure I edited all these spots:

    $config['Database']['dbname']
    $config['Database']['technicalemail']
    $config['MasterServer']['servername']
    $config['MasterServer']['username']
    $config['MasterServer']['password']
    What errors are you getting? Obviously you are not entering the right info somewhere in there otherwise you wouldn''t have had a connection problem.
    Last edited by borbole; Mon 26 Apr '10, 2:13pm.

    Comment


    • #3
      Well, I've tried inputting my info multiple different ways.

      For the db name, I'd put: name_myDBname
      For the tech email, I'd put my own email.
      For the servername, I'd put localhost (it's there automatically).
      For the username, I'd put: name_myDBuser
      For the password, I'd put the database password.

      And some errors:

      Database error in vBulletin :

      mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'boardfps_rdfuser'@'localhost' (using password: YES)
      /home/boardfps/public_html/includes/class_core.php on line 311

      MySQL Error :
      Error Number :
      Request Date : Monday, April 26th 2010 @ 04:05:08 PM
      Error Date : Monday, April 26th 2010 @ 04:05:08 PM
      Script : ********
      Referrer :
      IP Address : ********
      Username :
      Classname : vB_Database
      MySQL Version :
      Database error in vBulletin :

      Invalid SQL:

      SELECT *
      FROM datastore
      WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','user stats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');

      MySQL Error : Table 'boardfps_rdfdb.datastore' doesn't exist
      Error Number : 1146
      Request Date : Monday, April 26th 2010 @ 03:58:49 PM
      Error Date : Monday, April 26th 2010 @ 03:58:49 PM
      Script : **********
      Referrer :
      IP Address : *******
      Username :
      Classname : vB_Database
      MySQL Version :

      Comment


      • #4
        The first error points to a permission problem. Did you gave the db user full permissions/access to the db where he is assigned to? Also, go to phpmyadmin and check if the servername is really localhost. Some hosts use their name.

        The second error points to a db table that it doesn''t exists (datastore).

        Ask your host to double check your info as well.

        Comment


        • #5
          What does this one mean?

          Database error in vBulletin :

          Invalid SQL:

          SELECT *
          FROM datastore
          WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','user stats','birthdaycache','maxloggedin','iconcache','eventcache','mailqueue');

          MySQL Error : Table 'boardfps_rdfdb.datastore' doesn't exist
          Error Number : 1146
          Request Date : Monday, April 26th 2010 @ 04:18:41 PM
          Error Date : Monday, April 26th 2010 @ 04:18:41 PM
          Script : *********
          Referrer :
          IP Address : ********
          Username :
          Classname : vB_Database
          MySQL Version :

          Comment


          • #6
            As I said above, the second error points to a db table that it doesn''t exists (datastore). Which is strange because if you are having trouble to connect to the db when running the installer, you shouldn''t have any tables in the db.

            Comment


            • #7
              Yes, it certainly is weird. I really don't know what I'm doing wrong. All my info is correct?

              Comment


              • #8
                Originally posted by Fratal View Post
                Yes, it certainly is weird. I really don't know what I'm doing wrong. All my info is correct?
                When you created the db, did you gave the db user full permissions/access to the db where he is assigned to? Also, go to phpmyadmin and check if the servername is really localhost. Some hosts use their name.

                Ask your host to double check your info as well. because some settings somewhere is not correct.

                Who is your host btw?

                Comment


                • #9
                  Yes, when I connected the db user to the db, I made sure I checked the "All Priviledges" box. As for the server name, I did go into phpMyAdmin, and it clearly shows that Server: localhost.

                  Comment


                  • #10
                    Got it fixed. I just went through with the install/install.php and it worked.

                    Comment


                    • #11
                      Glad to hear that.

                      Comment

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