Welcome to Pandora FMS Community!

Find answers, ask questions, and connect with our community around the world.

Welcome to Pandora FMS Community Forums Community support Phpradmin and Postgresql

  • Phpradmin and Postgresql

    Posted by compulinx on November 6, 2007 at 17:23

    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

    cgb replied 17 years, 3 months ago 2 Members · 1 Reply
  • 1 Reply
  • cgb

    Member
    November 20, 2007 at 19:35
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    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