Topic: Zarafa contrib doesn't work

[soprom]

What would be a command line to drop database zarafa if exist ?

[dadoudidon]

Code: [Select]

mysql
DROP DATABASE IF EXISTS zarafa;
David

[jcc]

Hi.
I have the same problem described in this thread, but i can't drop the database:

Code: [Select]

[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?

[dadoudidon]

You can try to install phpmyadmin ans drop the database via the gui.
http://wiki.contribs.org/PHPMyAdmin
David

[vpurger]

/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

[jcc]

/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...

[shawnbishop]

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??

[axessit]

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.

[jester]

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).


@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

HTH.

[janet]

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;

[shawnbishop]

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.

[Stefano]

shawnbishop: please search also in Zarafa's forums and ask there too..

IMHO this is not a SME/SME's contrib issue, but a Zarafa one