Koozali.org: home of the SME Server
Obsolete Releases => SME 7.x Contribs => Topic started by: edform on December 14, 2008, 05:36:48 PM
-
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
-
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?service mysqld status
-
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?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.
-
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?service mysqld status
And what happens when you login as root user and type this on the command line:
mysql
-
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:
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
-
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
-
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.
-
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
-
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
-
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.
-
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
-
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
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.
-
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!
-
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
-
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
-
What would be a command line to drop database zarafa if exist ?
-
mysql
DROP DATABASE IF EXISTS zarafa;
David
-
Hi.
I have the same problem described in this thread, but i can't drop the database:
[root@kammerserver ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.1.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> DROP DATABASE IF EXISTS zarafa;
ERROR 1051 (42S02): Unknown table 'searchresults,objectrelation,syncs,users,versions,names,object,receivefolder,singleinstances,outgoin'
mysql>
it is an almost untouched smeserver 7.4.
any ideas?
-
You can try to install phpmyadmin ans drop the database via the gui.
http://wiki.contribs.org/PHPMyAdmin
David
-
/etc/e-smith/db configuration setprop mysqld InnoDB disabled
/etc/e-smith/expand-template /etc/my.cnf
sv t /service/mysqld
... then drop database zarafa
-
/etc/e-smith/db configuration setprop mysqld InnoDB disabled
/etc/e-smith/expand-template /etc/my.cnf
sv t /service/mysqld
... then drop database zarafa
Yes, that was it!
:)
I first accidentally tried it without dropping the zarafa-database, so i enabled InnoDB and with InnoDB enabled, it seems to be not possible to drop the database.
Now everything worked, and my first user (jcc) is configured.
Thanks a lot dadoudidon,
jcc
@vpurger: phpadmin gave the same error-message, but it is still a nice contrib, so thanks anyway...
;)
-
Hi
I have tried with version 6.40 and 6.30 and I get the following errors
ok: run: /service/httpd-e-smith: (pid 8420) 1s, normally down
creating zarafa database
Loading 80zabbix-server into mysql ERROR 1030 (HY000) at line 1: Got error 1 from storage engine
ERROR 1030 (HY000) at line 32: Got error 1 from storage engine
[FAILED]
Loading 80zarafa into mysql [ OK ]
Enter your user plugin. Values: unix, db, ldap
db
expanding zarafa templates
starting services
Starting zarafa-gateway: [ OK ]
Starting zarafa-ical: [ OK ]
Starting zarafa-licensed: [ OK ]
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.
Output of the Log file as follows
Sat 09 Oct 2010 02:20:49 PM SAST: Unable to connect to database: Access denied for user 'zarafa'@'localhost' (using password: YES)
Sat 09 Oct 2010 02:20:49 PM SAST: Server shutdown complete.
Sat 09 Oct 2010 02:25:25 PM SAST: Starting zarafa-server version 6,30,6,18063 (18063), pid 10453
Sat 09 Oct 2010 02:25:25 PM SAST: Unable to connect to database: Access denied for user 'zarafa'@'localhost' (using password: YES)
Sat 09 Oct 2010 02:25:25 PM SAST: Server shutdown complete.
Now if I check the /etc/zarafa/server.cfg file I see entries for the MySQL database that has the user 'zarafa' and a password '879697859595'
I GRANT ACESS on the zarafa database for the user and password, but still no joy?, the Wiki install entry isnt so clear.. as follows
GRANT SELECT ON zarafa.* TO 'zarafa'@'localhost' IDENTIFIED BY '879697859595';
Also I cannot DROP the zarafa table anymore, I am not a MySQL fundie, but it tells me the tables are being used, even when I shut the mysql down, and try via phpmyadmin
Anybody have anyideas??
-
I recall having heaps of grief with getting Zarafa going on a box. Turns out Zarafa used UID maximum and minimum values OK, but in between me creating users, I also created groups, and the group ID was in among the user ID range, so Zarafa was really confused between groups and users.
In the end, after removing and trying to clean up the users and groups by editing the /etc/passwd file to separate users and groups, it created all sorts of issues. In the end I removed zarafa and manually removed the folders under /var/lib/mysql, then reinstalled zarafa. Everything worked fine after that.
Using Zarafa 6.40.0-20419.
-
Just done a clean install of SME 7.5.1 and followed the Wiki on installing Zarafa (took me about 20min. in total :-)) to find out if the installation is really that troublesome... except for finding an undocumented new dependency with the latest Zarafa packages (that is automatically satisfied by yum from the base repository), i had absolutely no trouble.
About user and group problems axessit had, this was an issue only when using the unix plugin that has been resolved a while ago (see bug #5828 (http://bugs.contribs.org/show_bug.cgi?id=5828)).
@shawnbishop: you can try to drop the zarafa database, but i don't think it has been created in the first place judging from:
creating zarafa database
Loading 80zabbix-server into mysql ERROR 1030 (HY000) at line 1: Got error 1 from storage engine
ERROR 1030 (HY000) at line 32: Got error 1 from storage engine
[FAILED]
I think you've messed your installation up previously to installing Zarafa. Have you altered your MySQL root pass?! If so, start reading here: MySQL root password (http://wiki.contribs.org/MySQL#MySQL_root_password)
HTH.
-
shawnbishop
Further to jester's comments.
In the Zarafa wiki article it says:
"Note:
You have to enable InnoDB support in MySql in order to get zarafa-server running, for information on how to do so, see MySQL#Enable_InnoDB_engine"
Maybe you did not do that, or if you did, then refer post #19 of this thread re disabling it before deleting the table.
Surely it's too easy to determine in the table exists or not using phymyadmin or the command line,
Ie IIRC
mysql
show databases;
exit;
-
Going to have to go with a clean install and add the Zarafa...
I now get the following error
Tue Oct 26 16:54:58 2010: Server shutdown complete.
Tue Oct 26 16:55:36 2010: Starting zarafa-server version 6,40,2,22452, pid 23522
Tue Oct 26 16:55:36 2010: Connection to database 'zarafa' succeeded
Tue Oct 26 16:55:36 2010: Using commercial license serial ''
Tue Oct 26 16:55:36 2010: 0x00000009ea0410: SQL Failed: Can't find file: 'versions' (errno: 2), Query: "SELECT major,minor,revision,databaserevision FROM versions ORDER BY major DESC, minor DESC, revision DESC, databaserevision DESC LIMIT 1"
Tue Oct 26 16:55:36 2010: Can't update the database:
Tue Oct 26 16:55:36 2010: Server shutdown complete.
-
shawnbishop: please search also in Zarafa's (http://forums.zarafa.com/) forums and ask there too..
IMHO this is not a SME/SME's contrib issue, but a Zarafa one