nZEDb errors with database setup

[NasKar]

I'm trying to recreate nZEDb in a jail as my old jail stopped allowing me to access it with the jexec 9 csh command. https://forums.freenas.org/index.php?threads/jexec-execvp-tcsh-no-such-file-or-directory.42927/

I got everything working and can run the nZEDb web interface to set it up but get stuck at the Database Setup with the errors:
The following error(s) were encountered:
• Unable to connect to database:
Unable to connect to the SQL server

[root@freenas] /# jexec 9 csh
jexec: execvp(): csh: No such file or directory

root@SQL:/var/db/mysql # service mysql-server start
mysql already running? (pid=86792).

I'm not sure how to use 'sockstart' to show if it is listening where I expect. Any other ideas on how to either fix the broken jail or connect to the SQL server would be appreciated.

 

[depasseg]

What is the output of jls?

 

[NasKar]

Making some progress. I created a new user name in the Mariadb and was able to login into it with mysql -u nzedb2 -p -h localhost nzedb.
I no longer get errors on the db setup of the nzedb web interface but get
The 192.168.1.156 page isn’t working
192.168.1.156 is currently unable to handle this request.

500
php-fpm is running
Any ideas?

 

[NasKar]

What is the output of jls?

jls
JID IP Address Hostname Path
1 - SQL /mnt/v1/jails/SQL
2 - crashplan_1 /mnt/v1/jails/crashplan_1
3 - emby_1 /mnt/v1/jails/emby_1
5 - nzedb /mnt/v1/jails/nzedb
6 - plexmediaserver_1 /mnt/v1/jails/plexmediaserver_1
7 - sabnzbd_1 /mnt/v1/jails/sabnzbd_1
9 - nZEDb /mnt/v1/jails/nZEDb
where #9 was the working nZEDb
jexec 9 tcsh
jexec: execvp(): tcsh: No such file or directory

 

[depasseg]

Have you tried jexec 9 sh? What about using ssh to connect directly?

 

[NasKar]

[root@freenas] /# jexec 9 sh
#

What about using ssh to connect directly?

How do you do that?

 

[depasseg]

So my guess is whatever you are trying to do is messing up the shell. It looks like 'sh' still works so you can use that instead of tcsh or csh.

 

[NasKar]

sh doesn't seem to work either as I can't do an ls -l command

 

[depasseg]

What did you do inside that jail before it stopped working?

 

[NasKar]

I think I was pasting code into a nano window and typing ctrl x to save and exit.

 

[NasKar]

After typing : screen sh simple-expanded.sh
PHP Fatal error: Class 'nzedb\db\DB' not found in /usr/local/www/nZEDb/nzedb/db/Settings.php on line 28
find: illegal option -- t
usage: find [-H | -L | -P] [-EXdsx] [-f path] path ... [expression]
find [-H | -L | -P] [-EXdsx] -f path [path ...] [expression]
override r-xr-xr-x root/wheel for /bin/tcsh?
Not sure what option I typed.