MySQL installation problem

[Ogru]

Hello,

Can someone help me out.

I'm trying to install MySQL on my FreeNAS box so I can synchronize my XBMC Media Center.

My FreeNAS box:

Code:

FreeNAS Build: FreeNAS-8.0.4-RELEASE-x64 (10351) 
Platform: AMD Athlon(tm) 64 X2 Dual Core Processor 3800+ 
Memory: 3825MB
OS Version: FreeBSD 8.2-RELEASE-p6

I've been flowing this tutorial:
http://www.howtoforge.com/installing-mysql-and-phpmyadmin-on-freenas

Code:

[root@OgruFreeNAS] ~# mkdir /mnt/ADD/db
[root@OgruFreeNAS] ~# mkdir /mnt/ADD/db/mysql
[root@OgruFreeNAS] ~# ln -s /mnt/ADD/db/mysql/ /var/db/mysql
[root@OgruFreeNAS] ~# chown -R mysql:mysql  /mnt/ADD/db/mysql/
[root@OgruFreeNAS] ~# chown -R mysql:mysql /mnt/ADD/db
[root@OgruFreeNAS] ~# chmod 777 /tmp/
[root@OgruFreeNAS] ~# chmod 777 /var/tmp/

So far so good, but when I get to the most impotent part i get error:

Code:

