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

How to get php to use a mysql server on pfsense ???

Scheduled Pinned Locked Moved Development
10 Posts 6 Posters 24.9k 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.
  • J
    jeroen234
    last edited by Jan 6, 2007, 4:57 PM Jan 6, 2007, 4:53 PM

    hi,

    i try to use mysql on pfsense from php
    but php don't get the mysql
    i think i missed somting this is wat i have done :

    pkg_add -r ftp://ftp.freebsd.org/pub/FreeBSD/releases/i386/6.2-RC2/packages/databases/mysql-server-5.1.11.tbz
    /usr/local/bin/mysql_install_db
    chmod 777 /var/db/mysql
    chmod 777 /var/db/mysql/mysql
    chmod 777 /var/db/mysql/mysql/.
    mv /usr/local/etc/rc.d/mysql-server /usr/local/etc/rc.d/mysql-server.sh
    vi /usr/local/etc/rc.d/mysql-server.sh

    chanced
    : ${mysql_enable="NO"}
    to
    : ${mysql_enable="YES"}
    save the file

    vi /usr/local/lib/php.ini
    add
    extension=mysql.so
    save the file

    cd /tmp
    mkdir php
    cd php
    fetch ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-6.2-release/All/php4-mysql-4.4.4_1.tbz
    tar -xjvf php4-mysql-4.4.4_1.tbz
    cd lib/php/20020429/
    cp mysql.so /usr/local/lib/php/extensions/no-debug-non-zts-20020429/mysql.so
    chmod 755 /usr/local/lib/php/extensions/no-debug-non-zts-20020429/mysql.so

    but afther a reboot still no mysql suport in php
    the mysql server is started

    1 Reply Last reply Reply Quote 0
    • M
      magikman
      last edited by Jan 6, 2007, 11:26 PM

      I am no security expert, but i don't see how it would be beneficial to install msql on your firewall. If you really need to have database access, install the server on aonther machine within your network and use it from there. Installing it on your bastion host is a BAD idea, no matter what the purpose.

      1 Reply Last reply Reply Quote 0
      • Y
        yoda715
        last edited by Jan 7, 2007, 12:23 AM

        I think MySQL, or for that matter any database, should never be installed on a firewall device. From a security standpoint, that would be basically shooting yourself in the foot. Firewalls are simply not meant to run databases :).

        1 Reply Last reply Reply Quote 0
        • J
          jeroen234
          last edited by Jan 7, 2007, 9:20 AM Jan 7, 2007, 8:05 AM

          its not run on my pfsense firewall server but on my pfsense aplication server

          i have found the problem
          on boot php.ini is made new again can't find where but this fixes it

          cd /usr/local/lib
          cp php.ini php.mysql
          vi php.mysql
          add
          extension=mysql.so
          save file

          vi /usr/local/etc/rc.d/mysql-server.sh
          add after

          run_rc_command "$1"
          these lines

          killall php
          cp /usr/local/lib/php.mysql /usr/local/lib/php.ini

          save file

          now mysql in php on the gui works

          1 Reply Last reply Reply Quote 0
          • D
            DanielSHaischt
            last edited by Jan 13, 2007, 11:02 AM

            Ugh! Why are you using pfSense as an app server??? If you would have been using a stock FreeBSD 6.x, there wouldn't have been the need to twiddle with the php.ini file. At least not the way you had to …

            Regards
            Daniel S. Haischt

            Mit freundlichen Gruessen / With kind regards
            DAn.I.El S. Haischt

            1 Reply Last reply Reply Quote 0
            • J
              jeroen234
              last edited by Jan 13, 2007, 5:41 PM

              butt then you don't have a good gui
              that what i love on pfsense its gui
              so i have a pfsense server configed as a firewall
              and one as a pfsense aplication server

              1 Reply Last reply Reply Quote 0
              • D
                DanielSHaischt
                last edited by Jan 13, 2007, 10:14 PM

                hummm but on an app server ypu have Apache etc. and the pfSense GUI isn't meant to administer Apache via it's GUI. Why don't you install webmin orsomething similar on your application server?

                Regards
                Daniel S. Haischt

                Mit freundlichen Gruessen / With kind regards
                DAn.I.El S. Haischt

                1 Reply Last reply Reply Quote 0
                • J
                  Justinw
                  last edited by Mar 21, 2007, 4:47 PM

                  yup, if you have another freebsd system just say pkg_add -r webmin and run setup, it runs pretty much right out of the box.  You have to give it a few directory names to setup mysql support and other things in the gui, but not too difficult overall.  Ebox and Freenas have some interesting application server junk included in them as well.

                  1 Reply Last reply Reply Quote 0
                  • S
                    simoncpu
                    last edited by May 8, 2007, 9:37 AM

                    @jeroen234:

                    butt then you don't have a good gui
                    that what i love on pfsense its gui
                    so i have a pfsense server configed as a firewall
                    and one as a pfsense aplication server

                    You might want to look into sqlite if you really, really, really need a database.  If you only need to store a few settings, just use the XML dude. =)

                    [ simon.cpu ]

                    1 Reply Last reply Reply Quote 0
                    • D
                      DanielSHaischt
                      last edited by May 8, 2007, 1:38 PM

                      Basically people should take five minutes to sit down and think about roles. After that you will realize that pfSense has not the role of a database server (period!). So if you need to store data, setup a RDBMS on a dedicated machine.

                      Cheers
                      Daniel S. Haischt

                      Mit freundlichen Gruessen / With kind regards
                      DAn.I.El S. Haischt

                      1 Reply Last reply Reply Quote 0
                      • First post
                        Last post
                      Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.
                        This community forum collects and processes your personal information.
                        consent.not_received