Freenas und MYSQL

Hardwarefreaky · 28. November 2014

Hiho,

Ich habe vor wenigen Tagen mein Windows Server aufgelöst und mit ein Eigenbau Nas mit Freenas zusammen gebaut.
Ich bin auch so ganz zufrieden und er reicht definitiv für meine zwecke. Allerdings benötige ich Mysql und das bekomm ich nicht installiert. Mein Englisch ist auch total schlecht was das ganze noch erschwert.

Folgende Anleitung habe ich versucht.

http://rediantosatya.wordpress.com/2012/03/07/how-to-install-mysql-on-embedded-freenas/
http://geekfreely.blogspot.de/2014/02/installing-centralized-mysql-db-on.html

beide scheitern beim Installieren von Mysql. Ordner und Benutzer erstellen klapte.

folgendes kommt

[root@freenas] ~# pkg_add -r mysql55-server -P /mnt/disk1/Services/pkg
Fetching ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-9.2-release/Latest/mysql55-server.tbz... Done.
Fetching ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-9.2-release/All/mysql-client-5.5.33.tbz... Done.

/mnt: write failed, filesystem is full
bin/mysql: Write failed
bin/mysql_config: Write to restore size failed
bin/mysql_find_rows: Write to restore size failed
bin/mysql_waitpid: Write to restore size failed
bin/mysqlaccess: Write to restore size failed
bin/mysqlaccess.conf: Write to restore size failed
bin/mysqladmin: Write to restore size failed
bin/mysqlbinlog: Write to restore size failed
bin/mysqlcheck: Write to restore size failed
bin/mysqldump: Write to restore size failed
bin/mysqlimport: Write to restore size failed
bin/mysqlshow: Write to restore size failed
bin/mysqlslap: Write to restore size failed
include/mysql/decimal.h: Write to restore size failed
include/mysql/errmsg.h: Write to restore size failed
include/mysql/keycache.h: Write to restore size failed
include/mysql/m_ctype.h: Write to restore size failed
include/mysql/m_string.h: Write to restore size failed
include/mysql/my_alloc.h: Write to restore size failed
include/mysql/my_attribute.h: Write to restore size failed
include/mysql/my_compiler.h: Write to restore size failed
include/mysql/my_config.h: Write to restore size failed
include/mysql/my_dbug.h: Write to restore size failed
include/mysql/my_dir.h: Write to restore size failed
include/mysql/my_getopt.h: Write to restore size failed
include/mysql/my_global.h: Write to restore size failed
include/mysql/my_list.h: Write to restore size failed
include/mysql/my_net.h: Write to restore size failed
include/mysql/my_pthread.h: Write to restore size failed
include/mysql/my_sys.h: Write to restore size failed
include/mysql/my_xml.h: Write to restore size failed
include/mysql/mysql/client_plugin.h: Write to restore size failed
include/mysql/mysql/innodb_priv.h: Write to restore size failed
include/mysql/mysql/plugin.h: Write to restore size failed
include/mysql/mysql/plugin_audit.h: Write to restore size failed
include/mysql/mysql/plugin_auth.h: Write to restore size failed
include/mysql/mysql/plugin_auth_common.h: Write to restore size failed
include/mysql/mysql/plugin_ftparser.h: Write to restore size failed
include/mysql/mysql/psi/mysql_file.h: Write to restore size failed
include/mysql/mysql/psi/mysql_thread.h: Write to restore size failed
include/mysql/mysql/psi/psi.h: Write to restore size failed
include/mysql/mysql/psi/psi_abi_v1.h: Write to restore size failed
include/mysql/mysql/psi/psi_abi_v2.h: Write to restore size failed
include/mysql/mysql/service_my_snprintf.h: Write to restore size failed
include/mysql/mysql/service_thd_alloc.h: Write to restore size failed
include/mysql/mysql/service_thd_wait.h: Write to restore size failed
include/mysql/mysql/service_thread_scheduler.h: Write to restore size failed
include/mysql/mysql/services.h: Write to restore size failed
include/mysql/mysql/thread_pool_priv.h: Write to restore size failed
include/mysql/mysql.h: Write to restore size failed
include/mysql/mysql_com.h: Write to restore size failed
include/mysql/mysql_embed.h: Write to restore size failed
include/mysql/mysql_time.h: Write to restore size failed
include/mysql/mysql_version.h: Write to restore size failed
include/mysql/mysqld_ername.h: Write to restore size failed
include/mysql/mysqld_error.h: Write to restore size failed
include/mysql/sql_common.h: Write to restore size failed
include/mysql/sql_state.h: Write to restore size failed
include/mysql/sslopt-case.h: Write to restore size failed
include/mysql/sslopt-longopts.h: Write to restore size failed
include/mysql/sslopt-vars.h: Write to restore size failed
include/mysql/typelib.h: Write to restore size failed
lib/mysql/libmysqlclient.a: Write to restore size failed
lib/mysql/libmysqlclient.so: Write to restore size failed
lib/mysql/libmysqlclient.so.18: Write to restore size failed
lib/mysql/libmysqlclient_r.a: Write to restore size failed
lib/mysql/libmysqlclient_r.so: Write to restore size failed
lib/mysql/libmysqlclient_r.so.18: Write to restore size failed
lib/mysql/libmysqlservices.a: Write to restore size failed
share/aclocal/mysql.m4: Write to restore size failed
tar: (Empty error message)
tar: Error exit delayed from previous errors.
pkg_add: extract_plist: can not invoke 2536 byte tar pipeline: /usr/bin/tar cf - share/licenses/mysql-client-5.5.33/catalog.mk share/licenses/mysql-client-5.5.33/LICENSE share/licenses/mysql-client-5.5.33/GPLv2 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/thread\_pool\_priv.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.18 lib/mysql/libmysqlclient\_r.a lib/mysql/libmysqlclient\_r.so lib/mysql/libmysqlclient\_r.so.18 lib/mysql/libmysqlservices.a share/aclocal/mysql.m4|/usr/bin/tar --unlink -xpPf - -C /mnt/disk1/Services/pkg
pkg_add: pkg_add of dependency 'mysql-client-5.5.33' failed!

