Topic: Local LDAP addresses gone after upgrade to 7.4

[runded]

Hello,

I have been having an issue with my local ldap (global address book) not showing any addresses after upgrading to 7.4 from 7.3.  I was wanting to see if this was something I did or if other people were having the sam issues. I took a look at the addressbooks missing post and was unsuccessfull in fixing my issue.  Do I need to post a bug or am I missing something silly?


Here is part of my /var/log/messages log:

Nov 24 23:04:03 mail HORDE[3821]: [turba] DB Error: no such field: SELECT object_id, owner_id, object_type, object_members, object_uid, object_firstname, object_lastname, object_middlenames, object_nameprefix, object_namesuffix, object_alias, object_bday, object_homestreet, object_homepob, object_homecity, object_homeprovince, object_homepostalcode, object_homecountry, object_workstreet, object_workpob, object_workcity, object_workprovince, object_workpostalcode, object_workcountry, object_tz, object_email, object_homephone, obj
Nov 24 23:04:03 mail HORDE[3821]: [turba] DB Error: no such field: SELECT object_id, owner_id, object_type, object_members, object_uid, object_firstname, object_lastname, object_middlenames, object_nameprefix, object_namesuffix, object_alias, object_bday, object_homestreet, object_homepob, object_homecity, object_homeprovince, object_homepostalcode, object_homecountry, object_workstreet, object_workpob, object_workcity, object_workprovince, object_workpostalcode, object_workcountry, object_tz, object_email, object_homephone, obj
Nov 24 23:04:04 mail slapd[4498]: conn=0 op=1 UNBIND
Nov 24 23:04:04 mail slapd[4498]: conn=0 fd=7 closed
Nov 24 23:04:04 mail squid[4750]: storeLateRelease: released 0 objects
Nov 24 23:04:05 mail slapd[4498]: conn=1 fd=7 ACCEPT from IP=127.0.0.1:32783 (IP=0.0.0.0:389)
Nov 24 23:04:05 mail slapd[4498]: conn=1 op=0 BIND dn="" method=128
Nov 24 23:04:05 mail slapd[4498]: conn=1 op=0 RESULT tag=97 err=0 text=
Nov 24 23:04:05 mail HORDE[3820]: [turba] DB Error: no such field: SELECT object_id, owner_id, object_type, object_members, object_uid, object_firstname, object_lastname, object_middlenames, object_nameprefix, object_namesuffix, object_alias, object_bday, object_homestreet, object_homepob, object_homecity, object_homeprovince, object_homepostalcode, object_homecountry, object_workstreet, object_workpob, object_workcity, object_workprovince, object_workpostalcode, object_workcountry, object_tz, object_email, object_homephone, obj
Nov 24 23:04:05 mail HORDE[3820]: [turba] DB Error: no such field: SELECT object_id, owner_id, object_type, object_members, object_uid, object_firstname, object_lastname, object_middlenames, object_nameprefix, object_namesuffix, object_alias, object_bday, object_homestreet, object_homepob, object_homecity, object_homeprovince, object_homepostalcode, object_homecountry, object_workstreet, object_workpob, object_workcity, object_workprovince, object_workpostalcode, object_workcountry, object_tz, object_email, object_homephone, obj
Nov 24 23:04:05 mail slapd[4498]: conn=1 op=1 UNBIND
Nov 24 23:04:05 mail slapd[4498]: conn=1 fd=7 closed
Nov 24 23:04:08 mail messagebus: messagebus startup succeeded
Nov 24 23:04:09 mail haldaemon: haldaemon startup succeeded
Nov 24 23:04:09 mail 10fix_privilege_tables: ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
Nov 24 23:04:09 mail 10fix_privilege_tables: ERROR 1060 (42S21) at line 28: Duplicate column name 'Grant_priv'
Nov 24 23:04:09 mail 10fix_privilege_tables: ERROR 1060 (42S21) at line 29: Duplicate column name 'Grant_priv'
Nov 24 23:04:09 mail 10fix_privilege_tables: ERROR 1060 (42S21) at line 30: Duplicate column name 'Grant_priv'
Nov 24 23:04:09 mail 10fix_privilege_tables: ERROR 1060 (42S21) at line 41: Duplicate column name 'ssl_type'
Nov 24 23:04:09 mail 10fix_privilege_tables: ERROR 1054 (42S22) at line 87: Unknown column 'Type' in 'columns_priv'
Nov 24 23:04:09 mail 10fix_privilege_tables: ERROR 1060 (42S21) at line 93: Duplicate column name 'type'
Nov 24 23:04:09 mail 10fix_privilege_tables: ERROR 1060 (42S21) at line 103: Duplicate column name 'Show_db_priv'
Nov 24 23:04:09 mail 10fix_privilege_tables: ERROR 1060 (42S21) at line 120: Duplicate column name 'max_questions'
Nov 24 23:04:09 mail 10fix_privilege_tables: ERROR 1060 (42S21) at line 130: Duplicate column name 'Create_tmp_table_priv'
Nov 24 23:04:09 mail 10fix_privilege_tables: ERROR 1060 (42S21) at line 133: Duplicate column name 'Create_tmp_table_priv'
Nov 24 23:04:10 mail 10fix_privilege_tables: ERROR 1061 (42000) at line 141: Duplicate key name 'Grantor'
Nov 24 23:04:10 mail atalkd[4785]: zip_getnetinfo for eth0
Nov 24 23:04:10 mail 10fix_privilege_tables: @hadGrantPriv:=1
Nov 24 23:04:10 mail 10fix_privilege_tables: 1
Nov 24 23:04:12 mail last message repeated 15 times
Nov 24 23:04:12 mail 10fix_privilege_tables: @hadShowDbPriv:=1
Nov 24 23:04:12 mail 10fix_privilege_tables: 1
Nov 24 23:04:13 mail last message repeated 15 times
Nov 24 23:04:13 mail 10fix_privilege_tables: waiting for mysqld to restart
Nov 24 23:04:13 mail mysql.init: Loading 10fix_privilege_tables into mysql succeeded
Nov 24 23:04:13 mail mysql.init: Loading 20mysql_migrate_horde into mysql succeeded
Nov 24 23:04:13 mail mysql.init: Loading 21horde.mysql_set_password into mysql succeeded
Nov 24 23:04:14 mail mysql.init: Loading 30horde_mysql_create_tables into mysql succeeded
Nov 24 23:04:16 mail mysql.init: Loading 31horde_upgrade into mysql succeeded
Nov 24 23:04:17 mail mysql.init: Loading 35imp_mysql_create_tables into mysql succeeded
Nov 24 23:04:17 mail mysql.init: Loading 36imp_upgrade into mysql succeeded
Nov 24 23:04:17 mail 40horde_mysql_create_indexes: /etc/e-smith/sql/init/40horde_mysql_create_indexes: line 3: /etc/e-smith/events/actions/horde_create_indexes: No such file or directory
Nov 24 23:04:17 mail 40horde_mysql_create_indexes: /etc/e-smith/sql/init/40horde_mysql_create_indexes: line 3: exec: /etc/e-smith/events/actions/horde_create_indexes: cannot execute: No such file or directory
Nov 24 23:04:17 mail mysql.init: Loading 40horde_mysql_create_indexes into mysql failed
Nov 24 23:04:17 mail mysql.init: Loading 40mysql.create.turba into mysql succeeded
Nov 24 23:04:18 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_firstname VARCHAR(255)
Nov 24 23:04:19 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_lastname VARCHAR(255)
Nov 24 23:04:19 mail 49turba_migrate_contacts: [   OK   ] UPDATE turba_objects SET object_lastname = object_name
Nov 24 23:04:20 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects DROP COLUMN object_name
Nov 24 23:04:21 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_middlenames VARCHAR(255)
Nov 24 23:04:22 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_nameprefix VARCHAR(255)
Nov 24 23:04:23 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_namesuffix VARCHAR(32)
Nov 24 23:04:24 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_phototype VARCHAR(10)
Nov 24 23:04:25 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_bday VARCHAR(10)
Nov 24 23:04:25 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_homestreet VARCHAR(255)
Nov 24 23:04:26 mail 49turba_migrate_contacts: [   OK   ] UPDATE turba_objects SET object_homestreet = object_homeaddress
Nov 24 23:04:27 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects DROP COLUMN object_homeaddress
Nov 24 23:04:27 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_homepob VARCHAR(10)
Nov 24 23:04:28 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_homecity VARCHAR(255)
Nov 24 23:04:29 mail sshd(pam_unix)[5139]: session opened for user root by (uid=0)
Nov 24 23:04:30 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_homeprovince
Nov 24 23:04:30 mail 49turba_migrate_contacts:            VARCHAR(255)
Nov 24 23:04:20 mail atalkd[4785]: zip_getnetinfo for eth0
Nov 24 23:04:30 mail atalkd[4785]: config for no router
Nov 24 23:04:31 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_homepostalcode
Nov 24 23:04:31 mail 49turba_migrate_contacts:            VARCHAR(255)
Nov 24 23:04:31 mail atalkd[4785]: ready 0/0/0
Nov 24 23:04:31 mail atalk: atalkd startup succeeded
Nov 24 23:04:32 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_homecountry VARCHAR(255)
Nov 24 23:04:33 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_workstreet VARCHAR(255)
Nov 24 23:04:33 mail 49turba_migrate_contacts: [   OK   ] UPDATE turba_objects SET object_workstreet = object_workaddress
Nov 24 23:04:34 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects DROP COLUMN object_workaddress
Nov 24 23:04:35 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_workpob VARCHAR(10)
Nov 24 23:04:36 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_workcity VARCHAR(255)
Nov 24 23:04:37 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_workprovince
Nov 24 23:04:37 mail 49turba_migrate_contacts:            VARCHAR(255)
Nov 24 23:04:37 mail atalk:   Registering mail:Workstation: succeeded
Nov 24 23:04:38 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_workpostalcode
Nov 24 23:04:38 mail 49turba_migrate_contacts:            VARCHAR(255)
Nov 24 23:04:39 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_workcountry VARCHAR(255)
Nov 24 23:04:40 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_tz VARCHAR(32)
Nov 24 23:04:41 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_geo VARCHAR(255)
Nov 24 23:04:42 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_pager VARCHAR(25)
Nov 24 23:04:43 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_role VARCHAR(255)
Nov 24 23:04:43 mail atalk:   Registering mail:netatalk: succeeded
Nov 24 23:04:43 mail atalk: papd startup succeeded
Nov 24 23:04:43 mail papd[5187]: restart (2.0.3)
Nov 24 23:04:44 mail atalk: cnid_metad startup succeeded
Nov 24 23:04:44 mail afpd[5195]: Registering CNID module [last]
Nov 24 23:04:44 mail afpd[5195]: Registering CNID module [cdb]
Nov 24 23:04:44 mail afpd[5195]: Registering CNID module [dbd]
Nov 24 23:04:44 mail afpd[5195]: Loading ConfigFile
Nov 24 23:04:44 mail atalk: afpd startup succeeded
Nov 24 23:04:44 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_logotype VARCHAR(10)
Nov 24 23:04:45 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_category VARCHAR(80)
Nov 24 23:04:46 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_url VARCHAR(255)
Nov 24 23:04:48 mail 49turba_migrate_contacts: [   OK   ] CREATE INDEX turba_email_idx ON turba_objects (object_email)
Nov 24 23:04:49 mail slapd[4498]: conn=2 fd=7 ACCEPT from IP=127.0.0.1:32786 (IP=0.0.0.0:389)
Nov 24 23:04:49 mail slapd[4498]: conn=2 op=0 BIND dn="" method=128
Nov 24 23:04:49 mail slapd[4498]: conn=2 op=0 RESULT tag=97 err=0 text=
Nov 24 23:04:49 mail slapd[4498]: get_ssa: conn 2 unknown attribute type=turbaType (17)
Nov 24 23:04:49 mail slapd[4498]: conn=2 op=1 SRCH base="dc=ttown,dc=k12,dc=il,dc=us" scope=1 deref=0 filter="(&(?=undefined))"
Nov 24 23:04:49 mail slapd[4498]: conn=2 op=1 SRCH attr=dn uid turbaType turbaMembers cn mail homephone telephonenumber mobiletelephonenumber homepostaladdress calFBURL sn
Nov 24 23:04:49 mail slapd[4498]: conn=2 op=1 SEARCH RESULT tag=101 err=0 nentries=0 text=
Nov 24 23:04:49 mail slapd[4498]: conn=2 op=2 UNBIND
Nov 24 23:04:49 mail slapd[4498]: conn=2 fd=7 closed
Nov 24 23:04:50 mail 49turba_migrate_contacts: [   OK   ] CREATE INDEX turba_firstname_idx ON turba_objects (object_firstname)
Nov 24 23:04:50 mail afpd[5195]: mail:AFPServer@* started on 65280.213:128 (2.0.3)
Nov 24 23:04:50 mail afpd[5195]: ASIP started on 10.0.0.6:548(6) (2.0.3)
Nov 24 23:04:50 mail afpd[5195]: uam: loading (/usr/lib/uams_dhx.so)
Nov 24 23:04:50 mail afpd[5195]: uam: uams_dhx.so loaded
Nov 24 23:04:50 mail afpd[5195]: uam: loading (/usr/lib/uams_pgp.so)
Nov 24 23:04:50 mail afpd[5195]: uam: uam not found (status=-1)
Nov 24 23:04:50 mail afpd[5195]: uam: "DHCAST128" available
Nov 24 23:04:50 mail afpd[5195]: Finished parsing Config File
Nov 24 23:04:53 mail 49turba_migrate_contacts: [   OK   ] CREATE INDEX turba_lastname_idx ON turba_objects (object_lastname)
Nov 24 23:04:55 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_photo BLOB
Nov 24 23:04:56 mail 49turba_migrate_contacts: [   OK   ] ALTER TABLE turba_objects ADD COLUMN object_logo BLOB
Nov 24 23:05:00 mail 49turba_migrate_contacts: [   OK   ] Contact name fields parsed.
Nov 24 23:05:00 mail 49turba_migrate_contacts: [   OK   ] Home address fields parsed.
Nov 24 23:05:00 mail 49turba_migrate_contacts: [   OK   ] Work address fields parsed.
Nov 24 23:05:09 mail mysql.init: Loading 49turba_migrate_contacts into mysql succeeded
Nov 24 23:05:10 mail mysql.init: Loading 50horde-2.2_to_3.0 into mysql succeeded
Nov 24 23:05:10 mail mysql.init: Loading 50turba_upgrade into mysql succeeded
Nov 24 23:05:10 mail mysql.init: Loading 55horde-3.0_to_3.1 into mysql succeeded
Nov 24 23:05:10 mail 56horde-3.1_alter_table: /etc/e-smith/sql/init/56horde-3.1_alter_table: line 2: /etc/e-smith/events/actions/horde_alter_table: No such file or directory
Nov 24 23:05:10 mail 56horde-3.1_alter_table: /etc/e-smith/sql/init/56horde-3.1_alter_table: line 2: exec: /etc/e-smith/events/actions/horde_alter_table: cannot execute: No such file or directory
Nov 24 23:05:10 mail mysql.init: Loading 56horde-3.1_alter_table into mysql failed
Nov 24 23:05:11 mail mysql.init: Loading 57turba_mysql_reset_addressbook_pref into mysql succeeded
Nov 24 23:05:11 mail mysql.init: Loading 60migrate-imp-to-turba into mysql succeeded
Nov 24 23:05:11 mail mysql.init: Loading 77horde_mysql_update_privs into mysql succeeded
Nov 24 23:05:11 mail mysql.init: Loading 78mysql.create.ingo into mysql succeeded
Nov 24 23:05:12 mail mysql.init: Loading 79ingo_upgrade into mysql succeeded
Nov 24 23:05:12 mail mysql.init: Loading 84mysql.create.kronolith into mysql succeeded
Nov 24 23:05:12 mail mysql.init: Loading 85kronolith_upgrade into mysql succeeded
Nov 24 23:05:13 mail esmith::event[5310]: Processing event: local 
Nov 24 23:05:13 mail esmith::event[5310]: Running event handler: /etc/e-smith/events/actions/generic_template_expand
Nov 24 23:05:13 mail esmith::event[5310]: expanding /etc/sysconfig/kernel 
Nov 24 23:05:13 mail esmith::event[5310]: expanding /boot/grub/grub.conf 
Thanks

