• Welcome to RadioDJ - Free Radio Automation Software Forum. Please log in or sign up.

RDJ1.7.0 with mysql5.5.24 keeps failing

Started by suffolk, June 28, 2014, 01:02:10 AM

suffolk

Hi all

Had rdj running 1.6.57  8?   with 5.1 mysql  fine  awsome for months no problems

but now i took out  rdj  reinstalled  1.7.0   and nothing

so i formatted pc win 7 all updated fully  started to install  all pres for  some encoder  1.7.0 mysql 5.5.24  newest database exe
database just wont connect  try  a full reinstall win 7  3 times just incase i got somit wrong

i just keep  reading ins  and doing it  as i always have but  it wont have it
but  right now im going to reinstall 1657  and  older mysql    for tonight see  if things are ok   and its  not me 

thanks
john
Listen:  http://suffolkshoutcast.co.uk/flashplayera/player.html
RadioDJ v1.7.2 - MariaDB  Win 7 
flightradar24.com  server feeder
irc.suffolkchat.com  Mirc Chat

suffolk

no im totally lost  now 

aint got a clue what has happend

Listen:  http://suffolkshoutcast.co.uk/flashplayera/player.html
RadioDJ v1.7.2 - MariaDB  Win 7 
flightradar24.com  server feeder
irc.suffolkchat.com  Mirc Chat

starlite

Do you you have Radiodj already installed in a folder?

Are you installing Radiodj170 in a new folder on c:\ like  c:\Radiodj170 ?

Have you got the some encoder Encoder Plug in?

Have you installed one of the MySQL databases?

If so, is it running?

Just a few to start so we can see where you are

Good luck, I know how you feel.. :-(

oz

suffolk

Thanks for quick reply


windows7 ultimate fully updated with c++2003  2010
c:/radiodj170
some encoder 2.1 not install yet standalone
mysql made new users but apon clicking  user  no info
i use mysql admin    and workbench  seperate  database cant connect to  mysql  with details yet  workbench says its running 
im using root   and  radiodj databases  neither will connect  from mysql to  database setup 

i had  1657 working a treat  for  many months  just updated  and got this big problem 
ive just tried adding  users via client  i can create but not add grant  on all  fails
ive used  5.6  5.524  and lates  all with  new win 7 install 


theres only so much hair i can pull out  hehe
Listen:  http://suffolkshoutcast.co.uk/flashplayera/player.html
RadioDJ v1.7.2 - MariaDB  Win 7 
flightradar24.com  server feeder
irc.suffolkchat.com  Mirc Chat

starlite

#4
Not sure I am not sure I am the one to help.. however, I have found it is best to separate each element as usually it in only one thing not several.

If it is the db your having troubles with maybe best to set up MySQL again and start afresh there.  I have just started to use a new database called mini_server_11 which was mentioned on the forums the last couple of days. It was dead easy to setup. Once that done used the RDJ Database.exe.

There is also talk about another one called MariaDB which they all say is also very easy to setup.

Maybe a fresh start is the way to go.

Good luck.. keep reporting you progress as I am sure you will get help. They are great here. You may have to wait because of time zones but it is worth it.

Good Luck

SnowHow

Formatting and reinstalling windows is a bit extreme - There is rarely a need for that.


Which database and version are you trying to install?


Copper007

#6
Quote from: Copper007 on June 28, 2014, 02:51:56 PM
Same here.... fresh installed everyting.....


Krid  8)

unticked use ID3 cue data and autofades..... now it works.... for now.... got 75000 songs to do :)

edit..... no luck... even with mariadb...

win 7, 64 bit, 8 core xeon and 6 gb ram...
RDJ does it all!

http://www.studio0187.nl

suffolk

Thanks for replys 
i have  installed userver  and all is well although  very slow loading songs in db

ok for now 

will work on another server to perfect things  sort out  the problem   

thanks  for now
Listen:  http://suffolkshoutcast.co.uk/flashplayera/player.html
RadioDJ v1.7.2 - MariaDB  Win 7 
flightradar24.com  server feeder
irc.suffolkchat.com  Mirc Chat

