Pages: [1]   Go Down
Author Topic: Phpradmin and Postgresql  (Read 817 times)
0 Members and 2 Guests are viewing this topic.
compulinx
Newbie
*

Karma: 0
Offline Offline

Posts: 2


View Profile
« on: November 06, 2007, 02:23:33 PM »

Hello, it wanted to know if there is form of which phpradmin works with postgresql since I need to integrate it with another software.

Thanks
« Last Edit: January 01, 1970, 01:00:00 AM by compulinx » Logged

cgb
Newbie
*

Karma: 0
Offline Offline

Posts: 3


View Profile
« Reply #1 on: November 20, 2007, 04:35:37 PM »

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"
[/code]

- 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)
[/code]

Good luck and post back if you have any further queries.

Chris Bennett
« Last Edit: January 01, 1970, 01:00:00 AM by cgb » Logged

Pages: [1]   Go Up
Print
 
Jump to:  


SourceForge.net Logo  This site is monitored by Pandora FMS   ArticaST