nZEDB database setup failing

[diedrichg]

@Joshua Parker Ruehlig I'm having a heck of a time getting through the web setup for nzedb. I've successfully made it through the https://github.com/nZEDb/nZEDb/wiki/Install-Guide:-FreeNAS-(FreeBSD) guide through to Part 3. The only thing I had to change along the way was the part where I had to swap the default fastcgi comments because I was getting a 502 error.

Code:

# Uncomment the following line and comment the .sock line if you want to use TCP.
	# fastcgi_pass 127.0.0.1:9000;
	fastcgi_pass unix:/var/run/php-fpm.sock;

Once I made it to the webui setup I was able to get to the database setup page but then I keep getting this

What's going on?

If I change the @localhost to @192.168.1.25 to the database

Code:

grant all privileges on nzedb.* to 'nzedb'@'localhost' identified by 'your-password';

then I get past the database setup screen (screenshot above but changing the Hostname to 192.168.1.25) but then I get a blank page http://192.168.1.51/install/step2.php?

 

[diedrichg]

Update:
I manually typed in the next install step into the URL bar and was able to go to the step3.php page (http://192.168.1.51/install/step3.php). I was able to make it to step5.php but then step6.php and step7.php are both blank if I type them in manually. It sounds like there is something wrong with the nzedb freebsd git clone?

 

[Allan Wilmath]

Internet and networking rely a lot on domain and host names, DNS. Having a legitimate DNS server with up to date entries can make a lot of this stuff to work properly.

giving your gas a proper host name, and and using a proper domain name, having all of this configured across your network would help machines find each other. For instance if your FreeNAS box has a different domain name than your client computer, that can cause problems. This is where you can set everything the same by doing the work configuring your DHCP server, reserving IP addressing for MAC addresses of your servers.

The solution to your problem is in whatever you are using for a router.
Then you can avoid services not links not being able to find each other.

 

[diedrichg]

I found the fix for getting blank pages during the install process. It has to do with having the mysql database pre-filled with some data. I updated the wiki install page with

Code:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

The final issue to deal with is the location of php-fpm.sock. This can be overcome as per the modified instructions at the bottom of the wiki install page.