0
Completed

Is there any problem using mariadb instead of mysql???

Daniel Tsionit 10 years ago updated by wrrr 8 years ago 15

Answer

+1
Answer
Completed
Just with anything else, you can use MariaDB as a drop-in MySQL replacement without any changes.
+1
Answer
Completed
Just with anything else, you can use MariaDB as a drop-in MySQL replacement without any changes.
Do you mean just install the mariadb-server and it should work? 
keep getting this error:


[root@ajenti ~]# yum install ajenti-v-mysql.noarch
Failed to set locale, defaulting to C
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: mirror.isoc.org.il
* epel: mirror.nonstop.co.il
* extras: mirror.isoc.org.il
* updates: mirror.isoc.org.il
Resolving Dependencies
--> Running transaction check
---> Package ajenti-v-mysql.noarch 0:0.3.1-1 will be installed
--> Processing Dependency: mysql-server for package: ajenti-v-mysql-0.3.1-1.noarch
--> Finished Dependency Resolution
Error: Package: ajenti-v-mysql-0.3.1-1.noarch (ajenti)
Requires: mysql-server
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest


Your MariaDB RPMs should provide "mysql-server" name. For example, RPMs from MariaDB website do that.
Hi Eugene,

I didn't find any proper RPM.
I tried to use mysql-community server and ajenti seems to communicate with it...

now i have another error when I run puma:

