Open Source Training Seminar


Not Logged in - No Account?

Don't have an account? Registering an account with us allows you to post to the forums, easily track new posts, subscribe to threads, pm (private message) other forum members, and receive periodic news letters (you can opt out if you desire). Once you are logged in this message will no longer appear. If you don't have an account, you can create one by registering here. Lost your password, request a new password. We respect your privacy which means we collect minimal information when you register and we do not resell that information or use it in any objectionable way. You can review our privacy policy for full details.


How To Secure MySQL?

rockinthesixstring's picture
Posted July 19th, 2008 by rockinthesixstring (tadpole)

Just wondering how to secure MySQL here. I tried changing the Password in the config, however that caused it to break the Web UI. Where do I go to change the password FOR ALL APPLICATIONS that use MySQL?


__________________

Chase


‹ voicemail.conf - FreePBX 2.4 current Installation Script with automatic Modules Upgrade & Modules installation ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Secure Asterisk + FreePbx installation

YoK's picture
On July 21st, 2008 YoK (tadpole) said:

Change asteriskuser SQL password :

  • Change AMPDBPASS=amp109 in /etc/amportal.conf
  • Change PASSWORD in database : SET PASSWORD FOR 'asteriskuser'@'localhost' = PASSWORD('amp109');

Change asterisk manager password :

  • Change secret = amp111 in /etc/asterisk/manager.conf
  • Change AMPMGRPASS=amp111 in /etc/amportal.conf

Change default root SQL password :

  • SET PASSWORD FOR 'root'@'localhost' = PASSWORD('default_password');

Secure Asterisk + FreePbx installation

markuswarlich's picture
On July 21st, 2008 markuswarlich (tadpole) said:

Hi
I change passwords in manager.conf and amportal.conf and in mysql. Connection to mysql works with the new password (cecked with external program) put FreePBX will not connect.
Message by opening the webside:
FATAL ERROR
DB Error: connect failed

Any help?

Regards Markus

OK I get it. Changing the permission of the asterisk user was the problem. Getting back to "localhost" solves my problem.