| | 262 | |
| | 263 | {{{ |
| | 264 | |
| | 265 | > Hi Mirek, |
| | 266 | > |
| | 267 | > here what you will need to do is to create a VIEW on your PostgreSQL |
| | 268 | > database that Sogo will access. In my case (MySQL) the create view |
| | 269 | > command is: |
| | 270 | > |
| | 271 | > create or replace view sogo as select domain, email as mail, email |
| | 272 | > as c_uid, email as c_mail, email as c_name, password as c_password, |
| | 273 | > name as c_cn from accounts; |
| | 274 | > |
| | 275 | > Then, on my sogo.conf I have: |
| | 276 | > SOGoUserSources = |
| | 277 | > ( |
| | 278 | > { |
| | 279 | > type = sql; |
| | 280 | > id = publicmav; |
| | 281 | > viewURL = "mysql://user:password@hostname/database/sogo"; |
| | 282 | > canAuthenticate = YES; |
| | 283 | > isAddressBook = YES; |
| | 284 | > userPasswordAlgorithm = crypt; |
| | 285 | > displayName = "Global"; |
| | 286 | > DomainFieldName = "domain"; |
| | 287 | > } |
| | 288 | > ); |
| | 289 | > |
| | 290 | > I recommend that you read the installation guide, there are a lot of |
| | 291 | > important parameters for you sogo.conf file that you need to |
| | 292 | > understand: |
| | 293 | > http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf . |
| | 294 | > |
| | 295 | > Best, |
| | 296 | > Daniel Colchete |
| | 297 | > |
| | 298 | > On Wed, Jul 1, 2015 at 1:48 PM, Mirek <miroslaw@slawinski.net.pl |
| | 299 | > <mailto:miroslaw@slawinski.net.pl>> wrote: |
| | 300 | > |
| | 301 | > Hi. |
| | 302 | > |
| | 303 | > I have already installed Postfix and Dovecot supported with PostgreSQL |
| | 304 | > database. In my DB i keep users, domain and aliases. Now i want to |
| | 305 | > add SOGo |
| | 306 | > but i have a problem with users because i don't want create new |
| | 307 | > database and |
| | 308 | > tables for sogo but use my previouse DB with my users. Can I |
| | 309 | > connect SOGo to |
| | 310 | > another database ? and can I create own SELECT scripts ? |
| | 311 | > |
| | 312 | > Best regards |
| | 313 | > Mirek |
| | 314 | > -- |
| | 315 | > users@sogo.nu <mailto:users@sogo.nu> |
| | 316 | > https://inverse.ca/sogo/lists |
| | 317 | > |
| | 318 | > |
| | 319 | |
| | 320 | }}} |
| | 321 | |
