Skip to Content
It is currently November 11th, 2019, 7:35 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 17 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Firebird versus MySQL
PostPosted: May 25th, 2009, 4:20 pm 
Offline
Junior User
Junior User

Joined: May 19th, 2009, 2:01 pm
Posts: 36
I am a new user to SAM Broadcaster but have another streamer running SOS and Spacial encoder so I am not totally unfamiliar with streaming. However, the other service is a simulcast of a 24/7 terrestrial radio station. Naturally it does not use SAM so it does not need a separate automation/database setup.

On the new service, before I commit to a database, I wanted to ask what the advantages are for running Firebird versus MySQL database manager. I tried Firebird in demo mode runnning on an WIN XP Home OS and it seems to get confused easily. Shows the wrong info for songs playing, doesn't seem to track changes in song data, etc. Is MySQL a better database tool? Or am I doing something wrong with Firebird? Thank you for any insight!


Top
 Profile  
Reply with quote  
PostPosted: May 25th, 2009, 5:13 pm 
Offline
Alumni
Alumni

Joined: December 20th, 2006, 9:23 pm
Posts: 12211
Location: Show Low, AZ
MySQL is much superior to Firebird.

* MySQL is much more stable, especially for bigger libraries
* You'll find limited-to-zero support for Firebird here in the forums

Here's a MySQL setup tutorial: http://www.festerhead.com/forums/viewto ... f=17&t=118

Get it installed, THEN install SAM.

_________________
Andrew Cannon
(SVS) Spacial Volunteer Support

WE DANCE AS ONE: A Celebration In Groove
All That Is GOOD In Dance Music from the
70's, 80's, 90's and Now... plus some of the
best DJs from around the world.
http://www.wda1.com


Top
 Profile  
Reply with quote  
PostPosted: May 25th, 2009, 11:26 pm 
Offline
Junior User
Junior User

Joined: May 19th, 2009, 2:01 pm
Posts: 36
Thanks Andrew. That explains a LOT! I will install MySQL and reinstall SAM. Thanks for all of your
help here in the forums. I've read a lot of it and it is much appreciated.


Top
 Profile  
Reply with quote  
PostPosted: May 26th, 2009, 7:06 am 
Offline
Alumni
Alumni

Joined: December 20th, 2006, 9:23 pm
Posts: 12211
Location: Show Low, AZ
You're most welcome. Let us know if we can assist you further.

_________________
Andrew Cannon
(SVS) Spacial Volunteer Support

WE DANCE AS ONE: A Celebration In Groove
All That Is GOOD In Dance Music from the
70's, 80's, 90's and Now... plus some of the
best DJs from around the world.
http://www.wda1.com


Top
 Profile  
Reply with quote  
PostPosted: May 26th, 2009, 10:53 am 
Offline
Junior User
Junior User

Joined: May 19th, 2009, 2:01 pm
Posts: 36
After usingthe steps outlined on your site (and rechecking a few times) MySQL installer stops on "start MySQL" (red "x" on that) and won't finish the insall. Any ideas what might cause that? I am running Windows XP Home on a 2.4Ghz machine with 4 GB RAM. No other databases running. No other programs running yet. (SAM, etc.) Firewall is ON with exception UNchecked for MySQL as shown in the setup steps. Help?!


Top
 Profile  
Reply with quote  
PostPosted: May 26th, 2009, 11:10 am 
Offline
Alumni
Alumni

