I tried installing PHPMyAdmin on the distro box.
Went throught the process and got the error
The mbstring extension is missing. Please check your PHP configuration.
I found this comment:
Latest phpMyAdmin versions require mysqli extension and will no longer work with mysql one (note the extra “i” at the end of it’s name).
sudo apt-get install php5-mysql
Will install package containing both old one and the new one, so afterwards all you need to do is to add extension=mysqli.so
in your php.ini, restart apache and it should work.
This worked for me on Ubuntu 12.04. Thanks :
Is this safe to do on the distro system? Am I going to mess anything else up?
There are also third party tools SQL tools for Windows/MAC that can connect to the DB.
Frankly, the config database is anything but flat, it is a complex interaction from the modules. If you have to ask how to grant permission to the database from another host then nothing good could possibly come of you poking around in the DB.
With that being said why don’t you tell us what you are trying to accomplish and perhaps we can give you a suggestion on how to accomplish your goals.
If you must open the DB and look around, I would say install tools that are desktop based like MySQL Admin, Navicat and I’m sure there are others. The key would be to allow the outside connection for your custom user ONLY from your fixed ip number (hopefully you have one), this would prevent from anyone else trying to connect to the DB in this fashion.
From there you can develop your script from another box ( also granting access from a specific IP ) to READ ONLY the tables which you want to generate your report/xml from.
As an alternative to installing phpMyAdmin directly on FreePBX, try going into mysql from command line and allowing external access to another linux server (by ip)
Then configure phpmyadmin on *that server to connect to your FreePBX box.
As long as it’s inside your internal network, should be no problem regarding security. If you’re on WAN, you may not want to do that.
Unfortunately that solution only passes the inherent phpmyadmin security problems downline (dozens of critical security patches needed every year). I really suggest exploration of a more trustworthy client, how about mysql-client itself either from the Asterisk box or any other machine, the intrinsic acl’s of mysql-server are really very secure but IMHO you REALLY need a root password for root@localhost access, recent root access exploits just emphasize that risk.
Or just use mysql workbench which is written by Oracle, it has a handy feature called Tunnel SSH which means it will connect over ssh THEN connect to mysql and yes you can use SSH keys