MySQL 4.1.8

[i-web]

We upgraded to MySQL 4.1.8 today, however have found that fantastico installs are going horribly wrong....

Basically after the client has installed it, we need to find the user/pass that gets created by fantastico then run this in mysql

update mysql.user set password = old_password("password") where user="user";

Is there something we can do to get fantastico to do this correctly???

[Aric]

I run a number of servers that were upgraded from 4 to 4.1 without similar issues. Did you recompile apache after upgrading? Did you check your MySQL 4.1 install is working properly and has a root password assigned to it?

Check this:

http://netenberg.com/forum/viewtopic.php?t=2157

Regards,

Aric

[i-web]

Yes, apache was recompiled, yes MySQL 4.1 is working properly as there are loads of other installs currently working perfectly, its just new installs.... Yes it has root password assigned, as i use the root phpmyadmin login all the time.....

I had a look at that other post, and searched and it is installed in the correct place only... so that cant be the problem... this issue is on 2 seperate servers... 1 is CentOS and the other is RHEL, both running cPanel 10

[i-web]

Ive just tried recompiling apache, and changing the root password, on both servers, went to fantastico, installed a php-nuke site on both servers, and a coppermine photo gallery on both servers and neither work on either server... if i go into mysql and run the old_password setting, then both work perfectly.....

[kosmo]

Fantastico creates mysql users and databases using cpanel commands which any skin also uses:
<cpanel Mysql="adddb($FORM{'thismakedb'})">
<cpanel Mysql="adduser($FORM{'thismakedb'},$FORM{'SQLPass'})">
<cpanel Mysql="adduserdb($FORM{'connect'},$FORM{'connect'})">

If the Fantastico created databases do not work, the cpanel created databases should also not work. Did you try to create some databases/users through cpanel and test the functionality of the password?

kosmo

[i-web]

It appears it only works via cPanel if i create the user first, then create the DB, if i do it the other way around... it doesnt want to work......

Any ideas?

[i-web]

forget that.... it helps if i type the password in correctly...

Yes any user/pass i create in cpanel works, no matter which order i create them in

[kosmo]

If this is true, it is a cpanel bug. You may open any fantastico autoinstall*do.php file and change the lines:

<cpanel Mysql="adddb($FORM{'thismakedb'})">
<cpanel Mysql="adduser($FORM{'thismakedb'},$FORM{'SQLPass'})">

to

<cpanel Mysql="adduser($FORM{'thismakedb'},$FORM{'SQLPass'})">
<cpanel Mysql="adddb($FORM{'thismakedb'})">

to see if it works (in this case the user will be created first).

You should open a cpanel ticket (but do not refer to the Fantastico issue, better refer to the cpanel issue or you will get a "this is a Fantastico issue" answer).

kosmo

[i-web]

looks like our posts crossed :p

right then, i have just created a database, then a user, added the priviledges and am going to test a manual install of phpBB on it....

[i-web]

Right that didnt work, im getting the error

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/personal/public_html/test/db/mysql4.php on line 48

Which means i have to run that mysql command... so its obviously a problem with my cPanel's its just really weird that its on both servers..... :S

[i-web]

the only other thing, which ive just thought of, is both servers have an almost identical my.cnf file (modified for ram installed etc...)

Could this be a cause at all?

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
connect_timeout=15
interactive_timeout=100
join_buffer_size=1M
key_buffer=128M
max_allowed_packet=16M
max_connections=500  
max_connect_errors=10
myisam_sort_buffer_size=64M
read_buffer_size=1M
read_rnd_buffer_size=768K
sort_buffer_size=1M
table_cache=1024
thread_cache_size=100
thread_concurrency=4
wait_timeout=300
query_cache_size=32M
query_cache_limit=1M
query_cache_type=1
skip-innodb
collation-server=latin1_general_ci
 
[mysql.server]
user=mysql
basedir=/var/lib
 
 
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
 
[mysqldump]
quick
max_allowed_packet=16M
 
[mysql]
no-auto-rehash
#safe-updates
 
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
 
[myisamchk]  
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
 
[mysqlhotcopy]
interactive-timeout

Ill post on cpanel forum too, and have submitted a support ticket.... so will post here the outcome, just incase anyone else has the same issue

[Aric]

I've checked several servers with MySQL 4.1.8 and the default my.cnf is:

[mysqld]
set-variable = max_connections=500
safe-show-database


You might consider trying that setting alone (and restart mysql) to see if the problem goes away or not. This will let you know if it is related to your altered settings.

Regards,

Aric

[i-web]

Thanks Aric i will give that a go..

Take a look here

http://forums.cpanel.net/showpost.php?p=172706&postcount=94

to see cpanels response to my problem

[i-web]

well that didnt work... but thanks aric

Only other thing that i can think of is that we use zendoptimizer, could this be interfearing in anyway...

i know this isnt a general support forum, so appologise, just looking for help as cpanel cant be arsed......

[Aric]

I can tell you that isn't it either, since Zendoptimizer is installed on my servers also.

In any case, there is a 4.0 compatibility mode in 4.1 you may want to look at.