Mysql - No User ID's in Sharing Screen
Mysql - No User ID's in Sharing Screen
Hi
Running 2017.04 Ultimate
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 created
On 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 access
BUT 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)
Same on PC2 - no users ID to select
It looks like VUeMinder is not creating users in the MYSQL
Leigh
Running 2017.04 Ultimate
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 created
On 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 access
BUT 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)
Same on PC2 - no users ID to select
It looks like VUeMinder is not creating users in the MYSQL
Leigh
Re: Mysql - No User ID's in Sharing Screen
Just an Update
Deleted whole VUEMinder database in the sql server, re shared on both and still the same - no UID's
Leigh
Deleted whole VUEMinder database in the sql server, re shared on both and still the same - no UID's
Leigh
- VueSoft
- Dan Chartrand
- Posts: 3901
- Joined: Sat Aug 23, 2008 12:39 am
- Location: St. Louis, Missouri, USA
- Contact:
Re: Mysql - No User ID's in Sharing Screen
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.
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.
Dan Chartrand, Founder
VueSoft LLC | St. Louis, Missouri, USA
VueSoft LLC | St. Louis, Missouri, USA
Re: Mysql - No User ID's in Sharing Screen
Hi Dan
Test connections works fine, no errors on both
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/transactions
PC 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.
Leigh
Test connections works fine, no errors on both
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/transactions
PC 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.
Leigh
- VueSoft
- Dan Chartrand
- Posts: 3901
- Joined: Sat Aug 23, 2008 12:39 am
- Location: St. Louis, Missouri, USA
- Contact:
Re: Mysql - No User ID's in Sharing Screen
Hi Leigh, thank you for the information. I haven't been able to replicate the problem on my test network, so I'm not yet sure what is causing the behavior you're seeing. I'll investigate further.
If you require permissions for different users, you could try forcing the user names into the users table by running some SQL in the console or MySQL Workbench. Try this:
Where xxx is the user ID that needs to have permissions assigned in VueMinder, and yyy is the user's full name (or the same as xxx). Does that work?
If you require permissions for different users, you could try forcing the user names into the users table by running some SQL in the console or MySQL Workbench. Try this:
Code: Select all
INSERT INTO vueminder.users (UserId, Name) VALUES ("xxx", "yyy")
Dan Chartrand, Founder
VueSoft LLC | St. Louis, Missouri, USA
VueSoft LLC | St. Louis, Missouri, USA
Re: Mysql - No User ID's in Sharing Screen
Hi Dan
Added 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.
Leigh
Added 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.
Leigh
- VueSoft
- Dan Chartrand
- Posts: 3901
- Joined: Sat Aug 23, 2008 12:39 am
- Location: St. Louis, Missouri, USA
- Contact:
Re: Mysql - No User ID's in Sharing Screen
Hi Leigh, I'm glad that worked. Please let me know if you have any other questions.
Dan Chartrand, Founder
VueSoft LLC | St. Louis, Missouri, USA
VueSoft LLC | St. Louis, Missouri, USA