MySQL on NAS - problem

[web-nas-tom]

FreeNAS works on ip 192.168.1.5

1 The problem with running mysql (worked)

root @ www :/ # / usr / local / etc / rc.d / mysql-server start
Starting mysql.
su: pam_start: system error
/ usr / local / etc / rc.d / mysql-server: WARNING: failed to start mysql


2 I can not connect via ssh (work)

[root @ FreeNAS] ~ # ssh root@192.168.1.1
Connection closed by 192.168.1.1


PermitRootLogin is set to yes (ie you can connect as root)

 

[dlavigne]

This post makes no sense. What is it you are trying to do? What is the IP address of the jail? Which version of FreeNAS?

 

[web-nas-tom]

version 9.0.2,
I have problem with starting mysql service.
Maybe someone know what to do, and help me?

 

[dlavigne]

Not without more information. What command did you use to install mysql? What type of jail did you install it into? What are the settings on that jail?

 

[web-nas-tom]

instalation was by ssh:

# cd /usr/ports/databases/mysql55-server/
# make
# make install
To be able to start the MySQL server add the following to your /etc/rc.conf
mysql_enable="YES"
Type : pluginjail

i thing someting is wrong by premitions, i cant login to shh by putty - www only.

 

[DoubleIPA]

I'm not sure about your setup, but for my mysql setup I have a different IP address then the freenas address. My Mysql is under jails. That being said, you're accessing mysql through 192.168.1.1, which is normally your routers internal address. Is your mysql install showing up under jails? Is it set to autostart?

 

[web-nas-tom]

NAS have ip 192.168.1.2
Jails Server is 192.168.1.1

As is to be available on other ip mysql if not going to run it :) and autostart will not work.

 

[DoubleIPA]

NAS have ip 192.168.1.2
Jails Server is 192.168.1.1

As is to be available on other ip mysql if not going to run it :) and autostart will not work.

Did you follow these instructions or someone else's when installing? Can you start MySQL manually from the shell?

Code:

Here is a walkthrough:
 
SSH in freenas
jexec 1 csh
 
>in jail
pkg_add -r mysql55-server
 
vi /etc/rc.conf
>add line
mysql_enable="YES"
 
service mysql-server start
 
>exit and re-enter the jail
 
mysql_secure_installation
 
mysql -u root -p
 
>in mysql

From here: http://forums.freenas.org/index.php?threads/mysql-plugin.9338/
Also this is good: http://wiki.xbmc.org/index.php?titl...ySQL/Setting_up_MySQL#tab=FreeNAS_and_freeBSD

 

[joelmusicman]

Re: SSH - did you edit the rc.conf file to enable sshd, and then start the sshd service?