Re: [RDD] Moving RD to another system

[Fred Gleason]

On Sep 27, 2018, at 13:05, Rick  wrote:

> I sincerely hope you're fast at the keybord. We run multiple streams in a 
> live environment on 1 rdserver. This doesn't seam an acceptable option to me. 
> Better sequence : create new load swap old/new delete  old

The (admittedly implicit) context was that of bringing up a new system, hence 
being in an off-line environment. If one needs to do this sort of thing in a 
live production environment, then I’d be looking at using something like LVM 
snapshots, or at the *very* least scripting the operations. That’s a problem of 
a different kind, not just degree.

Cheers!


|--|
| Frederick F. Gleason, Jr. |  Chief Developer |
|   |  Paravel Systems |
|--|
|  A room without books is like a body without a soul. |
| -- Cicero|
|--|___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Moving RD to another system

[Diego]

Thanks Frederick.

>That sounds like its not finding the Qt3 MySQL plug-in. Do:
>
>   rpm -q qt3-MySQL
>
>to verify.
qt3-MySQL-3.3.8b-51.el7.x86_64

>Also, verify that the MariaDB service is actually running:
>
>systemctl status mariadb
>
Loaded, active and running

>and also check ?/etc/rd.conf? to verify that it?s looking at the correct 
>>MySQL/MariaDB DB instance.
yes, default data.
I just installed following Centos7 instructions (as said in my first post)

Indeed I got it working after I realized that Restoring weren't
loading sql into rivendell database.
So I make it from command line, as I wrote in my previous e-mail
After that, rdadmin asked me for schema update.

We can close this issue. Should I use some netiquette, like adding
[SOLVED] to subject??

Thansk again
Diego Rucci
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Moving RD to another system

[Fred Gleason]

On Sep 26, 2018, at 22:18, Diego  wrote:

> owner:group are ok. Double checked (Linux user since 2003 ;) )
> Did MySQL backup from source PC using rdadmin
> Then did restore on target PC using rdadmin. 
> But not worked. Launched rdadmin from terminal and saw several errors about 
> QMYSQL3.
> So logged in into MySQL and were no tables inside Rivendell database!
> Maybe restore is not working with previous versions?

That sounds like its not finding the Qt3 MySQL plug-in. Do:

rpm -q qt3-MySQL

to verify.

Also, verify that the MariaDB service is actually running:

systemctl status mariadb

and also check ‘/etc/rd.conf’ to verify that it’s looking at the correct 
MySQL/MariaDB DB instance.

Cheers!


|--|
| Frederick F. Gleason, Jr. |  Chief Developer |
|   |  Paravel Systems |
|--|
|  A room without books is like a body without a soul. |
| -- Cicero|
|--|___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Moving RD to another system

[Lorne Tyndale]

Hi,

As far as I understand the Restore in rdadmin does not do a schema check
/ update, so it will work if you are staying at the same version of
Rivendell.  In your case you were going from an older version to a newer
version.  In that situation it is best to do the restore from the
command line so that it will do the schema check / update when rdadmin
is run.

Lorne Tyndale

