phpMyAdmin revisited

I would very much like to see phpMyAdmin supported.
I have several installations where mysql is used for office data.
Our FreePBX servers have plenty of extra horsepower.
In my test systems I have the extra databases running well and backup/restore is even taking care of the extra databases.

Any plans on offering phpMyAdmin in the repos?
It would be keen to have that tool available to administer nonPBX data.

phpMyadmin takes insecurity to new heights as it requires root privs to run.

With that being said if your machine is not on the Internet certainly you can install it without significant risk into most environments.

Just because it’s not in the repo does not mean you can’t install it. Download the RPM and run rpm -ivh package name.

http://www.rpm.org/max-rpm/ch-rpm-install.html

I already tried the latest phpMyAdmin.
It depends on mcrypt, and apparently it too is disabled/missing from the repo.

I’m going to forget this pipe dream and let the FreePBX be just that and let the application servers be separate.

Its enough pain in the neck to just keep a primary and backup pbx healthy without hanging other duties such as a file server and mysql databases.

Even though it would be cool, I think it more important to keep FreePBX as close to stock as possible

You might be interested in my notes for installing phpmyadmin on the Freepbx Distro:

Load phpMyAdmin by running the following commands:
cd /usr/share
wget http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/2.11.11.3/phpMyAdmin-2.11.11.3-english.tar.gz/download
tar xvfz phpMyAdmin-2.11.11.3-english.tar.gz
mv phpMyAdmin-2.11.11.3-english phpmyadmin
rm phpMyAdmin-2.11.11.3-english.tar.gz
cd phpmyadmin
cp config.sample.inc.php config.inc.php
nano /etc/httpd/conf.d/phpmyadmin.conf and add the following lines:

Web application to manage MySQL

<Directory “/usr/share/phpmyadmin”>

Order Deny,Allow

Deny from all

Allow from 127.0.0.1

Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpMyAdmin /usr/share/phpmyadmin
Alias /mysqladmin /usr/share/phpmyadmin

Control X and Save

service httpd restart

chown asterisk /usr/share/phpmyadmin/config.inc.php
chmod 777 /var/lib/php/session/

nano /usr/share/phpmyadmin/config.inc.php and remove cookie from line $cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’ and replace with ‘http’ then Control X and follow prompts to save.

yum install php-mbstring and follow the prompts
service httpd restart

nano /etc/amportal.conf and page down using Control V to near the end and find AMPDBUSER=username and AMPDBPASS=password. Write these down, you will need them to log in to phpMyAdmin. Control X and exit.

so, whats the url to access phpmyadmin

localhost/phpmyadmin

nano /etc/httpd/conf.d/phpmyadmin.conf and add the following lines:

Web application to manage MySQL

Order Deny,Allow

Deny from all

Allow from 127.0.0.1

Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpMyAdmin /usr/share/phpmyadmin
Alias /mysqladmin /usr/share/phpmyadmin

Control X and Save

service httpd restart


When i do it, why i see this error: [[email protected] ~]# service httpd restart
Stopping httpd: [FAILED]
Starting httpd: Syntax error on line 5 of /etc/httpd/conf.d/phpmyadmin.conf: allow not allowed here [FAILED]