1 Topic by aayllon

  • aayllon
  • Member
  • Offline
  • Registered: 2015-01-15
  • Posts: 3

Topic: Sogo errors "addressbook source 'vmail_mailbox' has no displayname"

============ Required information ====
- iRedMail version:  iRedMail-0.9.0
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  MySQL
- Linux/BSD distribution name and version: Ubuntu 14.04
- Related log if you're reporting an issue: sogo.log
====

Hello, recently I installed iRedmail in a Ubuntu 14.04 LTS server, I'm using Sogo as webmail and MySQL as backend, I don't know why but after restart Sogo, in solo.log appear the next error;


Jan 15 15:03:59 sogod [3772]: [ERROR] <0x0x7f15fca12258[SOGoUserManager]> addressbook source 'vmail_mailbox' has no displayname


I tried to find some information about it, but i didn't find anything that explain what is wrong in SOgo.

Here the log section that contains the error after restart Sogo.

Jan 15 11:06:12 sogod [3763]: <0x0x7f15fca17078[WOWatchDog]> child spawned with pid 3771
Jan 15 11:06:12 sogod [3763]: <0x0x7f15fca17078[WOWatchDog]> child spawned with pid 3772
Jan 15 11:06:12 sogod [3763]: <0x0x7f15fca17078[WOWatchDog]> child spawned with pid 3774
Jan 15 11:06:12 sogod [3763]: <0x0x7f15fca17078[WOWatchDog]> child spawned with pid 3775
Jan 15 15:03:59 sogod [3772]: <0x0x7f15fca99088[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
Jan 15 15:03:59 sogod [3772]: <0x0x7f15fca99088[SOGoCache]> Using host(s) 'memcache01' as server(s)
Jan 15 15:03:59 sogod [3772]: [ERROR] <0x0x7f15fca12258[SOGoUserManager]> addressbook source 'vmail_mailbox' has no displayname
2015-01-15 15:03:59.934 sogod[3772] -[WEClientCapabilities initWithRequest:]: Unknown WebClient: user-agent='SAMSUNG-GT-I9505/101.40402'
2015-01-15 15:03:59.935 sogod[3772] Note(SoObject): SoDebugKeyLookup is enabled!
2015-01-15 15:03:59.935 sogod[3772] Note(SoObject): SoDebugBaseURL is enabled!
2015-01-15 15:03:59.935 sogod[3772] Note(SoObject): relative base URLs are enabled.
2015-01-15 15:03:59.942 sogod[3772] Note: Using UTF-8 as URL encoding in NGExtensions.
2015-01-15 15:03:59.948 sogod[3772] Sleeping 10 seconds while detecting changes...
2015-01-15 15:04:09.954 sogod[3772] Sleeping 10 seconds while detecting changes...
2015-01-15 15:04:19.958 sogod[3772] Sleeping 10 seconds while detecting changes...

I executed the command sogo-tool dump-defaults, and and I saw that my server has the next config related to "vmail_mailbox":

    SOGoUserSources = (
        {
            canAuthenticate = YES;
            id = "vmail_mailbox";
            isAddressBook = YES;
            prependPasswordScheme = YES;
            type = sql;
            userPasswordAlgorithm = ssha;
            viewURL = "mysql://sogo:b8FPs3hl8Ch5cgmAg3xyjMwwHOigqa@dbdev:3306/sogo/users";
        }
    );

In my MySQL server ther are not any table call user, into sogo database, Is this why these errors appear?


Please, could anyone explain me what these errors means?

Thanks,

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by 7t3chguy (edited by 7t3chguy 2015-01-15 23:36:15)

  • 7t3chguy
  • 7t3chguy
  • Forum Moderator
  • Offline
  • From: United Kingdom
  • Registered: 2015-01-08
  • Posts: 713

Re: Sogo errors "addressbook source 'vmail_mailbox' has no displayname"

There isn't a table users, its a MySQL View into the vmail database. Plus look below for the "fix":

SOGoUserSources = (
        {
            type = sql;
            id = vmail_mailbox;
            viewURL = "mysql://sogo:password@127.0.0.1:3306/sogo/users";
            canAuthenticate = YES;

            // Default algorithm used when changing passwords.
            userPasswordAlgorithm = ssha;
            prependPasswordScheme = YES;
    
            // Use vmail.mailbox as global address book.
            // WARNING: This will search all user accounts, not just accounts
            // under same domain as login user.
            isAddressBook = YES;
            displayName = "Global Address Book";
        }
    );

7t3chguy's Website

3 Reply by aayllon

  • aayllon
  • Member
  • Offline
  • Registered: 2015-01-15
  • Posts: 3

Re: Sogo errors "addressbook source 'vmail_mailbox' has no displayname"

Thank you for your time and for your quick answer.

It works fine, error message doesn't appear any more.