Hans Melis
|
Friday 26 November 2004 5:17:00 am
I think I'm going to patent this :-)
See my replies in this thread: http://ez.no/community/forum/install_configuration/kernel_50_on_solaris_mysql_4_1_7_ez_3_4_3 As stated in the MySQL 4.1 notes, the authentication protocol in 4.1.x changed which causes problems for old clients (PHP4 is one of them). Logging in from the command line always works because then you're using the MySQL client itself which is of course updated to use the new protocol. For the record, I'm running MySQL 4.1.7 for all eZ publish installations I have (live server, workstation and 2 desktops at home) and have yet to encounter an issue.
Hans
http://blog.hansmelis.be
|
Arran Price
|
Sunday 28 November 2004 12:13:04 pm
seems my post got lost, so hopefully this isnt a duplicate.
anyways
installing mysql 4.0.22 worked for us (ie ealier version than we had used).
for those interested on a redhat box, the following rpms from mysql.com should work.
MySQL-client-4.0.22-0.i386.rpm MySQL-server-4.0.22-0.i386.rpm cheers Arran
|
Mikhail Chekanov
|
Monday 29 November 2004 12:36:42 am
This problem is concerned to MySQL 4.1.x "bug" -- eztrigger table contains too long key eztrigger_def_id, because key lentgh in MySQL 4.1.x is limited to ~330 chars(UTF), AFAIK.
So, eZ setup can't fill up the database. Only way to istall eZ, imho, is to insert data manually from modified kernel/sql/mysql/kernel_schema.sql :
CREATE TABLE eztrigger (
connect_type char(1) NOT NULL default '',
function_name varchar(160) NOT NULL default '',
id int(11) NOT NULL auto_increment,
module_name varchar(160) NOT NULL default '',
name varchar(255) default NULL,
workflow_id int(11) default NULL,
PRIMARY KEY (id),
UNIQUE KEY eztrigger_def_id (module_name,function_name,connect_type),
KEY eztrigger_fetch (name(25),module_name(50),function_name(50))
);
then insert data from cleandata.sql.
During install eZ will ask what to do with database, just leave the database alone.
This is a very dirty hack, but... Also you can try to tune your MySQL to use latin1 charset (for example), but I'm unassured of the effect.
--
mike
#6595551
|