Softaculous

Topic : Setup Ispconfi3 Centos 6.5

Page 1 of 2

Posted By: freddy on September 2, 2014, 12:18 pm

good morning to all I have a problem with SOFTA I installed everything as a guide for ispconfig3 3.0.5.4p3 log on

/var/softaculous/error.log gives me this error:
[01-Sep-2014 14:07:45] PHP Fatal error: Class 'mysqli' not found in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 31

I tried to check the directory is not configured here it is:

db class extends mysqli
{
private $ dbhost = ''; // Hostname of the MySQL server
private $ dbName = ''; That // logical database name on server
private $ dbUser = ''; // Database for authorized user
private $ dbpass = ''; // User's password
private $ dbCharset = 'utf8'; // Database charset
private $ dbNewLink = false; Return to // new linkID When connect is called again
private $ dbClientFlags = 0; // MySQL Client falgs
private $ linkID = 0; // Last result of mysqli_connect ()
private $ QueryId = 0; // Last result of mysqli_query ()
private $ record = array (); // Last record fetched
private $ autoCommit = 1; // Autocommit Transactions
private $ currentRow; // Current row number
private $ ErrorNumber = 0; // Last error number
public $ errorMessage = ''; // Last error message
private $ errorLocation = ''; // last error location
public $ show_error_messages = false; // False in the server, in true interface
private $ isConnected = false; // Needed to know if we have a valid mysqli object from the constructor

I tried to put php.ini config softacoluos of these strings but nothing ...

extension = mysql.so
extension = mysqli.so
extension = curl.so

blank page

test url: https://188.165.85.25:8080/softaculous/

Posted By: jigar on September 2, 2014, 12:28 pm | Post: 1

Hi,

Did you restart the Web Server then ?

Posted By: montanaweb on September 14, 2014, 8:29 pm | Post: 2

I am getting this same error.
Should i be putting the user information in my db_mysql.inc.php ?

Posted By: tidus on September 15, 2014, 7:30 am | Post: 3

Hi,

in console, what is the output of :

Code
php -c /usr/local/softaculous/php.ini -m

-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook : http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack

Posted By: montanaweb on September 15, 2014, 2:36 pm | Post: 4

[PHP Modules]
apc
bz2
calendar
Core
ctype
curl
date
dom
ereg
exif
fileinfo
filter
ftp
gd
gettext
gmp
hash
iconv
imap
ionCube Loader
json
ldap
libxml
mbstring
mcrypt
mssql
mysql
mysqli
odbc
openssl
pcntl
pcre
PDO
pdo_dblib
pdo_mysql
PDO_ODBC
pdo_sqlite
Phar
readline
Reflection
session
shmop
SimpleXML
snmp
soap
sockets
SPL
sqlite3
standard
tidy
tokenizer
wddx
xml
xmlreader
xmlrpc
xmlwriter
xsl
zip
zlib

[Zend Modules]
the ionCube PHP Loader

Posted By: tidus on September 16, 2014, 7:35 am | Post: 5

Hi,

Quote

Should i be putting the user information in my db_mysql.inc.php ?

No. Basically, PHP for some reason is not able to load mysqli extension so the error. While the command line output shows that the mysqli extension is loaded.

Can you open a ticket. We will look into this issue.

-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook : http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack

Posted By: montanaweb on September 16, 2014, 4:14 pm | Post: 6

no luck
<?php print_r(get_loaded_extensions());
outputs mysqli

will continue to look into this.

j

Posted By: montanaweb on September 16, 2014, 4:19 pm | Post: 7

[root@localhost intrin]# php -i |grep -i mysqli
Configure Command => './configure' '--build=i386-redhat-linux-gnu' '--host=i386-redhat-linux-gnu' '--target=i686-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/var/lib' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--without-pear' '--with-bz2' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--with-kerberos' '--enable-ucd-snmp-hack' '--enable-shmop' '--enable-calendar' '--without-sqlite' '--with-libxml-dir=/usr' '--enable-xml' '--with-system-tzdata' '--enable-force-cgi-redirect' '--enable-pcntl' '--with-imap=shared' '--with-imap-ssl' '--enable-mbstring=shared' '--enable-mbregex' '--with-gd=shared' '--enable-bcmath=shared' '--enable-dba=shared' '--with-db4=/usr' '--with-xmlrpc=shared' '--with-ldap=shared' '--with-ldap-sasl' '--with-mysql=shared,/usr' '--with-mysqli=shared,/usr/lib/mysql/mysql_config' '--enable-dom=shared' '--with-pgsql=shared' '--enable-wddx=shared' '--with-snmp=shared,/usr' '--enable-soap=shared' '--with-xsl=shared,/usr' '--enable-xmlreader=shared' '--enable-xmlwriter=shared' '--with-curl=shared,/usr' '--enable-fastcgi' '--enable-pdo=shared' '--with-pdo-odbc=shared,unixODBC,/usr' '--with-pdo-mysql=shared,/usr/lib/mysql/mysql_config' '--with-pdo-pgsql=shared,/usr' '--with-pdo-sqlite=shared,/usr' '--with-sqlite3=shared,/usr' '--enable-json=shared' '--enable-zip=shared' '--without-readline' '--with-libedit' '--with-pspell=shared' '--enable-phar=shared' '--with-tidy=shared,/usr' '--enable-sysvmsg=shared' '--enable-sysvshm=shared' '--enable-sysvsem=shared' '--enable-posix=shared' '--with-unixODBC=shared,/usr' '--enable-fileinfo=shared' '--enable-intl=shared' '--with-icu-dir=/usr' '--with-enchant=shared,/usr' '--with-recode=shared,/usr'
/etc/php.d/mysqli.ini,
PHP Warning: Unknown: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Denver' for 'MDT/-6.0/DST' instead in Unknown on line 0
mysqli
MysqlI Support => enabled
MYSQLI_SOCKET => /var/lib/mysql/mysql.sock
mysqli.allow_local_infile => On => On
mysqli.allow_persistent => On => On
mysqli.default_host => no value => no value
mysqli.default_port => 3306 => 3306
mysqli.default_pw => no value => no value
mysqli.default_socket => no value => no value
mysqli.default_user => no value => no value
mysqli.max_links => Unlimited => Unlimited
mysqli.max_persistent => Unlimited => Unlimited
mysqli.reconnect => Off => Off
[root@localhost intrin]#

Posted By: montanaweb on September 16, 2014, 5:07 pm | Post: 8

I created a php test file for mysqli,

<?php
$mysqli = new mysqli("localhost", "root", "mypass");

/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

/* print protocol version */
printf("Protocol version: %d\n", $mysqli->protocol_version);

/* print host information */
printf("Host info: %s\n", mysqli_get_host_info($mysqli));

/* close connection */
$mysqli->close();
?>

running the php files

[root@localhost intrin]# php -q /var/www/test.php
Protocol version: 10
Host info: Localhost via UNIX socket

Posted By: montanaweb on September 16, 2014, 5:21 pm | Post: 9

[root@localhost intrin]# tail -100 /var/softaculous/error_log
[14-Sep-2014 11:41:20] PHP Fatal error: Class 'mysqli' not found in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 31
[14-Sep-2014 11:41:26] PHP Fatal error: Class 'mysqli' not found in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 31
[14-Sep-2014 11:41:36] PHP Fatal error: Class 'mysqli' not found in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 31
[15-Sep-2014 09:52:16] PHP Warning: Module 'curl' already loaded in Unknown on line 0
[15-Sep-2014 09:52:16] PHP Warning: Module 'mysql' already loaded in Unknown on line 0
[15-Sep-2014 09:52:16] PHP Warning: Module 'mysqli' already loaded in Unknown on line 0
[16-Sep-2014 10:07:55] PHP Warning: Module 'curl' already loaded in Unknown on line 0
[16-Sep-2014 10:07:55] PHP Warning: Module 'mysql' already loaded in Unknown on line 0
[16-Sep-2014 10:07:55] PHP Warning: Module 'mysqli' already loaded in Unknown on line 0
[root@localhost intrin]#

Posted By: montanaweb on September 16, 2014, 5:34 pm | Post: 10

[root@localhost intrin]# ls -la /mnt/ispconfig/interface/lib/app.inc.php
ls: cannot access /mnt/ispconfig/interface/lib/app.inc.php: No such file or directory
[root@localhost intrin]# locate app.inc.php
/usr/local/ispconfig/interface/lib/app.inc.php
/usr/local/ispconfig/server/lib/app.inc.php
[root@localhost intrin]#

maybe i need to bind mount in fstab? not sure how to do that off hand

Posted By: tidus on September 17, 2014, 10:06 am | Post: 11

Hi,

Okay. run the following command:

Code
Root> php /usr/local/softaculous/cli.php --repair

-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook : http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack

Posted By: tikklik on September 17, 2014, 11:44 am | Post: 12

looks like i have the same problem
but
[root@61 /]# php /usr/local/softaculous/cli.php --repair
[root@61 /]#
doesnt do anything for me

Posted By: montanaweb on September 17, 2014, 1:52 pm | Post: 13

[intrin@localhost ~]$ php --version
PHP 5.3.3 (cli) (built: Aug 6 2014 05:40:05)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with the ionCube PHP Loader v4.6.1, Copyright (c) 2002-2014, by ionCube Ltd.

Posted By: tikklik on September 17, 2014, 2:21 pm | Post: 14

not php related

PHP 5.4.31 (cli) (built: Aug 1 2014 09:24:33)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies
with the ionCube PHP Loader v4.4.1, Copyright (c) 2002-2013, by ionCube Ltd.