Joined: December 20th, 2006, 9:23 pm
Posts: 12211
Location: Show Low, AZ
Turn off the firewall, and try restarting MySQL. This tends to be a firewall issue sometimes. The ports that will connect to your MySQL are 1221, and 3306 (someone correct me if I'm wrong).

_________________
Andrew Cannon
(SVS) Spacial Volunteer Support

WE DANCE AS ONE: A Celebration In Groove
All That Is GOOD In Dance Music from the
70's, 80's, 90's and Now... plus some of the
best DJs from around the world.
http://www.wda1.com


Top
 Profile  
Reply with quote  
PostPosted: May 26th, 2009, 11:27 am 
Offline
Junior User
Junior User

Joined: May 19th, 2009, 2:01 pm
Posts: 36
No change. With firewall off, same result.


Top
 Profile  
Reply with quote  
PostPosted: May 26th, 2009, 12:30 pm 
Offline
Alumni
Alumni

Joined: December 20th, 2006, 9:23 pm
Posts: 12211
Location: Show Low, AZ
Which version of MySQL did you get?

_________________
Andrew Cannon
(SVS) Spacial Volunteer Support

WE DANCE AS ONE: A Celebration In Groove
All That Is GOOD In Dance Music from the
70's, 80's, 90's and Now... plus some of the
best DJs from around the world.
http://www.wda1.com


Top
 Profile  
Reply with quote  
PostPosted: May 26th, 2009, 1:22 pm 
Offline
Junior User
Junior User

Joined: May 19th, 2009, 2:01 pm
Posts: 36
5.1.34 Windows essentials (X86) 35.5MB file.


Top
 Profile  
Reply with quote  
PostPosted: May 26th, 2009, 1:32 pm 
Offline
Junior User
Junior User

Joined: May 19th, 2009, 2:01 pm
Posts: 36
Returns an error message that says: Cannot create Windows Service for MYSQL. Error:0


Top
 Profile  
Reply with quote  
PostPosted: May 26th, 2009, 1:36 pm 
Offline
Alumni
Alumni

Joined: December 20th, 2006, 9:23 pm
Posts: 12211
Location: Show Low, AZ
Step back to the 5.0.x Community download version.... I do know that SAM works fine with that version. I believe there have been some issues w/ newer versions.

_________________
Andrew Cannon
(SVS) Spacial Volunteer Support

WE DANCE AS ONE: A Celebration In Groove
All That Is GOOD In Dance Music from the
70's, 80's, 90's and Now... plus some of the
best DJs from around the world.
http://www.wda1.com


Top
 Profile  
Reply with quote  
PostPosted: May 26th, 2009, 1:47 pm 
Offline
Junior User
Junior User

Joined: May 19th, 2009, 2:01 pm
Posts: 36
Stepped back to 5.0.81 available on their website but same issue. I uninstalled the old one and physically deleted the folder before reinstalling the older version, just to be sure no install info was remaining. Is there an older version that is known to work---and do you know a location for a DL? Sorry to keep pestering you!


Top
 Profile  
Reply with quote  
PostPosted: May 26th, 2009, 1:55 pm 
Offline
Alumni
Alumni

Joined: December 20th, 2006, 9:23 pm
Posts: 12211
Location: Show Low, AZ
I got mine right from that website, using the tutorial posted above and had no issues. Something's just not starting right for your MySQL. You may touch base with support over at MySQL, as it's a third party database, and setting THAT up is where you're having issues. See what they say.

_________________
Andrew Cannon
(SVS) Spacial Volunteer Support

WE DANCE AS ONE: A Celebration In Groove
All That Is GOOD In Dance Music from the
70's, 80's, 90's and Now... plus some of the
best DJs from around the world.
http://www.wda1.com


Top
 Profile  
Reply with quote  
PostPosted: May 26th, 2009, 2:21 pm 
Offline
Junior User
Junior User

Joined: May 19th, 2009, 2:01 pm
Posts: 36
TONS of complaints about the very same issue from many XP users. No fixes coming from the maker of the software as far as I can see.


Top
 Profile  
Reply with quote  
PostPosted: May 26th, 2009, 3:00 pm 
Offline
Junior User
Junior User

Joined: May 19th, 2009, 2:01 pm
Posts: 36
So, given all of the gyrations going on about MySQL does it make sense to use it or is Firebird better in terms of playing nice with SAM? Does anyone USE Firbird now and have no problems?


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 17 posts ]  Go to page 1, 2  Next

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 2 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