Pfsense 2.3 mysql install ?

serdar_bay

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>

azekiel

should be "pkg install php56-mysql"

try it

serdar_bay

@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

azekiel

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.

arrmo

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!

arrmo

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

Thanks!