ChrisB. on 14 Jan 2005 19:58:02 -0000


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

RE: [PLUG] Looking for a good open source CRM


I am pretty sure this error message is due to the fact the RT uses an older
client to connect to MySQL. You can read more about it and how to get around
it here:

http://dev.mysql.com/doc/mysql/en/Old_client.html



-----Original Message-----
From: plug-bounces@lists.phillylinux.org
[mailto:plug-bounces@lists.phillylinux.org] On Behalf Of Brett Harris
Sent: Friday, January 14, 2005 2:30 PM
To: Philadelphia Linux User's Group Discussion List
Subject: RE: [PLUG] Looking for a good open source CRM

I decided to setup Best Practical's RT first but am running into some
problems.

-------------------------------------------------------------------
I'm installing on Fedora Core 2 and using this doc:
http://wiki.bestpractical.com/index.cgi?FedoraCore2InstallGuide

-------------------------------------------------------------------
I keep getting an error at step 14:
root@btest:~/rt-3.2.2:782>make initialize-database
/usr/bin/perl //usr/local/rt3/sbin/rt-setup-database --action init --dba
root --prompt-for-dba-password
In order to create a new database and grant RT access to that database,
this script needs to connect to your mysql instance on localhost as root.
Please specify that user's database password below. If the user has no
database
password, just press return.

Password: DBI connect(';host=localhost','root',...) failed: Client does
not support authentication protocol requested by server; consider
upgrading MySQL client at //usr/local/rt3/sbin/rt-setup-database line 101
Failed to connect to dbi:mysql:;host=localhost as root: Client does not
support authentication protocol requested by server; consider upgrading
MySQL client at //usr/local/rt3/sbin/rt-setup-database line 101, <STDIN>
line 1.
make: *** [initialize-database] Error 255

-------------------------------------------------------------------
I'm running the latest versions of MySQL:
root@btest:~/rt-3.2.2:785>rpm -q MySQL-client
MySQL-client-4.1.8-0
root@btest:~/rt-3.2.2:786>rpm -q MySQL-server
MySQL-server-4.1.8-0
root@btest:~/rt-3.2.2:787>rpm -q MySQL-shared-compat
MySQL-shared-compat-4.1.8-0

-------------------------------------------------------------------
And I dont have any problems accessing mysql:
root@btest:~/rt-3.2.2:792>mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 4.1.8-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

-------------------------------------------------------------------
Any ideas?

-Brett

___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug

___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug