Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    POSTGRESQL extension for PHP

    Scheduled Pinned Locked Moved Captive Portal
    1 Posts 1 Posters 2.0k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • I
      ianrhen
      last edited by

      Here is the scenario.

      I was developing a customized wireless internet access system with pfsense.  I am using a postgresql database server on another box and pfsense captive portal on another box.

      I know that when you add a user in pfsense captive portal, it is stored in a file in pfsense server. if a user logs in to captiveportal, the details of his login is also stored in a file call captiveportal.db.

      Here is how my customized wireless system works.

      when a user want to access internet, i will redirect it to my website login. i will check his username, password, then if valid i will also check his/her internet access account. if the user has still remaining hours of internet access (coz we gave each user a 50hrs internet access time) then that is only the time he will be granted to access the internet.

      What i want to happen is when the captiveportal allows the user to the firewall, i will run php scripts in pfsense that will connect to my database server and logs the starting time, the last activity time and eventually logs that total hours of access so i can track his/her internet access hours history using my database.

      the problem is i dont see and i can not find the pgsql.so extension which is needed to connect to posgresql database from the pfsense box.
      If the pgsql.so extension is there, i can directly connect to my database server and logs everything by just adding some php scripts in /usr/local/captiveportal.index.php and my problem is solve.
      But that is until i find the pgsql.so extension….

      Any ideas about this matter would be a great help for me to solve my problem.

      Thanks....

      1 Reply Last reply Reply Quote 0
      • First post
        Last post
      Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.