Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: Henry on February 08, 2004, 08:48:28 PM

Title: webmail address book problems
Post by: Henry on February 08, 2004, 08:48:28 PM

I can't seem to add addresses to the webmail address book. I get a generic error message and a suggestion to contact my admin.

Happens from both the internal network and remotly from the internet.

I'm using 6.0 b3 with all updates.

Any ideas?

Title: webmail address book problems
Post by: DanB35 on February 17, 2004, 05:27:01 PM

What, exactly, is the "generic error message"?

Title: Addressbook
Post by: kmcelwain on February 17, 2004, 07:06:24 PM

Having this same problem.  Thought I licked it with the password connecting to mySQL, fixed it and now IMP works but turba is still having a problem.

Do you have any idea where the username and password that turba uses is setup.

I know what it needs to be changed to I just have no idea where it is.

Title: AddressBook
Post by: kmcelwain on February 17, 2004, 07:30:12 PM

Figured it out, and man was I like...duh.

The problem was the field names changed for turba after the upgrade but they didn't change in mySQL.

Ran the script through phpmyadmin and it works like a charm.

Just in case here it is.

Make sure you have the horde database selected when you run this.

ALTER TABLE turba_objects CHANGE object_homeAddress object_homeaddress VARCHAR(255);

ALTER TABLE turba_objects CHANGE object_workAddress object_workaddress VARCHAR(255);

ALTER TABLE turba_objects CHANGE object_homePhone object_homephone VARCHAR(25);

ALTER TABLE turba_objects CHANGE object_workPhone object_workphone VARCHAR(25);

ALTER TABLE turba_objects CHANGE object_cellPhone object_cellphone VARCHAR(25);

ALTER TABLE turba_objects MODIFY object_title VARCHAR(255);

ALTER TABLE turba_objects MODIFY object_company VARCHAR(255);

ALTER TABLE turba_objects ADD object_type VARCHAR(255) NOT NULL DEFAULT 'Object';

ALTER TABLE turba_objects ADD object_members BLOB;

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);

Title: webmail address book problems
Post by: Henry on February 18, 2004, 01:58:59 AM

Can you be a bit more low level for me? I don't know what the phpadmin stuff is?

Title: webmail address book problems
Post by: ergozd on February 19, 2004, 08:22:53 PM

PhpMyAdmin - is a tool to handle MySQL databeses. You can find more info at http://phpmyadmin.net

1 - Install phpmyadmin contrib from
http://mirror.contribs.org/smeserver/contribs/nightspirit/

2 - Access phpmyadmin by typing
https://your-sme-ip-adress/phpmyadmin

login with admin and password

3 - choose database horde on the left
click on SQL and run script below (you can cut and paste)

ALTER TABLE turba_objects CHANGE object_homeAddress object_homeaddress VARCHAR(255);

ALTER TABLE turba_objects CHANGE object_workAddress object_workaddress VARCHAR(255);

ALTER TABLE turba_objects CHANGE object_homePhone object_homephone VARCHAR(25);

ALTER TABLE turba_objects CHANGE object_workPhone object_workphone VARCHAR(25);

ALTER TABLE turba_objects CHANGE object_cellPhone object_cellphone VARCHAR(25);

ALTER TABLE turba_objects MODIFY object_title VARCHAR(255);

ALTER TABLE turba_objects MODIFY object_company VARCHAR(255);

ALTER TABLE turba_objects ADD object_type VARCHAR(255) NOT NULL DEFAULT 'Object';

ALTER TABLE turba_objects ADD object_members BLOB;

CREATE INDEX turba_owner_idx ON turba_objects (owner_id);
 
 
Good luck.