Topic: Zarafa contrib doesn't work

[edform]

I've tried a total of four times now to set up and run Zarafa using the contribution at http://wiki.contribs.org/Zarafa. Following the instructions in the contribution means that I have used zarafa-6.20-rhel4-i386.tar.gz and smeserver-zarafa-0.9-4a.noarch.rpm, the latest version of the rpm in Darryl May's repository at http://mirror.contribs.org/smeserver/contribs/dmay/smeserver/7.x/.

On each occasion the zarafa server fails to start...

# /etc/e-smith/events/actions/zarafa-install
initialize-default-databases
Migrating existing database yum_repositories
Migrating existing database domains
Migrating existing database accounts
Migrating existing database yum_updates
Migrating existing database yum_available
Migrating existing database configuration
Migrating existing database backups
Migrating existing database hosts
Migrating existing database yum_installed
Migrating existing database networks
Migrating existing database spamassassin
Migrating existing database mailpatterns
remoteaccess-update
creating zarafa database
Loading 80zarafa into mysql                                [  OK  ]
webaccess config
ok: run: /service/httpd-e-smith: (pid 5447) 1s, normally down
expanding zarafa templates
expanding zarafa templates
starting services
Starting zarafa-gateway:                                   [  OK  ]
Starting zarafa-ical:
Starting zarafa-licensed:
Starting zarafa-monitor:                                   [  OK  ]
Starting zarafa-server:                                    [FAILED]
Starting zarafa-spooler:                                   [  OK  ]
creating Public store
Unable to open Admin session.
The server is not running, or not accessable through file:///var/run/zarafa.

Looking in the server log at /var/log/zarafa, I find...

Sun 14 Dec 2008 04:13:52 PM GMT: Starting zarafa-server version 0,6,20 (12710), pid 4899
Sun 14 Dec 2008 04:13:52 PM GMT: Unable to connect to database: Access denied for user 'root'@'localhost' (using password: YES)
Sun 14 Dec 2008 04:13:52 PM GMT: Server shutdown complete.
Sun 14 Dec 2008 04:16:39 PM GMT: Starting zarafa-server version 0,6,20 (12710), pid 5506
Sun 14 Dec 2008 04:16:39 PM GMT: Unable to connect to database: Access denied for user 'zarafa'@'localhost' (using password: YES)
Sun 14 Dec 2008 04:16:39 PM GMT: Server shutdown complete.

...so it looks like some kind of permissions problem.

I also find that the database zarafa exists, but is empty, with no tables.

Whatever the reason behind the failure, this pair of components simply do not work.

Ed Form

[cactus]

Sun 14 Dec 2008 04:13:52 PM GMT: Unable to connect to database: Access denied for user 'root'@'localhost' (using password: YES)

Have you (in the past) changed your MySQL root user password perhaps? If you did than reset it before installing zarafa, like this: http://wiki.contribs.org/SME_Server:Documentation:FAQ#Resetting_the_MySQL_root_password

If you did not are you sure MySQL is running?

Code: [Select]

service mysqld status

[edform]

Have you (in the past) changed your MySQL root user password perhaps? If you did than reset it before installing zarafa, like this: http://wiki.contribs.org/SME_Server:Documentation:FAQ#Resetting_the_MySQL_root_password

If you did not are you sure MySQL is running?

Code: [Select]

service mysqld status

Bog standard V7.3 server, and bog standard v7.4 server, both running several MySQL contributions perfectly. The zarafa contrib never populates its database and consequently cannot start its server.

Ed Form

Ps. I've added a couple of lines to my original message about the unpopulated database.

[cactus]

Bog standard V7.3 server, and bog standard v7.4 server, both running several MySQL contributions perfectly. The zarafa contrib never populates its database and consequently cannot start its server.

Ed Form

Ps. I've added a couple of lines to my original message about the unpopulated database.

You forgot to answer one of my questions, we would like you to help diagnose the problem, but we need some information from your side:

If you did not are you sure MySQL is running?

Code: [Select]

service mysqld status

And what happens when you login as root user and type this on the command line:

Code: [Select]

mysql

[edform]

You forgot to answer one of my questions, we would like you to help diagnose the problem, but we need some information from your side:

And what happens when you login as root user and type this on the command line:

Code: [Select]

mysql

