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?**
*
--
[email protected]
https://inverse.ca/sogo/lists
