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 manageri 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.txzI 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
-
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!