Phpinfo Shows Wrong MySQL Version
Mar 25, 2008
I have recently upgraded MySQL to 5.25
However, when I run phpinfo, I see the following:
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.1.21
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
mysqli
MysqlI Support enabled
Client API library version 4.1.21
Client API header version 4.1.20
MYSQLI_SOCKET /var/lib/mysql/mysql.sock
View 4 Replies
ADVERTISEMENT
Mar 5, 2008
I've a small reseller account with cPanel with 5 sites. After transfering to other host (full cPanel backup of old sites, restoring on new host) cPanel of 2 sites still displays the version number of the old host, the other 3 sites are correct.
CP1: correct - CP2: wrong
View 4 Replies
View Related
Jun 27, 2009
I have recently upgraded mysql server from 5.0.75 to 5.1.31 on my Ubuntu server 9.04 32 bit. After that when I am running phpmyadmin it is printing a warning :
Your PHP MySQL library version 5.0.75 differs from your MySQL server version 5.1.31.
View 2 Replies
View Related
Aug 18, 2014
I'm new to Plesk - I've inherited a web site for a local social club so have just been handed login and password. I believe I have version 11.0.9 and as I can see mention of an Apache webserver I'm guessing its linux.
So - I want to redesign and use Joomla so I can share the content updating with others.
I can't install Joomla as I have PHP 5.1 and need 5.3. I have no 'server' or any sort of option I can find (and I've looked everywhere!) to find a command line or somewhere I can run things.
When I try to allow SSH access the option says Forbidden and there is no option to change it.
View 1 Replies
View Related
Jun 1, 2007
loading a phpinfo() shows that the mysql variable "Client API version" on my server doesn't match the version of mysql installed ( 4.0.20 when mysql version is 4.1.21).
Can this cause trouble and php or mysql errors on scripts i'm running?
View 0 Replies
View Related
Jan 15, 2007
I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.
Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.
The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).
The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.
Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
View 11 Replies
View Related
Nov 14, 2008
I just upgraded to the latest version of APF. I am running CentOS with the 2.6 kernel.
I added my ports to allow, started it up, and it does not seem to be blocking anything.
I get no errors on startup though. If i do an nmap, mysql shows up as open still. I can even telnet to it.
root@me [~]# /usr/local/sbin/apf -r
apf(6367): {glob} flushing
View 6 Replies
View Related
Oct 12, 2007
my server is jammed and takes minutes to load simple pages, can you please take a look ath the following image, its show under "CPU %" for mysql 177, does that mean mysql is using 177% of resources of cpu?
View 3 Replies
View Related
Feb 22, 2007
I have a mysql-only server and the server is constantly > 30 in server load. I'm ousted as to what is wrong with mysql and what can be done to optimize it. Using mysql report to generate the following:
Quote:
MySQL 4.1.22-standard uptime 0 0:22:30 Thu Feb 22 07:14:45 2007
__ Key _________________________________________________________________
Buffer used 30.93M of 256.00M %Used: 12.08
Current 60.41M %Usage: 23.60
Write ratio 0.891
Read ratio 0.001
__ Questions ___________________________________________________________
Total 416.13k 308.2/s
DMS 136.54k 101.1/s %Total: 32.81
Com_ 120.17k 89.0/s 28.88
COM_QUIT 117.10k 86.7/s 28.14
QC Hits 44.35k 32.9/s 10.66
-Unknown 2.04k 1.5/s 0.49
Slow 19 0.0/s 0.00 %DMS: 0.01
DMS 136.54k 101.1/s 32.81
SELECT 82.50k 61.1/s 19.82 60.42
UPDATE 27.28k 20.2/s 6.56 19.98
REPLACE 10.85k 8.0/s 2.61 7.95
INSERT 7.98k 5.9/s 1.92 5.84
DELETE 7.93k 5.9/s 1.91 5.81
Com_ 120.17k 89.0/s 28.88
change_db 119.37k 88.4/s 28.69
admin_comma 791 0.6/s 0.19
show_variab 3 0.0/s 0.00
__ SELECT and Sort _____________________________________________________
Scan 6.38k 4.7/s %SELECT: 7.73
Range 6.35k 4.7/s 7.70
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 3.99k 3.0/s
Sort range 9.92k 7.4/s
Sort mrg pass 1.27k 0.9/s
__ Query Cache _________________________________________________________
Memory usage 5.85M of 32.00M %Used: 18.28
Block Fragmnt 22.41%
Hits 44.35k 32.9/s
Inserts 75.31k 55.8/s
Insrtrune 75.31k:1 55.8/s
Hit:Insert 0.59:1
__ Table Locks _________________________________________________________
Waited 54.03k 40.0/s %Total: 31.44
Immediate 117.80k 87.3/s
__ Tables ______________________________________________________________
Open 763 of 1500 %Cache: 50.87
Opened 769 0.6/s
__ Connections _________________________________________________________
Max used 651 of 650 %Max: 100.15
Total 119.74k 88.7/s
__ Created Temp ________________________________________________________
Disk table 24 0.0/s
Table 3.75k 2.8/s
File 2.55k 1.9/s
__ Threads _____________________________________________________________
Running 106 of 132
Cached 36 of 128 %Hit: 96.43
Created 4.28k 3.2/s
Slow 4 0.0/s
__ Aborted _____________________________________________________________
Clients 5.28k 3.9/s
Connects 1.16k 0.9/s
__ Bytes _______________________________________________________________
Sent 2.03G 1.5M/s
Received 159.51M 118.2k/s
And my my.cnf
Quote:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections = 650
key_buffer = 256M
myisam_sort_buffer_size = 64M
skip-locking
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 1M
table_cache = 1500
thread_cache_size = 128
wait_timeout = 10
connect_timeout = 5
tmp_table_size = 128M
max_allowed_packet = 36M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
max_user_connections =600
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
View 5 Replies
View Related
Jun 2, 2008
I am just trying out MySQL on the external Apache server. I must have written down the wrong password. My commands to enter mysql with a password results in denied access.
What file do I undo in order to create a new password? I don't know the exact steps I'm supposed to take. I don't think this is a MySQL issue, but a server issue, right?
I used to create databases and tables on my regular computer and left off the password altogether while I was practicing. Now I'm taking steps to do it on the actual server, and have run across this problem.
View 6 Replies
View Related
Nov 4, 2007
A very unusual issue;
MySQL updated from 3 to 4.1. PHPinfo reports 3.1 is still in effect.
Any ideas?
Stumped me a little, every other MySQL upgrade has gone 100% perfect.
Im blaming PHPINFO for now
View 8 Replies
View Related
Oct 25, 2007
I need MySQL 5.x for my IPB forum and took one host, but I cannot understand what version of MySQL i have, as:
cPanel says:
MySQL version: 5.0.45-community
but phpMyAdmin says:
Server version: 5.0.45-community
MySQL client version: 4.1.22
What version of MySQL do I really have?
What is difference with Server and client? and why version of client is not 5?
View 8 Replies
View Related
Feb 5, 2007
for a hosting plan now. I will mainly use it for developing. What version of PHP and MySql is reasonable to settle for? I understand that the later the better, but I see that most hosting companies are stuck in PHP 4.1 and MySql 4.4. Is that good enough?
View 7 Replies
View Related
Aug 4, 2009
Which version of MySQL is the most used version in webhosts? The latest version of MySQL is version 5.1.
I am wondering because PHP5 which came out back in 2005 has still not been adopted in many web hosts.
Is mysql 4 the most used or mysql 5.x ? Which is the most common mysql version?
View 9 Replies
View Related
Jun 14, 2008
What will be best combo of those 3 which is main core for running almost any web server.Presently i have latest mysql,apache and php installed,but some people says how that is not good beacuse newest version arenot tested yet well enough.
View 6 Replies
View Related
Jun 14, 2007
I can't for the life of me figure out how to upgrade the Client API version authencation method in php for MySQL.
The server had MySQL 3.23.58 before and doing a phpinfo() reflects that. The problem is even after I install a newer version of MySQL 4.1.22 (using RPMs), it still doesn't see it.
I've ran privilege table fix but I am unable to use any mysql accounts unless I use the old password method.
I can have MySQL be up and running using the old password method but I prefer that it works with the newer authentication method since things could go wrong if I do the other way.
Is there a way I can resolve this? or do I just have to stick with the old password hashing method?
View 3 Replies
View Related
Jan 26, 2007
Which version of Mysql is proven to be the most fastest and stable
View 3 Replies
View Related
Sep 22, 2014
I'm still using Plesk 11.5.30 and MySql 5.5.39. That was discribed here how to update. But i need to have a MySql 5.6.5 (minimum) for some software (This version is over 2 years old). I'm using CentOs 6.5. and PHP 5.4.33
how to do this, whitout breaking plesk 11.5.30??
View 4 Replies
View Related
Jun 6, 2015
Is it possible to update the MySQL version on the db nodes from 5.1 to 5.5 or is it supported?
View 3 Replies
View Related
Mar 26, 2014
I am running Apache on a Windows server and it is up and running.I downloaded and installed:
Apache 2.4.9 Win32 [Apache VC11 Binary] httpd-2.4.9-win32-VC11.zip
And included ModSecurity from download: modules-2.4-win32-VC11.zip..
The version of ModSecurity is mod_security-2.7.7 . It is up and running, but I get a warning:
ModSecurity: Loaded PCRE do not match with compiled!
Here's the difference in the PCRE from the logs:
PCRE compiled version="8.33 "; loaded version="8.34 2013-12-15".
The compiled version does not match the loaded version. Is this something I should be concerned about and try to find compiled versions that match?
View 2 Replies
View Related
Apr 17, 2009
when some one upload and load files with phpinfo()
he can see our server PHP Configuration.
how can us disable phpinfo()?
View 13 Replies
View Related
Feb 9, 2007
How do I set this Environment variable "SERVER_ADMIN" that I am seeing on phpinfo()?
View 1 Replies
View Related
Mar 6, 2007
Having this problem on chroot'ed sites in Ensim.
This is what I have in my php.conf:
Code:
[root@ns1 conf.d]# cat /etc/httpd/conf.d/php.conf
#
# PHP is an HTML-embedded scripting language which attempts to make it
# easy for developers to write dynamically generated webpages.
#
LoadModule php5_module modules/libphp5.so
SetOutputFilter PHP
SetInputFilter PHP
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
This prevents file.php.gif from executing in a non-chrooted site, but in my chrooted sites, file.php.gif will execute as a PHP file. Any idea why? Some other config I have to change?
View 10 Replies
View Related
Mar 27, 2007
i give following error so how can i enable phpinfo()
Code:
warning : phpinfo() has been disabled for security reasons
View 6 Replies
View Related
Mar 31, 2008
cat /proc/version
Linux version 2.6.23.15-80.fc7 (gcc version 4.1.2 20070925 (Red Hat 4.1.2-27)) #1 SMP Sun Feb 10 17:29:10 EST 2008
I installed Zend Optimizer (this is NOT a cpanel box to clarify)
1. Downloaded ZendOptimizer-3.3.3-linux-glibc23-i386.tar.gz
2. cd's into that directory
3. ./install.sh
No errors
[root@host ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]
However, ZO does not show up in php info
php -v
PHP 5.2.4 (cli) (built: Sep 18 2007 08:50:58)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with eAccelerator v0.9.5.2, Copyright (c) 2004-2006 eAccelerator, by eAccelerator
php -m
[Zend Modules]
eAccelerator
File: /usr/local/Zend/etc/php.ini
[Zend]
zend_extension_manager.optimizer=/usr/local/Zend/lib/Optimizer-3.3.3
zend_extension_manager.optimizer_ts=/usr/local/Zend/lib/Optimizer_TS-3.3.3
zend_optimizer.version=3.3.3
zend_extension=/usr/local/Zend/lib/ZendExtensionManager.so
zend_extension_ts=/usr/local/Zend/lib/ZendExtensionManager_TS.so
Code:
[root@host lib]# ls -lh
total 32K
drwxr-xr-x 9 root root 4.0K 2008-03-28 20:27 Optimizer-3.3.3
drwxr-xr-x 7 root root 4.0K 2008-03-28 20:27 Optimizer_TS-3.3.3
-rwxr-xr-x 1 root root 11K 2008-03-31 16:21 ZendExtensionManager.so
-rwxr-xr-x 1 root root 11K 2008-03-31 16:21 ZendExtensionManager_TS.so
View 7 Replies
View Related
