Mysql - No User ID's in Sharing Screen

Been syncing 2 PC's with Google calendars (Only one calendar between 2 pc's) and wanted to move to my own server - keep data private.

So under FreeNAS 11, I'm running MariaDB (V10) (Mysql) in a jail - all works fine.

Using eidiSQL, I created 2 users (SES and LSD) and gave both full control (For the moment anyway) to the who MYSQL server

On PC 1 - Shared the calendar with mysql server using one account - appears to be OK, HeidiSQL shows VUMinder database createdOn PC 2 - did the same, PC2 appears to have duplicate entries, so removed google shares - still has duplicate

On PC1 - deleted all calendars, created a new blank (Leigh Calendar)Select calendar, Go to Share/share calendar and have only share with vueminder on other computers set.Everyone permission is set to no accessBUT i can select ses user from user ID - its blank

If I set the everyone permissions to say read (PC1) then the Leigh calendar does appear on PC 2

Using HeidiSQL, at the end is of the VUMinder database, there a Users table but the data is blank is this the problem ?(Also note that Engine is InnoDB and the my.cnf has a section about InnoDB settings ??)(Update - Tried the InnoDB changes, restarted the MYSQL server no difference)

Hi Leigh, thank you for the information. When you add specific user permissions to the Calendar Properties, those user names should get inserted into the "users" table of the database. First, please open the Sharing Options and click the "Test Connection" button. Do you see any errors? If so, could you let me know what error you see?

If the connection tests okay, then my guess is there's a permissions problem with the MySQL user account. User accounts need (at a minimum) the following privileges: ALTER, CREATE, DELETE, INSERT, SELECT, and UPDATE.

Both users have full Global Privileges on ALL databases just to make sure there were no permissions problems.

The Calendar on PC2 does get put in the MYSQL server (768KB) size with values in contacts/events/transactionsPC 1 can see PC2 calendar, if I set everyone to contribute access I can edit the calendar on PC2 - its just that there's no users

Under the database users has Userid Varchar and Name Text, Data tab shows blank.

Hi DanAdded the two users in manually and set users to contributor on both PC's and everyone else to no access. - Works fine

FYI, The Freenas (11.0 U2) is running MariaDB 10.2.7 in a jail, - both users have Global privileges (all boxes ticked) - Changing a password on a SQL user - stops a connection - so the SQL uid is being checked - just that the Users under VueMinder are not being created.Everything else appears to be working including creating/sharing new calendars.