Installation issues with mysql

Author Message

chandra s

Thursday 25 November 2004 7:04:07 pm

Hi all,
Im having a fair amount of pain trying to install ezpublish on a redhat linux box (version XXXXXXX).
Ive already installed and had running the same version of ezpublish on both a debian and a solaris platform.

Im running:
ezpublish 3.4.4
mysql 4.1.7
PHP 4.3.9
apache apache 1.3.33

I can through the setup wizzard up until the database settings page. Here I cant enter in the username and password for the database I have created for ezpublish (I can log in manually from the command line and prove the user and password are valid).
The only settings that will allow me past this stage is to use, root as the user with no password (I removed the mysql root password for testing purposes), I also have to use the actual hostname of the server instead of localhost. The database is residing on the same server, so Im unsure as to why that is required and wont be suprised if thats part of the problem.

If I continue on, It will allow me to select the correct database from the wizzard page further on, but eventually will fail with the error: Fatal error: Call to a member function on a non-object
in /home/www/ezpublish/kernel/classes/ezcontenobjectversion.php on line 911. Fatal error: eZ publish did not finish its request.
-no further debug infromation is provided.

Just for testing I also tried with ezpublish-3[1].5.0rc1 with the same results only the debug output from the wizzard is:
EZSW-004Failed inserting data to mysql
EZSW-040Failed to initialize site package intranet

I am stumped. As stated, the users with passwords can succesfully connect to mysql from the command line.

Dainis Valtas

Friday 26 November 2004 4:37:22 am

The same problem
I'm running:

ezPublish 3.5.RC1
mysql 4.1.7
PHP 4.3.9
Apache Web Server 2
Windows XP SP2

Łukasz Serwatka

Friday 26 November 2004 5:09:25 am

Hi,

Strange bug. With MySQL 4.0.xx eZ publish intalation works fine
http://www.ez.no/community/bug_reports/problem_with_instalation_fatal_error

I had problems with PHP and MySQL 4.1.7 on both Win32 and Linux platform.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

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

Łukasz Serwatka

Friday 26 November 2004 5:23:54 am

I had this error when i`m running MySQL 4.1.7 with old_password parametr. So i think that problem is somewhere else, because during instalations tables was created properly in MySQL 4.1.7. phpMyAdmin 2.6.0 works properly (old_password enabled) eZ publish don`t

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Arran Price

Sunday 28 November 2004 10:57:53 am

Im working with Chandra (original poster).
Ive followed Hans instructions and after restarting mysql and apache I still have the same problems.

any other ideas?

Arran

Arran Price

Sunday 28 November 2004 12:03:26 pm

Installing an earlier version of mysql has fixed the problem for us.
On our redhat box we used version 4.0.22, and its now working.
For those interested the 2 rpms you want are:
MySQL-client-4.0.22-0.i386.rpm
MySQL-server-4.0.22-0.i386.rpm

cheers

Arran

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

Tony Wood

Monday 29 November 2004 12:52:19 am

This is also a reported bug in eZ.
http://ez.no/community/bug_reports/mysql_error_1071_with_utf8_db_on_kernel_injection

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.