/srv/store1/www/vendor/bundle/ruby/2.1.0/gems/mysql2-0.3.16/lib/mysql2.rb:8:in `require': Incorrect MySQL client library version! This gem was compiled for 5.5.37-MariaDB but the client library is 5.6.20. (RuntimeError)

How do I fix it?


Well, that's your app's problem. Apparently there's a version mismatch between your Ruby libs and MySQL server libs.
I prefer working with MariaDB. It just that I can't make Ajenti to recognize it...

Is there any way to make it work with MariaDB?
can you send me the links for the right RPM?
Here are the ones I use myself: http://mirrors.n-ix.net/mariadb/mariadb-10.0.13/yum/

[resolved] install ajenti-v-mysql in addition to php-7.0-mysql


Is this valid for the latest Ajenti -V with php-7.0. I installed fresh on Ubuntu 16.04, restarted Ajenti and MySql. I cannot see mysql in websites tab but it MySql shows properly in the Software section with default schema and user.

+1
Can you help me install it?

Thanks

can anyone help me upgrade my existing msql to mariadb. I have a 4gb database in MySQL which should be migrated to mariadb. The operating system is on centos 6.7.

I am using Ubuntu 15.10. configured apache/php & mariadb. The phpinfo() is as follows :


PHP logo

PHP Version 5.6.11-1ubuntu3.1

SystemLinux gp-HP-Compaq-Pro-6300-SFF 4.2.0-22-generic #27-Ubuntu SMP Thu Dec 17 22:57:08 UTC 2015 x86_64
Server APIApache 2.0 Handler
Virtual Directory Supportdisabled
Configuration File (php.ini) Path/etc/php5/apache2
Loaded Configuration File/etc/php5/apache2/php.ini
Scan this dir for additional .ini files/etc/php5/apache2/conf.d
Additional .ini files parsed/etc/php5/apache2/conf.d/05-opcache.ini, /etc/php5/apache2/conf.d/10-mysqlnd.ini, /etc/php5/apache2/conf.d/10-pdo.ini, /etc/php5/apache2/conf.d/20-apcu.ini, /etc/php5/apache2/conf.d/20-curl.ini, /etc/php5/apache2/conf.d/20-gd.ini, /etc/php5/apache2/conf.d/20-imagick.ini, /etc/php5/apache2/conf.d/20-intl.ini, /etc/php5/apache2/conf.d/20-json.ini, /etc/php5/apache2/conf.d/20-memcached.ini, /etc/php5/apache2/conf.d/20-ming.ini, /etc/php5/apache2/conf.d/20-mysql.ini, /etc/php5/apache2/conf.d/20-mysqli.ini, /etc/php5/apache2/conf.d/20-odbc.ini, /etc/php5/apache2/conf.d/20-pdo_mysql.ini, /etc/php5/apache2/conf.d/20-pdo_odbc.ini, /etc/php5/apache2/conf.d/20-pdo_pgsql.ini, /etc/php5/apache2/conf.d/20-pdo_sqlite.ini, /etc/php5/apache2/conf.d/20-pgsql.ini, /etc/php5/apache2/conf.d/20-pspell.ini, /etc/php5/apache2/conf.d/20-readline.ini, /etc/php5/apache2/conf.d/20-recode.ini, /etc/php5/apache2/conf.d/20-snmp.ini, /etc/php5/apache2/conf.d/20-sqlite3.ini, /etc/php5/apache2/conf.d/20-ssh2.ini, /etc/php5/apache2/conf.d/20-tidy.ini, /etc/php5/apache2/conf.d/20-xmlrpc.ini, /etc/php5/apache2/conf.d/20-xsl.ini
PHP API20131106
PHP Extension20131226
Zend Extension220131226
Zend Extension BuildAPI220131226,NTS
PHP Extension BuildAPI20131226,NTS
Debug Buildno
Thread Safetydisabled
Zend Signal Handlingdisabled
Zend Memory Managerenabled
Zend Multibyte Supportprovided by mbstring
IPv6 Supportenabled
DTrace Supportenabled
Registered PHP Streamshttps, ftps, compress.zlib, compress.bzip2, php, file, glob, data, http, ftp, phar, zip, ssh2.shell, ssh2.exec, ssh2.tunnel, ssh2.scp, ssh2.sftp
Registered Stream Socket Transportstcp, udp, unix, udg, ssl, sslv3, tls, tlsv1.0, tlsv1.1, tlsv1.2
Registered Stream Filterszlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk
Zend logo This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.6.0, Copyright (c) 1998-2015 Zend Technologies
with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2015, by Zend Technologies

Configuration

apache2handler

Apache VersionApache/2.4.12 (Ubuntu)
Apache API Version20120211
Server Administratorwebmaster@localhost
Hostname:Port127.0.1.1:80
User/Groupwww-data(33)/33
Max RequestsPer Child: 0 - Keep Alive: on - Max Per Connection: 100
TimeoutsConnection: 300 - Keep-Alive: 5
Virtual ServerYes
Server Root/etc/apache2
Loaded Modulescore mod_so mod_watchdog http_core mod_log_config mod_logio mod_version mod_unixd mod_access_compat mod_alias mod_auth_basic mod_authn_core mod_authn_file mod_authz_core mod_authz_host mod_authz_user mod_autoindex mod_deflate mod_dir mod_env mod_filter mod_mime prefork mod_negotiation mod_php5 mod_setenvif mod_status
DirectiveLocal ValueMaster Value
engine11
last_modified00
xbithack00

Apache Environment

VariableValue
HTTP_HOSTlocalhost
HTTP_USER_AGENTMozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:43.0) Gecko/20100101 Firefox/43.0
HTTP_ACCEPTtext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_LANGUAGEen-US,en;q=0.5
HTTP_ACCEPT_ENCODINGgzip, deflate
HTTP_REFERERhttp://localhost/
HTTP_COOKIEPHPSESSID=ic51j3qk8r2i1o4d1cjno501u7
HTTP_CONNECTIONkeep-alive
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
SERVER_SIGNATURE<address>Apache/2.4.12 (Ubuntu) Server at localhost Port 80</address>
SERVER_SOFTWAREApache/2.4.12 (Ubuntu)
SERVER_NAMElocalhost
SERVER_ADDR127.0.0.1
SERVER_PORT80
REMOTE_ADDR127.0.0.1
DOCUMENT_ROOT/home/gp
REQUEST_SCHEMEhttp
CONTEXT_PREFIXno value
CONTEXT_DOCUMENT_ROOT/home/gp
SERVER_ADMINwebmaster@localhost
SCRIPT_FILENAME/home/gp/test.php
REMOTE_PORT46590
GATEWAY_INTERFACECGI/1.1
SERVER_PROTOCOLHTTP/1.1
REQUEST_METHODGET
QUERY_STRINGno value
REQUEST_URI/test.php
SCRIPT_NAME/test.php

HTTP Headers Information

HTTP Request Headers
HTTP RequestGET /test.php HTTP/1.1
Hostlocalhost
User-AgentMozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:43.0) Gecko/20100101 Firefox/43.0
Accepttext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Languageen-US,en;q=0.5
Accept-Encodinggzip, deflate
Refererhttp://localhost/
CookiePHPSESSID=ic51j3qk8r2i1o4d1cjno501u7
Connectionkeep-alive
HTTP Response Headers
X-Powered-ByPHP/5.6.11-1ubuntu3.1

apc

APC supportEmulated

apcu

APCu SupportEnabled
Version4.0.7
APCu DebuggingDisabled
MMAP SupportEnabled
MMAP File Maskno value
Serialization Supportphp
Revision$Revision: 328290 $
Build DateJan 27 2015 18:19:19
DirectiveLocal ValueMaster Value
apc.coredump_unmapOffOff
apc.enable_cliOffOff
apc.enabledOnOn
apc.entries_hint40964096
apc.gc_ttl36003600
apc.mmap_file_maskno valueno value
apc.preload_pathno valueno value
apc.rfc1867OffOff
apc.rfc1867_freq00
apc.rfc1867_nameAPC_UPLOAD_PROGRESSAPC_UPLOAD_PROGRESS
apc.rfc1867_prefixupload_upload_
apc.rfc1867_ttl36003600
apc.serializerphpphp
apc.shm_segments11
apc.shm_size32M32M
apc.slam_defenseOnOn
apc.smart00
apc.ttl00
apc.use_request_timeOnOn
apc.writable/tmp/tmp

bcmath

BCMath supportenabled
DirectiveLocal ValueMaster Value
bcmath.scale00

bz2

BZip2 SupportEnabled
Stream Wrapper supportcompress.bzip2://
Stream Filter supportbzip2.decompress, bzip2.compress
BZip2 Version1.0.6, 6-Sept-2010

calendar

Calendar supportenabled

Core

PHP Version5.6.11-1ubuntu3.1
DirectiveLocal ValueMaster Value
allow_url_fopenOnOn
allow_url_includeOffOff
always_populate_raw_post_data00
arg_separator.input&&
arg_separator.output&&
asp_tagsOffOff
auto_append_fileno valueno value
auto_globals_jitOnOn
auto_prepend_fileno valueno value
browscapno valueno value
default_charsetUTF-8UTF-8
default_mimetypetext/htmltext/html
disable_classesno valueno value
disable_functionspcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,
display_errorsOnOn
display_startup_errorsOffOff
doc_rootno valueno value
docref_extno valueno value
docref_rootno valueno value
enable_dlOffOff
enable_post_data_readingOnOn
error_append_stringno valueno value
error_logno valueno value
error_prepend_stringno valueno value
error_reporting2457524575
exit_on_timeoutOffOff
expose_phpOnOn
extension_dir/usr/lib/php5/20131226/usr/lib/php5/20131226
file_uploadsOnOn
highlight.comment#FF8000#FF8000
highlight.default#0000BB#0000BB
highlight.html#000000#000000
highlight.keyword#007700#007700
highlight.string#DD0000#DD0000
html_errorsOnOn
ignore_repeated_errorsOffOff
ignore_repeated_sourceOffOff
ignore_user_abortOffOff
implicit_flushOffOff
include_path.:/usr/share/php:/usr/share/pear.:/usr/share/php:/usr/share/pear
input_encodingno valueno value
internal_encodingno valueno value
log_errorsOnOn
log_errors_max_len10241024
mail.add_x_headerOnOn
mail.force_extra_parametersno valueno value
mail.logno valueno value
max_execution_time3030
max_file_uploads2020
max_input_nesting_level6464
max_input_time6060
max_input_vars10001000
memory_limit128M128M
open_basedirno valueno value
output_buffering40964096
output_encodingno valueno value
output_handlerno valueno value
post_max_size8M8M
precision1414
realpath_cache_size16K16K
realpath_cache_ttl120120
register_argc_argvOffOff
report_memleaksOnOn
report_zend_debugOnOn
request_orderGPGP
sendmail_fromno valueno value
sendmail_path/usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
serialize_precision1717
short_open_tagOffOff
SMTPlocalhostlocalhost
smtp_port2525
sql.safe_modeOffOff
sys_temp_dirno valueno value
track_errorsOffOff
unserialize_callback_funcno valueno value
upload_max_filesize2M2M
upload_tmp_dirno valueno value
user_dirno valueno value
user_ini.cache_ttl300300
user_ini.filename.user.ini.user.ini
variables_orderGPCSGPCS
xmlrpc_error_number00
xmlrpc_errorsOffOff
zend.detect_unicodeOnOn
zend.enable_gcOnOn
zend.multibyteOffOff
zend.script_encodingno valueno value

ctype

ctype functionsenabled

curl

cURL supportenabled
cURL Information7.43.0
Age3
Features
AsynchDNSYes
CharConvNo
DebugNo
GSS-NegotiateNo
IDNYes
IPv6Yes
krb4No
LargefileYes
libzYes
NTLMYes
NTLMWBYes
SPNEGOYes
SSLYes
SSPINo
TLS-SRPYes
Protocolsdict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, ldaps, pop3, pop3s, rtmp, rtsp, smb, smbs, smtp, smtps, telnet, tftp
Hostx86_64-pc-linux-gnu
SSL VersionOpenSSL/1.0.2d
ZLib Version1.2.8

date

date/time supportenabled
"Olson" Timezone Database Version0.system
Timezone Databaseinternal
Default timezoneAsia/Calcutta
DirectiveLocal ValueMaster Value
date.default_latitude31.766731.7667
date.default_longitude35.233335.2333
date.sunrise_zenith90.58333390.583333
date.sunset_zenith90.58333390.583333
date.timezoneno valueno value

dba

DBA supportenabled
libdb header versionBerkeley DB 5.3.28: (September 9, 2013)
libdb library versionBerkeley DB 5.3.28: (September 9, 2013)
Supported handlerscdb cdb_make db4 inifile flatfile
DirectiveLocal ValueMaster Value
dba.default_handlerflatfileflatfile

dom

DOM/XMLenabled
DOM/XML API Version20031129
libxml Version2.9.2
HTML Supportenabled
XPath Supportenabled
XPointer Supportenabled
Schema Supportenabled
RelaxNG Supportenabled

ereg

Regex LibraryBundled library enabled

exif

EXIF Supportenabled
EXIF Version1.4 $Id: 5504545b9be3379c5244b371d825eb64659eb5f5 $
Supported EXIF Version0220
Supported filetypesJPEG,TIFF
DirectiveLocal ValueMaster Value
exif.decode_jis_intelJISJIS
exif.decode_jis_motorolaJISJIS
exif.decode_unicode_intelUCS-2LEUCS-2LE
exif.decode_unicode_motorolaUCS-2BEUCS-2BE
exif.encode_jisno valueno value
exif.encode_unicodeISO-8859-15ISO-8859-15

fileinfo

fileinfo supportenabled
version1.0.5
libmagic517

filter

Input Validation and Filteringenabled
Revision$Id: 86120bba568c551914a35636ec408f1e7e66af32 $
DirectiveLocal ValueMaster Value
filter.defaultunsafe_rawunsafe_raw
filter.default_flagsno valueno value

ftp

FTP supportenabled

gd

GD Supportenabled
GD headers Version2.1.1
GD library Version2.1.1
FreeType Supportenabled
FreeType Linkagewith freetype
FreeType Version2.5.2
GIF Read Supportenabled
GIF Create Supportenabled
JPEG Supportenabled
libJPEG Version8
PNG Supportenabled
libPNG Version1.2.51
WBMP Supportenabled
XPM Supportenabled
libXpm Version30411
XBM Supportenabled
WebP Supportenabled
DirectiveLocal ValueMaster Value
gd.jpeg_ignore_warning00

gettext

GetText Supportenabled

hash

hash supportenabled
Hashing Enginesmd2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5

iconv

iconv supportenabled
iconv implementationglibc
iconv library version2.21
DirectiveLocal ValueMaster Value
iconv.input_encodingno valueno value
iconv.internal_encodingno valueno value
iconv.output_encodingno valueno value

imagick

imagick moduleenabled
imagick module version3.3.0RC2
imagick classesImagick, ImagickDraw, ImagickPixel, ImagickPixelIterator, ImagickKernel
Imagick compiled with ImageMagick versionImageMagick 6.8.9-9 Q16 x86_64 2015-01-06 http://www.imagemagick.org
Imagick using ImageMagick library versionImageMagick 6.8.9-9 Q16 x86_64 2015-08-06 http://www.imagemagick.org
ImageMagick copyrightCopyright (C) 1999-2014 ImageMagick Studio LLC
ImageMagick release date2015-08-06
ImageMagick number of supported formats:205
ImageMagick supported formats3FR, AAI, AI, ART, ARW, AVI, AVS, BGR, BGRA, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CRW, CUR, CUT, DCM, DCR, DCX, DDS, DFONT, DNG, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, FAX, FITS, FRACTAL, FTS, G3, GIF, GIF87, GRADIENT, GRAY, GROUP4, HALD, HDR, HISTOGRAM, HRZ, HTM, HTML, ICB, ICO, ICON, INFO, INLINE, IPL, ISOBRL, JBG, JBIG, JNG, JNX, JPEG, JPG, JSON, K25, KDC, LABEL, M2V, M4V, MAC, MAP, MASK, MAT, MATTE, MEF, MIFF, MNG, MONO, MOV, MP4, MPC, MPEG, MPG, MRW, MSL, MTV, MVG, NEF, NRW, NULL, ORF, OTB, OTF, PAL, PALM, PAM, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, PPM, PREVIEW, PS, PS2, PS3, PSB, PSD, PTIF, PWP, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UIL, UYVY, VDA, VICAR, VID, VIFF, VIPS, VST, WBMP, WMV, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YCbCr, YCbCrA, YUV
DirectiveLocal ValueMaster Value
imagick.locale_fix00
imagick.progress_monitor00
imagick.skip_version_check00

intl

Internationalization supportenabled
version1.1.0
ICU version55.1
ICU Data version55.1
DirectiveLocal ValueMaster Value
intl.default_localeno valueno value
intl.error_level00
intl.use_exceptions00

json

json supportenabled
json version1.3.7
JSON-C headers version0.11.99
JSON-C library version0.11.99

libxml

libXML supportactive
libXML Compiled Version2.9.2
libXML Loaded Version20902
libXML streamsenabled

mbstring

Multibyte Supportenabled
Multibyte string enginelibmbfl
HTTP input encoding translationdisabled
libmbfl version1.3.2
mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.
Multibyte (japanese) regex supportenabled
Multibyte regex (oniguruma) backtrack checkOn
Multibyte regex (oniguruma) version5.9.5
DirectiveLocal ValueMaster Value
mbstring.detect_orderno valueno value
mbstring.encoding_translationOffOff
mbstring.func_overload00
mbstring.http_inputno valueno value
mbstring.http_outputno valueno value
mbstring.http_output_conv_mimetypes^(text/|application/xhtml\+xml)^(text/|application/xhtml\+xml)
mbstring.internal_encodingno valueno value
mbstring.languageneutralneutral
mbstring.strict_detectionOffOff
mbstring.substitute_characterno valueno value

memcached

memcached supportenabled
Version2.2.0
libmemcached version1.0.18
SASL supportyes
Session supportyes
igbinary supportno
json supportno
msgpack supportno
DirectiveLocal ValueMaster Value
memcached.compression_factor1.31.3
memcached.compression_threshold20002000
memcached.compression_typefastlzfastlz
memcached.serializerphpphp
memcached.sess_binary00
memcached.sess_connect_timeout10001000
memcached.sess_consistent_hash00
memcached.sess_lock_expire00
memcached.sess_lock_max_wait00
memcached.sess_lock_wait150000150000
memcached.sess_locking11
memcached.sess_number_of_replicas00
memcached.sess_prefixmemc.sess.key.memc.sess.key.
memcached.sess_randomize_replica_read00
memcached.sess_remove_failed00
memcached.sess_sasl_passwordno valueno value
memcached.sess_sasl_usernameno valueno value
memcached.store_retry_count22
memcached.use_sasl00

mhash

MHASH supportEnabled
MHASH API VersionEmulated Support

ming

Ming SWF output libraryenabled
Version0.4.5

mysql

MySQL Supportenabled
Active Persistent Links0
Active Links0
Client API versionmysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
DirectiveLocal ValueMaster Value
mysql.allow_local_infileOnOn
mysql.allow_persistentOnOn
mysql.connect_timeout6060
mysql.default_hostno valueno value
mysql.default_passwordno valueno value
mysql.default_portno valueno value
mysql.default_socket/var/run/mysqld/mysqld.sock/var/run/mysqld/mysqld.sock
mysql.default_userno valueno value
mysql.max_linksUnlimitedUnlimited
mysql.max_persistentUnlimitedUnlimited
mysql.trace_modeOffOff

mysqli

MysqlI Supportenabled
Client API library versionmysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
Active Persistent Links0
Inactive Persistent Links0
Active Links0
DirectiveLocal ValueMaster Value
mysqli.allow_local_infileOnOn
mysqli.allow_persistentOnOn
mysqli.default_hostno valueno value
mysqli.default_port33063306
mysqli.default_pwno valueno value
mysqli.default_socket/var/run/mysqld/mysqld.sock/var/run/mysqld/mysqld.sock
mysqli.default_userno valueno value
mysqli.max_linksUnlimitedUnlimited
mysqli.max_persistentUnlimitedUnlimited
mysqli.reconnectOffOff
mysqli.rollback_on_cached_plinkOffOff

mysqlnd

mysqlndenabled
Versionmysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
Compressionsupported
core SSLsupported
extended SSLsupported
Command buffer size4096
Read buffer size32768
Read timeout31536000
Collecting statisticsYes
Collecting memory statisticsNo
Tracingn/a
Loaded pluginsmysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_password
API Extensionsmysql,mysqli,pdo_mysql
mysqlnd statistics
bytes_sent0
bytes_received0
packets_sent0
packets_received0
protocol_overhead_in0
protocol_overhead_out0
bytes_received_ok_packet0
bytes_received_eof_packet0
bytes_received_rset_header_packet0
bytes_received_rset_field_meta_packet0
bytes_received_rset_row_packet0
bytes_received_prepare_response_packet0
bytes_received_change_user_packet0
packets_sent_command0
packets_received_ok0
packets_received_eof0
packets_received_rset_header0
packets_received_rset_field_meta0
packets_received_rset_row0
packets_received_prepare_response0
packets_received_change_user0
result_set_queries0
non_result_set_queries0
no_index_used0
bad_index_used0
slow_queries0
buffered_sets0
unbuffered_sets0
ps_buffered_sets0
ps_unbuffered_sets0
flushed_normal_sets0
flushed_ps_sets0
ps_prepared_never_executed0
ps_prepared_once_executed0
rows_fetched_from_server_normal0
rows_fetched_from_server_ps0
rows_buffered_from_client_normal0
rows_buffered_from_client_ps0
rows_fetched_from_client_normal_buffered0
rows_fetched_from_client_normal_unbuffered0
rows_fetched_from_client_ps_buffered0
rows_fetched_from_client_ps_unbuffered0
rows_fetched_from_client_ps_cursor0
rows_affected_normal0
rows_affected_ps0
rows_skipped_normal0
rows_skipped_ps0
copy_on_write_saved0
copy_on_write_performed0
command_buffer_too_small0
connect_success0
connect_failure0
connection_reused0
reconnect0
pconnect_success0
active_connections0
active_persistent_connections0
explicit_close0
implicit_close0
disconnect_close0
in_middle_of_command_close0
explicit_free_result0
implicit_free_result0
explicit_stmt_close0
implicit_stmt_close0
mem_emalloc_count0
mem_emalloc_amount0
mem_ecalloc_count0
mem_ecalloc_amount0
mem_erealloc_count0
mem_erealloc_amount0
mem_efree_count0
mem_efree_amount0
mem_malloc_count0
mem_malloc_amount0
mem_calloc_count0
mem_calloc_amount0
mem_realloc_count0
mem_realloc_amount0
mem_free_count0
mem_free_amount0
mem_estrndup_count0
mem_strndup_count0
mem_estndup_count0
mem_strdup_count0
proto_text_fetched_null0
proto_text_fetched_bit0
proto_text_fetched_tinyint0
proto_text_fetched_short0
proto_text_fetched_int240
proto_text_fetched_int0
proto_text_fetched_bigint0
proto_text_fetched_decimal0
proto_text_fetched_float0
proto_text_fetched_double0
proto_text_fetched_date0
proto_text_fetched_year0
proto_text_fetched_time0
proto_text_fetched_datetime0
proto_text_fetched_timestamp0
proto_text_fetched_string0
proto_text_fetched_blob0
proto_text_fetched_enum0
proto_text_fetched_set0
proto_text_fetched_geometry0
proto_text_fetched_other0
proto_binary_fetched_null0
proto_binary_fetched_bit0
proto_binary_fetched_tinyint0
proto_binary_fetched_short0
proto_binary_fetched_int240
proto_binary_fetched_int0
proto_binary_fetched_bigint0
proto_binary_fetched_decimal0
proto_binary_fetched_float0
proto_binary_fetched_double0
proto_binary_fetched_date0
proto_binary_fetched_year0
proto_binary_fetched_time0
proto_binary_fetched_datetime0
proto_binary_fetched_timestamp0
proto_binary_fetched_string0
proto_binary_fetched_blob0
proto_binary_fetched_enum0
proto_binary_fetched_set0
proto_binary_fetched_geometry0
proto_binary_fetched_other0
init_command_executed_count0
init_command_failed_count0
com_quit0
com_init_db0
com_query0
com_field_list0
com_create_db0
com_drop_db0
com_refresh0
com_shutdown0
com_statistics0
com_process_info0
com_connect0
com_process_kill0
com_debug0
com_ping0
com_time0
com_delayed_insert0
com_change_user0
com_binlog_dump0
com_table_dump0
com_connect_out0
com_register_slave0
com_stmt_prepare0
com_stmt_execute0
com_stmt_send_long_data0
com_stmt_close0
com_stmt_reset0
com_stmt_set_option0
com_stmt_fetch0
com_deamon0
bytes_received_real_data_normal0
bytes_received_real_data_ps0

odbc

ODBC Supportenabled
Active Persistent Links0
Active Links0
ODBC libraryunixODBC
ODBC_INCLUDE-I/usr/include
ODBC_LFLAGS-L/usr/lib
ODBC_LIBS-lodbc
DirectiveLocal ValueMaster Value
odbc.allow_persistentOnOn
odbc.check_persistentOnOn
odbc.default_cursortypeStatic cursorStatic cursor
odbc.default_dbno valueno value
odbc.default_pwno valueno value
odbc.default_userno valueno value
odbc.defaultbinmodereturn as isreturn as is
odbc.defaultlrlreturn up to 4096 bytesreturn up to 4096 bytes
odbc.max_linksUnlimitedUnlimited
odbc.max_persistentUnlimitedUnlimited

openssl

OpenSSL supportenabled
OpenSSL Library VersionOpenSSL 1.0.2d 9 Jul 2015
OpenSSL Header VersionOpenSSL 1.0.2d 9 Jul 2015
DirectiveLocal ValueMaster Value
openssl.cafileno valueno value
openssl.capathno valueno value

pcre

PCRE (Perl Compatible Regular Expressions) Supportenabled
PCRE Library Version8.35 2014-04-04
DirectiveLocal ValueMaster Value
pcre.backtrack_limit10000001000000
pcre.recursion_limit100000100000

PDO

PDO supportenabled
PDO driversmysql, odbc, pgsql, sqlite

pdo_mysql

PDO Driver for MySQLenabled
Client API versionmysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
DirectiveLocal ValueMaster Value
pdo_mysql.default_socket/var/run/mysqld/mysqld.sock/var/run/mysqld/mysqld.sock

PDO_ODBC

PDO Driver for ODBC (unixODBC)enabled
ODBC Connection PoolingEnabled, strict matching

pdo_pgsql

PDO Driver for PostgreSQLenabled
PostgreSQL(libpq) Version9.4.5
Module version1.0.2
Revision$Id: 93432550a76a2298959ec74f40d65c7195a82ad2 $

pdo_sqlite

PDO Driver for SQLite 3.xenabled
SQLite Library3.8.11.1

pgsql

PostgreSQL Supportenabled
PostgreSQL(libpq) Version9.4.5
PostgreSQL(libpq)PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 5.2.1-21ubuntu2) 5.2.1 20151003, 64-bit
Multibyte character supportenabled
SSL supportenabled
Active Persistent Links0
Active Links0
DirectiveLocal ValueMaster Value
pgsql.allow_persistentOnOn
pgsql.auto_reset_persistentOffOff
pgsql.ignore_noticeOffOff
pgsql.log_noticeOffOff
pgsql.max_linksUnlimitedUnlimited
pgsql.max_persistentUnlimitedUnlimited

Phar

Phar: PHP Archive supportenabled
Phar EXT version2.0.2
Phar API version1.1.1
SVN revision$Id: b0b14b0c2fb9071b12aeda7f02eb2152daae580d $
Phar-based phar archivesenabled
Tar-based phar archivesenabled
ZIP-based phar archivesenabled
gzip compressionenabled
bzip2 compressionenabled
OpenSSL supportenabled
Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
DirectiveLocal ValueMaster Value
phar.cache_listno valueno value
phar.readonlyOnOn
phar.require_hashOnOn

posix

Revision$Id: 5d20de77687b7d961b15450873fa23b9e64a136a $

pspell

PSpell Supportenabled

readline

Readline Supportenabled
Readline libraryEditLine wrapper
DirectiveLocal ValueMaster Value
cli.pagerno valueno value
cli.prompt\b \> \b \>

recode

Recode Supportenabled
Revision$Id: d95ffdf43fdab6078875dc99d333da459d8d8cd6 $

Reflection

Reflectionenabled
Version$Id: eff8bdc65b0beaf8f4ade6f06f848e6d43dfd826 $

session

Session Supportenabled
Registered save handlersfiles user memcached
Registered serializer handlersphp_serialize php php_binary wddx
DirectiveLocal ValueMaster Value
session.auto_startOffOff
session.cache_expire180180
session.cache_limiternocachenocache
session.cookie_domainno valueno value
session.cookie_httponlyOffOff
session.cookie_lifetime00
session.cookie_path//
session.cookie_secureOffOff
session.entropy_file/dev/urandom/dev/urandom
session.entropy_length3232
session.gc_divisor10001000
session.gc_maxlifetime14401440
session.gc_probability00
session.hash_bits_per_character55
session.hash_function00
session.namePHPSESSIDPHPSESSID
session.referer_checkno valueno value
session.save_handlerfilesfiles
session.save_path/var/lib/php5/sessions/var/lib/php5/sessions
session.serialize_handlerphpphp
session.upload_progress.cleanupOnOn
session.upload_progress.enabledOnOn
session.upload_progress.freq1%1%
session.upload_progress.min_freq11
session.upload_progress.namePHP_SESSION_UPLOAD_PROGRESSPHP_SESSION_UPLOAD_PROGRESS
session.upload_progress.prefixupload_progress_upload_progress_
session.use_cookiesOnOn
session.use_only_cookiesOnOn
session.use_strict_modeOffOff
session.use_trans_sid00

shmop

shmop supportenabled

SimpleXML

Simplexml supportenabled
Revision$Id: 6b8e23a01a85046737ef7d31346da5164505c179 $
Schema supportenabled

snmp

NET-SNMP Supportenabled
NET-SNMP Version5.7.3
PHP SNMP Version0.1

soap

Soap Clientenabled
Soap Serverenabled
DirectiveLocal ValueMaster Value
soap.wsdl_cache11
soap.wsdl_cache_dir/tmp/tmp
soap.wsdl_cache_enabled11
soap.wsdl_cache_limit55
soap.wsdl_cache_ttl8640086400

sockets

Sockets Supportenabled

SPL

SPL supportenabled
InterfacesCountable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
ClassesAppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

sqlite3

SQLite3 supportenabled
SQLite3 module version0.7-dev
SQLite Library3.8.11.1
DirectiveLocal ValueMaster Value
sqlite3.extension_dirno valueno value

ssh2

SSH2 supportenabled
extension version0.12
libssh2 version1.4.3
bannerSSH-2.0-libssh2_1.4.3

standard

Dynamic Library Supportenabled
Path to sendmail/usr/sbin/sendmail -t -i
DirectiveLocal ValueMaster Value
assert.active11
assert.bail00
assert.callbackno valueno value
assert.quiet_eval00
assert.warning11
auto_detect_line_endings00
default_socket_timeout6060
fromno valueno value
url_rewriter.tagsa=href,area=href,frame=src,input=src,form=fakeentrya=href,area=href,frame=src,input=src,form=fakeentry
user_agentno valueno value

sysvmsg

sysvmsg supportenabled
Revision$Id: 1e821e8a0cbb868efec453560ba303e04f3a1db2 $

tidy

Tidy supportenabled
libTidy Release25 March 2009
Extension Version2.0 ($Id: e066a98a414c7f79f89f697c19c4336c61bc617b $)
DirectiveLocal ValueMaster Value
tidy.clean_outputno valueno value
tidy.default_configno valueno value

tokenizer

Tokenizer Supportenabled

wddx

WDDX Supportenabled
WDDX Session Serializerenabled

xml

XML Supportactive
XML Namespace Supportactive
libxml2 Version2.9.2

xmlreader

XMLReaderenabled

xmlrpc

core library versionxmlrpc-epi v. 0.51
php extension version0.51
authorDan Libby
homepagehttp://xmlrpc-epi.sourceforge.net
open sourced byEpinions.com

xmlwriter

XMLWriterenabled

xsl

XSLenabled
libxslt Version1.1.28
libxslt compiled against libxml Version2.9.2
EXSLTenabled
libexslt Version1.1.28

Zend OPcache

Opcode CachingUp and Running
OptimizationEnabled
StartupOK
Shared memory modelmmap
Cache hits278
Cache misses98
Used memory10302240
Free memory56806624
Wasted memory0
Interned Strings Used memory1646824
Interned Strings Free memory2547480
Cached scripts98
Cached keys185
Max keys3907
OOM restarts0
Hash keys restarts0
Manual restarts0
DirectiveLocal ValueMaster Value
opcache.blacklist_filenameno valueno value
opcache.consistency_checks00
opcache.dups_fixOffOff
opcache.enableOnOn
opcache.enable_cliOffOff
opcache.enable_file_overrideOffOff
opcache.error_logno valueno value
opcache.fast_shutdown00
opcache.file_update_protection22
opcache.force_restart_timeout180180
opcache.inherited_hackOnOn
opcache.interned_strings_buffer44
opcache.load_comments11
opcache.log_verbosity_level11
opcache.max_accelerated_files20002000
opcache.max_file_size00
opcache.max_wasted_percentage55
opcache.memory_consumption6464
opcache.optimization_level0xFFFFFFFF0xFFFFFFFF
opcache.preferred_memory_modelno valueno value
opcache.protect_memory00
opcache.restrict_apino valueno value
opcache.revalidate_freq22
opcache.revalidate_pathOffOff
opcache.save_comments11
opcache.use_cwdOnOn
opcache.validate_timestampsOnOn

zip

Zipenabled
Extension Version$Id: f9f12af1274212b9f22867472e4aa57eab4bb4cf $
Zip version1.12.5
Libzip version0.11.2

zlib

ZLib Supportenabled
Stream Wrappercompress.zlib://
Stream Filterzlib.inflate, zlib.deflate
Compiled Version1.2.8
Linked Version1.2.8
DirectiveLocal ValueMaster Value
zlib.output_compressionOffOff
zlib.output_compression_level-1-1
zlib.output_handlerno valueno value

Additional Modules

Module Name
sysvsem
sysvshm

Environment

VariableValue
APACHE_RUN_DIR/var/run/apache2
APACHE_PID_FILE/var/run/apache2/apache2.pid
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
APACHE_LOCK_DIR/var/lock/apache2
LANGC
APACHE_RUN_USERwww-data
APACHE_RUN_GROUPwww-data
APACHE_LOG_DIR/var/log/apache2
PWD/

PHP Variables

VariableValue
_COOKIE["PHPSESSID"]ic51j3qk8r2i1o4d1cjno501u7
_SERVER["HTTP_HOST"]localhost
_SERVER["HTTP_USER_AGENT"]Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:43.0) Gecko/20100101 Firefox/43.0
_SERVER["HTTP_ACCEPT"]text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
_SERVER["HTTP_ACCEPT_LANGUAGE"]en-US,en;q=0.5
_SERVER["HTTP_ACCEPT_ENCODING"]gzip, deflate
_SERVER["HTTP_REFERER"]http://localhost/
_SERVER["HTTP_COOKIE"]PHPSESSID=ic51j3qk8r2i1o4d1cjno501u7
_SERVER["HTTP_CONNECTION"]keep-alive
_SERVER["PATH"]/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
_SERVER["SERVER_SIGNATURE"]<address>Apache/2.4.12 (Ubuntu) Server at localhost Port 80</address>
_SERVER["SERVER_SOFTWARE"]Apache/2.4.12 (Ubuntu)
_SERVER["SERVER_NAME"]localhost
_SERVER["SERVER_ADDR"]127.0.0.1
_SERVER["SERVER_PORT"]80
_SERVER["REMOTE_ADDR"]127.0.0.1
_SERVER["DOCUMENT_ROOT"]/home/gp
_SERVER["REQUEST_SCHEME"]http
_SERVER["CONTEXT_PREFIX"]no value
_SERVER["CONTEXT_DOCUMENT_ROOT"]/home/gp
_SERVER["SERVER_ADMIN"]webmaster@localhost
_SERVER["SCRIPT_FILENAME"]/home/gp/test.php
_SERVER["REMOTE_PORT"]46590
_SERVER["GATEWAY_INTERFACE"]CGI/1.1
_SERVER["SERVER_PROTOCOL"]HTTP/1.1
_SERVER["REQUEST_METHOD"]GET
_SERVER["QUERY_STRING"]no value
_SERVER["REQUEST_URI"]/test.php
_SERVER["SCRIPT_NAME"]/test.php
_SERVER["PHP_SELF"]/test.php
_SERVER["REQUEST_TIME_FLOAT"]1456139000.945
_SERVER["REQUEST_TIME"]1456139000
I have delvelped a small application whcih is perfectly working on RHEL 5.2 with mysql 5 , php5.2 & apache.


But on Ubuntu 15.10 it is giving following error :

Warning: mysql_connect(): mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file in


Can you please help me ?