Pfsense 2.3 mysql install ?



  • hi friands ,

    i use pfsense 2.3 X86 versions i need install mysql 5.5.46 vesion  and following packages

    libxml2-2.9.3                  XML parser library for GNOME
    mysql55-client-5.5.46          Multithreaded SQL database (client)
    mysql55-server-5.5.46          Multithreaded SQL database (server)
    perl5-5.20.3_8                Practical Extraction and Report Language
    php55-soap-5.5.33              The soap shared extension for php
    pkg-1.6.4_1                    Package manager

    i used pfsense 2.2.6 I use the following commands using the version and  I could successfully install the packages.

    pkg install
    pkg install mysql55-client mysql55-server
    pkg add -M http://pkg.freebsd.org/freebsd:10:x86:32/latest/All/php55-soap-5.5.33.txz

    I get the following error in the new version
    How do I install these packages.

    [2.3-RC][root@pfSense.localdomain]/root: pkg install
    Usage: pkg install [-AfInFMqRUy] [-r reponame] [-Cgix] <pkg-name>...
    
    For more information see 'pkg help install'.
    [2.3-RC][root@pfSense.localdomain]/root: pkg install mysql55-client mysql55-server
    Updating pfSense-core repository catalogue...
    pfSense-core repository is up-to-date.
    Updating pfSense repository catalogue...
    pfSense repository is up-to-date.
    All repositories are up-to-date.
    New version of pkg detected; it needs to be installed first.
    The following 1 package(s) will be affected (of 0 checked):
    
    Installed packages to be UPGRADED:
            pkg: 1.6.2 -> 1.7.2_1 [pfSense]
    
    The process will require 65 KiB more space.
    2 MiB to be downloaded.
    
    Proceed with this action? [y/N]: y
    Fetching pkg-1.7.2_1.txz: 100%    2 MiB 183.2kB/s    00:14
    Checking integrity... done (0 conflicting)
    [1/1] Upgrading pkg from 1.6.2 to 1.7.2_1...
    You may need to manually remove /usr/local/etc/pkg.conf if it is no longer needed.
    [1/1] Extracting pkg-1.7.2_1: 100%
    Updating pfSense-core repository catalogue...
    pfSense-core repository is up-to-date.
    Updating pfSense repository catalogue...
    pfSense repository is up-to-date.
    All repositories are up-to-date.
    pkg: No packages available to install matching 'mysql55-client' have been found in the repositories
    [2.3-RC][root@pfSense.localdomain]/root: pkg install libxml2
    Updating pfSense-core repository catalogue...
    pfSense-core repository is up-to-date.
    Updating pfSense repository catalogue...
    pfSense repository is up-to-date.
    All repositories are up-to-date.
    Checking integrity... done (0 conflicting)
    The most recent version of packages are already installed</pkg-name> 
    


  • should be "pkg install php56-mysql"

    try it



  • @azekiel:

    should be "pkg install php56-mysql"

    try it

    Thanks bro I've tried I think install php

    [2.3-RC][root@pfSense.localdomain]/root: pkg install php56-mysql
    Updating pfSense-core repository catalogue...
    pfSense-core repository is up-to-date.
    Updating pfSense repository catalogue...
    pfSense repository is up-to-date.
    All repositories are up-to-date.
    The following 1 package(s) will be affected (of 0 checked):
    
    New packages to be INSTALLED:
            php56-mysql: 5.6.20 [pfSense]
    
    16 KiB to be downloaded.
    
    Proceed with this action? [y/N]: y
    Fetching php56-mysql-5.6.20.txz: 100%   16 KiB  15.9kB/s    00:01
    Checking integrity... done (0 conflicting)
    [1/1] Installing php56-mysql-5.6.20...
    [1/1] Extracting php56-mysql-5.6.20: 100%
    [2.3-RC][root@pfSense.localdomain]/root: /etc/rc.php_ini_setup
    [2.3-RC][root@pfSense.localdomain]/root: php -m | grep mysql
    mysql
    mysqlnd
    [2.3-RC][root@pfSense.localdomain]/root: /usr/local/etc/rc.d/mysql-server.sh start
    [color][b]/usr/local/etc/rc.d/mysql-server.sh: Command not found.[/b][/color]
    
    

    but I was using the following commands in the old version but did not run pfsense 2.3 version
    I receive the following error  :(

    I want to run the following commands what should I do  :'(

    usr/local/bin/mysql_install_db --basedir=/usr/local
    chmod 777 /var/db/mysql
    mv /usr/local/etc/rc.d/mysql-server /usr/local/etc/rc.d/mysql-server.sh
    ee /usr/local/etc/rc.d/mysql-server.sh (mysql enable, esc , save settings)
    /usr/local/etc/rc.d/mysql-server.sh start
    


  • why do you want to install mysql on pfSense?

    This is not recommended.

    If you type in "pkg search mysql" you don't see any mysql-server, so I think it's not implemented in the repos right now.

    You need to download it from another repo and install it manually.



  • Hi,

    Did this, and installed mysql-client … as I only want to be able to push some data to a server on another machine. Install went fine, but no "mysql" command existing still ... hmmm. Does that make sense?

    Thanks!



  • FYI - to close the loop, found the install at /usr/local/bin.

    Thanks!


Log in to reply