Hi Alessio and list members,
Thank you once more for your assistance!
We run a pretty basic setup: one machine running Rivendell and the backup
volumes are two hard drives, one internal the other external that have
/var/snd copied to them each day. The same user, 'rd' is what I've been
logged in when I have always backed up successfully in the past, whether
locally or remotely logged in. I'm mystified as to why, after about a year
of working properly with the same drives, etc. the RDAdmin backup function
no longer works.
I am unfamiliar with where one finds the GUI implementation of mysqladmin,
so I typed that into console and here's the input I got:
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
count 0
force FALSE
compress FALSE
character-sets-dir (No default value)
default-character-set (No default value)
host (No default value)
port 0
relative FALSE
socket (No default value)
sleep 0
ssl FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
ssl-verify-server-cert FALSE
user (No default value)
verbose FALSE
vertical FALSE
connect_timeout 43200
shutdown_timeout 3600
Rene
On Wed, Jan 30, 2013 at 4:12 AM, Alessio Elmi <[email protected]>wrote:
> Hi,
> I suppose the database isn't locally or mysql user specified in
> rd.conf (usually *rduser*) doesn't have enough rights to do that
> (specifically LOCK TABLES) or both of them.
> Here two solutions:
>
> - You give those rights to the user under which you run the backup. If
> it has LOCK TABLES, it may be that the user can't have permissions
> outside 'localhost' (where localhost is where is the server and you're
> from an other client).
> So check this two things, you can use mysqladmin if you want a gui.
> - You append --single-transaction to the command (from console).
>
> Alessio
>
> 2013/1/30 ICR Programs <[email protected]>:
> > Thanks so much, Nathan. I really appreciate the details with each step,
> as
> > that helps me learn.
> >
> > I tried your command but I got an error of 'unknown variable'. I copied
> and
> > pasted from the email, so perhaps the spacing got thrown off. I didn't
> want
> > to mess with it and break something, so I left things as they are for
> now.
> > Here's my input and output :
> >
> >
> > [rd@icr-dj-desktop ~]$ mysqldump -u rduser -pletmein --locktables=false
> > Rivendell > /home/rd/20130130rd.sql
> > mysqldump: unknown variable 'locktables=false'
> > [rd@icr-dj-desktop ~]$
> >
> > [rd@icr-dj-desktop ~]$ mysqldump -u rduser -pletmein--locktables=false
> > Rivendell > /home/rd/20130130rd.sql
> > mysqldump: unknown variable 'locktables=false'
> > [rd@icr-dj-desktop ~]$
> >
> >
> > Did I mistype something? I did try copying from the email and pasting a
> > second and third time.
> >
> > Cheers,
> > Rene
> >
> >
> >
> > On Tue, Jan 29, 2013 at 5:56 PM, Nathan Steele
> > <[email protected]> wrote:
> >>
> >> Is this in anyway related to our not being able to see anything in the
> >> GUI's Trash folder?
> >>
> >>
> >> I wouldn't think so, but I am no expert either.
> >>
> >> This worked for me from the terminal as root, not sure it was necessary
> to
> >> be root but it probably was or I wouldn't have done it....
> >>
> >> mysqldump -u rduser -pletmein --locktables=false Rivendell >
> >> /home/rd/20130110rd.sql
> >>
> >> I'll break it down as best I understand
> >>
> >> mysqldump the command to do the backup
> >> -u rduser the username to access mysql, this is the default if you
> >> areusing the broadcast appliance installation, otherwise it will be
> whatever
> >> you setup.
> >> -pletmein the password to login to mysql, again default on Broadcast
> >> appliance. the username and password are the same as what is specified
> in
> >> the rd.conf file also. not the lack of a space between the -p flag and
> the
> >> password is intentional. you can also just use -p but then it will ask
> you
> >> for the password.
> >> --locktables=false tells mysql not to lock the tables, which is what was
> >> causing you the error. so potentially the database could lose some
> things
> >> like if a song plays during the backup the play count could be off by
> one.
> >> maybe worse things could happen I don't know....
> >> Rivendell the database you wish to backup
> >> > /home/rd/20130110rd.sql tells where you want the backup to go,
> including
> >> > what the file will be named. i use the date and add rd to remind me
> it is
> >> > the rivendell database. note there is a space between > and the path.
> >>
> >>
> >> AS a curious side effect, the resulting backup shows as a 0kb file, but
> it
> >> actually is not and has data in it. not sure why
> >>
> >> If any f my info is wrong someone please correct me, but I had to do
> this
> >> during a recent server migration and it was a success.
> >>
> >> Thanks,
> >>
> >>
> >>
> >> Nathaniel C. Steele
> >> Assistant Chief Engineer/Technical Director
> >> WTRM-FM / TheCrossFM
> >>
> >> On 1/29/2013 5:31 PM, ICR Programs wrote:
> >>
> >> Thanks again, to the best user list out there!
> >>
> >> Nathan, I can wait. I'll google it anyway to see what I can glean, but I
> >> am sooo far from a power user I don't want to break anything.
> >>
> >> Is this in anyway related to our not being able to see anything in the
> >> GUI's Trash folder? We can only see if from the Terminal as in
> >>
> >> cd .Trash
> >> ls -al .....
> >>
> >> then I manually delete by using
> >>
> >> rm *.*
> >>
> >>
> >>
> >> On Tue, Jan 29, 2013 at 5:22 PM, Nathan Steele
> >> <[email protected]> wrote:
> >>>
> >>> I had the same problem, it has nothing to do with the 2.4.0 update.
> >>> Google mysql errno 24 and find out how to do a backup without lock
> tables
> >>> from the command line. IF you give me some time I'll tell you the
> command
> >>> that worked for me but I'll have to go find it in the history.
> >>>
> >>> Wish it would work right from RDadmin though.
> >>>
> >>> Nathaniel C. Steele
> >>> Assistant Chief Engineer/Technical Director
> >>> WTRM-FM / TheCrossFM
> >>>
> >>> On 1/29/2013 5:17 PM, ICR Programs wrote:
> >>>
> >>> Thanks Wayne,
> >>>
> >>> The issue that worries me is this: I am not able to back up the
> database.
> >>> I should be able to, shouldn't I?
> >>>
> >>> (this was using the Backup Database button on RDAdmin) and trying it
> from
> >>> command line (though I am not sure how to do that).
> >>>
> >>> And, the system wasn't 'live' in the sense that I didn't have RDAirplay
> >>> or any other Rivendell components running. I rebooted the system and
> then
> >>> tried all this.
> >>>
> >>> Any suggestions, please?
> >>>
> >>> thanks!
> >>> Rene
> >>>
> >>> On Tue, Jan 29, 2013 at 4:36 PM, waynemerricks
> >>> <[email protected]> wrote:
> >>>>
> >>>> To update the schema you just need to run RDAdmin. From memory not
> >>>> much happens as far as the user is concerned (unless it dies in which
> >>>> case you get an error message). As for the mysqldump error it failed
> >>>> because it couldn't lock the tables on a live system. You can dump
> >>>> without lock tables but data integrity is not guaranteed as changes
> >>>> could have been made while the dump was running.
> >>>>
> >>>> Basically, business as usual but an off putting error message that
> >>>> makes you wonder.
> >>>>
> >>>> Regards,
> >>>>
> >>>> Wayne
> >>>>
> >>>> On 2013-01-29 21:27, ICR Programs wrote:
> >>>> > Dear list members,
> >>>> >
> >>>> > Im sorry to basically post this same question again, but the thread
> >>>> > it
> >>>> > was in went in another direction and I didnt want to get my query
> >>>> > "lost in the shuffle."
> >>>> >
> >>>> > What I did glean from the thread and a few other messages was that
> >>>> > Apache may be at play here ... however, I dont know anything about
> >>>> > Apache or how/why it was affect our system such that we were able to
> >>>> > back up the Database before upgrading from 2.3.x to 2.4.0
> >>>> >
> >>>> > Also, Im NOT sure about whether this is relevant, and indeed it was
> a
> >>>> > problem that cropped up BEFORE this v2.4.0 update, but whenever one
> >>>> > moves a file to the trash (logged in as user rd) it doesnt appear in
> >>>> > the GUI in the Trash. If one logs in via terminal, however, the
> >>>> > deleted files are there and one can expunge them from the system. I
> >>>> > am guessing this is a permissions problem, but am mystified why it
> >>>> > would have happened.
> >>>> >
> >>>> > Thanks to all!
> >>>> > Rene
> >>>> >
> >>>> > Hello Fred and all,
> >>>> >
> >>>> > Thanks for your work on the updates and indeed, the Rivendell
> System.
> >>>> >
> >>>> > I upgraded, but have what I hope is a slight problem.
> >>>> >
> >>>> > I used the Package Updater -- it had a notification up about the
> >>>> > updates -- and it installed fine.
> >>>> >
> >>>> > I then opened RDAdmin, typed the user name "admin" and wasnt sure
> >>>> > what
> >>>> > to do next in order to update the database schema (which is now,
> >>>> > according to System Info, Rivendell Version 2.4.0; Database schema
> >>>> > 216).
> >>>> >
> >>>> > I did try to do a backup of the database, and that gave the error
> >>>> > "Unable to create backup"
> >>>> >
> >>>> > I then went to Terminal, typed "rddamin" and got this:
> >>>> >
> >>>> > Terminal Output:
> >>>> >
> >>>> > [rd@icr-dj-desktop ~]$ rdadmin
> >>>> > mysqldump: Got error: 1016: Cant open file:
> >>>> > ./Rivendell/Weekday_6_AM_CLK.frm (errno: 24) when using LOCK TABLES
> >>>> >
> >>>> > What should I do now, please?
> >>>> >
> >>>> > Thanks,
> >>>> > Rene
> >>>> >
> >>>> > --
> >>>> >
> >>>> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >>>> > "Democracy is not a spectator
> >>>> > sport"
> >>>> >
> >>>> > Ithaca Community Radio -- 88.1 FM in
> >>>> > Ithaca
> >>>> > WRFI 91.9 FM in
> >>>> > Watkins Glen
> >>>> > WINO 89.9 FM
> >>>> > in Odessa
> >>>> >
> >>>> > News, Culture & Information from our Neighborhoods and the World
> >>>> >
> >>>> > _Phone_: 607.319.5445 [1]
> >>>> > _Email_: [email protected] [2]
> >>>> > _Web_: http://ithacaradio.org/ [3]
> >>>> >
> >>>> >
> >>>> > Mailing address:
> >>>> > The Clinton House
> >>>> > 103 West Seneca St.
> >>>> > Suite 305
> >>>> > Ithaca, N.Y, 14850
> >>>> >
> >>>> >
> >>>> >
> >>>> > Links:
> >>>> > ------
> >>>> > [1] http://mail2.thevoiceasia.com/tel:607.319.5445
> >>>> > [2] mailto:[email protected]
> >>>> > [3] http://ithacaradio.org/
> >>>>
> >>>> _______________________________________________
> >>>> Rivendell-dev mailing list
> >>>> [email protected]
> >>>> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
> >>>
> >>>
> >>>
> >>>
> >>> --
> >>>
> >>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >>> "Democracy is not a spectator sport"
> >>>
> >>> Ithaca Community Radio -- 88.1 FM in Ithaca
> >>> WRFI 91.9 FM in Watkins Glen
> >>> WINO 89.9 FM in Odessa
> >>>
> >>> News, Culture & Information from our Neighborhoods and the World
> >>>
> >>> Phone: 607.319.5445
> >>> Email: [email protected]
> >>> Web: http://ithacaradio.org/
> >>>
> >>>
> >>> Mailing address:
> >>> The Clinton House
> >>> 103 West Seneca St.
> >>> Suite 305
> >>> Ithaca, N.Y, 14850
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>> _______________________________________________
> >>> Rivendell-dev mailing list
> >>> [email protected]
> >>> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
> >>>
> >>>
> >>>
> >>> _______________________________________________
> >>> Rivendell-dev mailing list
> >>> [email protected]
> >>> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
> >>>
> >>
> >>
> >>
> >> --
> >>
> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> >> "Democracy is not a spectator sport"
> >>
> >> Ithaca Community Radio -- 88.1 FM in Ithaca
> >> WRFI 91.9 FM in Watkins Glen
> >> WINO 89.9 FM in Odessa
> >>
> >> News, Culture & Information from our Neighborhoods and the World
> >>
> >> Phone: 607.319.5445
> >> Email: [email protected]
> >> Web: http://ithacaradio.org/
> >>
> >>
> >> Mailing address:
> >> The Clinton House
> >> 103 West Seneca St.
> >> Suite 305
> >> Ithaca, N.Y, 14850
> >>
> >>
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> Rivendell-dev mailing list
> >> [email protected]
> >> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
> >>
> >>
> >>
> >> _______________________________________________
> >> Rivendell-dev mailing list
> >> [email protected]
> >> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
> >>
> >
> >
> >
> > --
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > "Democracy is not a spectator sport"
> >
> > Ithaca Community Radio -- 88.1 FM in Ithaca
> > WRFI 91.9 FM in Watkins Glen
> > WINO 89.9 FM in Odessa
> >
> > News, Culture & Information from our Neighborhoods and the World
> >
> > Phone: 607.319.5445
> > Email: [email protected]
> > Web: http://ithacaradio.org/
> >
> >
> > Mailing address:
> > The Clinton House
> > 103 West Seneca St.
> > Suite 305
> > Ithaca, N.Y, 14850
> >
> >
> >
> >
> >
> > _______________________________________________
> > Rivendell-dev mailing list
> > [email protected]
> > http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
> >
> _______________________________________________
> Rivendell-dev mailing list
> [email protected]
> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
>
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Democracy is not a spectator sport"
Ithaca Community Radio -- 88.1 FM in Ithaca
WRFI 91.9 FM in Watkins Glen
WINO 89.9 FM in Odessa
News, Culture & Information from our Neighborhoods and the World
*Phone*: 607.319.5445
*Email*: [email protected]
*Web*: http://ithacaradio.org/
Mailing address:
The Clinton House
103 West Seneca St.
Suite 305
Ithaca, N.Y, 14850
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
