Results 1 to 15 of 15
  1. #1
    Join Date
    May 2004
    Posts
    237

    database has proplem after restore

    hi everyone



    i used this /scripts/pkgacct ACCOUNTNAME& in ssh to backup all my accounts and moved them to backup hdd and then reload OS, after reloaded OS, i moved them back to /home and used Cpanel restore them. The proplem is my vbb forums does not work and other site using database don't work neither. The rest of html site are ok.


    here is the message:

    Code:
    There seems to have been a slight problem with the database.
    
    Please try again by pressing the refresh button in your browser.
    
    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
    
    We apologise for any inconvenience.


    Thanks for reading

    p/s: somehow it says access denied for user
    Last edited by tinhnho; 07-26-2005 at 02:07 PM.

  2. #2
    Join Date
    May 2002
    Location
    Moscow
    Posts
    1,490
    try repaire your database. generally vbulletin very frequently create problem when it database restore from backup. if repairing will not help, try separate your database to create tables part and insert data parts when you will import database.
    Last edited by rustelekom; 07-26-2005 at 02:10 PM.
    Rustelekom LLC Dedicated server since 2002, RIPE NCC member, LIR, AS51168

  3. #3
    Join Date
    May 2004
    Posts
    237
    Originally posted by worldhosting
    try repaire your database. generally vbulletin very frequently create problem when it database restore from backup. if repairing will not help, try separate your database to create tables part and insert data parts.
    repair it in cpanel ?. The proplem is other sites which are using mysql also don't work, not only vbb. Thanks

  4. #4
    Also please double check all the sites that connect to the database is having the issue. Also try to connect to the database from the shell and verify whether it is working for you. Sometimes there can be issue with the php connecting to the database. It can help if you can recomplie apache with the php and you might also try changing the php version to one higher. i can't say that this is exactly the issue with out actually looking at it. But these are all worth a try.

    ----
    Aby,

  5. #5
    Join Date
    May 2002
    Location
    Moscow
    Posts
    1,490
    ah, in this case you first should check what happen with your mysql server. try check what showing in mysql processlist
    Rustelekom LLC Dedicated server since 2002, RIPE NCC member, LIR, AS51168

  6. #6
    Join Date
    May 2004
    Posts
    237
    i tried to repair it in cpanel , but it doesn't work
    still at the same error
    Code:
    IPB WARNING [2] mysql_connect(): Access denied for user: [email protected]' (Using password: NO) (Line: 120 of /ips_kernel/class_db_mysql.php)
     
    
    
    There appears to be an error with the database.
    You can try to refresh the page by clicking here. 
    
    Error Returned
    mySQL error: Access denied for user: [email protected]' (Using password: NO)
    mySQL error code: 
    Date: Tuesday 26th of July 2005 02:33:02 PM

  7. #7
    Join Date
    May 2002
    Location
    Moscow
    Posts
    1,490
    hm, in this case you just lost your config settings. mysql say that user try connect without password. check your config files for existing and also for database connectons.
    BTW. are you use same version of mysql server that you have before backup databases?
    Rustelekom LLC Dedicated server since 2002, RIPE NCC member, LIR, AS51168

  8. #8
    Join Date
    May 2004
    Posts
    237
    Originally posted by worldhosting
    hm, in this case you just lost your config settings. mysql say that user try connect without password. check your config files for existing and also for database connectons.
    BTW. are you use same version of mysql server that you have before backup databases?
    Yes, the same version database and the config files still existing. How do i check database connection ?
    Last edited by tinhnho; 07-26-2005 at 02:58 PM.

  9. #9
    You can check it from shell on the server

    mysql -u username -p
    it will prompt for the password. supply it

    ----
    Aby,

  10. #10
    Join Date
    May 2002
    Location
    Moscow
    Posts
    1,490
    if ALL of your mysql driven site not work after restoring try following:

    1) create test database and little very simple scripts for ensure that your current mysql server and php work correct and you able use full functionality with php+mysql.
    2) if above is done successfully and you haven't any problem, try recreate each mysql database user with same password and check connection to database again.
    Rustelekom LLC Dedicated server since 2002, RIPE NCC member, LIR, AS51168

  11. #11
    Join Date
    May 2004
    Posts
    237
    Code:
    [email protected] [~]# mysql -u username -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 977 to server version: 4.0.24-standard
    
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    
    mysql>
    I think the mysql connection still ok, Any idea why it happen like that ? thanks

  12. #12
    Join Date
    May 2002
    Location
    Moscow
    Posts
    1,490
    try connect with your vb user name and his password

    and what about mysql connection from php?
    Rustelekom LLC Dedicated server since 2002, RIPE NCC member, LIR, AS51168

  13. #13
    Join Date
    May 2004
    Posts
    237
    Originally posted by worldhosting
    try connect with your vb user name and his password

    and what about mysql connection from php?
    when i use my user name and his password, then it said
    ERROR 1045: Access denied for user: [email protected]' (Using password: YES)
    my vbb forums still showing :
    There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.

  14. #14
    Join Date
    May 2002
    Location
    Moscow
    Posts
    1,490
    try recreate vbb user with same password. you can do this from cpanel. and after recreating and reassigng to database try again.
    Rustelekom LLC Dedicated server since 2002, RIPE NCC member, LIR, AS51168

  15. #15
    Where did you get the access denied error

    Is it when you tried it from shell to connect to vb user name and his password
    if that is the case try to reset the password to what is in your configuration file

    -----
    Aby,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •