Topic: need help WebMail problem

[Dave]

after upgrading from 4.1.2 to 5.5, and elimanating a duplacate domain in named, I get this error...
what does < mysql_create.sql supposed to do??
as in [root@styx db]# mysql < mysql_create.sql

here is my message.log re: the error
Aug  5 16:52:51 seaport rc: Starting smb:  succeeded
Aug  5 16:52:52 seaport migrate-imp-to-turba: Migrating IMP 2.x address book to IMP 3.x (Turba)
Aug  5 16:52:52 seaport migrate-imp-to-turba: Migrating database
Aug  5 16:52:52 seaport migrate-imp-to-turba: loading /etc/e-smith/sql/init/30mysql.create.horde.sql into mysql
Aug  5 16:52:53 seaport migrate-imp-to-turba: Loading data into mysql
Aug  5 16:52:53 seaport migrate-imp-to-turba: ERROR 1061 at line 74: Duplicate key name 'category_category_name_idx'
Aug  5 16:52:53 seaport mysql.init: Loading data into mysql failed
Aug  5 16:52:53 seaport migrate-imp-to-turba: ^[[60G
Aug  5 16:52:53 seaport migrate-imp-to-turba:
Aug  5 16:52:53 seaport migrate-imp-to-turba: Creating Turba objects table
Aug  5 16:52:54 seaport migrate-imp-to-turba: Can't call method "finish" on an undefined value at /etc/rc.d/init.d/migrate-imp-to-turba line 162.
Aug  5 16:52:54 seaport migrate-imp-to-turba: Converting book entries
Aug  5 16:52:54 seaport rc: Starting migrate-imp-to-turba:  failed
Aug  5 16:52:58 seaport mysql.init: loading /etc/e-smith/sql/init/30mysql.create.horde.sql into mysql
Aug  5 16:52:58 seaport mysql.init: ERROR
Aug  5 16:52:58 seaport mysql.init: Loading data into mysql
Aug  5 16:52:58 seaport mysql.init:  1061 at line 74: Duplicate key name 'category_category_name_idx'
Aug  5 16:52:58 seaport mysql.init: Loading data into mysql failed
Aug  5 16:52:58 seaport mysql.init: ^[[60G
Aug  5 16:52:58 seaport mysql.init:
Aug  5 16:52:58 seaport rc: Starting mysql.init:  succeeded
Aug  5 16:53:20 seaport atalk: atalkd startup succeeded
Aug  5 16:53:33 seaport atalk: papd startup succeeded
Aug  5 16:53:33 seaport atalk: afpd startup succeeded

the tables in horde are:
Database changed
mysql> show tables;
+-----------------------------+
| Tables_in_horde             |
+-----------------------------+
| active_sessions             |
| horde_categories            |
| horde_categories_categories |
| horde_prefs                 |
| horde_users                 |
| imp_addr                    |
| imp_pref                    |
| turba_objects               |
+-----------------------------+
8 rows in set (0.00 sec)

what is the fix?

[rene]

I have the same error message, which is

mysql.init: loading /etc/e-smith/sql/init/30mysql.create.horde.sql into mysql
mysql.init: ERROR
mysql.init: Loading data into mysql
mysql.init:  1061 at line 74: Duplicate key name 'category_category_name_idx'
mysql.init: Loading data into mysql failed
mysql.init: ^[[60G
mysql.init:
Starting mysql.init:  succeeded

and it only happens after reboot, but funny enough my webmail runs fine.... any idea?