I did answer the questions - I have tried 2 servers, both of which are functioning perfectly *and running several mySQL contributions perfectly*. I checked the status of hte zarafa database, for example, by opening phpmyadmin, which wouldn't work at all without a functioning mysql system.

Nevertheless to be more specific - I have never, nor would I ever, for any reason, alter the mysql root password. and when I type mysql at the console prompt I get a mysql command line environment in the normal way which I also get 'bye' from if I type quit and press return.

The results of the commands 'service mysqld status' and 'mysql' are shown below...

service mysqld status
run: /service/mysqld: (pid 4700) 1542s, normally down; run: log: (pid 2807) 1639s

# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 39 to server version: 4.1.22

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

mysql> quit
Bye

Ed Form

[edform]

More information on the failure of the zarafa contribution to work...

/etc/e-smith/events/actions/zarafa-create-database calls for a template called /etc/e-smith/sql/init/80zarafa to be expanded. That template doesn't exist on either of the servers on which I've run the contribution [ie a 7.3 and a 7.4].

I've looked everywhere for the code that is supposed to create the database and populate it with tables and I can't find it - any ideas where it is?

Ed Form

[cactus]

More information on the failure of the zarafa contribution to work...

/etc/e-smith/events/actions/zarafa-create-database calls for a template called /etc/e-smith/sql/init/80zarafa to be expanded. That template doesn't exist on either of the servers on which I've run the contribution [ie a 7.3 and a 7.4].

I've looked everywhere for the code that is supposed to create the database and populate it with tables and I can't find it - any ideas where it is?

Ed Form

OK, so everything else related seems normal in your system. Please report it as a bug as this is what should be done to get issues resolved.

[edform]

OK, so everything else related seems normal in your system. Please report it as a bug as this is what should be done to get issues resolved.

Done: bug 4854 entered.

Ed Form

[dadoudidon]

same probleme
fresh virtual 7.4 (server only) on a vmware hosted on a sme server.(installed 7.4 + yum update)
can't start zarafer-server
zarafa mysql base exist but empty (no table).
Installation was done from the wiki.
i also did an update with smedev but no result
David

[johnp]

I saw a problem when using zarafa on 7.3 where the zarafa-server db had a space in front of the mysql password that caused the same kind of issue. I couldn't call it a bug since the wiki states clean 7.4

I can't say that is your problem, but it's worth a look.

[jmbac]

I had the same issue installing zarafa 6.30.1 & Smeserver-zarafa-0.40 on Smeserver-7.4 & Smeserver-8beta4 clean install+updates.

The only way I had it working was to Install  a older version of Zarafa-6.20.8 & Smeserver-0.40 and then updated to zarafa-6.30.1.

jon
 

[soprom]

There must be a bug because installing zarafa-6.20.7-rhel4-i386 on sme7.4 gives no errors but httpd.conf can't be generated:

29ZarafaAliases is having problems :

expand-template /etc/httpd/conf/httpd.conf

Code: [Select]

WARNING in /etc/e-smith/templates//etc/httpd/conf/httpd.conf/VirtualHosts/29ZarafaAliases:
Use of uninitialized value in concatenation (.) or string at /etc/e-smith/templates//etc/httpd/conf/httpd.conf/VirtualHosts/29ZarafaAliases line 24.

[soprom]

It's working with these:

zarafa-6.30.0-rhel4-i386
yum install smeserver-zarafa --enablerepo=smetest

The panel is available from the server-manager.

Yeh!

[vpurger]

It seems that Zarafa >= 6.30 need InoDB.

workaround for fresh install:

(drop database zarafa if exist)

db configuration setprop mysqld InnoDB enabled
expand-template /etc/my.cnf
sv t /service/mysqld

/etc/e-smith/events/actions/zarafa-install
signal-event post-upgrade; signal-event reboot

[dadoudidon]

It seems that Zarafa >= 6.30 need InoDB.

workaround for fresh install:

(drop database zarafa if exist)

db configuration setprop mysqld InnoDB enabled
expand-template /etc/my.cnf
sv t /service/mysqld

/etc/e-smith/events/actions/zarafa-install
signal-event post-upgrade; signal-event reboot

Thanks that's was the problem!
it works with zarafa.6.30.1

It should be fine to modify the wiki and had this trick!
David