Pkg install mysql

Ivart

Please help me, after pfSense upgrade to 2.2.1 I can´t install php52-mysql and mysql-server-5.5.21 pkg to make Captive Portal + freeradius2 + mysql work.


pkg install -R http://ftp-archive.freebsd.org/pub/FreeBSD-Archive/old-releases/i386/8.3-RELEASE/packages/All/php52-mysql-5.2.17_7.tbz
Updating FreeBSD repository catalogue...
FreeBSD repository is up-to-date.
All repositories are up-to-date.
pkg: No packages available to install matching 'http://ftp-archive.freebsd.org/pub/FreeBSD-Archive/old-releases/i386/8.3-RELEASE/packages/All/php52-mysql-5.2.17_7.tbz' have been found in the repositories

KOM

I don't know anything about your problem, but why on Earth would you try to install an ancient version of mysql for FreeBSD 8.3? You need to find the latest stable mysql version for FreeBSD 11.1 and install that.

phil.davis

~~FreeBSD 11.1~~
FreeBSD 10.1

Ivart

Ok KOM, I´ve tried do install old version of mysql because a guide for captive portal + freeradius2 + mysql, but now after your post I´m trying to install new version of mysql + php-mysql, after pkg install mysql56-server and php56-mysql I have a problem with libraries.


libxml2-2.9.2_2                XML parser library for GNOME
mysql56-client-5.6.23          Multithreaded SQL database (client)
mysql56-server-5.6.23          Multithreaded SQL database (server)
pcre-8.35_2                    Perl Compatible Regular Expressions library
perl5-5.18.4_11                Practical Extraction and Report Language
php56-5.6.6                    PHP Scripting Language
php56-mysql-5.6.6              The mysql shared extension for php
pkg-1.4.12                     Package manager

[2.2.1-RELEASE][root@treknetgw.treknet.local]/root: mysql -u root -p
Shared object "libz.so.5" not found, required by "mysql"

[2.2.1-RELEASE][root@treknetgw.treknet.local]/root: ldd /usr/local/bin/mysql
/usr/local/bin/mysql:
        libreadline.so.8 => /lib/libreadline.so.8 (0x28326000)
        libz.so.5 => not found (0)
        libstdc++.so.6 => not found (0)
        libm.so.5 => /lib/libm.so.5 (0x2835a000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x28380000)
        libthr.so.3 => /lib/libthr.so.3 (0x2838c000)
        libc.so.7 => /lib/libc.so.7 (0x283ae000)
        libncurses.so.8 => /lib/libncurses.so.8 (0x2850d000)

doktornotor

Install zlib and libstdc++? (Dunno if they packaged libstdc++ separately really, if not, you'd need gcc instead.) Regardless, sounds like a packaging bug to me if they are missing dependencies.

Ivart

Fixed. Thanks for your help.


pkg install php56-mysql
touch /etc/php_dynamodules/php56-mysql

pkg install mysql56-server
pkg install compat8x-i386

mysql working! ;D

avnel

i am getting error after

pkg install php56-mysql
touch /etc/php_dynamodules/php56-mysql

pkg install mysql56-server
pkg install compat8x-i386

please help me

pf.jpg_thumb

urok

@avnel:

i am getting error after

pkg install php56-mysql
touch /etc/php_dynamodules/php56-mysql

pkg install mysql56-server
pkg install compat8x-i386

please help me

https://doc.pfsense.org/index.php/How_do_I_get_PHP_support_for_mysql,_sqlite,_sockets,_etc