General discussion on installation and configuration of SOGo

Text archives Help


[SOGo] Using SOGo as a room/resource booking system


Chronological Thread 
  • From: "\"Siegfried Kurz\"" ( ) < >
  • To: < >
  • Subject: [SOGo] Using SOGo as a room/resource booking system
  • Date: Tue, 8 Aug 2017 11:33:54 +0200
  • Dmarc-filter: OpenDMARC Filter v1.2.0 mail.inverse.ca 1F590F029EA


Hello,

at the moment we try to evaluate SOGo Version 2.3.22 on Ubuntu 16.04.3 LTS.

We are looking for a replacement for mrbs (Meeting Boom Booking System),
and at the moment, we only need the calandar-part of SOGo.

For simplicity, at the moment we are using mysql-user-authentification.

We followed the steps given in http://wiki.sogo.nu/ResourceConfiguration,
especially the part "Configure resources with SQL databases"


Especially we did create the user room1:
.....
INSERT INTO sogo_users(c_uid, c_name, c_password, c_cn, mail, kind,
multiple_bookings) VALUES ('room1', 'room1', MD5('room1'), 'Meeting room1',
' ',
'location', 1);
.....

But It doesn't work as we expected.

For our configuration see below.

What we expected was:
The user room1 logs into SOGo.
In each of the calendars of room1, only one appointment at a time can be
created.
This means, the situation in the Image SOGo-Overbooking.jpg attached should
not be possible.
I expected, when trying to occupy the resource a second time, an error
message would be generated.


My questions are:

- Is there a problem with our configuration?
- Or do SOGo resources not work like described above?



Our config:

mysql> select * from sogo_users;
| c_uid | c_name | c_password | c_cn | mail
| kind | multiple_bookings |
+-------+--------+----------------------------------+----------------+------
-------------+----------+-------------------+
| room1 | room1 | 3ccabb59915d2d79c7f377fd9d35f9f4 | Meeting room1 |

| location | 1 |
+-------+--------+----------------------------------+----------------+------
-------------+----------+-------------------+

for /etc/sogo/sogo.conf, see attached file sogo.conf.txt

Best regards
Siegfried

-





{
/* Database configuration mysql: */
SOGoProfileURL = "mysql://sogo:sogo@localhost:3306/sogo/sogo_user_profile";
OCSFolderInfoURL = "mysql://sogo:sogo@localhost:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder";

SOGoSuperUsernames = ( "bene", "sogo", "fil01" ) ;
SOGoLoginModule = Calendar ;
SOGoVacationEnabled = YES ;
SOGoFirstDayOfWeek = 1 ;
SOGoTrustProxyAuthentication = YES ;
WOWorkersCount = 6 ;

/* Mail */
SOGoDraftsFolderName = Drafts;
SOGoSentFolderName = Sent;
SOGoTrashFolderName = Trash;
SOGoIMAPServer = localhost;
SOGoSieveScriptsEnabled = YES ;
SOGoSieveServer = sieve://127.0.0.1:4190;
SOGoSMTPServer = 127.0.0.1;
SOGoMailDomain = acme.com;
SOGoMailingMechanism = smtp;
SOGoForceExternalLoginWithEmail = NO;
SOGoMailSpoolPath = /var/spool/sogo;
NGImap4ConnectionStringSeparator = "/";

/* Notifications */
//SOGoAppointmentSendEMailNotifications = NO;
//SOGoACLsSendEMailNotifications = NO;
//SOGoFoldersSendEMailNotifications = NO;

SOGoUserSources =
(
{
canAuthenticate = YES;
displayName = "SOGo Users";
type = sql;
id = users;
viewURL = "mysql://sogo:sogo@127.0.0.1:3306/sogo/sogo_users";
isAddressBook = YES;
userPasswordAlgorithm = md5;
KindFieldName = kind;
MultipleBookingsFieldName = multiple_bookings;
}
);

/* Web Interface */


/* General - SOGoTimeZone *MUST* be defined */
SOGoLanguage = English;
SOGoTimeZone = Europe/Berlin;
SOGoCalendarDefaultRoles = (
PublicDAndTViewer,
ConfidentialDAndTViewer,
PrivateDAndTViewer
);
//SxVMemLimit = 384;
//WOPidFile = "/var/run/sogo/sogo.pid";
//SOGoMemcachedHost = "/var/run/memcached.sock";

/* Debug */
SOGoDebugRequests = YES;
SoDebugBaseURL = YES;
ImapDebugEnabled = YES;
//LDAPDebugEnabled = YES;
//PGDebugEnabled = YES;
MySQL4DebugEnabled = YES;
SOGoUIxDebugEnabled = YES;
//WODontZipResponse = YES;
//WOLogFile = /var/log/sogo/sogo.log;
}

Attachment: SOGo-Overbooking.jpg
Description: JPEG image




Archive powered by MHonArc 2.6.18.

Top of page