Posted July 2Jul 2 Hi. I'm moving to a new server and the new mysql server requires SSL. I'm getting an access denied message when I try load up my forum's web page. Everyone else seems right other than specifying ssl. This command line works from the shell copying and pasting the password:mysql -u username -p -h mysql.hostname.com -P 25060 -D mydatabaseThis is from my conf_global: 'sql_driver' => 'mysql', 'sql_host' => 'mysql.hostname.com', 'sql_port' => '25060', 'sql_database' => 'mydatabase', 'sql_user' => 'username', 'sql_pass' => 'thepassword',Thanks in advance for your help.
July 2Jul 2 You would need to speak to your hosting company to ask the question there, as from what you have put above, there isnt anything special about how you are connecting from command line. We don't have anything specific for connecting to MySQL via SSL at the application level at present.
July 2Jul 2 7 hours ago, SLD Staff said:I'm getting an access denied messageWhat is the precise error message that you are getting?
July 2Jul 2 Author 2 hours ago, Miss_B said:What is the precise error message that you are getting?It’s very MySQL-ish. Thanks much. 5 hours ago, Marc said:You would need to speak to your hosting company to ask the question there, as from what you have put above, there isnt anything special about how you are connecting from command line. We don't have anything specific for connecting to MySQL via SSL at the application level at present.Thanks. Good to know that I haven’t screwed up the conf file in any way. Like the port number syntax, for example. Is there a log file somewhere I can see what IPB is trying to do/send to my MySQL server to see what I’m doing wrong?Thanks again.
July 2Jul 2 Its trying to send exactly what you added to your conf_global.php file. There isnt really a log anywhere that would tell you that, unfortunately.
July 2Jul 2 Have you confirmed the database user is actually assigned to the database itself? It’s not uncommon for people to create a DB user and not assign it to a specific database. Thus creating a permissions issue.Also does that user have full permissions to the database? A read only account for example would not be anywhere near enough permission.
July 2Jul 2 3 hours ago, Randy Calvert said:Have you confirmed the database user is actually assigned to the database itself? It’s not uncommon for people to create a DB user and not assign it to a specific database. Thus creating a permissions issue.Also does that user have full permissions to the database? A read only account for example would not be anywhere near enough permission.This.
July 4Jul 4 Author I think I'm past the database access issues. I ended up not using my hosts remote mysql instance and installing one locally. Now when I try to open my forum I get this and the same page when I try to sign in:Is there a mysql table that has an error log I can look at to figure out what is wrong?Thanks much.
July 4Jul 4 Author Additionally... I get this error when I try to go to the ACP:[[Template core/admin/global/globalTemplate is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]I changed the forum's default theme to the IPB default theme on the old server, reexported the database and retransferred all the files but it still gives that error.Thanks again for your help. Edited July 4Jul 4 by SLD Staff
July 5Jul 5 14 hours ago, SLD Staff said:Is there a mysql table that has an error log I can look at to figure out what is wrong?If you can't access your admin panel either where you can check the System Logs page, you can check the core_log table at your phpmyadmin. It would also be a good idea imo to check the server error log page too.13 hours ago, SLD Staff said:I changed the forum's default theme to the IPB default theme on the old server, reexported the database and retransferred all the files but it still gives that error.Can you try something? Give the Recovery Mode a try and see if it will help. The section you need for that at the blow link is called: Recovery Mode (Self hosted only) Edited July 5Jul 5 by Miss_B
Monday at 08:55 AM5 days We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you.