> 
> Hi drew. Thanks.
> owner:group are ok. Double checked (Linux user since 2003 ;) )
> Did MySQL backup from source PC using rdadmin
> Then did restore on target PC using rdadmin.
> But not worked. Launched rdadmin from terminal and saw several errors about
> QMYSQL3.
> So logged in into MySQL and were no tables inside Rivendell database!
> Maybe restore is not working with previous versions?
> 
> Used command line:
> mysql -u rduser -p letmein -h localhost -D Rivendell < rivendell.sql
> 
> Checked tables: ok.
> Ran rdadmin again and now I saw scheme migration message.
> I think is working now.
> 
> That's all for now. Next I'll have to figure out how todo use two
> soundcards + jack.
> 
> Thanks again.
> Diego
> 
> El mié., 26 de sep. de 2018 19:01, drew Roberts 
> escribió:
> 
> >
> >
> > On Wed, Sep 26, 2018 at 3:42 PM Diego  wrote:
> >
> >> Hi, this is my first post. I've tried to search the web on this issue,
> >> but didn't find anything useful. Maybe you can point me in the right path.
> >>
> >> I have a linux distro called 'EterTics' [0]. It's a Frankenstein distro
> >> (sadly), Devuan based, with Rivendell 2.10.3-1 version from tryphon.eu
> >> (not online right now); repos from ubuntu, too messy. I didn't built it.
> >>
> >> It worked fine, but recently we needed to update some packages and seems
> >> RD broked in the process. Macros wont work, neither rmlsend, RDLibrary
> >> crashes first time but second attemp work... sigh... I not looking for a
> >> solution for this.
> >>
> >> I'm already installed Centos7 64bits on another PC following official
> >> instructions and ran rivendell-install script. I plan working with this
> >> stable installation [1]
> >>
> >> My first attemp was export /var/snd and MySQL from original installation
> >> (using rdadmin), and put into this new CentOS. Both PC have same hostname,
> >> same IP (on different location).
> >>
> >> But importing mysql broke RD. I think because I'm trying to move from
> >> rivendell/mysql to different versions.
> >>
> >> Is there a way to move data to new PC? Is there some missing steps I not
> >> doing? I don't want to create carts, nor schedule everything again.
> >>
> >
> > On the new machine:
> >
> > ls -la /var/snd
> >
> > Make a note of this info as after to copy/move files from the old machine
> > you may have to make everything match the owner/group and permission that
> > the new machine wants.
> >
> > Do a Backup Database from rdadmin on the old machine. Do a Restore
> > Database from rdadmin on the new machine. Copy / move all the files from
> > /var/snd on the old machine to /var/snd on the new machine.
> >
> > On the new machine:
> >
> > ls -la /var/snd
> >
> > Do the just copied/moved files match what you had before? If not you need
> > to fix this with chown and chmod.
> >
> >>
> >> Thank you in advance.
> >> Diego Rucci
> >>
> >
> > You are most welcome.
> >
> > all the best,
> >
> > drew
> >
> >
> >>
> >> [0] https://gnuetertics.org/
> >> [1]
> >> http://static.paravelsystems.com/rivendell-install/rivendell-install-rhel7.html
> >>
> >> 
> >> ___
> >> Rivendell-dev mailing list
> >> Rivendell-dev@lists.rivendellaudio.org
> >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
> >>
> >
> >
> > --
> > Enjoy great *Bahamian Music* at:
> > Bahamian Or Nuttin - http://www.bahamianornuttin.com
> > 
> >___
> Rivendell-dev mailing list
> Rivendell-dev@lists.rivendellaudio.org
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Moving RD to another system

[drew Roberts]

On Wed, Sep 26, 2018 at 10:18 PM Diego  wrote:

> Hi drew. Thanks.
> owner:group are ok. Double checked (Linux user since 2003 ;) )
>

IIRC, I jumped on board sometime around the win95 days. I know I did my
first install from floppies...


> Did MySQL backup from source PC using rdadmin
> Then did restore on target PC using rdadmin.
> But not worked. Launched rdadmin from terminal and saw several errors
> about QMYSQL3.
> So logged in into MySQL and were no tables inside Rivendell database!
> Maybe restore is not working with previous versions?
>
> Used command line:
> mysql -u rduser -p letmein -h localhost -D Rivendell < rivendell.sql
>
> Checked tables: ok.
> Ran rdadmin again and now I saw scheme migration message.
> I think is working now.
>

Great.

>
> That's all for now. Next I'll have to figure out how todo use two
> soundcards + jack.
>

I have played around with this some in the past so feel free to run
questions and ideas by me.

all the best,

drew

