Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th August 2008, 19:22
pakogah pakogah is offline
Member
 
Join Date: Feb 2008
Posts: 56
Thanks: 13
Thanked 2 Times in 2 Posts
Default MySQL5 client access to ISPConfig box vs plain centos5

I have ispconfig box which setup properly according Centos 5 Perfect Server Setup (has Mysql 5 in it) then I install ispconfig on it. and I have another box which I am only install mysql 5 also using Centos 5 (for test dbserver). here's is my problem:

I have user who still using old 2002 mysql-front (which I assumed still using libmysql library from mysql 3.23), he can access to mysql dbs at ispconfig box without problem, but then when tried to connect to test dbserver he can't.


error shows up:
Code:
MySQL-Error:
Connection failed:
1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
he is using the same program, connect to both servers, which the servers' OS version are the same Centos 5, and they both have Mysql5. here are the mysql packages on both machines:
Code:
# rpm -qa | grep mysql
libdbi-dbd-mysql-0.8.1a-1.2.2
mysql-server-5.0.45-7.el5
mysql-connector-odbc-3.51.12-2.2
mysql-5.0.45-7.el5
mysql-devel-5.0.45-7.el5
now then it take me to mysql configuration, but both machines also have the same config file, here are the content:
Code:
# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-innodb

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
I was curious, perhaps my test dbserver, unable to take login from user program because it dont have mysqlclient10 package/file but then when I check on my ispconfig box and via yum. there is no package/file called mysqlclient10 for centos5 (I have enabled centosplus repos'). so I am very positive there is must be some packages, files, or configuration which missing on my testdbserver but they all available/configured on ispconfig box.

when I am installing Centos 5 perfect server + ispconfig, i didn't notice some configuration / installing other packages for mysql which may required by ispconfig.

so please can you tell me, what do I miss on my plain Centos5 with mysql5 box? why I can't accessing it using the same program (mysql-front) which I can use it to another server running ispconfig (centos5 with mysql5)

thank you in advance for your time to take reply
Reply With Quote
Sponsored Links
  #2  
Old 5th August 2008, 19:47
pakogah pakogah is offline
Member
 
Join Date: Feb 2008
Posts: 56
Thanks: 13
Thanked 2 Times in 2 Posts
 
Default

oke case closed, I have found the answer,
after I change /etc/my.cnf on test-dbserver with
Code:
old-password=1
I need to create a new user, then mysql will store the new user's password using old password format which readable by previous client (mysql 3.23 library) after that, you can use normally...

but then it brings up a question. Mysql 5 already support stored procedure, views, sub-select etc, etc, which not available when mysql 3.23, can my old programs or dll which still using mysql 3.23 library take those advantages? I mean using sub-select, insert-select and perhaps read views table or running stored procedure??

I know the old mysql-front 2.5 which created on 2002 wont be able to create views, stored procedure etc, but I think it can read view tables and execute stored procedure right ??

please tell me your tought, this is the first time I am playing in reality using for in-house developing using delphi 5

once again, thank you in advance for your time to take reply
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot access ispconfig site Nu2Linux Installation/Configuration 13 3rd January 2009 16:29
2 ispconfig box pakogah Installation/Configuration 2 12th July 2008 16:47
Can I setup a client to have access to create FTP accounts without giving root? cristobalmiguelo General 1 7th January 2008 09:28
Internet sharing and Gateway in Same ISPConfig Box Morons Installation/Configuration 7 21st September 2006 16:18
Can't access ISPConfig by http://...:81 driftguy Installation/Configuration 7 14th September 2005 15:47


All times are GMT +2. The time now is 08:17.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.