Jump to content

Featured Replies

Posted

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 mydatabase

This 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.

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.

7 hours ago, SLD Staff said:

I'm getting an access denied message

What is the precise error message that you are getting?

  • Author
2 hours ago, Miss_B said:

What is the precise error message that you are getting?

It’s very MySQL-ish.

IMG_0282.jpeg

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.

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.

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.

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.

  • 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:

CleanShot 2025-07-04 at 16.34.34.png

Is there a mysql table that has an error log I can look at to figure out what is wrong?

Thanks much.

  • 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.

CleanShot 2025-07-04 at 17.56.30.png

Edited by SLD Staff

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 by Miss_B

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. 

Recently Browsing 0

  • No registered users viewing this page.