Updating mysql to 5.6 failed

M

MaKenZi

Verified User
Joined
Jul 27, 2016
Messages
14
Hi

I tried to update mysql to 5.6
before this, I updated PHP to 7.0
but after the process this error appeared in PHPMyadmin
http://pastebin.com/eUtc20ja

and as I see the status of woocommerce it still say that mysql is 5.5

so any suggestion for fixing this?
 
there is no error while updating mysql

but after update process, I checked PHPMyadmin and I saw this error


Code: 
Warning in ./libraries/logging.lib.php#56
 fopen(./log/auth.log): failed to open stream: Permission denied

Backtrace

./libraries/logging.lib.php#56: fopen(
string './log/auth.log',
string 'a',
)
./libraries/logging.lib.php#84: log_to_file(
string 'admin',
string 'ok',
)
./libraries/common.inc.php#898: PMA_logUser(string 'admin')
./chk_rel.php#9: require_once(./libraries/common.inc.php)


I Tried rebuild phpmyadmin and this is the result

Code: 
Patching phpMyAdmin to log failed authentications for BFM...
patching file libraries/common.inc.php
Hunk #1 succeeded at 729 with fuzz 2 (offset 1 line).
patching file libraries/logging.lib.php
phpMyAdmin 4.6.4-all-languages installation is done.
 
the error vanished

but the main problem is that
in phpmyadmin it say
Server type: MySQL
Server version: 5.5.52 - MySQL Community Server (GPL)



and when I use ./build options
it say
Code: 
Apache: 2.4.23
mod_ruid2: no
ModSecurity: no
Dovecot: 2.2.25
Dovecot configuration: yes
AWstats: no
Exim: 4.87
exim.conf update: no
BlockCracking: no
Easy Spam Fighter: no
SpamAssassin: no
ClamAV: no
[COLOR="#FF0000"]MySQL: 5.6.34[/COLOR]
MySQL backup: yes
MySQL backup directory: /usr/local/directadmin/custombuild/mysql_backups
MySQL compress backups: no
PHP (default): 7.0 as mod_php
phpMyAdmin: 4.6.4-all-languages
ProFTPD: no
Pure-FTPd: 1.0.43
RoundCube webmail: 1.2.2
Replace "php.ini" with './build all' and './build php_ini': no
Auto updates/notifications: no
Run "clean" every time: yes
Run "clean_old_webapps" every time: yes
Run "clean_old_tarballs" every time: yes
Show texts in bold: yes
SquirrelMail: 1.4.23-20150507_0200
Zend Guard Loader: yes
ionCube loader: 6.0.5
Suhosin: 0.9.38
 
What OS are you using?

If MySQL have no error, have you tryed to restart it?
What output do you get if you run: mysql --version

Best regards
 
I am using Debian

output
Code: 
mysql  Ver 14.14 Distrib 5.5.52, for linux2.6 (x86_64) using readline 5.1
 
Ok,
you may need to go this way so:
Code: 
cd /usr/local/directadmin/custombuild
./build set mysql_force_compile yes
./build update
./build mysql
./build php d

Best regards
 
Hi,

The last command gave an error like this.

Code: 
rs from pointer target type
/usr/local/directadmin/custombuild/php-5.5.38/ext/openssl/xp_ssl.c:462: warning: assignment makes pointer fro                                               m integer without a cast
/usr/local/directadmin/custombuild/php-5.5.38/ext/openssl/xp_ssl.c:476: warning: 'TLSv1_client_method' is dep                                               recated (declared at /usr/local/include/openssl/ssl.h:1598)
/usr/local/directadmin/custombuild/php-5.5.38/ext/openssl/xp_ssl.c:476: warning: assignment discards qualifie                                               rs from pointer target type
/usr/local/directadmin/custombuild/php-5.5.38/ext/openssl/xp_ssl.c:480: warning: assignment discards qualifie                                               rs from pointer target type
/usr/local/directadmin/custombuild/php-5.5.38/ext/openssl/xp_ssl.c:497: warning: assignment makes pointer fro                                               m integer without a cast
/usr/local/directadmin/custombuild/php-5.5.38/ext/openssl/xp_ssl.c:502: warning: 'TLSv1_server_method' is dep                                               recated (declared at /usr/local/include/openssl/ssl.h:1597)
/usr/local/directadmin/custombuild/php-5.5.38/ext/openssl/xp_ssl.c:502: warning: assignment discards qualifie
 
Hi Andrea,

Code: 
[root@ns1 ~]# rpm -qa | grep -i openssl
openssl-devel-1.0.1e-48.el6_8.3.x86_64
openssl-1.0.1e-48.el6_8.3.x86_64
pyOpenSSL-0.13.1-2.el6.x86_64
 
You must log in or register to reply here.
Back
Top