[root@OgruFreeNAS] ~# pkg_add -r mysql55-server
Fetching ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-8.2-release/Latest/mysql55-server.tbz... Done.
Fetching ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-8.2-release/All/mysql-client-5.5.9.tbz... Done.
include/mysql/decimal.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/decimal.h'
include/mysql/errmsg.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/errmsg.h'
include/mysql/keycache.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/keycache.h'
include/mysql/m_ctype.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/m_ctype.h'
include/mysql/m_string.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/m_string.h'
include/mysql/my_alloc.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_alloc.h'
include/mysql/my_attribute.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_attribute.h'
include/mysql/my_compiler.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_compiler.h'
include/mysql/my_config.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_config.h'
include/mysql/my_dbug.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_dbug.h'
include/mysql/my_dir.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_dir.h'
include/mysql/my_getopt.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_getopt.h'
include/mysql/my_global.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_global.h'
include/mysql/my_list.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_list.h'
include/mysql/my_net.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_net.h'
include/mysql/my_pthread.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_pthread.h'
include/mysql/my_sys.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_sys.h'
include/mysql/my_xml.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/my_xml.h'
include/mysql/mysql/client_plugin.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/client_plugin.h'
include/mysql/mysql/innodb_priv.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/innodb_priv.h'
include/mysql/mysql/plugin.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/plugin.h'
include/mysql/mysql/plugin_audit.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/plugin_audit.h'
include/mysql/mysql/plugin_auth.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/plugin_auth.h'
include/mysql/mysql/plugin_auth_common.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/plugin_auth_common.h'
include/mysql/mysql/plugin_ftparser.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/plugin_ftparser.h'
include/mysql/mysql/psi/mysql_file.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/psi/mysql_file.h'
include/mysql/mysql/psi/mysql_thread.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/psi/mysql_thread.h'
include/mysql/mysql/psi/psi.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/psi/psi.h'
include/mysql/mysql/psi/psi_abi_v1.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/psi/psi_abi_v1.h'
include/mysql/mysql/psi/psi_abi_v2.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/psi/psi_abi_v2.h'
include/mysql/mysql/service_my_snprintf.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/service_my_snprintf.h'
include/mysql/mysql/service_thd_alloc.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/service_thd_alloc.h'
include/mysql/mysql/service_thd_wait.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/service_thd_wait.h'
include/mysql/mysql/service_thread_scheduler.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/service_thread_scheduler.h'
include/mysql/mysql/services.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql/services.h'
include/mysql/mysql.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql.h'
include/mysql/mysql_com.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql_com.h'
include/mysql/mysql_embed.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql_embed.h'
include/mysql/mysql_time.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql_time.h'
include/mysql/mysql_version.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysql_version.h'
include/mysql/mysqld_ername.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysqld_ername.h'
include/mysql/mysqld_error.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/mysqld_error.h'
include/mysql/sql_common.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/sql_common.h'
include/mysql/sql_state.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/sql_state.h'
include/mysql/sslopt-case.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/sslopt-case.h'
include/mysql/sslopt-longopts.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/sslopt-longopts.h'
include/mysql/sslopt-vars.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/sslopt-vars.h'
include/mysql/typelib.h: Failed to create dir 'include/mysql'Can't create 'include/mysql/typelib.h'
lib/mysql/libmysqlclient.a: Failed to create dir 'lib/mysql'Can't create 'lib/mysql/libmysqlclient.a'
lib/mysql/libmysqlclient.so: Failed to create dir 'lib/mysql'Can't create 'lib/mysql/libmysqlclient.so'
lib/mysql/libmysqlclient.so.16: Failed to create dir 'lib/mysql'Can't create 'lib/mysql/libmysqlclient.so.16'
lib/mysql/libmysqlclient_r.a: Failed to create dir 'lib/mysql'Can't create 'lib/mysql/libmysqlclient_r.a'
lib/mysql/libmysqlclient_r.so: Failed to create dir 'lib/mysql'Can't create 'lib/mysql/libmysqlclient_r.so'
lib/mysql/libmysqlclient_r.so.16: Failed to create dir 'lib/mysql'Can't create 'lib/mysql/libmysqlclient_r.so.16'
lib/mysql/libmysqlservices.a: Failed to create dir 'lib/mysql'Can't create 'lib/mysql/libmysqlservices.a'
tar: Error exit delayed from previous errors.
pkg_add: extract_plist: can not invoke 2352 byte tar pipeline: /usr/bin/tar cf - man/man1/comp\_err.1.gz man/man1/msql2mysql.1.gz man/man1/mysql.1.gz man/man1/mysql\_config.1.gz man/man1/mysql\_find\_rows.1.gz man/man1/mysql\_waitpid.1.gz man/man1/mysqlaccess.1.gz man/man1/mysqladmin.1.gz man/man1/mysqlbinlog.1.gz man/man1/mysqlcheck.1.gz man/man1/mysqldump.1.gz man/man1/mysqlimport.1.gz man/man1/mysqlshow.1.gz man/man1/mysqlslap.1.gz bin/msql2mysql bin/mysql bin/mysql\_config bin/mysql\_find\_rows bin/mysql\_waitpid bin/mysqlaccess bin/mysqlaccess.conf bin/mysqladmin bin/mysqlbinlog bin/mysqlcheck bin/mysqldump bin/mysqlimport bin/mysqlshow bin/mysqlslap include/mysql/decimal.h include/mysql/errmsg.h include/mysql/keycache.h include/mysql/m\_ctype.h include/mysql/m\_string.h include/mysql/my\_alloc.h include/mysql/my\_attribute.h include/mysql/my\_compiler.h include/mysql/my\_config.h include/mysql/my\_dbug.h include/mysql/my\_dir.h include/mysql/my\_getopt.h include/mysql/my\_global.h include/mysql/my\_list.h include/mysql/my\_net.h include/mysql/my\_pthread.h include/mysql/my\_sys.h include/mysql/my\_xml.h include/mysql/mysql/client\_plugin.h include/mysql/mysql/innodb\_priv.h include/mysql/mysql/plugin.h include/mysql/mysql/plugin\_audit.h include/mysql/mysql/plugin\_auth.h include/mysql/mysql/plugin\_auth\_common.h include/mysql/mysql/plugin\_ftparser.h include/mysql/mysql/psi/mysql\_file.h include/mysql/mysql/psi/mysql\_thread.h include/mysql/mysql/psi/psi.h include/mysql/mysql/psi/psi\_abi\_v1.h include/mysql/mysql/psi/psi\_abi\_v2.h include/mysql/mysql/service\_my\_snprintf.h include/mysql/mysql/service\_thd\_alloc.h include/mysql/mysql/service\_thd\_wait.h include/mysql/mysql/service\_thread\_scheduler.h include/mysql/mysql/services.h include/mysql/mysql.h include/mysql/mysql\_com.h include/mysql/mysql\_embed.h include/mysql/mysql\_time.h include/mysql/mysql\_version.h include/mysql/mysqld\_ername.h include/mysql/mysqld\_error.h include/mysql/sql\_common.h include/mysql/sql\_state.h include/mysql/sslopt-case.h include/mysql/sslopt-longopts.h include/mysql/sslopt-vars.h include/mysql/typelib.h lib/mysql/libmysqlclient.a lib/mysql/libmysqlclient.so lib/mysql/libmysqlclient.so.16 lib/mysql/libmysqlclient\_r.a lib/mysql/libmysqlclient\_r.so lib/mysql/libmysqlclient\_r.so.16 lib/mysql/libmysqlservices.a share/aclocal/mysql.m4|/usr/bin/tar --unlink -xpPf - -C /usr/local
pkg_add: pkg_add of dependency 'mysql-client-5.5.9' failed!
[root@OgruFreeNAS] ~#

I'm a n00b but it looks for me like some kind of permission issue.

Could someone please advise.


Thank you.

Ogru

 

[b1ghen]

I have been wanting to do this for some time as well, never got around to it though.

The turorial is for FreeNas 0.7 and not for FreeNas 8 that you are running, I assume you need to use jails and such to do this in FreeNas 8 so the procedure would be quite different.