Skip to Content
It is currently August 14th, 2022, 8:07 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
PostPosted: January 14th, 2022, 10:52 pm 
Offline
New User
New User

Joined: August 30th, 2020, 10:55 pm
Posts: 1
SAM & MySQL are Not Connecting. This is a brand new machine build running SAM v2021.6, MySQL v8.0.27 running as a service. MySQL Workbench 8.0 CE connects to the MySQL Server, samdb database (schema) created manually. OS: Win 11 v21H2 build 22000.434 with latest updates. Processor: 12th Gen Intel Core i7-12700K. MB: MSI MAG Z690, Tomahawk WiFi, DDR4, 32GB RAM. Everything is running on one machine. Other programs running on this machine include Libre Office, Firefox, Norton Security, dB Poweramp, Python 3.10, Tight VNC, Samsung Magician, MSI.CentralServer, MSI TerminalServer, RTKAudUService64, Asus Audio Center, Open Hardware Monitor, One Drive, MySQLWorkbench.

While running SAM Broadcaster Studio Setup:

In the Select Database System window, MySQL was already selected.
Login details for MySQL database: Specify custom settings(already selected)>Access mode: Local Server; Username: root; Database: SAMDB; Remote server settings (default, greyed out): Host: localhost, Port 3306.
Messages after entering all information:
Unable to connect to database. Please make sure the database server is properly installed and running. Also make sure your database login details are correct. Next screen: Failed to create, upgrade or configure database. Please check settings and try again. I’ve gone through this Setup series many times with different adjustments, thinking I had the answer, but no!

I’ve spent several hours every day over the last week searching Google, & FAQs for all 3 systems ending down in Rabbit HOles. I only found one SAM forum topic in the last year that addressed a similar problem. From User dan40, on 12-2-21: The solution is to install MySQL Workbench on my SQL server, and under (server)>“Users and Privileges” add a % sign in the “From Host” box for root and samusr. I placed a % for root user, created samusr account. No Joy. I’ve installed and administered several instances of SAM and MySQL in the last 20 years and thought I was proficient at overcoming problems...

Thank you for considering this problem and any suggestions you can give.


Top
 Profile  
Reply with quote  
PostPosted: January 16th, 2022, 11:16 pm 
Offline
Junior User
Junior User

Joined: January 31st, 2009, 9:43 pm
Posts: 66
I had similar issues for days trying to connect sam to mysql database, but ended up using MariaDB. One of the best choice I made by discontinuing to use MYSQL. Also just a suggestion as Windows 11 is currently not compatible with SAM. I have escalated the issue to the support team and waiting for a response. SAM keeps crashing every day or sometimes every two days. It is a lot of work to downgrade to Windows 10 for me so I am still waiting for a solution from Spacial.

FYI: http://support.spacialaudio.com/forums/viewtopic.php?f=20&t=73776

_________________
http://www.tamilragam.com


Top
 Profile  
Reply with quote  
PostPosted: February 9th, 2022, 10:32 pm 
Offline
New User
New User

Joined: February 9th, 2022, 10:28 pm
Posts: 1
cheekycroak wrote:
I had similar issues for days trying to connect sam to mysql database, but ended up using MariaDB. One of the best choice I made by discontinuing to use MYSQL. Also just a suggestion as Windows 11 is currently not compatible with SAM. I have escalated the issue to the support team and waiting for a response. SAM keeps crashing every day or sometimes every two days. It is a lot of work to downgrade to Windows 10 for me so I am still waiting for a solution from Spacial.

FYI: http://support.spacialaudio.com/forums/viewtopic.php?f=20&t=73776


Did anyone experience strange issues with the toolbar and icon bar when using Windows 11? I had to downgrade back to Windows 10 for the time being because the issue made SAM impossible to use.

Mike
RostersHamiton.com


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: Bing [Bot] and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group