spotweb: retrieve.php not working

Hi All,

On a fresh Ubuntu 16.04.1 LTS with php7 the retrieve.php is telling me:

root@mysql1:/var/www/html/spotweb# php retrieve.php Unable to connect to database: No database settings have been entered, please use the ‘install.php’ wizard to install and configure Spotweb. If you are upgrading from an earlier version of Spotweb, please consult https://github.com/spotweb/spotweb/wiki/Frequently-asked-questions/ first

Now obviously I have run the http://<host>/spotweb/install.php (twice), the output is all ok and the the dbsettings.inc.php is created. The frontend is working fine and the user is also allowed to connect to the database.

(not to worry, this is NOT the actual password) root@mysql1:/var/www/html/spotweb# cat dbsettings.inc.php

<?php
$dbsettings['engine'] = 'pdo_mysql';
$dbsettings['host'] = 'localhost';
$dbsettings['dbname'] = 'spotweb';
$dbsettings['user'] = 'spotweb';
$dbsettings['pass'] = 'slipTongQuig1';
root@mysql1:/var/www/html/spotweb# mysql spotweb -h 127.0.0.1 -u spotweb -pslipTongQuig1
mysql: [Warning] Using a password on the command line interface can be insecure.
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 74
Server version: 5.7.16-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Any idea what could cause this issue? Is spotweb php7 ready?

Thanks for any response. Paul.

About this issue

  • Original URL
  • State: closed
  • Created 8 years ago
  • Comments: 26 (5 by maintainers)

Commits related to this issue

Most upvoted comments

Ok, for some reason php retrieve.php is unable to determine where it lives. The result is that lib/Bootstrap.php is unable to open dbsettings.inc.php. I have updated 2 things in lib/Bootstrap.php and that is: line 81: @include “/var/www/html/spotweb/dbsettings.inc.php”; line 166: require “/var/www/html/spotweb/settings.php”;

And in settings.php Line 42: $settings[‘openssl_cnf_path’] = “/var/www/html/spotweb/lib/openssl/openssl.cnf”;

Things are starting to work again… (not quite there yet)

Retrieving new Spots from server news.eu.supernews.com… PHP Warning: stream_socket_client(): Peer certificate CN=news.supernews.com' did not match expected CN=news.eu.supernews.com’ in /var/www/html/spotweb/vendor/gdwebs/nntp/src/Protocol/Client.php on line 725 PHP Warning: stream_socket_client(): Failed to enable crypto in /var/www/html/spotweb/vendor/gdwebs/nntp/src/Protocol/Client.php on line 725 PHP Warning: stream_socket_client(): unable to connect to ssl://news.eu.supernews.com:563 (Unknown error) in /var/www/html/spotweb/vendor/gdwebs/nntp/src/Protocol/Client.php on line 725 SpotWeb v0.67.28.31 on PHP v7.0.8-0ubuntu0.16.04.3 crashed

@pjanzen I got the same errors. Followed your directions and it worked for me.

Thanks 😃