Calendars not syncing - MySQL problems

Need help with VueMinder Pro or Ultimate? Ask your questions here.
gmh
Posts: 30
Joined: Tue Feb 01, 2011 12:43 pm

Calendars not syncing - MySQL problems

Post by gmh » Sun Jul 06, 2014 2:01 am

Since some time in May our two PCs (running windows 7) have not been syncing. I have noticed that my PC is not connecting to the MySQL server. I have re-installed MySQL but still no connection. I have ensured that Norton Internet Security will allow the connection.
MySQLWorkbench - MySQLVueMinder details.JPG
MySQLWorkbench - MySQLVueMinder details.JPG (118.36 KiB) Viewed 6206 times
1.JPG
1.JPG (22.42 KiB) Viewed 6206 times
I hope this problem can be easily resolved.

User avatar
VueSoft
Dan Chartrand
Posts: 3877
Joined: Sat Aug 23, 2008 12:39 am
Location: St. Louis, Missouri, USA
Contact:

Re: Calendars not syncing - MySQL problems

Post by VueSoft » Sun Jul 06, 2014 9:10 pm

Hi gmh, this sounds like a permissions problem on the account you're using to connect. The minimum permissions are shown in the screenshot below:
Image

If you still can't get it to connect, please see the page linked below for a possible solution:
http://stackoverflow.com/questions/1559 ... sql-server
Dan Chartrand, Founder
VueSoft LLC | St. Louis, Missouri, USA

gmh
Posts: 30
Joined: Tue Feb 01, 2011 12:43 pm

Re: Calendars not syncing - MySQL problems

Post by gmh » Mon Jul 07, 2014 12:40 am

Still can't get it to work
1.JPG
1.JPG (27.19 KiB) Viewed 6201 times

User avatar
VueSoft
Dan Chartrand
Posts: 3877
Joined: Sat Aug 23, 2008 12:39 am
Location: St. Louis, Missouri, USA
Contact:

Re: Calendars not syncing - MySQL problems

Post by VueSoft » Tue Jul 08, 2014 12:30 am

Well, at least now you're getting a different message. Have you double-checked the correct password has been entered in the Sharing Options?

You might also try uninstalling MySQL Server and then reinstall it, closely following the instructions linked below (especially step 2-18).
http://www.vueminder.com/sharing.php
Dan Chartrand, Founder
VueSoft LLC | St. Louis, Missouri, USA

gmh
Posts: 30
Joined: Tue Feb 01, 2011 12:43 pm

Re: Calendars not syncing - MySQL problems

Post by gmh » Tue Jul 08, 2014 11:14 am

uninstalled and then re-installed MySQL. Main PClinks to the server OK.
Second PC failed to connect to MySQL server and came up with this error message
2nd PC error message.JPG
2nd PC error message.JPG (28.24 KiB) Viewed 6197 times

User avatar
VueSoft
Dan Chartrand
Posts: 3877
Joined: Sat Aug 23, 2008 12:39 am
Location: St. Louis, Missouri, USA
Contact:

Re: Calendars not syncing - MySQL problems

Post by VueSoft » Tue Jul 08, 2014 6:34 pm

Hi gmh, the "too many connections" problem has been corrected for the next release. I'll post a reply as soon as it's ready to download. In the meantime, try rebooting the server and your PCs.
Dan Chartrand, Founder
VueSoft LLC | St. Louis, Missouri, USA

gmh
Posts: 30
Joined: Tue Feb 01, 2011 12:43 pm

Re: Calendars not syncing - MySQL problems

Post by gmh » Wed Jul 09, 2014 3:41 am

Hi Dan
Tried your suggestion of re-starting PCs etc and I now have a pair of synced calendars!!
Thanks for all your help.

User avatar
VueSoft
Dan Chartrand
Posts: 3877
Joined: Sat Aug 23, 2008 12:39 am
Location: St. Louis, Missouri, USA
Contact:

Re: Calendars not syncing - MySQL problems

Post by VueSoft » Fri Jul 18, 2014 4:08 pm

The "too many connections" problem has been corrected in version 11.2.1, as well as a variety of other problems related to sharing calendars through MySQL Server. To update, click the "Check for Updates" command on the Help menu.
Dan Chartrand, Founder
VueSoft LLC | St. Louis, Missouri, USA

Post Reply