General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] Failed logins with DCERPC calls in 'smb.conf'


Chronological Thread 
  • From: Steve Ankeny < >
  • To:
  • Subject: Re: [SOGo] Failed logins with DCERPC calls in 'smb.conf'
  • Date: Sat, 01 Aug 2015 16:00:37 -0400

On 08/01/2015 03:28 PM, Steve Ankeny wrote:

I can login to MariaDB as 'openchange-user' with its password but I'm unsure if the configuration is right.

Do I need to reprovision OpenChange?  What are the issues with reprovisioning OpenChange?

Thanks for any suggestions.  I'll look at the database next.


The database appears to be populated correctly --

MariaDB [openchange]> show tables;
+------------------------------+
| Tables_in_openchange         |
+------------------------------+
| company                              |
| folders                                  |
| folders_properties                |
| mailboxes                             |
| mailboxes_properties           |
| mapistore_indexes               |
| mapistore_indexing              |
| messages                             |
| messages_properties           |
| migrations                            |
| named_properties                |
| organizational_units             |
| provisioning_folders             |
| provisioning_special_folders |
| public_folders                       |
| servers                                 |
+------------------------------+
16 rows in set (0.00 sec)

MariaDB [openchange]> select * from company;
+----+-------------+
| id | domain      |
+----+-------------+
|  1 | MEADORANDCO |
+----+-------------+
1 row in set (0.00 sec)

MariaDB [openchange]> select * from folders;
+----+-------+--------------------+--------------+------------+------------------+------------+-----------+--------------+
| id | ou_id | folder_id          | folder_class | mailbox_id | parent_folder_id | FolderType | SystemIdx | MAPIStoreURI |
+----+-------+--------------------+--------------+------------+------------------+------------+-----------+--------------+
|  1 |     1 |  72057594037927937 | public       |       NULL |             NULL |          1 |         1 | NULL         |
|  2 |     1 | 144115188075855873 | public       |       NULL |                1 |          1 |         2 | NULL         |
|  3 |     1 | 216172782113783809 | public       |       NULL |                1 |          1 |         3 | NULL         |
|  4 |     1 | 288230376151711745 | public       |       NULL |                3 |          1 |         4 | NULL         |
|  5 |     1 | 360287970189639681 | public       |       NULL |                3 |          1 |         6 | NULL         |
|  6 |     1 | 432345564227567617 | public       |       NULL |                5 |          1 |         9 | NULL         |
|  7 |     1 | 504403158265495553 | public       |       NULL |                3 |          1 |         5 | NULL         |
|  8 |     1 | 576460752303423489 | public       |       NULL |                7 |          1 |         8 | NULL         |
|  9 |     1 | 648518346341351425 | public       |       NULL |                3 |          1 |        -1 | NULL         |
+----+-------+--------------------+--------------+------------+------------------+------------+-----------+--------------+
9 rows in set (0.00 sec)

MariaDB [openchange]> select * from folders_properties;  (last portion)

........................................................................................................
|         8 | PidTagContainerClass       | IPF.Note (check this)                                                                |
|         9 | PidTagFolderChildCount     | 0                                                                                             |
|         9 | PidTagChangeNumber         | 648518346341351425                                                         |
|         9 | PidTagDisplayName          | Events Root                                                                             |
|         9 | PidTagCreationTime         | 130638215080000000                                                            |
|         9 | PidTagLastModificationTime | 130638215080000000                                                        |
|         9 | PidTagSubFolders           | FALSE                                                                                         |
|         9 | PidTagAttributeHidden      | 0                                                                                              |
|         9 | PidTagAttributeReadOnly    | 0                                                                                            |
|         9 | PidTagAttributeSystem      | 0                                                                                             |
|         9 | PidTagContainerClass       | IPF.Note (check this)                                                                |
+-----------+----------------------------+----------------------------------------------------------------------------+
86 rows in set (0.00 sec)

MariaDB [openchange]> select * from mailboxes;
Empty set (0.00 sec)

MariaDB [openchange]> select * from mailboxes_properties;
Empty set (0.00 sec)

MariaDB [openchange]> select * from mapistore_indexes;
+----+----------+-----------+
| id | username | next_fmid |
+----+----------+-----------+
|  1 | michael  | 1090      |                    (only one Outlook user)
+----+----------+-----------+
1 row in set (0.00 sec)

MariaDB [openchange]> select * from mapistore_indexing;
+----+----------+---------------------+--------------------------------------------------------------------------+--------------+
| id | username | fmid                | url                                                                      | soft_deleted |
+----+----------+---------------------+--------------------------------------------------------------------------+--------------+
|  1 | michael  | 289356276058554369  | sogo://michael@fallback/0x304000000000001/1856-55B37C00-1-506A3900.plist | 0            |
|  2 | michael  | 361413870096482305  | sogo://michael@fallback/0x304000000000001/                               | 0            |
|  3 | michael  | 2451084097196392449 | sogo://michael@fallback/0x2104000000000001/66D-55B62500-1-76E14280.plist | 0            |
|  4 | michael  | 2523141691234320385 | sogo://michael@fallback/0x2104000000000001/                              | 0            |
|  5 | michael  | 4612811918334230529 | sogo://michael@fallback/0x3f04000000000001/66B-55B8D580-1-12208160.plist | 0            |
|  6 | michael  | 4684869512372158465 | sogo://michael@fallback/0x3f04000000000001/                              | 0            |
+----+----------+---------------------+--------------------------------------------------------------------------+--------------+
6 rows in set (0.00 sec)