nonstopgospel

Quote from: suffolk on June 28, 2014, 04:50:33 PM
Thanks for replys 
i have  installed userver  and all is well although  very slow loading songs in db

ok for now 

will work on another server to perfect things  sort out  the problem   

thanks  for now

Hey Suffolk although you've said the installation has been completed, for future reference This link ===> http://www.radiodj.ro/tutorials/how-to-install-mysql-server.html has the how to download the Mysql server.
How to install RadioDJ database? Can also be found Here ===> http://www.radiodj.ro/tutorials/how-to-install-radiodj-database.html

NonStopGospel Radio USA
NonStopGospel is Powered Powered by RADIODJ Since 08/11/2014

www.nonstopgopsel.com
http://nonstopgospel.caster.fm/
s3.myradiostream.com:18088
http://usa4.fastcast4u.com:5224/1/

suffolk

Thanks nonstopgospel   i have used  the  info  off site

seems all ok when installed untill i go to use  root  or add  users i can make them  but click on  it  and errors  details not found may have been deleted  and refs to (uth ? )  but ive always used latin1

it wont beet me  just a little set back

john
Listen:  http://suffolkshoutcast.co.uk/flashplayera/player.html
RadioDJ v1.7.2 - MariaDB  Win 7 
flightradar24.com  server feeder
irc.suffolkchat.com  Mirc Chat

suffolk

Right  i have  mysql5.6 installed all ok  with workbench
workbench  wont allow me to  add db
if i use client  theres an error  if i use  client to add user

i log in as root  in client then add  mysql -u root -p -h 127.0.0.1 -P 3306  password
error comes up

error 1064  42000  you have an error in your syntax; check the manual  which i did  and it says  same as ive typed 

john
Listen:  http://suffolkshoutcast.co.uk/flashplayera/player.html
RadioDJ v1.7.2 - MariaDB  Win 7 
flightradar24.com  server feeder
irc.suffolkchat.com  Mirc Chat

suffolk

I have just installed  latest mysql  and workbench  worked first time  all sorted

john
Listen:  http://suffolkshoutcast.co.uk/flashplayera/player.html
RadioDJ v1.7.2 - MariaDB  Win 7 
flightradar24.com  server feeder
irc.suffolkchat.com  Mirc Chat

nonstopgospel

Quote from: suffolk on June 30, 2014, 01:52:11 AM
I have just installed  latest mysql  and workbench  worked first time  all sorted

john

I am glad all have sorted out for you Suffolk.. All credits due to all the info I have learned here From Marius and all the other Great Moderators and I won't forget to mention the other awesome Users in here.. This forum is off the Hook.. I love it here Thus far. (((( RadioDJ )))) Rocks..

NonStopGospel Radio
NonStopGospel is Powered Powered by RADIODJ Since 08/11/2014

www.nonstopgopsel.com
http://nonstopgospel.caster.fm/
s3.myradiostream.com:18088
http://usa4.fastcast4u.com:5224/1/

suffolk

Ah one thought it was working ...BUT  it was infact  userver i forgot  it was still running

Is there a mod  who could  take a quick look at  mysql, and see why my Database setup dont want to  work ?

i have team view  but more puzzled as why  its not doing as its spose  to

uk BST zone i really need a fast  mysql  and massive  record collection to add 

regards john

Listen:  http://suffolkshoutcast.co.uk/flashplayera/player.html
RadioDJ v1.7.2 - MariaDB  Win 7 
flightradar24.com  server feeder
irc.suffolkchat.com  Mirc Chat

suffolk

Problem sorted   i used mariadb but forgot to add  :port  on end as it was different 

many thanks to  joshuatree44

john
Listen:  http://suffolkshoutcast.co.uk/flashplayera/player.html
RadioDJ v1.7.2 - MariaDB  Win 7 
flightradar24.com  server feeder
irc.suffolkchat.com  Mirc Chat