[SOGo] Getting IMAP Password from database.
I have managed to set up our Sogo installation with shibboleth authentication by using the RequestHeader set x-webobjects-remote-user in the Apache config. Unfortunately it now doesn't use the password set in the mysql sogo_auth_user table to connect to the main IMAP server. My main question is: Can sogo somehow take the password of the user matched to the x-webobjects-remote-user request header and use that to log in to the imap server. Or is it somehow possible that the password gets set in a similar method as the username via an apache request header. if I set SOGoMailAuxiliaryUserAccountsEnabled it does save the user details in the mysql DB (sogo_user_profile) table for any additional accounts, would it maybe be possible to set default imap account here if sogo_auth_users is only meant for user authentication into sogo. Please do let me know if I have overlooked something completely which already does any of the above. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] caldav and carddav failing since upgrade to 1.3.7
On Tue, May 31, 2011 at 10:21 AM, Mark Adams m...@campbell-lange.net wrote: When I was on 4.3.1 I had to just disable/enable the account once to get things syncing again. I have other people on iPhones that didn't have to do that though, so put it down to something dodgy with my phone. Looks like there were a few issues that came up just after I upgraded our SOGo server. A user with an older iPod Touch 2G running iOS 4.2.1 deleted the calDav account and tried to set up a new calDav account. It would validate the account but none of the calendars were displayed in the Calendar app (it was set to sync All Events). Downgrading the Touch to 4.1 got things working correctly. A couple of new iPhone users were populating the Notes field for contacts in their Thunderbird address books. If the Notes field had multiple lines the sync process would fail on those entries and on the iPhone it caused the Contact app to close unexpectedly. Trimming the Notes fields to a single line fixed that problem. Another iPhone user was adding large photos to their Contacts and this caused the sync process to fail. Reducing the size of the photos or removing them fixed that problem. Thanks, Bill C. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Automatic Address Book Synchronization with Thunderbird
Is there a way that Thunderbird can synchronize its SOGo address books periodically instead of manually, similar to how calendars have a refresh interval? -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] LDAP missing fields
We have SOGo connected to a LDAP source for addresses. Our problem is SOGo is not receiving all LDAP fields. In particular fields related to a home address (mozillahomestate, mozillahomestreet, mozillahomepostalcode, etc...). We can see the LDAP query on the LDAP server and it includes these fields. Do we need to specify what fields we need returned from the LDAP server? -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Wrong SQL configuration hidden somewhere...
Hello, There are some errors in my log dealing with my database access that only popups from time to time. Here's an example from a sogo-tool check: $ /usr/local/sbin/sogo-tool check-doubles The warning limit for folder records is set at 1000 2011-06-07 23:29:34.356 sogo-tool[30903] ERROR: could not open MySQL4 connection to database 'sogo': Can't connect to MySQL server on 'luuna.tumfatig.net' (60) 0x0x2029d47d0[GCSChannelManager] could not open channel MySQL4Channel[0x0x2093ef590] connection=0x(null) for URL: mysql://login:passw...@luuna.tumfatig.net:3306/sogo/sogousername0014b4e7f99 0x0x2029d47d0[GCSChannelManager] will prevent opening of this channel 5 seconds after 2011-06-07 23:28:19 +0200 The thing is luuna.tumfatig.net is the old database hostname. The DB is now located on localhost, luuna is shutdown and every reference to it has been removed from the configuration file: $ grep -i sql GNUstep/Defaults/.GNUstepDefaults OCSEMailAlarmsFolderURL = mysql://login:password@localhost:3306/sogo/sogo_alarms_folder; OCSFolderInfoURL = mysql://login:password@localhost:3306/sogo/sogo_folder_info; OCSSessionsFolderURL = mysql://login:password@localhost:3306/sogo/sogo_sessions_folder; SOGoProfileURL = mysql://login:password@localhost:3306/sogo/sogo_user_profile; I've dumped the sogo database and grep it to find any reference to the old hostname but found nothing. Would there be some cache somewhere that I could clear ? (Of course, sogod have be restarted. The server has even been restarted twice :) TIA, Jo-- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Delete users from database
Hi, I missed an utility in SOGo for delete the users from the database (for
example, if a user-account gets corrupted, or a user leaves a company, etc).
That's why I created a simple python script that I share with you. For run it,
MySQLdb module for python needs to be installed.
Caution! That script have been tested only with sogo 1.3.7!
#!/usr/bin/python
# By: Alan Bover Argelaga
import MySQLdb
usage = \n Help: \n user list \t \t \t list the users in the database \n user
delete user \t \t Delete user from the database \n exit \t \t \t \t Exit the
script \n
def user(action):
def user_delete(user):
global db
cursor = db.cursor()
cursor.execute( SELECT c_location, c_quick_location,
c_acl_location FROM sogo_folder_info WHERE c_path2 = %s, (user,))
if cursor.rowcount 0:
result=cursor.fetchall()
for user_tables in result:
user_tables_for_delete =
[user_tables[0].partition('sogo/')[2],user_tables[1].partition('sogo/')[2],user_tables[2].partition('sogo/')[2]]
for user_table_for_delete in
user_tables_for_delete:
cursor.execute(DROP TABLE IF EXISTS
+ user_table_for_delete)
cursor.execute(DELETE FROM sogo_user_profile WHERE
c_uid = %s, (user,))
cursor.execute(DELETE FROM sogo_folder_info WHERE
c_path2 = %s, (user,))
print User + user + has been deleted
else:
print User + user + cannot be found in database
def user_list():
global db
cursor = db.cursor()
cursor.execute(SELECT c_uid FROM sogo_user_profile;)
result=cursor.fetchall()
for existing_user in result:
print existing_user[0]
def user_help():
global usage
print %s % usage
action_func = { delete: user_delete,
list: user_list }
order = action.partition( )
if order[0] == delete:
action_func[order[0]](order[2])
elif order[0] == list:
action_func[order[0]]()
else:
user_help()
def quit():
print quit
exit = False
try:
databaseuser = raw_input(Database user: )
database = raw_input(Database name: )
password = raw_input(Database password: )
db =
MySQLdb.connect(host='localhost',user=databaseuser,passwd=password,db=database)
except MySQLdb.Error, e:
print Database conection error
print e.args[1]
exit = True
while not exit:
entrada = raw_input( )
order = entrada.partition( )
if order[0] == user:
user(order[2])
else:
if entrada == exit:
exit = True
else :
print %s % usage
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] Delete users from database
Sorry, I realized that the code here lose the format. You can acces it on: http://pastebin.com/SLKgxJDS -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Tuesday, June 07 2011
Title: BTS activities for Tuesday, June 07 2011 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Tuesday, June 07 2011 idlast updatestatus (resolution)categorysummary 1322 2011-06-07 06:20:26 updated (open) Web Calendar Comma or minus in title prevents syncing to iCal / iPhone 1329 2011-06-07 07:16:11 updated (open) Web Calendar The web calendar doesn't show correctly the all day events 1332 2011-06-07 13:44:45 closed (fixed) Apple iCal.app iCal change name of calendar doesnt work for subscribed users
Re: [SOGo] Wrong SQL configuration hidden somewhere...
Le 8 juin 2011 à 02:44, Ludovic Marcotte a écrit : On 07/06/11 17:46, Joel Carnat wrote: Would there be some cache somewhere that I could clear ? You have broken entries in the sogo_folder_info table - fix it. quite a lot in fact :-/ is there a way to scan for such errors ? or the best bet is to backup/restore using sogo-tool and flush/recreate the database ? Thanks! Jo -- users@sogo.nu https://inverse.ca/sogo/lists