was ich ja noch verstehe ist:
/mnt: write failed, filesystem is full
aber auf den HDDs dadrinn ist noch 1,7tb frei und der USB Stick wo freenas drauf ist, ist 32gb groß also das sollte auch passen.

Hoffe jemand kann mir helfen.

DarkAngel · 28. November 2014

Lass dir mal mittels "df" die Festplatten Belegung Anzeigen. Und dann poste hier mal die Ausgabe die deinen Stick betreffen.

Hasamaatlas · 28. November 2014

Oder

df -h

. Vielleicht besser anzuschauen.

Hardwarefreaky · 28. November 2014

Filesystem Size Used Avail Capacity Mounted on
/dev/ufs/FreeNASs1a 926M 705M 146M 83% /
devfs 1.0k 1.0k 0B 100% /dev
/dev/md0 4.6M 3.3M 895k 79% /etc
/dev/md1 823k 2.0k 756k 0% /mnt
/dev/md2 149M 17M 119M 13% /var
/dev/ufs/FreeNASs4 19M 1.1M 17M 6% /data
Raid5 5.2T 3.5T 1.7T 67% /mnt/Raid5
Raid5/.system 1.7T 256k 1.7T 0% /mnt/Raid5/.system
Raid5/.system/cores 1.7T 209k 1.7T 0% /mnt/Raid5/.system/cores
Raid5/.system/rrd-f6da24756e2f4dee86c3a9c9fb75829f 1.7T 209k 1.7T 0% /mnt/Raid5/.system/rrd-f6da24756e2f4dee86c3a9c9fb75829f
Raid5/.system/samba4 1.7T 634k 1.7T 0% /mnt/Raid5/.system/samba4
Raid5/.system/syslog-f6da24756e2f4dee86c3a9c9fb75829f 1.7T 506k 1.7T 0% /mnt/Raid5/.system/syslog-f6da24756e2f4dee86c3a9c9fb75829f
Raid5/jails 1.7T 395k 1.7T 0% /mnt/Raid5/jails
Raid5/jails/.warden-template-pluginjail 1.7T 784M 1.7T 0% /mnt/Raid5/jails/.warden-template-pluginjail
Raid5/jails/sabnzbd_1 1.7T 1G 1.7T 0% /mnt/Raid5/jails/sabnzbd_1
devfs 1.0k 1.0k 0B 100% /mnt/Raid5/jails/sabnzbd_1/dev
procfs 4.0k 4.0k 0B 100% /mnt/Raid5/jails/sabnzbd_1/proc

da ich jetzt davon ausgehe das diese disk1 nicht exestiert habe ich die anleitung noch mal von vorne befolgt und habe sie immer durch raid5 ausgetauscht und es passiert das gleiche.

Hasamaatlas · 28. November 2014

Jetzt weiß ich erstmal was Du mit Disk1 meinst. Laut der Anleitung sollst Du ja unter

/mnt/disk1/Services/

einen Ordner namens

pkg

erstellen und ihm die Rechte 777 geben.

Ordner erstellen:

Code:

mkdir /mnt/disk1/Services/pkg

Rechte vergeben:

Code:

chmod -R 777 /mnt/disk1/Services/pkg

Schau doch mal im mnt ob da ein Verzeichnis disk1 ist. Also

Code:

cd mnt

und dann

Code:

ls

.

Hardwarefreaky · 28. November 2014

wenn ich das bei putty eingebe kommt.
mnt: No such file or directory.
aber das exestiert doch auf jedenfall immerhin habe ich die Paritation Raid5 ja auch im Netzwerk freigegeben und ich greif drauf zu.

edit: eine andere Frage Stablebit Drivepool funktioniert das wie Raid 5?
Dann pack ich mir nämlich wieder windows drauf. Hab jetzt mal testweise auf mein Rechner installiert aber da sind nur 2hdds und dann kann es natürlich nur wie raid1 funktionieren.

edit2:
Hab es hinbekommen!!
Mit der Anleitung ist es Idioten Sicher.
http://kodi.wiki/view/HOW-TO:Share_libraries_using_MySQL/Setting_up_MySQL#tab=FreeNAS_and_freeBSD

thompson004 · 28. November 2014

Man soll auch /mnt und nicht mnt eingeben @hasamaatlas. Beim nächsten Mal bitte genauer

Suche

Freenas und MYSQL

Hardwarefreaky

Ensign

DarkAngel

Lieutenant

Hasamaatlas

Lt. Junior Grade

Hardwarefreaky

Ensign

Hasamaatlas

Lt. Junior Grade

Hardwarefreaky

Ensign

thompson004

Admiral

Ähnliche Themen