Skip to main content

Access dined for user

Game1star
Hi, I have a forum, from past few days I am getting this message when I open my forum 'An unexpected database error occurred. Please try again later. " I am able to solve the problem by adding the user to data base and giving the privileges in the MySQL database. But after few hours, the user is getting removed, so I have to add the user to database(and give permission) again and again. Do you guys know what's happening? And how to resolve the issue? Thank you.

Comments

7 comments

Date Votes
  • cPRex Jurassic Moderator
    Hey there! I'm sorry to hear about this issue with the database system. It sounds like there is some type of corruption happening on the system, although I couldn't say for sure what that may be without seeing the system. By default, MySQL error logs are located at /var/lib/mysql/your.hostname.com.err, so it would be best to check that file and see if there are any errors there that may be helpful. If you don't see any recent entries in that log file, it's possible the log file location has been changed, and you would need to check the MySQL configuration at /etc/my.cnf to find the correct log. I would start there and see if that gets you more details on the issue.
    0
  • Game1star
    Thank You for the reply, I see some error in my error log, and i have noticed that whenever my forum shuts down this error is registered. "cmd: suspendedpage.cgi" Any idea on how to solve this issue? Thank you.
    0
  • cPRex Jurassic Moderator
    If the page showing up is the suspendedpage.cgi that would indicate the site is being suspended by the hosting provider. You'd need to speak with your host directly about that issue as there isn't a way for you to solve that with only access to cPanel, as the owner of the server will need to determine why the site is being suspended.
    0
  • Game1star
    Thanks for replying, I will give them a call, and i also noticed my cpu usage is quite high, usually it stays arround 99 percent, and cPanel showing me, my site has over 250K+ hits her month, i dont know what is causing my cpu overload, is there any tool in cPanel to monitor the issue (i am on shared hosting).
    0
  • cPRex Jurassic Moderator
    It sounds like your hosting account is running inside the CloudLinux operating system and your CPU usage is being reported from the LVE statistics there. There isn't going to be a way to monitor the CPU usage directly with a shared account, but if you aren't expecting that much traffic you may want to examine the stats for your site under the cPanel >> Metrics area to see if you can identify a certain area of your site that may be targeted.
    0
  • Game1star
    Thanks for replying, I have found out some more errors in phpmyadmin, i see 3 tables with this error "The storage engine for the table doesn't support check" when i check the table, tried repairing as well but it says the same thing, could this be the cause of the corruption happening, and their are no recent log entries in error log located in public_html (the logs are 3 years old), and i tried searching the problem on the net but could not find any solutions,
    0
  • cPRex Jurassic Moderator
    That message wouldn't be related to the corruption, as InnoDB tables can't be checked like MyISAM tables, so that is a normal message to see. Without root access to the machine I'm not sure what else could be checked on your end. Ideally the host would be able to test the problem once you've seen the issue and before it is repaired, but to do that they would need to respond quickly to your requests.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post