[runded]

Ok, I found this was something silly and something I should have known. Each user has to go into their address book options and choose to have the local LDAP setup as their default to display.  Is there a way to set this up so that it is done for everyone?

Thanks in advance,
Doug

[cactus]

Ok, I found this was something silly and something I should have known. Each user has to go into their address book options and choose to have the local LDAP setup as their default to display.  Is there a way to set this up so that it is done for everyone?

I don't know, but I suggest you launch a bug for that.

[runded]

Done: http://bugs.contribs.org/show_bug.cgi?id=4819

I was reading up on this: http://forums.contribs.org/index.php/topic,41781.0.html

Is there something I can do with my preference to create a custom template. I have never done a custom template before.

Doug

[cactus]

Done: http://bugs.contribs.org/show_bug.cgi?id=4819

I was reading up on this: http://forums.contribs.org/index.php/topic,41781.0.html

Is there something I can do with my preference to create a custom template. I have never done a custom template before.

Doug

The template fragments are usually split up in sections, the base line is that you create a copy of the directory tree for that fragment (in /etc/e-smith/templates-custom/) similar to the one in the original template tree (/etc/e-smith/templates/). You copy the original fragment there and make the modifications to this copy.

After making the modifications you can expand (regenerate) the configuration file and most of the times you need to reload the services that are affected by the file (for instance when they are run as a deamon on the server).

You can read much more on the template system in the SME Server Development Guide that is linked from the wiki.

If you need help you can post a new thread in the forums, but try to be specific so we can help and guide you through it.