installation issue (debian 12, nginx 1.22, php 8.2, mariadb-server 10.11.4)
I am attempting to install zoph on a debian system under nginx (instead of the recommended apache2). I know that there is a zoph
package but I do want to run under nginx which is not possible with the latter. I did try to follow the installation steps, namely
- install all php prerequisites and activate php on nginx server (I did check that php works correctly and is able to read/write files in
/var/www/htlm/
) - install the
mariadb-server
package and create two userszoph_admin
,zoph_rw
and azoph
database - copy the website to
/var/www/htlm/zoph/
- make a
/etc/zoph.ini
However, when connecting to the website at http://localhost/zoph
it redirects me to http://localhost/zoph/install
which in turn returns a 404.
Also, when trying to launch the zoph
cli I got
$ zoph
Error: Incorrect language header in /var/www/html/zoph/lang/zoph_strings.txt language.inc.php: 98.
Debug: <pre># to create a new language file, translate these string and rename this file
</pre> language.inc.php: 100.
Debug: SQL Query: SELECT * FROM zoph_albums; db.inc.php: 182.
PHP Fatal error: Uncaught db\exception: SQL failed
#0 /var/www/html/zoph/classes/db/db.inc.php(183): PDO->prepare()
#1 /var/www/html/zoph/classes/zophTable.inc.php(636): db\db::query()
#2 /var/www/html/zoph/classes/zophTable.inc.php(587): zophTable::getRecordsFromQuery()
#3 /var/www/html/zoph/classes/zophTable.inc.php(772): zophTable::getRecords()
#4 /var/www/html/zoph/classes/conf/confDefault.inc.php(170): zophTable::getSelectArray()
#5 /var/www/html/zoph/classes/conf/confDefault.inc.php(55): conf\confDefault::getConfigInterface()
#6 /var/www/html/zoph/classes/conf/conf.inc.php(70): conf\confDefault::getConfig()
#7 /var/www/html/zoph/classes/conf/conf.inc.php(165): conf\conf::loadFromDB()
#8 /var/www/html/zoph/classes/auth/cli.inc.php(45): conf\conf::get()
#9 /usr/local/bin/zoph(97): auth\cli->__construct()
#10 /usr/local/bin/zoph(66): init()
#11 {main}
SELECT * FROM zoph_albums;
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zoph.zoph_albums' doesn't exist
in /var/www/html/zoph/classes/db/db.inc.php:208
Stack trace:
#0 /var/www/html/zoph/classes/zophTable.inc.php(636): db\db::query()
#1 /var/www/html/zoph/classes/zophTable.inc.php(587): zophTable::getRecordsFromQuery()
#2 /var/www/html/zoph/classes/zophTable.inc.php(772): zophTable::getRecords()
#3 /var/www/html/zoph/classes/conf/confDefault.inc.php(170): zophTable::getSelectArray()
#4 /var/www/html/zoph/classes/conf/confDefault.inc.php(55): conf\confDefault::getConfigInterface()
#5 /var/www/html/zoph/classes/conf/conf.inc.php(70): conf\confDefault::getConfig()
#6 /var/www/html/zoph/classes/conf/conf.inc.php(165): conf\conf::loadFromDB()
#7 /var/www/html/zoph/classes/auth/cli.inc.php(45): conf\conf::get()
#8 /usr/local/bin/zoph(97): auth\cli->__construct()
#9 /usr/local/bin/zoph(66): init()
#10 {main}
thrown in /var/www/html/zoph/classes/db/db.inc.php on line 208
Any help would be appreciated.