Re: [RDD] First time install - infinite loop in rdadmin around MySQL

[Michael <mbarnes@xxxxxxxxxxxx>]

IIRC there is nothing in any documentation I have seen that has the user 
create a Rivendell database in advance.  RDAdmin looks for the existence 
of an RD database.  If it sees one, it expects it to have certain tables 
and data to examine.  If it does not see one, it creates one.

In this case, RDAdmin detected the existing RD database and tried to 
find expected data.  Since the database was empty, the query obviously 
broke, and threw the app into a tailspin.

I'm not trying to sound nasty, but IMHO, a user who does not follow 
directions or makes assumptions and adds steps not warranted or out of 
sequence is not a basis for a bug report. The program is working 
properly, there is no bug.  It is user error.

My $.0002

Michael

Andrew Widdowson told me, On 07/14/2009 02:21 AM:
> I figured it out - I had assumed that a "CREATE DATABASE rivendell;" was 
> in order before running the program. The existence of the database 
> without any tables put rdadmin into a loop. Doing "DROP DATABASE 
> rivendell;" did the trick nicely.
> 
> Is there a bugtracker I can file an issue against? It looks like the 
> link on the website is down.
> 
> Thanks,
> -Andrew Widdowson
> KZSU Engineering
> 
> On Sun, Jul 12, 2009 at 1:55 AM, Andrew Widdowson <apw@xxxxxxxxxxxxxxxxx 
> <mailto:apw@xxxxxxxxxxxxxxxxx>> wrote:
> 
>     Hi folks,
> 
>     I'm trying out Rivendell for the first time, out of CVS, from the
>     1x_branch. As per the instructions, I have compiled and installed
>     all of the binaries, and set up a new user account for the system,
>     as well as a mysql user with all privileges. When I got to run
>     rdadmin, it just spins forever. By wrapping rdadmin in strace, I
>     discovered that rdadmin was looping forever. I turned on debugging
>     in my MySQL server and discovered that it's just doing:
> 
>                          45 Connect     radio@localhost on rivendell
>                          45 Init DB     rivendell
>                          45 Query       select DB from VERSION
>                          45 Quit      
>                          46 Connect     radio@localhost on rivendell
>                          46 Init DB     rivendell
>                          46 Query       select DB from VERSION
>                          46 Quit      
>                          47 Connect     radio@localhost on rivendell
>                          47 Init DB     rivendell
>                          47 Query       select DB from VERSION
>                          47 Quit      
> 
>     ...forever.
> 
>     Anyone know what this is about? Any help or advice you have to share
>     is greatly appreciated.
>     Thanks,
>     -Andrew Widdowson
>     KZSU Engineering
> 
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@xxxxxxxxxxxxxxxxxxxxxxxx
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev