Failure to install ojs

Software Support
21

Hola de nuevo @Betania_E_Jimenez , como te ha indicado mohd, verifica si tienes instalado el módulo php-mysql

apt-get search php mysql

apt-get install php-mysql
/etc/init.d/apache2 restart

Normalmente en ubuntu/debian no es necesario especificar en los php.ini la carga del módulo. Normalmente.

22

@juanito si esta instalado y el archivo config.inc.php tanto de ojs como de html tienen la configuracion de base de datos asi:
driver = mysqli

23

Marque en la instalación

[x] Crear nueva base de datos

A ver si así te la crea y php puede interactuar con mysql. Eso en el caso que el usuario y la contraseña estén bien puestas. y Observe el log en tiempo real con tail -f a ver que le dice…

24

@juanito este es el resultado
::1 - - [15/Apr/2020:14:40:42 -0400] “GET /ojs/index.php/index/install HTTP/1.1” 200 6966 “-” “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.162 Safari/537.36”
::1 - - [15/Apr/2020:14:40:42 -0400] “GET /ojs/index.php/index/$$$call$$$/page/page/user-nav-backend?_=1586976042075 HTTP/1.1” 200 1338 “http://localhost/ojs/index.php/index/install” “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.162 Safari/537.36”
::1 - - [15/Apr/2020:14:41:16 -0400] “POST /ojs/index.php/index/install/install HTTP/1.1” 500 185 “http://localhost/ojs/index.php/index/install” “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.162 Safari/537.36”

y esto en el error.log
PHP Fatal error: Uncaught Error: Call to undefined function mysqli_connect_error() in /var/www/html/ojs/lib/pkp/lib/adodb/drivers/adodb-mysqli.inc.php:777\nStack trace:\n#0 /var/www/html/ojs/lib/pkp/classes/install/PKPInstall.inc.php(82): ADODB_mysqli->ErrorMsg()\n#1 /var/www/html/ojs/lib/pkp/classes/install/Installer.inc.php(178): PKPInstall->preInstall()\n#2 /var/www/html/ojs/lib/pkp/classes/install/form/InstallForm.inc.php(195): Installer->execute()\n#3 /var/www/html/ojs/lib/pkp/pages/install/InstallHandler.inc.php(67): InstallForm->execute()\n#4 /var/www/html/ojs/lib/pkp/classes/core/PKPRouter.inc.php(390): InstallHandler->install(Array, Object(Request))\n#5 /var/www/html/ojs/lib/pkp/classes/core/PKPPageRouter.inc.php(231): PKPRouter->_authorizeInitializeAndCallRequest(Array, Object(Request), Array, false)\n#6 /var/www/html/ojs/lib/pkp/classes/core/Dispatcher.inc.php(134): PKPPageRouter->route(Object(Request))\n#7 /var/www/html/ojs/lib/pkp/classes/core/PKPApplication.inc.php(252): Dispatcher->dispatch(Object(Request))\n#8 /var/www/ in /var/www/html/ojs/lib/pkp/lib/adodb/drivers/adodb-mysqli.inc.php on line 777, referer: http://localhost/ojs/index.php/index/install

25

whats the output if you run this

php -m | grep -i mysql
26

hi @mohd_arshad doesn’t show anything

27

whats the output if you run this

php -v
28

this comes out:

PHP 7.2.29-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: Mar 20 2020 13:54:16) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
with Zend OPcache v7.2.29-1+ubuntu16.04.1+deb.sury.org+1, Copyright (c) 1999-2018, by Zend Technologies

29

whats the output if you run this

ls /etc/apache2/mods-available/php*
30

/etc/apache2/mods-available/php7.2.conf
/etc/apache2/mods-available/php7.2.load
/etc/apache2/mods-available/php7.4.conf
/etc/apache2/mods-available/php7.4.load

31

whats the output if you run this

php -m
32

@mohd_arshad [PHP Modules]
Core
curl
date
dom
filter
gd
hash
intl
json
ldap
libxml
mbstring
openssl
pcntl
pcre
readline
Reflection
session
SimpleXML
soap
sodium
SPL
standard
wddx
xml
xmlreader
xmlrpc
xmlwriter
xsl
Zend OPcache
zip
zlib

[Zend Modules]
Zend OPcache

Thanks for the help

33

seems like missing mysql
run this

apt-get install php7.2-mysql

and then run again

php -m
34

when i run
apt-get install php7.2-mysql

this is the out:
Reading package list … Done
Creating dependency tree
Reading status information … Done
php7.2-mysql is already in its latest version (7.2.29-1 + ubuntu16.04.1 + deb.sury.org + 1).
0 updated, 0 new will be installed, 0 to remove and 22 not updated
.[PHP Modules]
Core
curl
date
dom
filter
gd
hash
intl
json
ldap
libxml
mbstring
openssl
pcntl
pcre
readline
Reflection
session
SimpleXML
soap
sodium
SPL
standard
wddx
xml
xmlreader
xmlrpc
xmlwriter
xsl
Zend OPcache
zip
zlib

[Zend Modules]
Zend OPcache

35

the problem is the mysql module doesnt load… so somehow we need to enable it…

36

run this command

phpenmod mysqli

then restart

service apache2 restart

then check the module

php -m
37

phpenmod mysqli

WARNING: Module mysqli ini file doesn’t exist under /etc/php/7.2/mods-available
WARNING: Module mysqli ini file doesn’t exist under /etc/php/7.2/mods-available
WARNING: Module mysqli ini file doesn’t exist under /etc/php/7.2/mods-available
WARNING: Module mysqli ini file doesn’t exist under /etc/php/7.0/mods-available

and when i run ls /etc/php/7.2/mods-available:

curl.ini gd.ini json.ini mbstring.ini readline.ini soap.ini xml.ini xmlrpc.ini xsl.ini
dom.ini intl.ini ldap.ini opcache.ini simplexml.ini wddx.ini xmlreader.ini xmlwriter.ini zip.ini

38

try this command

apt-get install -y php7.2-mysqli

restart apache and check the module again

39

this is the out:
Reading package list … Done
Creating dependency tree
Reading status information … Done
Note, selecting “php7.2-mysql” instead of “php7.2-mysqli”
php7.2-mysql is already in its latest version (7.2.29-1 + ubuntu16.04.1 + deb.sury.org + 1).
0 updated, 0 new will be installed, 0 to remove and 22 not updated.

40

can you create phpinfo.php with this code inside

<? phpinfo(); ?>

and view if mysqli is enable?