>
> Thanks again.
> Diego
>
> El mié., 26 de sep. de 2018 19:01, drew Roberts 
> escribió:
>
>>
>>
>> On Wed, Sep 26, 2018 at 3:42 PM Diego  wrote:
>>
>>> Hi, this is my first post. I've tried to search the web on this issue,
>>> but didn't find anything useful. Maybe you can point me in the right path.
>>>
>>> I have a linux distro called 'EterTics' [0]. It's a Frankenstein distro
>>> (sadly), Devuan based, with Rivendell 2.10.3-1 version from tryphon.eu
>>> (not online right now); repos from ubuntu, too messy. I didn't built it.
>>>
>>> It worked fine, but recently we needed to update some packages and seems
>>> RD broked in the process. Macros wont work, neither rmlsend, RDLibrary
>>> crashes first time but second attemp work... sigh... I not looking for a
>>> solution for this.
>>>
>>> I'm already installed Centos7 64bits on another PC following official
>>> instructions and ran rivendell-install script. I plan working with this
>>> stable installation [1]
>>>
>>> My first attemp was export /var/snd and MySQL from original installation
>>> (using rdadmin), and put into this new CentOS. Both PC have same hostname,
>>> same IP (on different location).
>>>
>>> But importing mysql broke RD. I think because I'm trying to move from
>>> rivendell/mysql to different versions.
>>>
>>> Is there a way to move data to new PC? Is there some missing steps I not
>>> doing? I don't want to create carts, nor schedule everything again.
>>>
>>
>> On the new machine:
>>
>> ls -la /var/snd
>>
>> Make a note of this info as after to copy/move files from the old machine
>> you may have to make everything match the owner/group and permission that
>> the new machine wants.
>>
>> Do a Backup Database from rdadmin on the old machine. Do a Restore
>> Database from rdadmin on the new machine. Copy / move all the files from
>> /var/snd on the old machine to /var/snd on the new machine.
>>
>> On the new machine:
>>
>> ls -la /var/snd
>>
>> Do the just copied/moved files match what you had before? If not you need
>> to fix this with chown and chmod.
>>
>>>
>>> Thank you in advance.
>>> Diego Rucci
>>>
>>
>> You are most welcome.
>>
>> all the best,
>>
>> drew
>>
>>
>>>
>>> [0] https://gnuetertics.org/
>>> [1]
>>> http://static.paravelsystems.com/rivendell-install/rivendell-install-rhel7.html
>>>
>>> 
>>> ___
>>> Rivendell-dev mailing list
>>> Rivendell-dev@lists.rivendellaudio.org
>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>>>
>>
>>
>> --
>> Enjoy great *Bahamian Music* at:
>> Bahamian Or Nuttin - http://www.bahamianornuttin.com
>> 
>>
> ___
> Rivendell-dev mailing list
> Rivendell-dev@lists.rivendellaudio.org
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>


-- 
Enjoy great *Bahamian Music* at:
Bahamian Or Nuttin - http://www.bahamianornuttin.com

___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Moving RD to another system

[Diego]

Hi drew. Thanks.
owner:group are ok. Double checked (Linux user since 2003 ;) )
Did MySQL backup from source PC using rdadmin
Then did restore on target PC using rdadmin.
But not worked. Launched rdadmin from terminal and saw several errors about
QMYSQL3.
So logged in into MySQL and were no tables inside Rivendell database!
Maybe restore is not working with previous versions?

Used command line:
mysql -u rduser -p letmein -h localhost -D Rivendell < rivendell.sql

Checked tables: ok.
Ran rdadmin again and now I saw scheme migration message.
I think is working now.

That's all for now. Next I'll have to figure out how todo use two
soundcards + jack.

Thanks again.
Diego

El mié., 26 de sep. de 2018 19:01, drew Roberts 
escribió:

