Skip to Content
It is currently July 20th, 2019, 12:51 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: Protecting my database
PostPosted: April 20th, 2019, 7:04 pm 
Offline
Senior User
Senior User

Joined: September 24th, 2007, 2:01 pm
Posts: 180
Can someone assist me in protecting my database from hackers. I use wamp for mysql and to serve the web site. Recently my database is consistently being hacked and removed with a "ransom note" left for the return of my data.

Fortunately I have a very good back up system, so restoring the database and getting the station running again only takes me seconds, but obviously I would prefer not to have to do this on a regular basis. I have already set a strong password for the database, but a lot of the other instructions I can find on the web are confusing to me. Can someone assist me in completely securing the database using layman's terms please.


Top
 Profile  
Reply with quote  
PostPosted: April 21st, 2019, 6:41 am 
Offline
SVS Member
SVS Member

Joined: May 8th, 2004, 9:00 am
Posts: 10434
Location: Denver, CO
In workbench, select left side under Users and Privileges, on right, have you allowed root to connect only from localhost and/or 127.0.0.1? Does your web site use the username root to access the db as well? This is not a good idea. You should have a username that has limited privileges (select, insert, delete, update) connecting from the web site to make queries and updates and to write to the database schema.

_________________
- Rob Oyler, SVS
Image


Top
 Profile  
Reply with quote  
PostPosted: April 21st, 2019, 2:11 pm 
Offline
Senior User
Senior User

Joined: September 24th, 2007, 2:01 pm
Posts: 180
Thank you, I will make those changes


Top
 Profile  
Reply with quote  
PostPosted: April 22nd, 2019, 7:22 am 
Offline
Senior User
Senior User

Joined: September 24th, 2007, 2:01 pm
Posts: 180
Is there any way I can change the database password used by Sam, without having to uninstall and reinstall the system again


Top
 Profile  
Reply with quote  
PostPosted: April 22nd, 2019, 8:54 am 
Offline
SVS Member
SVS Member

Joined: May 8th, 2004, 9:00 am
Posts: 10434
Location: Denver, CO
Yes, you can manually insert the password in the SAMBC.core.xml to match what you have change in the workbench for SAM to use. It will require a SAM restart. Look for the <password> tag in the first line of the file depending on your editor.

_________________
- Rob Oyler, SVS
Image


Top
 Profile  
Reply with quote  
PostPosted: April 22nd, 2019, 10:42 am 
Offline
Senior User
Senior User

Joined: September 24th, 2007, 2:01 pm
Posts: 180
Thank you


Top
 Profile  
Reply with quote  
PostPosted: April 24th, 2019, 6:36 am 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 7863
Location: Aachen (Germany)
You can alternatively use the shortcut named Reconfigure that is installed alongside SAM, or you can run
Code:
"C:\Program Files (x86)\Spacial Audio\SAMBC.exe" /reconfigure

from the windows run (win + r / right click on the windows icon in the lower left and click run...) or command prompt (cmd)

This will give you a GUI similar to when you first installed SAM to change database and other setup configuration without reinstalling all the files again.

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

We're offering custom PAL / PHP code and general SAM assistance at palscripts.com

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


Top
 Profile  
Reply with quote  
PostPosted: April 25th, 2019, 1:21 am 
Offline
Senior User
Senior User

Joined: September 24th, 2007, 2:01 pm
Posts: 180
Thank you Mastacheata. Note to other users with similar problem, using the reconfigure method will avoid you having to try to find all the different database config files, for example connecting the reporter etc


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

All times are UTC - 6 hours [ DST ]


Who is online

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