Welcome to Pandora FMS Community › Forums › Community support › Phpradmin and Postgresql
-
Phpradmin and Postgresql
Posted by compulinx on November 6, 2007 at 17:23Hello, it wanted to know if there is form of which phpradmin works with postgresql since I need to integrate it with another software.
Thanks
cgb replied 17 years, 3 months ago 2 Members · 1 Reply -
1 Reply
-
::
Hi there,
I am using mysql and am relatively to new phpradmin, but looking at the code it appears you can use Postgres. You’ll need to achieve a few things:
– create the table, import the SQL. The sql may be Mysql-centric. Adapt as necessary and post questions if it doesn’t “just work”
– convince freeradius to use Postgres. You’ll need the freeradius-postgresql module (rlm_sql_postgresql.so). Update /etc/raddb/sql.conf
[code:1]
driver = “rlm_sql_postgresql”– convince dialup_admin to use Postgres
Update /usr/local/phpradmin/conf/dialup_admin/conf/admin.conf
[code:1]
sql_type: pg (instead of mysql)
sql_server: ip.of.your.server
sql_port: 5432 (instead of 3306)Good luck and post back if you have any further queries.
Chris Bennett