I followed the instruction provided here : Enable remote connection to asteriskcdrdb on freepbx - FreePBX Documentation - Documentation
everything seems okay, except accessing the main database hahhaa
when I try to access the database remotely, I only have access to the “test” database which doesn’t have any data, but locally when I login as my new user, I have access to the main database and I can list the tables, what I did wrong?
December 15, 2022, 5:47am
You need to connect with an mysql account/user previously created that has been given access to whatever from wherever appropriately
Thanks dicko, so what’s the default root password for mysql? I haven’t added any other user before
December 15, 2022, 6:09am
FreePBX does not use a password for the root account, but it can only connect from localhost. (I can’t say I agree with that given the number or ‘compromises’ root has had over the years
So what I did:
I logged in mysql as root
GRANT USAGE ON . TO ‘my_user’@‘localhost’ IDENTIFIED BY ‘mypassword’;
So do I need to put the public ip instead of localhost? that’s it?
December 15, 2022, 6:36am
localhost is 127.0.0.1, your remote host won’t be
and granting access to everything is never a good idea for any remote account.
I added the permission to the public IP, but still can not remotely access to the main database, it’s just the test one
December 16, 2022, 12:14am
when you say;
are you referring to the public IP of the PBX or the public IP of the user trying to log in?
It needs to be the IP of the system that the request is coming from…
on the firewall, I opened the port for my IP(client) but in mysql, the IP that I covered it by red pen, is the public IP for the mysql server.
Have I made a mistake?
From the client, I can have the access to the test database, but can not see the main database.
December 16, 2022, 3:37am
December 23, 2022, 3:37am
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.