Pkg install mysql



  • 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
    
    


  • 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.



  • FreeBSD 11.1
    FreeBSD 10.1



  • 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)
    
    

  • Banned

    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.



  • 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



  • 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




  • @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


 

© Copyright 2002 - 2018 Rubicon Communications, LLC | Privacy Policy