[Outdated] HowTO: Install nZEDb on Ubuntu 16.0.4

[digger]

.

[Wally73]

add the timezone values to MySQL's timezone tables

Code: [Select]

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot -pyourpassword mysql
If you have an older install, you might also have to add the date.timezone setting to the php.ini file. Make sure to quote it.

[digger]

date.timezone is in step 10.

[kaibosh]

This is currently the best guide there is for Ubu 16.04. Be sure to load the TZ data into the DB was Wally mentions above.

[ragga64]

Step 8: Install yEnc  [ERROR]

like to say thank you for the good write up for the install.
there was  a thew hickups but finaly got round them, [Step 8: Install yEnc ] came across an error that kept coming up, and for some reason it was saying php7.0 not in stalled, even thow it was, so  apt-get install php7.0  reinstalled and all was good.
this is the first time i manage to get to install page with your install guied, would always get white screen myip/install antill now.
and again nice guied and many thank.
 ragga

[ragga64]

Spoke to soon
got new error.
ERROR: unable to connect to usenet
yet checked the config .php and is all set up in there ok and don't know were else i can look, as ubuntu is not my best plus running on VM

[11-Feb-2018 20:38:06 Europe/London] PHP Notice:  Only variables should be assigned by reference in /usr/share/php/PEAR.php on line 601 [11-Feb-2018 20:38:06 Europe/London] PHP Warning:  stream_socket_client(): Peer certificate CN=`news.sslusenet.com' did not match expected CN=`europe-ssl.newsdemon.com' in /var/www/nZEDb/libs/PEAR/Net_NNTP/NNTP/Protocol/Client.php on line 514 [11-Feb-2018 20:38:06 Europe/London] PHP Warning:  stream_socket_client(): Failed to enable crypto in /var/www/nZEDb/libs/PEAR/Net_NNTP/NNTP/Protocol/Client.php on line 514 [11-Feb-2018 20:38:06 Europe/London] PHP Warning:  stream_socket_client(): unable to connect to tls://europe-ssl.newsdemon.com:563 (Unknown error) in /var/www/nZEDb/libs/PEAR/Net_NNTP/NNTP/Protocol/Client.php on line 514 [11-Feb-2018 20:38:06 Europe/London] PHP Notice:  Only variables should be assigned by reference in /usr/share/php/PEAR.php on line 601 [11-Feb-2018 20:38:06 Europe/London] PHP Notice:  Only variables should be assigned by reference in /usr/share/php/PEAR.php on line 601

/ Use the aforementioned CA bundle file to verify remote SSL certificates when connecting to a server using TLS/SSL.
define('nZEDb_SSL_VERIFY_PEER', '');      [took out the 1 ]
// Verify the host is who they say they are.
define('nZEDb_SSL_VERIFY_HOST', '');     [took out the 1 ]
// Allow self signed certificates. Note this does not work on CURL as CURL does not have this option.
define('nZEDb_SSL_ALLOW_SELF_SIGNED', '1');  [put the 1 in ]


and now seems to be working   

[Roelski]

Can anyone add instructions on how to get updating to work?

i tried this, but failed in the last step:

--
--removed a lot of junk--
-

// edit ***********************
Ok, I figured it out.

// accidental composer installed. First need to remove package
sudo apt-get remove composer

mkdir ~/composerinstall
cd ~/composerinstall
php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
php -r "if (hash_file('SHA384', 'composer-setup.php') === '544e09ee996cdf60ece3804abc52599c22b1f40f4323403c44d44fdfdd586475ca9813a858088ffbc1f233e9b180f061') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"
sudo php composer-setup.php --install-dir=/usr/bin
php -r "unlink('composer-setup.php');"

// Composer (version 1.6.5) successfully installed to: /usr/bin/composer.phar
// Use it: php /usr/bin/composer.phar

cd /var/www/nZEDb/
sudo cp /usr/bin/composer.phar /usr/bin/composer
// ok, should have created a ln

// try updating (and stopping tmux, and restarting it):
cd /var/www/nZEDb/
tmux kill-session -t nZEDb
sudo ./zed update nzedb
rm /var/www/nZEDb/resources/smarty/templates_c/*
cd /var/www/nZEDb/misc/update/nix/tmux/
php start.php

// YESSSS (but no updates found, lol)

[pdupreez]

Code: [Select]

/var/log$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p

doesn't work anymore. You have to use sudo on mysql now

Code: [Select]

/var/log$ mysql_tzinfo_to_sql /usr/share/zoneinfo | sudo mysql -u root mysql
also

Code: [Select]

sudo apt-get –f install doesn't work if you copy & paste the code above, as the - is actually – which is not the same of course

[pdupreez]

Actually, the whole sequence in some areas are messed up. In step 9, you will use curl but later will be asked to install it. Same with the php7.0 installation, which was done earlier in the installation. Something is wrong here......