Hello all, I've just finished installing the latest version of Sogo on Debian Squeeze. I've choosen mysql for the database, and want to use mysql for authentication. Here is my .GNUstepDefaults file:
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//GNUstep//DTD plist 0.9//EN" "http://www.gnustep.org/plist-0_9.xml";> <plist version="0.9"> <dict> <key>NSGlobalDomain</key> <dict> </dict> <key>sogod</key> <dict> <key>OCSFolderInfoURL</key> <string>mysql://sogo:sogo@localhost:3306/sogo/sogo_folder_info</string> <key>OCSSessionsFolderURL</key> <string>mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder</string> <key>SOGoACLsSendEMailNotifications</key> <string>YES</string> <key>SOGoAppointmentSendEMailNotifications</key> <string>YES</string> <key>SOGoFoldersSendEMailNotifications</key> <string>YES</string> <key>SOGoLanguage</key> <string>French</string> <key>SOGoMailDomain</key> <string>rd4-was7.com</string> <key>SOGoMailingMechanism</key> <string>smtp</string> <key>SOGoProfileURL</key> <string>mysql://sogo:sogo@localhost:3306/sogo/sogo_user_profile</string> <key>SOGoSMTPServer</key> <string>localhost</string> <key>SOGoTimeZone</key> <string>Europe/Paris</string> <key>SOGoUserSources</key> <array> <dict> <key>canAuthenticate</key> <string>YES</string> <key>id</key> <string>directory</string> <key>isAddressBook</key> <string>YES</string> <key>type</key> <string>sql</string> <key>userPasswordAlgorithm</key> <string>plain-text</string> <key>viewURL</key> <string>mysql://sogo:[email protected]:3306/sogo/sogo_view</string> </dict> </array> </dict> </dict> </plist> The install of Sogo seems to be fine, the server starts up and the installation of Mysql with regards to sogo seems to be successful, as I have a database with three tables: sogo_folder_info, sogo_sessions_folder and sogo_user_profile. I'm trying to add the Admin user and a regular user, and I'm stuck. There doesn't seem to be a sogo_view table, which seems to be logical given the other DB options added and their corresponding tables in the DB. Also, the other tables don't have enough fields to make me think they're relevant for adding users. The documentation shows how to add users using LDAP, but nothing on SQL. How do I do this? Is there something I'm missing? Thanks..... Bien cordialement, [cid:[email protected]]<http://www.e-deal.com/> Brian KREULEN Ingénieur Senior R&D 41, rue Périer 92120 Montrouge www.e-deal.com<http://www.e-deal.com/> Blog CRM<http://blog-crm.e-deal.com/> Tél : +33 1 73 03 29 80 Fax : +33 1 73 01 69 77 [email protected]<mailto:[email protected]> ________________________________ Pensez environnement ! N'imprimez ce mail que si c'est vraiment nécessaire. Please consider your environmental responsibility before printing this e-mail.
<<inline: image001.png>>
