Problema instalar o mysql no pfsense



  • Instalei o mysql com o commando:
    pkg_add -r http://ftp-archive.freebsd.org/pub/FreeBSD-Archive/old-releases/amd64/8.1-RELEASE/packages/All/mysql-server-5.5.4.tbz

    Tudo ocorre normal, mando instalar o serviço ele n aprensenta erro, porem quando vou tentar conectar apresenta o seguinte erro:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

    No log do mysql dentro de /var/db/mysql
    Aprenseta o seguinte conteúdo:
    130513 18:53:52 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
    130513 18:53:52 [Note] Buffered information: Performance schema disabled (reason: start parameters).

    130513 18:53:52 [Note] Plugin 'FEDERATED' is disabled.
    /usr/local/libexec/mysqld: Table 'mysql.plugin' doesn't exist
    130513 18:53:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    InnoDB: The InnoDB memory heap is disabled
    InnoDB: Mutexes and rw_locks use GCC atomic builtins
    InnoDB: Compressed tables use zlib 1.2.3
    130513 18:53:52  InnoDB: highest supported file format is Barracuda.
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    130513 18:53:52  InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files…
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    130513 18:53:52 InnoDB 1.1.0 started; log sequence number 1595687
    130513 18:53:52 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
    130513 18:53:52 mysqld_safe mysqld from pid file /var/db/mysql/pfsense.localdomain.pid ended

    Alguem sabe me dizer como arrumar isso?

    Estou tentendo configurar o PF+Radius+Captive portal desse tuto aqui http://forum.pfsense.org/index.php/topic,57260.msg305604.html#msg305604
    Porem desda primeira parte está dando erro.



  • Já tentou executar o que o erro sugere?

     Please run mysql_upgrade to create it.
    


  • Sim,
    Já havia tentado, segue o erro

    Looking for 'mysql' as: mysql
    Looking for 'mysqlcheck' as: mysqlcheck
    Running 'mysqlcheck with default connection arguments
    mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
    FATAL ERROR: Upgrade failed


Log in to reply