MariaDB [openchange]> select * from messages;
Empty set (0.00 sec)

MariaDB [openchange]> select * from messages_properties;
Empty set (0.00 sec)

MariaDB [openchange]> select * from migrations;
+------------------+---------+---------------------+
| app              | version | applied             |
+------------------+---------+---------------------+
| indexing         |       1 | 2015-07-25 08:07:35 |
| indexing         |       2 | 2015-07-25 08:07:36 |
| named_properties |       1 | 2015-07-25 08:06:58 |
+------------------+---------+---------------------+
3 rows in set (0.00 sec)

MariaDB [openchange]> select * from named_properties;  (last portion)

........................................................................................................
| 700 |    1 |        1 | 00020329-0000-0000-c000-000000000046 |    38383 |      0 | http://schemas.microsoft.com/exchange/wcviewwidth                | NULL                         | PidNameWcviewwidth                              |
| 701 |    1 |        1 | 00020329-0000-0000-c000-000000000046 |    38384 |      0 | http://schemas.microsoft.com/exchange/wcviewheight               | NULL                         | PidNameWcviewheight                             |
| 702 |    1 |        1 | 00020329-0000-0000-c000-000000000046 |    38385 |      0 | http://schemas.microsoft.com/exchange/preview                    | NULL                         | PidNamePreview                                  |
| 703 |    1 |        1 | 00020329-0000-0000-c000-000000000046 |    38386 |      0 | http://schemas.microsoft.com/exchange/webclientlastusedsortcols  | NULL                         | PidNameWebclientlastusedsortcols                |
| 704 |    0 |        1 | 11000e07-b51b-40d6-af21-caa85edab1d0 |    38387 |  34265 | NULL                                                             | LID_UNKNOWN_PROPERTY_85d9    | PidLidUnknownProperty85d9                       |
| 705 |    1 |        1 | 02200600-0000-0000-c000-000000000046 |    38391 |      0 | TimeZone                                                         | NULL                         | PidNameTimeZone                                 |
+-----+------+----------+--------------------------------------+----------+--------+------------------------------------------------------------------+------------------------------+-------------------------------------------------+
705 rows in set (0.01 sec)

MariaDB [openchange]> select * from organizational_units;
+----+------------+--------------------+----------------------------+
| id | company_id | organization       | administrative_group       |
+----+------------+--------------------+----------------------------+
|  1 |          1 | First Organization | First Administrative Group |
+----+------------+--------------------+----------------------------+
1 row in set (0.00 sec)

MariaDB [openchange]> select * from provisioning_folders;
+--------+------------------------+-----------------+---------------+--------------+----------+--------+-------+-----------+-----------+-------+-------------------------+--------------------------+-------+--------+------------+---------------+
| locale | mailbox                | deferred_action | spooler_queue | common_views | schedule | finder | views | shortcuts | reminders | todo  | tracked_mail_processing | top_info_store           | inbox | outbox | sent_items | deleted_items |
+--------+------------------------+-----------------+---------------+--------------+----------+--------+-------+-----------+-----------+-------+-------------------------+--------------------------+-------+--------+------------+---------------+
| en     | OpenChange Mailbox: %s | Deferred Action | Spooler Queue | Common Views | Schedule | Finder | Views | Shortcuts | Reminders | To-Do | Tracked Mail Processing | Top of Information Store | Inbox | Outbox | Sent Items | Deleted Items |
+--------+------------------------+-----------------+---------------+--------------+----------+--------+-------+-----------+-----------+-------+-------------------------+--------------------------+-------+--------+------------+---------------+
1 row in set (0.00 sec)

MariaDB [openchange]> select * from provisioning_special_folders;
+--------+--------+----------+----------+-------+-------+---------+
| locale | drafts | calendar | contacts | tasks | notes | journal |
+--------+--------+----------+----------+-------+-------+---------+
| en     | Drafts | Calendar | Contacts | Tasks | Notes | Journal |
+--------+--------+----------+----------+-------+-------+---------+
1 row in set (0.00 sec)

MariaDB [openchange]> select * from public_folders;
+-------+-----------+--------------------------------------+
| ou_id | ReplicaID | StoreGUID                            |
+-------+-----------+--------------------------------------+
|     1 |         1 | 07b06de2-525f-4998-a2ed-e2147e2f768b |
+-------+-----------+--------------------------------------+
1 row in set (0.18 sec)

MariaDB [openchange]> select * from servers;
+----+------------+------------+---------------+
| id | company_id | replica_id | change_number |
+----+------------+------------+---------------+
|  1 |          1 |          1 |            10 |
+----+------------+------------+---------------+
1 row in set (0.00 sec)


I see nothing out-of-line with the database provisioning.

The only "real" error I see is the issue with 'exchange_emsmdb'

What would cause this "dcerpc" call to fail?





Archive powered by MHonArc 2.6.18.

Top of page