>
>
> On Wed, Sep 26, 2018 at 3:42 PM Diego  wrote:
>
>> Hi, this is my first post. I've tried to search the web on this issue,
>> but didn't find anything useful. Maybe you can point me in the right path.
>>
>> I have a linux distro called 'EterTics' [0]. It's a Frankenstein distro
>> (sadly), Devuan based, with Rivendell 2.10.3-1 version from tryphon.eu
>> (not online right now); repos from ubuntu, too messy. I didn't built it.
>>
>> It worked fine, but recently we needed to update some packages and seems
>> RD broked in the process. Macros wont work, neither rmlsend, RDLibrary
>> crashes first time but second attemp work... sigh... I not looking for a
>> solution for this.
>>
>> I'm already installed Centos7 64bits on another PC following official
>> instructions and ran rivendell-install script. I plan working with this
>> stable installation [1]
>>
>> My first attemp was export /var/snd and MySQL from original installation
>> (using rdadmin), and put into this new CentOS. Both PC have same hostname,
>> same IP (on different location).
>>
>> But importing mysql broke RD. I think because I'm trying to move from
>> rivendell/mysql to different versions.
>>
>> Is there a way to move data to new PC? Is there some missing steps I not
>> doing? I don't want to create carts, nor schedule everything again.
>>
>
> On the new machine:
>
> ls -la /var/snd
>
> Make a note of this info as after to copy/move files from the old machine
> you may have to make everything match the owner/group and permission that
> the new machine wants.
>
> Do a Backup Database from rdadmin on the old machine. Do a Restore
> Database from rdadmin on the new machine. Copy / move all the files from
> /var/snd on the old machine to /var/snd on the new machine.
>
> On the new machine:
>
> ls -la /var/snd
>
> Do the just copied/moved files match what you had before? If not you need
> to fix this with chown and chmod.
>
>>
>> Thank you in advance.
>> Diego Rucci
>>
>
> You are most welcome.
>
> all the best,
>
> drew
>
>
>>
>> [0] https://gnuetertics.org/
>> [1]
>> http://static.paravelsystems.com/rivendell-install/rivendell-install-rhel7.html
>>
>> 
>> ___
>> Rivendell-dev mailing list
>> Rivendell-dev@lists.rivendellaudio.org
>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>>
>
>
> --
> Enjoy great *Bahamian Music* at:
> Bahamian Or Nuttin - http://www.bahamianornuttin.com
> 
>
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Moving RD to another system

[drew Roberts]

On Wed, Sep 26, 2018 at 3:42 PM Diego  wrote:

> Hi, this is my first post. I've tried to search the web on this issue, but
> didn't find anything useful. Maybe you can point me in the right path.
>
> I have a linux distro called 'EterTics' [0]. It's a Frankenstein distro
> (sadly), Devuan based, with Rivendell 2.10.3-1 version from tryphon.eu
> (not online right now); repos from ubuntu, too messy. I didn't built it.
>
> It worked fine, but recently we needed to update some packages and seems
> RD broked in the process. Macros wont work, neither rmlsend, RDLibrary
> crashes first time but second attemp work... sigh... I not looking for a
> solution for this.
>
> I'm already installed Centos7 64bits on another PC following official
> instructions and ran rivendell-install script. I plan working with this
> stable installation [1]
>
> My first attemp was export /var/snd and MySQL from original installation
> (using rdadmin), and put into this new CentOS. Both PC have same hostname,
> same IP (on different location).
>
> But importing mysql broke RD. I think because I'm trying to move from
> rivendell/mysql to different versions.
>
> Is there a way to move data to new PC? Is there some missing steps I not
> doing? I don't want to create carts, nor schedule everything again.
>

On the new machine:

ls -la /var/snd

Make a note of this info as after to copy/move files from the old machine
you may have to make everything match the owner/group and permission that
the new machine wants.

Do a Backup Database from rdadmin on the old machine. Do a Restore Database
from rdadmin on the new machine. Copy / move all the files from /var/snd on
the old machine to /var/snd on the new machine.

On the new machine:

ls -la /var/snd

Do the just copied/moved files match what you had before? If not you need
to fix this with chown and chmod.

>
> Thank you in advance.
> Diego Rucci
>

You are most welcome.

all the best,

drew


>
> [0] https://gnuetertics.org/
> [1]
> http://static.paravelsystems.com/rivendell-install/rivendell-install-rhel7.html
>
> 
> ___
> Rivendell-dev mailing list
> Rivendell-dev@lists.rivendellaudio.org
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>


-- 
Enjoy great *Bahamian Music* at:
Bahamian Or Nuttin - http://www.bahamianornuttin.com

___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev