Skip to Content
It is currently September 23rd, 2020, 9:47 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
PostPosted: July 1st, 2020, 11:10 am 
Offline
New User
New User

Joined: July 1st, 2020, 11:08 am
Posts: 1
Hi!

What do I set incorrectly ?
No Syncron mysql between PC and Synology Nas mysq .

data:
Windows XP
Public fixed IP address
PC - Mysql 5.5
SAM Broadcaster v4.9.0 myloweslife
samPHPweb

dbconfig.xml.php
<Database>
<driver>MYSQL</ Driver >
<host>Xx.xxx.xxx.xxx</ Host >
<Port>3306< / Port >
<Database>samdb</ Database >
<username>radarok</ username>
<password>password</ Password >
</ Database >

Router - DIR- 600
Open ports 3306, 1221
PC's IP address - 192.168.0.101
Synology IP address - 192.168.0.100
DMZ eneble - 192.168.0.101
Mysql workbanch :
Connection SAMDB - radarok - Hosts : 192.168.0.100:3306
Connection SAMDB - localhost - radarok - Hosts : 192.168.0.100:3306
Server Instance - mysqld@192.168.0.100
Host: 192.168.0.100 Type Windows

The site is all right , everything works perfectly .
I can save database (Tools/Backup or Restore)
The problem is that the data does not go through the Synology NAS mysql database.
So if I stop the SAM and turn off the PC, the web Oops ...

If I reconfigure when I start the SAM, the connection (host: 192.168.0.100) all data goes to the Synology NAS mysql, but I can't save (Tools/Backup or Restore) - Backup failed

Please help me to find, what is the bad setting


Last edited by ksilein on July 2nd, 2020, 9:24 am, edited 1 time in total.

Top
 Profile  
Reply with quote  
PostPosted: July 2nd, 2020, 5:56 am 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 8060
Location: Cologne (Germany)
You can't use the SAM Backup feature with a remote database.
The backup feature of SAM merely instructs the database server to perform the dump itself, but if the remote database server has no access to the files on your computer (and especially at the very same path), SAM's instructions will fail.
I.e.: SAM tells your NAS to dump the database to C:\Users\ksilein\AppData\SpacialAudio\SAMBC\backup.csv, but your NAS has no idea what this C thing is or where on earth to find the AppData folder.


For remote MySQL you need to take care of the backup yourself. (And I would strongly suggest doing so for the local MySQL as well)

The only alternative to make this work and still use a remote database on your NAS is to set up Database replication between two DB servers on your computer and the NAS.
I wouldn't recommend that, as it's far from easy and introduces a lot of unneccessary complexity.

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode


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

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: Bing [Bot] and 40 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