subject:"\[RDD\] Rivendell v2.16.0"

[RDD] Rivendell v2.16.0 SQL issue (follow up of the Rivendell v2.16.0 topic)

2017-07-12 Thread Pedro Picoto

Here is the result...

pedro@pedro-home ~ $ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> show databases;
++
| Database   |
++
| information_schema |
| mysql  |
| performance_schema |
| sys|
++
4 rows in set (0,02 sec)
###

I'm installing RD on a standalone machine
###
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Rivendell v2.16.0

2017-07-12 Thread Mike Carroll

Every command you enter in the MySQL shell must end with a semi colon.
Otherwise the shell thinks you're continuing the statement, and will issue
another prompt to get the remaining text (that's the "->" at the start of
the line).  If you forget the semi-colon, you can enter it at that
continuation prompt.

I didn't check all of the messages: are you running as a client/server,
where the MySQL server is on another machine?  If that's the case, you may
be having a problem with MySQL authorizations.

On Wed, Jul 12, 2017 at 7:48 AM Pedro Picoto  wrote:

> *When you see the mysql> prompt. That Is where you type show databases and*
> *press enter.  It should return all the database that exist on your
> server.*
>
> Noob here...
>
> But... here's what I get:
>
> mysql> show databases
> ->
>
>  Nothing else...
> ##
>
> On the /etc/rd.conf I have this values:
>
>
> [mySQL]
> ; The connection parameters for the MySQL server.
> Hostname=localhost
> Loginname=rduser
> Password=letmein
> Database=Rivendell
> Driver=QMYSQL3
>
> Are these OK or should they be different? They seem to be defaults...
>
>
>
>
>
>
>
>
>
>
>
>
> On Wed, Jul 12, 2017 at 2:49 PM, Todd Baker  wrote:
>
>> Dear Pedro,
>>
>> You seem to have logged into mysql correctly here ...I assume you gave it
>> a password (WITH PASSWORD)
>> and you got in - because thats when you get the Welcome message..
>>
>>
>> -
>>
> pedro@pedro-home ~ $ mysql -u root -p
>> Enter password: (WITH PASSWORD)
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 15
>> Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)
>>
>> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights
>> reserved.
>>
>> Oracle is a registered trademark of Oracle Corporation and/or its
>> affiliates. Other names may be trademarks of their respective
>> owners.
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>> statement.
>>
>> mysql>
>>
>
>> --
>>
>> When you see the mysql> prompt. That Is where you type show databases and
>> press enter.  It should return all the database that exist on your server.
>>
>> Are you getting in with a password or am I confused about your output
>> Todd
>>
>>
>>
>> --
>> *From: *"Pedro Picoto" 
>> *To: *"Todd Baker" 
>> *Cc: *"drew Roberts" , "User discussion about the
>> Rivendell Radio Automation System" <
>> rivendell-dev@lists.rivendellaudio.org>
>> *Sent: *Wednesday, July 12, 2017 9:29:36 AM
>>
>
>> *Subject: *Re: [RDD] Rivendell v2.16.0
>>
>
>> Todd, thanks for the input.
>> I do believe that I'm making a pretty mess around this.
>>
>> I actually removed/purged mysql and reinstalled it with "sudo apt -y
>> install apache2 mysql-server"
>> The usual DOS look password request popped and I introduced/reintroduced
>> the password wich is the same (my option) I'm using on my #
>>
>> ##
>> Here is the current status:
>>
>> pedro@pedro-home ~ $ systemctl status mysql.service
>> ● mysql.service - MySQL Community Server
>>Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor
>> preset: en
>>Active: active (running) since Qua 2017-07-12 13:24:45 WEST; 17min ago
>>   Process: 22931 ExecStartPost=/usr/share/mysql/mysql-systemd-start post
>> (code=e
>>   Process: 22921 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre
>> (code=exi
>>  Main PID: 22930 (mysqld)
>>CGroup: /system.slice/mysql.service
>>└─22930 /usr/sbin/mysqld
>>
>> Jul 12 13:24:44 pedro-home systemd[1]: Starting MySQL Community Server...
>> Jul 12 13:24:45 pedro-home systemd[1]: Started MySQL Community Server.
>> Jul 12 13:39:04 pedro-home systemd[1]: Started MySQL Community Server.
>> l
>>
>> pedro@pedro-home ~ $ mysqladmin -p -u root version
>> Enter password: (WITH PASSWORD)
>> mysqladmin  Ver 8.42 Distrib 5.7.18, for Linux on x86_64

Re: [RDD] Rivendell v2.16.0

2017-07-12 Thread Pedro Picoto

*When you see the mysql> prompt. That Is where you type show databases and*
*press enter.  It should return all the database that exist on your server.*

Noob here...

But... here's what I get:

mysql> show databases
->

 Nothing else...
##

On the /etc/rd.conf I have this values:

[mySQL]
; The connection parameters for the MySQL server.
Hostname=localhost
Loginname=rduser
Password=letmein
Database=Rivendell
Driver=QMYSQL3

Are these OK or should they be different? They seem to be defaults...












On Wed, Jul 12, 2017 at 2:49 PM, Todd Baker  wrote:

> Dear Pedro,
>
> You seem to have logged into mysql correctly here ...I assume you gave it
> a password (WITH PASSWORD)
> and you got in - because thats when you get the Welcome message..
>
> 
> -
>
> pedro@pedro-home ~ $ mysql -u root -p
> Enter password: (WITH PASSWORD)
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 15
> Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)
>
> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights
> reserved.
>
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> mysql>
> 
> --
>
> When you see the mysql> prompt. That Is where you type show databases and
> press enter.  It should return all the database that exist on your server.
>
> Are you getting in with a password or am I confused about your output
> Todd
>
>
>
> --
> *From: *"Pedro Picoto" 
> *To: *"Todd Baker" 
> *Cc: *"drew Roberts" , "User discussion about the
> Rivendell Radio Automation System"  >
> *Sent: *Wednesday, July 12, 2017 9:29:36 AM
>
> *Subject: *Re: [RDD] Rivendell v2.16.0
>
> Todd, thanks for the input.
> I do believe that I'm making a pretty mess around this.
>
> I actually removed/purged mysql and reinstalled it with "sudo apt -y
> install apache2 mysql-server"
> The usual DOS look password request popped and I introduced/reintroduced
> the password wich is the same (my option) I'm using on my #
> 
> ##
> Here is the current status:
>
> pedro@pedro-home ~ $ systemctl status mysql.service
> ● mysql.service - MySQL Community Server
>Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor
> preset: en
>Active: active (running) since Qua 2017-07-12 13:24:45 WEST; 17min ago
>   Process: 22931 ExecStartPost=/usr/share/mysql/mysql-systemd-start post
> (code=e
>   Process: 22921 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre
> (code=exi
>  Main PID: 22930 (mysqld)
>CGroup: /system.slice/mysql.service
>└─22930 /usr/sbin/mysqld
>
> Jul 12 13:24:44 pedro-home systemd[1]: Starting MySQL Community Server...
> Jul 12 13:24:45 pedro-home systemd[1]: Started MySQL Community Server.
> Jul 12 13:39:04 pedro-home systemd[1]: Started MySQL Community Server.
> l
>
> pedro@pedro-home ~ $ mysqladmin -p -u root version
> Enter password: (WITH PASSWORD)
> mysqladmin  Ver 8.42 Distrib 5.7.18, for Linux on x86_64
> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights
> reserved.
>
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
>
> Server version5.7.18-0ubuntu0.16.04.1
> Protocol version10
> ConnectionLocalhost via UNIX socket
> UNIX socket/var/run/mysqld/mysqld.sock
> Uptime:14 min 36 sec
>
> Threads: 1  Questions: 12  Slow queries: 0  Opens: 115  Flush tables: 1
> Open tables: 34  Queries per second avg: 0.013
> 
> ##
>
> pedro@pedro-home ~ $ mysql> show databases
> ERROR 1045 (28000): Access denied for user 'pedro'@'localhost' (using
> password: NO)
> 
> 
>
> pedro@pedro-home ~ $ mysql -u root -p
> Enter password: (WITH PASSWORD)
> Welcome to t

Re: [RDD] Rivendell v2.16.0

2017-07-12 Thread Todd Baker

Dear Pedro, 

You seem to have logged into mysql correctly here ...I assume you gave it a 
password (WITH PASSWORD) 
and you got in - because thats when you get the Welcome message.. 

- 

pedro@pedro-home ~ $ mysql -u root -p 
Enter password: (WITH PASSWORD) 
Welcome to the MySQL monitor. Commands end with ; or \g. 
Your MySQL connection id is 15 
Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu) 

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. 

Oracle is a registered trademark of Oracle Corporation and/or its 
affiliates. Other names may be trademarks of their respective 
owners. 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 

mysql> 
--
 

When you see the mysql> prompt. That Is where you type show databases and 
press enter. It should return all the database that exist on your server. 

Are you getting in with a password or am I confused about your output 
Todd 


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

Re: [RDD] Rivendell v2.16.0

2017-07-12 Thread Pedro Picoto

Todd, thanks for the input.
I do believe that I'm making a pretty mess around this.

I actually removed/purged mysql and reinstalled it with "sudo apt -y
install apache2 mysql-server"
The usual DOS look password request popped and I introduced/reintroduced
the password wich is the same (my option) I'm using on my #

##
Here is the current status:

pedro@pedro-home ~ $ systemctl status mysql.service
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor
preset: en
   Active: active (running) since Qua 2017-07-12 13:24:45 WEST; 17min ago
  Process: 22931 ExecStartPost=/usr/share/mysql/mysql-systemd-start post
(code=e
  Process: 22921 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre
(code=exi
 Main PID: 22930 (mysqld)
   CGroup: /system.slice/mysql.service
   └─22930 /usr/sbin/mysqld

Jul 12 13:24:44 pedro-home systemd[1]: Starting MySQL Community Server...
Jul 12 13:24:45 pedro-home systemd[1]: Started MySQL Community Server.
Jul 12 13:39:04 pedro-home systemd[1]: Started MySQL Community Server.
l

pedro@pedro-home ~ $ mysqladmin -p -u root version
Enter password: (WITH PASSWORD)
mysqladmin  Ver 8.42 Distrib 5.7.18, for Linux on x86_64
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version5.7.18-0ubuntu0.16.04.1
Protocol version10
ConnectionLocalhost via UNIX socket
UNIX socket/var/run/mysqld/mysqld.sock
Uptime:14 min 36 sec

Threads: 1  Questions: 12  Slow queries: 0  Opens: 115  Flush tables: 1
Open tables: 34  Queries per second avg: 0.013
##

pedro@pedro-home ~ $ mysql> show databases
ERROR 1045 (28000): Access denied for user 'pedro'@'localhost' (using
password: NO)


pedro@pedro-home ~ $ mysql -u root -p
Enter password: (WITH PASSWORD)
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql>



pedro@pedro-home ~ $ mysql -u root -p
Enter password: (BLANK)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
#




I might be wrong but can this be Ubuntu messing around?









On Wed, Jul 12, 2017 at 12:37 PM, Todd Baker  wrote:

> Dear Pedro,
>Just want to chime in to make sure we are on the right page (same
> page?).
>
> There is a difference between the System root user, and the mysql root
> user.  The
> default password for root when you create a new mysql server is NOTHING
> (null).
>
> So,  if you are using a brand new installation of mysql and you type
>mysql -u root -p
>   Enter Password   
>
> If it is brand new - and you press enter (no password) - you should get
> something like
>Welcome to MySql  (blah Blah).. (or Welcome to MaraidDB (blah
> Blah)...on my machine).
> Note:  No Password  when it is brand new install
>
> So,  if you are getting a password challenge, and null (no password)
> doesn't work,
> probably not a brand new installation of mysql - me thinks.
>
> If blank password does work, then type
>show databases and try to do what Drew said below.
>
> Hope you have success..
>
> Todd Baker
> --
> *From: *"Pedro Picoto" 
> *To: *"drew Roberts" 
> *Cc: *"User discussion about the Rivendell Radio Automation System" <
> rivendell-dev@lists.rivendellaudio.org>
> *Sent: *Wednesday, July 12, 2017 12:00:21 AM
> *Subject: *Re: [RDD] Rivendell v2.16.0
>
> My bad!!!
>
> Upon mysql -u root -p:
> I'VE entered my root password and NOW I got the "mysql: [Warning] Using a
> password on the command line interface can be insecure.
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)"
> *AND this is new

Re: [RDD] Rivendell v2.16.0

2017-07-12 Thread Todd Baker

Dear Pedro, 
Just want to chime in to make sure we are on the right page (same page?). 

There is a difference between the System root user, and the mysql root user. 
The 
default password for root when you create a new mysql server is NOTHING (null). 

So, if you are using a brand new installation of mysql and you type 
mysql -u root -p 
Enter Password  

If it is brand new - and you press enter (no password) - you should get 
something like 
Welcome to MySql (blah Blah).. (or Welcome to MaraidDB (blah Blah)...on my 
machine). 
Note: No Password when it is brand new install 

So, if you are getting a password challenge, and null (no password) doesn't 
work, 
probably not a brand new installation of mysql - me thinks. 

If blank password does work, then type 
show databases and try to do what Drew said below. 

Hope you have success.. 

Todd Baker 

From: "Pedro Picoto"  
To: "drew Roberts"  
Cc: "User discussion about the Rivendell Radio Automation System" 
 
Sent: Wednesday, July 12, 2017 12:00:21 AM 
Subject: Re: [RDD] Rivendell v2.16.0 

My bad!!! 

Upon mysql -u root -p : 
I'VE entered my root password and NOW I got the "mysql: [Warning] Using a 
password on the command line interface can be insecure. 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
YES)" AND this is new to me. B4 I had the list of \* commands. 

Meanwhile: 
On /etc/rd.conf I have this: 

[mySQL] 
; The connection parameters for the MySQL server. 
Hostname=localhost 
Loginname=rduser 
Password=letmein 
Database=Rivendell 
Driver=QMYSQL3 

Regarding Matthew's suggestion... will a RH script run on Debian (Ubuntu)? 

It's 5am here... i have to take some rest. Thank you all! 



On Wed, Jul 12, 2017 at 3:37 AM, drew Roberts < zotz...@gmail.com > wrote: 



Pedro, 

On Tue, Jul 11, 2017 at 8:49 PM, Pedro Picoto < pedro.pic...@gmail.com > wrote: 

BQ_BEGIN

Back home... here's what I've got: 

Upon sql> show databases. 
ERROR 1045 (28000): Access denied for user 'pedro'@'localhost' (using password: 
NO) 

Upon mysql -u root -p get a password request wich shows: 



Pedro, I think you are giving incomplete information which may cause trouble. 

You say you get a password request but you don't indicate that you enter one. I 
am assuming that you did. If not, tell us because that may imply something 
else. 


BQ_BEGIN

Welcome to the MySQL monitor. Commands end with ; or \g. 
Your MySQL connection id is 25 
Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu) 

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. 

Oracle is a registered trademark of Oracle Corporation and/or its 
affiliates. Other names may be trademarks of their respective 
owners. 

Upon mysql> \r: 

Connection id: 27 
Current database: *** NONE *** 

BQ_END

at this point, enter: 

show databases; -> like so: 

mysql> show databases; 

Look for Rivendell as I explained. 

If you see it, drop it, exit mysql, and then run rdadmin. 

Enter root and the root password I assumed you entered above. 

This will create a Rivendell database. 

Go back into mysql: 

mysql -u root -p 

enter that assumed root password, then: 

show databases; 

and now you should see Rivendell 

Let us know either way. 

BQ_BEGIN


I have a RD db backup from a previous system... can I impose it to this setup, 
if so, how? 

BQ_END

If we get to success as above, we can test that the test tone plays and then 
work on restoring an old database. 

all the best, 

drew 


BQ_BEGIN












pedro-home pedro # mysql -u root -p 
Enter password: 
Welcome to the MySQL monitor. Commands end with ; or \g. 
Your MySQL connection id is 25 
Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu) 

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. 

Oracle is a registered trademark of Oracle Corporation and/or its 
affiliates. Other names may be trademarks of their respective 
owners. 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 



On Tue, Jul 11, 2017 at 10:07 PM, drew Roberts < zotz...@gmail.com > wrote: 

BQ_BEGIN

Pedro, 

On Tue, Jul 11, 2017 at 1:49 PM, Pedro Picoto < pedro.pic...@gmail.com > wrote: 

BQ_BEGIN

I'm not at my pc... from memory when I " mysql -uroot -p" I'm not asked for any 
password. All I get is a sort o list of "\*" commands... 

BQ_END

That would mean there is not root password for mysql. 

try: 

mysql> show databases; 

do you see a Rivendell database? 

If so, and this machine has never been running before, and if perhaps you have 
backup from another system, drop it and run rdadmin. 

When it runs, try putting in root as a user and leaving the password blank. 

Then come back and see if you have a Rivendell database. 

all the best, 

drew 

BQ_BEGIN


On Tue,

Re: [RDD] Rivendell v2.16.0

2017-07-11 Thread Pedro Picoto

My bad!!!

Upon mysql -u root -p:
I'VE entered my root password and NOW I got the "mysql: [Warning] Using a
password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)"
*AND this is new to me. B4 I had the list of  \* commands.*
Meanwhile:
On /etc/rd.conf I have this:

[mySQL]
; The connection parameters for the MySQL server.
Hostname=localhost
Loginname=rduser
Password=letmein
Database=Rivendell
Driver=QMYSQL3

Regarding Matthew's suggestion... will a RH script run on Debian (Ubuntu)?

It's 5am here... i have to take some rest. Thank you all!



On Wed, Jul 12, 2017 at 3:37 AM, drew Roberts  wrote:

> Pedro,
>
> On Tue, Jul 11, 2017 at 8:49 PM, Pedro Picoto 
> wrote:
>
>> Back home... here's what I've got:
>>
>> Upon sql> show databases.
>> ERROR 1045 (28000): Access denied for user 'pedro'@'localhost' (using
>> password: NO)
>>
>> Upon mysql -u root -p get a password request wich shows:
>>
>
> Pedro, I think you are giving incomplete information which may cause
> trouble.
>
> You say you get a password request but you don't indicate that you enter
> one. I am assuming that you did. If not, tell us because that may imply
> something else.
>
>
>
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 25
>> Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)
>>
>> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights
>> reserved.
>>
>> Oracle is a registered trademark of Oracle Corporation and/or its
>> affiliates. Other names may be trademarks of their respective
>> owners.
>>
>> Upon mysql> \r:
>>
>> Connection id:27
>> Current database: *** NONE ***
>>
>
> at this point, enter:
>
> show databases; -> like so:
>
> mysql> show databases;
>
> Look for Rivendell as I explained.
>
> If you see it, drop it, exit mysql, and then run rdadmin.
>
> Enter root and the root password I assumed you entered above.
>
> This will create a Rivendell database.
>
> Go back into mysql:
>
> mysql -u root -p
>
> enter that assumed root password, then:
>
> show databases;
>
> and now you should see Rivendell
>
> Let us know either way.
>
>>
>> I have a RD db backup from a previous system... can I impose it to this
>> setup, if so, how?
>>
>
> If we get to success as above, we can test that the test tone plays and
> then work on restoring an old database.
>
> all the best,
>
> drew
>
>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> pedro-home pedro # mysql -u root -p
>> Enter password:
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 25
>> Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)
>>
>> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights
>> reserved.
>>
>> Oracle is a registered trademark of Oracle Corporation and/or its
>> affiliates. Other names may be trademarks of their respective
>> owners.
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>> statement.
>>
>>
>>
>> On Tue, Jul 11, 2017 at 10:07 PM, drew Roberts  wrote:
>>
>>> Pedro,
>>>
>>> On Tue, Jul 11, 2017 at 1:49 PM, Pedro Picoto 
>>> wrote:
>>>
 I'm not at my pc... from memory when I " mysql -uroot -p" I'm not asked
 for any password. All I get is a sort o list of  "\*" commands...

>>>
>>> That would mean there is not root password for mysql.
>>>
>>> try:
>>>
>>>  mysql> show databases;
>>>
>>> do you see a Rivendell database?
>>>
>>> If so, and this machine has never been running before, and if perhaps
>>> you have  backup from another system, drop it and run rdadmin.
>>>
>>> When it runs, try putting in root as a user and leaving the password
>>> blank.
>>>
>>> Then come back and see if you have a Rivendell database.
>>>
>>> all the best,
>>>
>>> drew
>>>

 On Tue, Jul 11, 2017 at 6:03 PM, Rob Landry <41001...@interpring.com>
 wrote:

>
> Do you have all the relevant MySQL packages installed?
>
> Have you assigned a password to the MySQL root user?
>
> What happens if you type:
>
> mysql -uroot -p[whatever]
>
> If that comand works, you should be able to give mysqladmin 'root' and
> whatever password you assigned the MySQL root user, and it should create a
> database.
>
>
> Rob
>
> --
> Я там, где ребята толковые,
> Я там, где плакаты "Вперёд",
> Где песни рабочие новые
> Страна трудовая поёт.
>
>
> On Tue, 11 Jul 2017, Pedro Picoto wrote:
>
> Long time no see...
>> Since the end(?)  of Tryphon's Ubuntu "just add water" Rivendell fork
>> I have
>> "quit" from RD... untill I start missing it.
>> I'm on a stage of compiling from source on a already running Mint
>> 18.1.
>>
>> I'm using this tutorial:
>> http://rivendell.tryphon.org/wiki/UbuntuXenial
>>
>> Issues so far:
>> - RDADMIN: "Unable to connect to mysql", thus unable to create a new
>> DB.
>>
>> Also:
>> pedro-

Re: [RDD] Rivendell v2.16.0

2017-07-11 Thread drew Roberts

Pedro,

On Tue, Jul 11, 2017 at 8:49 PM, Pedro Picoto 
wrote:

> Back home... here's what I've got:
>
> Upon sql> show databases.
> ERROR 1045 (28000): Access denied for user 'pedro'@'localhost' (using
> password: NO)
>
> Upon mysql -u root -p get a password request wich shows:
>

Pedro, I think you are giving incomplete information which may cause
trouble.

You say you get a password request but you don't indicate that you enter
one. I am assuming that you did. If not, tell us because that may imply
something else.



> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 25
> Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)
>
> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights
> reserved.
>
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
>
> Upon mysql> \r:
>
> Connection id:27
> Current database: *** NONE ***
>

at this point, enter:

show databases; -> like so:

mysql> show databases;

Look for Rivendell as I explained.

If you see it, drop it, exit mysql, and then run rdadmin.

Enter root and the root password I assumed you entered above.

This will create a Rivendell database.

Go back into mysql:

mysql -u root -p

enter that assumed root password, then:

show databases;

and now you should see Rivendell

Let us know either way.

>
> I have a RD db backup from a previous system... can I impose it to this
> setup, if so, how?
>

If we get to success as above, we can test that the test tone plays and
then work on restoring an old database.

all the best,

drew


>
>
>
>
>
>
>
>
>
>
> pedro-home pedro # mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 25
> Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)
>
> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights
> reserved.
>
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
>
>
> On Tue, Jul 11, 2017 at 10:07 PM, drew Roberts  wrote:
>
>> Pedro,
>>
>> On Tue, Jul 11, 2017 at 1:49 PM, Pedro Picoto 
>> wrote:
>>
>>> I'm not at my pc... from memory when I " mysql -uroot -p" I'm not asked
>>> for any password. All I get is a sort o list of  "\*" commands...
>>>
>>
>> That would mean there is not root password for mysql.
>>
>> try:
>>
>>  mysql> show databases;
>>
>> do you see a Rivendell database?
>>
>> If so, and this machine has never been running before, and if perhaps you
>> have  backup from another system, drop it and run rdadmin.
>>
>> When it runs, try putting in root as a user and leaving the password
>> blank.
>>
>> Then come back and see if you have a Rivendell database.
>>
>> all the best,
>>
>> drew
>>
>>>
>>> On Tue, Jul 11, 2017 at 6:03 PM, Rob Landry <41001...@interpring.com>
>>> wrote:
>>>

 Do you have all the relevant MySQL packages installed?

 Have you assigned a password to the MySQL root user?

 What happens if you type:

 mysql -uroot -p[whatever]

 If that comand works, you should be able to give mysqladmin 'root' and
 whatever password you assigned the MySQL root user, and it should create a
 database.


 Rob

 --
 Я там, где ребята толковые,
 Я там, где плакаты "Вперёд",
 Где песни рабочие новые
 Страна трудовая поёт.


 On Tue, 11 Jul 2017, Pedro Picoto wrote:

 Long time no see...
> Since the end(?)  of Tryphon's Ubuntu "just add water" Rivendell fork
> I have
> "quit" from RD... untill I start missing it.
> I'm on a stage of compiling from source on a already running Mint 18.1.
>
> I'm using this tutorial:
> http://rivendell.tryphon.org/wiki/UbuntuXenial
>
> Issues so far:
> - RDADMIN: "Unable to connect to mysql", thus unable to create a new
> DB.
>
> Also:
> pedro-home rivendell-2.16.0 # patch /rdadmin/opendb.cpp
> opendb.cpp.patch
> patching file /rdadmin/opendb.cpp
> Hunk #1 FAILED at 240.
> patch:  Can't reopen file /rdadmin/opendb.cpp : No such file or
> directory
>
> pedro-home rivendell-2.16.0 # patch /rdadmin/createdb.cpp
> createdb.cpp-instance.patch
> patching file /rdadmin/createdb.cpp
> Hunk #1 FAILED at 1241.
> Hunk #2 FAILED at 1353.
> Hunk #3 FAILED at 1773.
> Hunk #4 FAILED at 1808.
> patch:  Can't reopen file /rdadmin/createdb.cpp : No such file or
> directory
>
> I don't know if the patch problem (wich I might be doing something
> wrong)
> can be related to the "Unable to connect to mysql"
>
> QUESTION; What should be the (RDADMIN) Username and password for a
> compiled
> from source? I'm using "root/root" with no success
>
>

Re: [RDD] Rivendell v2.16.0

2017-07-11 Thread Pedro Picoto

Complementary info (if usefull):

The /etc/rd.conf shows:

[Identity]
; These entries are used to define the system user and group that will
; own the audio files.
AudioOwner=pedro
AudioGroup=rivendell

; This password is used by the various Rivendell modules to log into
; Rivendell system services [caed(8), ripcd(8), rdcatchd(8)].
Password=letmein

; This entry is what will appear in RDSelect's list for this configuration.
Label=Default (Local)

[mySQL]
; The connection parameters for the MySQL server.
Hostname=localhost
Loginname=rduser
Password=letmein
Database=Rivendell
Driver=QMYSQL3


On Wed, Jul 12, 2017 at 1:49 AM, Pedro Picoto 
wrote:

> Back home... here's what I've got:
>
> Upon sql> show databases.
> ERROR 1045 (28000): Access denied for user 'pedro'@'localhost' (using
> password: NO)
>
> Upon mysql -u root -p get a password request wich shows:
>
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 25
> Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)
>
> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights
> reserved.
>
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
>
> Upon mysql> \r:
>
> Connection id:27
> Current database: *** NONE ***
>
> I have a RD db backup from a previous system... can I impose it to this
> setup, if so, how?
>
>
>
>
>
>
>
>
>
>
>
> pedro-home pedro # mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 25
> Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)
>
> Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights
> reserved.
>
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
>
>
> On Tue, Jul 11, 2017 at 10:07 PM, drew Roberts  wrote:
>
>> Pedro,
>>
>> On Tue, Jul 11, 2017 at 1:49 PM, Pedro Picoto 
>> wrote:
>>
>>> I'm not at my pc... from memory when I " mysql -uroot -p" I'm not asked
>>> for any password. All I get is a sort o list of  "\*" commands...
>>>
>>
>> That would mean there is not root password for mysql.
>>
>> try:
>>
>>  mysql> show databases;
>>
>> do you see a Rivendell database?
>>
>> If so, and this machine has never been running before, and if perhaps you
>> have  backup from another system, drop it and run rdadmin.
>>
>> When it runs, try putting in root as a user and leaving the password
>> blank.
>>
>> Then come back and see if you have a Rivendell database.
>>
>> all the best,
>>
>> drew
>>
>>>
>>> On Tue, Jul 11, 2017 at 6:03 PM, Rob Landry <41001...@interpring.com>
>>> wrote:
>>>

 Do you have all the relevant MySQL packages installed?

 Have you assigned a password to the MySQL root user?

 What happens if you type:

 mysql -uroot -p[whatever]

 If that comand works, you should be able to give mysqladmin 'root' and
 whatever password you assigned the MySQL root user, and it should create a
 database.


 Rob

 --
 Я там, где ребята толковые,
 Я там, где плакаты "Вперёд",
 Где песни рабочие новые
 Страна трудовая поёт.


 On Tue, 11 Jul 2017, Pedro Picoto wrote:

 Long time no see...
> Since the end(?)  of Tryphon's Ubuntu "just add water" Rivendell fork
> I have
> "quit" from RD... untill I start missing it.
> I'm on a stage of compiling from source on a already running Mint 18.1.
>
> I'm using this tutorial:
> http://rivendell.tryphon.org/wiki/UbuntuXenial
>
> Issues so far:
> - RDADMIN: "Unable to connect to mysql", thus unable to create a new
> DB.
>
> Also:
> pedro-home rivendell-2.16.0 # patch /rdadmin/opendb.cpp
> opendb.cpp.patch
> patching file /rdadmin/opendb.cpp
> Hunk #1 FAILED at 240.
> patch:  Can't reopen file /rdadmin/opendb.cpp : No such file or
> directory
>
> pedro-home rivendell-2.16.0 # patch /rdadmin/createdb.cpp
> createdb.cpp-instance.patch
> patching file /rdadmin/createdb.cpp
> Hunk #1 FAILED at 1241.
> Hunk #2 FAILED at 1353.
> Hunk #3 FAILED at 1773.
> Hunk #4 FAILED at 1808.
> patch:  Can't reopen file /rdadmin/createdb.cpp : No such file or
> directory
>
> I don't know if the patch problem (wich I might be doing something
> wrong)
> can be related to the "Unable to connect to mysql"
>
> QUESTION; What should be the (RDADMIN) Username and password for a
> compiled
> from source? I'm using "root/root" with no success
>
>
> The database is apparentely ok. I've checked on the terminal it with no
> errors returned.
>
> Hints?... TIA!
>
>
>
>
>
>
> On Fri, Jun 2, 2017 at 1:47 PM, Fred Gleason  >
>

Re: [RDD] Rivendell v2.16.0

2017-07-11 Thread Pedro Picoto

Back home... here's what I've got:

Upon sql> show databases.
ERROR 1045 (28000): Access denied for user 'pedro'@'localhost' (using
password: NO)

Upon mysql -u root -p get a password request wich shows:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Upon mysql> \r:

Connection id:27
Current database: *** NONE ***

I have a RD db backup from a previous system... can I impose it to this
setup, if so, how?

pedro-home pedro # mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.7.18-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

On Tue, Jul 11, 2017 at 10:07 PM, drew Roberts  wrote:

> Pedro,
>
> On Tue, Jul 11, 2017 at 1:49 PM, Pedro Picoto 
> wrote:
>
>> I'm not at my pc... from memory when I " mysql -uroot -p" I'm not asked
>> for any password. All I get is a sort o list of  "\*" commands...
>>
>
> That would mean there is not root password for mysql.
>
> try:
>
>  mysql> show databases;
>
> do you see a Rivendell database?
>
> If so, and this machine has never been running before, and if perhaps you
> have  backup from another system, drop it and run rdadmin.
>
> When it runs, try putting in root as a user and leaving the password blank.
>
> Then come back and see if you have a Rivendell database.
>
> all the best,
>
> drew
>
>>
>> On Tue, Jul 11, 2017 at 6:03 PM, Rob Landry <41001...@interpring.com>
>> wrote:
>>
>>>
>>> Do you have all the relevant MySQL packages installed?
>>>
>>> Have you assigned a password to the MySQL root user?
>>>
>>> What happens if you type:
>>>
>>> mysql -uroot -p[whatever]
>>>
>>> If that comand works, you should be able to give mysqladmin 'root' and
>>> whatever password you assigned the MySQL root user, and it should create a
>>> database.
>>>
>>>
>>> Rob
>>>
>>> --
>>> Я там, где ребята толковые,
>>> Я там, где плакаты "Вперёд",
>>> Где песни рабочие новые
>>> Страна трудовая поёт.
>>>
>>>
>>> On Tue, 11 Jul 2017, Pedro Picoto wrote:
>>>
>>> Long time no see...
 Since the end(?)  of Tryphon's Ubuntu "just add water" Rivendell fork I
 have
 "quit" from RD... untill I start missing it.
 I'm on a stage of compiling from source on a already running Mint 18.1.

 I'm using this tutorial:
 http://rivendell.tryphon.org/wiki/UbuntuXenial

 Issues so far:
 - RDADMIN: "Unable to connect to mysql", thus unable to create a new DB.

 Also:
 pedro-home rivendell-2.16.0 # patch /rdadmin/opendb.cpp opendb.cpp.patch
 patching file /rdadmin/opendb.cpp
 Hunk #1 FAILED at 240.
 patch:  Can't reopen file /rdadmin/opendb.cpp : No such file or
 directory

 pedro-home rivendell-2.16.0 # patch /rdadmin/createdb.cpp
 createdb.cpp-instance.patch
 patching file /rdadmin/createdb.cpp
 Hunk #1 FAILED at 1241.
 Hunk #2 FAILED at 1353.
 Hunk #3 FAILED at 1773.
 Hunk #4 FAILED at 1808.
 patch:  Can't reopen file /rdadmin/createdb.cpp : No such file or
 directory

 I don't know if the patch problem (wich I might be doing something
 wrong)
 can be related to the "Unable to connect to mysql"

 QUESTION; What should be the (RDADMIN) Username and password for a
 compiled
 from source? I'm using "root/root" with no success

 The database is apparentely ok. I've checked on the terminal it with no
 errors returned.

 Hints?... TIA!

 On Fri, Jun 2, 2017 at 1:47 PM, Fred Gleason 
 wrote:
   On behalf of the entire Rivendell development team, I'm pleased
   to announce the availability of Rivendell v2.16.0.  Rivendell is
   a full-featured radio automation system targeted for use in
   professional broadcast environments. It is available under the
   GNU General Public License.

   From the NEWS file:*** snip snip ***
 Changes:
Audio Store Hashing. Rivendell now automatically generates a SHA1
 hash
for each file in the audio store and records this value in the
 database,
thus permitting automated recovery of audio in the event of loss or
 damage
to the audio store's filesystem directory. See the --relink-audio
 option
in the rddbcheck(8) man page for details.

Kernel GPIO. Added switcher support for Kernel G

Re: [RDD] Rivendell v2.16.0

2017-07-11 Thread drew Roberts

Pedro,

On Tue, Jul 11, 2017 at 1:49 PM, Pedro Picoto 
wrote:

> I'm not at my pc... from memory when I " mysql -uroot -p" I'm not asked
> for any password. All I get is a sort o list of  "\*" commands...
>

That would mean there is not root password for mysql.

try:

 mysql> show databases;

do you see a Rivendell database?

If so, and this machine has never been running before, and if perhaps you
have  backup from another system, drop it and run rdadmin.

When it runs, try putting in root as a user and leaving the password blank.

Then come back and see if you have a Rivendell database.

all the best,

drew

>
> On Tue, Jul 11, 2017 at 6:03 PM, Rob Landry <41001...@interpring.com>
> wrote:
>
>>
>> Do you have all the relevant MySQL packages installed?
>>
>> Have you assigned a password to the MySQL root user?
>>
>> What happens if you type:
>>
>> mysql -uroot -p[whatever]
>>
>> If that comand works, you should be able to give mysqladmin 'root' and
>> whatever password you assigned the MySQL root user, and it should create a
>> database.
>>
>>
>> Rob
>>
>> --
>> Я там, где ребята толковые,
>> Я там, где плакаты "Вперёд",
>> Где песни рабочие новые
>> Страна трудовая поёт.
>>
>>
>> On Tue, 11 Jul 2017, Pedro Picoto wrote:
>>
>> Long time no see...
>>> Since the end(?)  of Tryphon's Ubuntu "just add water" Rivendell fork I
>>> have
>>> "quit" from RD... untill I start missing it.
>>> I'm on a stage of compiling from source on a already running Mint 18.1.
>>>
>>> I'm using this tutorial:
>>> http://rivendell.tryphon.org/wiki/UbuntuXenial
>>>
>>> Issues so far:
>>> - RDADMIN: "Unable to connect to mysql", thus unable to create a new DB.
>>>
>>> Also:
>>> pedro-home rivendell-2.16.0 # patch /rdadmin/opendb.cpp opendb.cpp.patch
>>> patching file /rdadmin/opendb.cpp
>>> Hunk #1 FAILED at 240.
>>> patch:  Can't reopen file /rdadmin/opendb.cpp : No such file or
>>> directory
>>>
>>> pedro-home rivendell-2.16.0 # patch /rdadmin/createdb.cpp
>>> createdb.cpp-instance.patch
>>> patching file /rdadmin/createdb.cpp
>>> Hunk #1 FAILED at 1241.
>>> Hunk #2 FAILED at 1353.
>>> Hunk #3 FAILED at 1773.
>>> Hunk #4 FAILED at 1808.
>>> patch:  Can't reopen file /rdadmin/createdb.cpp : No such file or
>>> directory
>>>
>>> I don't know if the patch problem (wich I might be doing something wrong)
>>> can be related to the "Unable to connect to mysql"
>>>
>>> QUESTION; What should be the (RDADMIN) Username and password for a
>>> compiled
>>> from source? I'm using "root/root" with no success
>>>
>>>
>>> The database is apparentely ok. I've checked on the terminal it with no
>>> errors returned.
>>>
>>> Hints?... TIA!
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Fri, Jun 2, 2017 at 1:47 PM, Fred Gleason 
>>> wrote:
>>>   On behalf of the entire Rivendell development team, I'm pleased
>>>   to announce the availability of Rivendell v2.16.0.  Rivendell is
>>>   a full-featured radio automation system targeted for use in
>>>   professional broadcast environments. It is available under the
>>>   GNU General Public License.
>>>
>>>   From the NEWS file:*** snip snip ***
>>> Changes:
>>>Audio Store Hashing. Rivendell now automatically generates a SHA1
>>> hash
>>>for each file in the audio store and records this value in the
>>> database,
>>>thus permitting automated recovery of audio in the event of loss or
>>> damage
>>>to the audio store's filesystem directory. See the --relink-audio
>>> option
>>>in the rddbcheck(8) man page for details.
>>>
>>>Kernel GPIO. Added switcher support for Kernel GPIO devices, such
>>> as
>>>the GPIO interface on the Raspberry Pi 2 and 3.
>>>
>>>Modbus TCP. Added switcher support for Modbus TCP devices.
>>>
>>>RDConvert. Added an rdconvert(1) utility,
>>>
>>>User Authentication. It is now possible to delegate authentication
>>> of
>>>Rivendell users by means of a PAM module, thus permitting 'single
>>> sign-on'
>>>integration with systems such as ActiveDirectory and FreeIPA.
>>>
>>>Web API. Added various methods to the Rivendell Web API to permit
>>>integration with external audio and log editors.
>>>
>>>Various other bug fixes.  See the ChangeLog for details.
>>>
>>> Database Update:
>>>This version of Rivendell uses database schema version 263, and
>>> will
>>>automatically upgrade any earlier versions.  To see the current
>>> schema
>>>version prior to upgrade, see RDAdmin->SystemInfo.
>>>
>>>As always, be sure to run RDAdmin immediately after upgrading to
>>> allow
>>>any necessary changes to the database schema to be applied.
>>>
>>> *** snip snip ***
>>>
>>> Further information, screenshots and download links are available at:
>>>
>>> http://www.rivendellaudio.org
>>>
>>> Cheers!
>>>
>>>
>>> |--|
>>> | Frederick F. Gleason, Jr. |  Chief Developer
>>> |
>>> |   |  Paravel Systems
>

Re: [RDD] Rivendell v2.16.0

2017-07-11 Thread Pedro Picoto

I'm not at my pc... from memory when I " mysql -uroot -p" I'm not asked for
any password. All I get is a sort o list of  "\*" commands...

On Tue, Jul 11, 2017 at 6:03 PM, Rob Landry <41001...@interpring.com> wrote:

>
> Do you have all the relevant MySQL packages installed?
>
> Have you assigned a password to the MySQL root user?
>
> What happens if you type:
>
> mysql -uroot -p[whatever]
>
> If that comand works, you should be able to give mysqladmin 'root' and
> whatever password you assigned the MySQL root user, and it should create a
> database.
>
>
> Rob
>
> --
> Я там, где ребята толковые,
> Я там, где плакаты "Вперёд",
> Где песни рабочие новые
> Страна трудовая поёт.
>
>
> On Tue, 11 Jul 2017, Pedro Picoto wrote:
>
> Long time no see...
>> Since the end(?)  of Tryphon's Ubuntu "just add water" Rivendell fork I
>> have
>> "quit" from RD... untill I start missing it.
>> I'm on a stage of compiling from source on a already running Mint 18.1.
>>
>> I'm using this tutorial:
>> http://rivendell.tryphon.org/wiki/UbuntuXenial
>>
>> Issues so far:
>> - RDADMIN: "Unable to connect to mysql", thus unable to create a new DB.
>>
>> Also:
>> pedro-home rivendell-2.16.0 # patch /rdadmin/opendb.cpp opendb.cpp.patch
>> patching file /rdadmin/opendb.cpp
>> Hunk #1 FAILED at 240.
>> patch:  Can't reopen file /rdadmin/opendb.cpp : No such file or
>> directory
>>
>> pedro-home rivendell-2.16.0 # patch /rdadmin/createdb.cpp
>> createdb.cpp-instance.patch
>> patching file /rdadmin/createdb.cpp
>> Hunk #1 FAILED at 1241.
>> Hunk #2 FAILED at 1353.
>> Hunk #3 FAILED at 1773.
>> Hunk #4 FAILED at 1808.
>> patch:  Can't reopen file /rdadmin/createdb.cpp : No such file or
>> directory
>>
>> I don't know if the patch problem (wich I might be doing something wrong)
>> can be related to the "Unable to connect to mysql"
>>
>> QUESTION; What should be the (RDADMIN) Username and password for a
>> compiled
>> from source? I'm using "root/root" with no success
>>
>>
>> The database is apparentely ok. I've checked on the terminal it with no
>> errors returned.
>>
>> Hints?... TIA!
>>
>>
>>
>>
>>
>>
>> On Fri, Jun 2, 2017 at 1:47 PM, Fred Gleason 
>> wrote:
>>   On behalf of the entire Rivendell development team, I'm pleased
>>   to announce the availability of Rivendell v2.16.0.  Rivendell is
>>   a full-featured radio automation system targeted for use in
>>   professional broadcast environments. It is available under the
>>   GNU General Public License.
>>
>>   From the NEWS file:*** snip snip ***
>> Changes:
>>Audio Store Hashing. Rivendell now automatically generates a SHA1
>> hash
>>for each file in the audio store and records this value in the
>> database,
>>thus permitting automated recovery of audio in the event of loss or
>> damage
>>to the audio store's filesystem directory. See the --relink-audio
>> option
>>in the rddbcheck(8) man page for details.
>>
>>Kernel GPIO. Added switcher support for Kernel GPIO devices, such
>> as
>>the GPIO interface on the Raspberry Pi 2 and 3.
>>
>>Modbus TCP. Added switcher support for Modbus TCP devices.
>>
>>RDConvert. Added an rdconvert(1) utility,
>>
>>User Authentication. It is now possible to delegate authentication
>> of
>>Rivendell users by means of a PAM module, thus permitting 'single
>> sign-on'
>>integration with systems such as ActiveDirectory and FreeIPA.
>>
>>Web API. Added various methods to the Rivendell Web API to permit
>>integration with external audio and log editors.
>>
>>Various other bug fixes.  See the ChangeLog for details.
>>
>> Database Update:
>>This version of Rivendell uses database schema version 263, and
>> will
>>automatically upgrade any earlier versions.  To see the current
>> schema
>>version prior to upgrade, see RDAdmin->SystemInfo.
>>
>>As always, be sure to run RDAdmin immediately after upgrading to
>> allow
>>any necessary changes to the database schema to be applied.
>>
>> *** snip snip ***
>>
>> Further information, screenshots and download links are available at:
>>
>> http://www.rivendellaudio.org
>>
>> Cheers!
>>
>>
>> |--|
>> | Frederick F. Gleason, Jr. |  Chief Developer
>> |
>> |   |  Paravel Systems
>> |
>> |--|
>> |  I look at it this way:  if the station doesn't receive at least one
>> |
>> |  bomb threat a week, it means that we're not reaching our audience.
>> |
>> | -- Keith Leach
>> |
>> |--|
>>
>>
>> ___
>> Rivendell-dev mailing list
>> Rivendell-dev@lists.rivendellaudio.org
>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>>
>>
>>
>>
__

Re: [RDD] Rivendell v2.16.0

2017-07-11 Thread Rob Landry



Do you have all the relevant MySQL packages installed?

Have you assigned a password to the MySQL root user?

What happens if you type:

mysql -uroot -p[whatever]

If that comand works, you should be able to give mysqladmin 'root' and 
whatever password you assigned the MySQL root user, and it should create a 
database.



Rob

--
Я там, где ребята толковые,
Я там, где плакаты "Вперёд",
Где песни рабочие новые
Страна трудовая поёт.

On Tue, 11 Jul 2017, Pedro Picoto wrote:


Long time no see...
Since the end(?)  of Tryphon's Ubuntu "just add water" Rivendell fork I have
"quit" from RD... untill I start missing it.
I'm on a stage of compiling from source on a already running Mint 18.1.

I'm using this tutorial:
http://rivendell.tryphon.org/wiki/UbuntuXenial

Issues so far:
- RDADMIN: "Unable to connect to mysql", thus unable to create a new DB.

Also:
pedro-home rivendell-2.16.0 # patch /rdadmin/opendb.cpp opendb.cpp.patch
patching file /rdadmin/opendb.cpp
Hunk #1 FAILED at 240.
patch:  Can't reopen file /rdadmin/opendb.cpp : No such file or
directory

pedro-home rivendell-2.16.0 # patch /rdadmin/createdb.cpp
createdb.cpp-instance.patch
patching file /rdadmin/createdb.cpp
Hunk #1 FAILED at 1241.
Hunk #2 FAILED at 1353.
Hunk #3 FAILED at 1773.
Hunk #4 FAILED at 1808.
patch:  Can't reopen file /rdadmin/createdb.cpp : No such file or
directory

I don't know if the patch problem (wich I might be doing something wrong)
can be related to the "Unable to connect to mysql"

QUESTION; What should be the (RDADMIN) Username and password for a compiled
from source? I'm using "root/root" with no success

 
The database is apparentely ok. I've checked on the terminal it with no
errors returned.

Hints?... TIA!






On Fri, Jun 2, 2017 at 1:47 PM, Fred Gleason 
wrote:
  On behalf of the entire Rivendell development team, I'm pleased
  to announce the availability of Rivendell v2.16.0.  Rivendell is
  a full-featured radio automation system targeted for use in
  professional broadcast environments. It is available under the
  GNU General Public License.

  From the NEWS file:*** snip snip ***
Changes:
   Audio Store Hashing. Rivendell now automatically generates a SHA1
hash
   for each file in the audio store and records this value in the
database,
   thus permitting automated recovery of audio in the event of loss or
damage
   to the audio store's filesystem directory. See the --relink-audio
option
   in the rddbcheck(8) man page for details.

   Kernel GPIO. Added switcher support for Kernel GPIO devices, such
as
   the GPIO interface on the Raspberry Pi 2 and 3.

   Modbus TCP. Added switcher support for Modbus TCP devices.

   RDConvert. Added an rdconvert(1) utility,

   User Authentication. It is now possible to delegate authentication
of
   Rivendell users by means of a PAM module, thus permitting 'single
sign-on'
   integration with systems such as ActiveDirectory and FreeIPA.

   Web API. Added various methods to the Rivendell Web API to permit
   integration with external audio and log editors.

   Various other bug fixes.  See the ChangeLog for details.   

Database Update:
   This version of Rivendell uses database schema version 263, and
will
   automatically upgrade any earlier versions.  To see the current
schema
   version prior to upgrade, see RDAdmin->SystemInfo.

   As always, be sure to run RDAdmin immediately after upgrading to
allow 
   any necessary changes to the database schema to be applied.

*** snip snip ***

Further information, screenshots and download links are available at:

http://www.rivendellaudio.org

Cheers!


|--|
| Frederick F. Gleason, Jr. |              Chief Developer            
|
|                           |              Paravel Systems            
|
|--|
|  I look at it this way:  if the station doesn't receive at least one
|
|  bomb threat a week, it means that we're not reaching our audience. 
|
|                                             -- Keith Leach          
|
|--|


___
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

[RDD] Rivendell v2.16.0

2017-07-10 Thread Pedro Picoto

(update)

Changed the RDADMIN username/pw to "root/(my su pw)" and got a different
response: it takes a while to react and then: "Unable to create Rivendell
database"
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Rivendell v2.16.0

2017-07-10 Thread Pedro Picoto

Long time no see...
Since the end(?)  of Tryphon's Ubuntu "just add water" Rivendell fork I
have "quit" from RD... untill I start missing it.
I'm on a stage of compiling from source on a already running Mint 18.1.

I'm using this tutorial:
http://rivendell.tryphon.org/wiki/UbuntuXenial

Issues so far:
- RDADMIN: "Unable to connect to mysql", thus unable to create a new DB.

Also:
pedro-home rivendell-2.16.0 # patch /rdadmin/opendb.cpp opendb.cpp.patch
patching file /rdadmin/opendb.cpp
Hunk #1 FAILED at 240.
patch:  Can't reopen file /rdadmin/opendb.cpp : No such file or
directory

pedro-home rivendell-2.16.0 # patch /rdadmin/createdb.cpp
createdb.cpp-instance.patch
patching file /rdadmin/createdb.cpp
Hunk #1 FAILED at 1241.
Hunk #2 FAILED at 1353.
Hunk #3 FAILED at 1773.
Hunk #4 FAILED at 1808.
patch:  Can't reopen file /rdadmin/createdb.cpp : No such file or
directory

I don't know if the patch problem (wich I might be doing something wrong)
can be related to the "Unable to connect to mysql"

QUESTION; What should be the (RDADMIN) Username and password for a compiled
from source? I'm using "root/root" with no success


The database is apparentely ok. I've checked on the terminal it with no
errors returned.

Hints?... TIA!






On Fri, Jun 2, 2017 at 1:47 PM, Fred Gleason 
wrote:

> On behalf of the entire Rivendell development team, I'm pleased to
> announce the availability of Rivendell v2.16.0.  Rivendell is a
> full-featured radio automation system targeted for use in professional
> broadcast environments. It is available under the GNU General Public
> License.
>
> From the NEWS file:
> *** snip snip ***
> Changes:
>Audio Store Hashing. Rivendell now automatically generates a SHA1 hash
>for each file in the audio store and records this value in the database,
>thus permitting automated recovery of audio in the event of loss or
> damage
>to the audio store's filesystem directory. See the --relink-audio option
>in the rddbcheck(8) man page for details.
>
>Kernel GPIO. Added switcher support for Kernel GPIO devices, such as
>the GPIO interface on the Raspberry Pi 2 and 3.
>
>Modbus TCP. Added switcher support for Modbus TCP devices.
>
>RDConvert. Added an rdconvert(1) utility,
>
>User Authentication. It is now possible to delegate authentication of
>Rivendell users by means of a PAM module, thus permitting 'single
> sign-on'
>integration with systems such as ActiveDirectory and FreeIPA.
>
>Web API. Added various methods to the Rivendell Web API to permit
>integration with external audio and log editors.
>
>Various other bug fixes.  See the ChangeLog for details.
>
> Database Update:
>This version of Rivendell uses database schema version 263, and will
>automatically upgrade any earlier versions.  To see the current schema
>version prior to upgrade, see RDAdmin->SystemInfo.
>
>As always, be sure to run RDAdmin immediately after upgrading to allow
>any necessary changes to the database schema to be applied.
>
> *** snip snip ***
>
> Further information, screenshots and download links are available at:
>
> http://www.rivendellaudio.org
>
> Cheers!
>
>
> |--|
> | Frederick F. Gleason, Jr. |  Chief Developer |
> |   |  Paravel Systems |
> |--|
> |  I look at it this way:  if the station doesn't receive at least one |
> |  bomb threat a week, it means that we're not reaching our audience.  |
> | -- Keith Leach   |
> |--|
>
>
> ___
> 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] Rivendell v2.16.0

2017-06-02 Thread Bill Putney

Thank you Fred! Does the update automagically to add a hash to the db 
for preexisting audio files or do we have to run a routine to do that?


Bill Putney - WB6RFW
Chief Engineer
KPTZ - Port Townsend, WA

PP-SEL/A&P-IA

I'm running for Port Commissioner. If you're interested: 
http://PutneyForThePort.VOTE



On 6/2/17 5:47 AM, Fred Gleason wrote:
On behalf of the entire Rivendell development team, I'm pleased to 
announce the availability of Rivendell v2.16.0.  Rivendell is a 
full-featured radio automation system targeted for use in professional 
broadcast environments. It is available under the GNU General Public 
License.


From the NEWS file:
*** snip snip ***
Changes:
Audio Store Hashing. Rivendell now automatically generates a SHA1 hash
for each file in the audio store and records this value in the database,
thus permitting automated recovery of audio in the event of loss or damage
to the audio store's filesystem directory. See the --relink-audio option
in the rddbcheck(8) man page for details.

Kernel GPIO. Added switcher support for Kernel GPIO devices, such as
the GPIO interface on the Raspberry Pi 2 and 3.

Modbus TCP. Added switcher support for Modbus TCP devices.

RDConvert. Added an rdconvert(1) utility,

User Authentication. It is now possible to delegate authentication of
Rivendell users by means of a PAM module, thus permitting 'single sign-on'
integration with systems such as ActiveDirectory and FreeIPA.

Web API. Added various methods to the Rivendell Web API to permit
integration with external audio and log editors.

Various other bug fixes.  See the ChangeLog for details.

Database Update:
This version of Rivendell uses database schema version 263, and will
automatically upgrade any earlier versions.  To see the current schema
version prior to upgrade, see RDAdmin->SystemInfo.

As always, be sure to run RDAdmin immediately after upgrading to allow
any necessary changes to the database schema to be applied.

*** snip snip ***

Further information, screenshots and download links are available at:

http://www.rivendellaudio.org 

Cheers!


|--|
| Frederick F. Gleason, Jr. |  Chief Developer |
|   |  Paravel Systems |
|--|
|  I look at it this way:  if the station doesn't receive at least one |
|  bomb threat a week, it means that we're not reaching our audience.  |
| -- Keith Leach |
|--|



___
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

[RDD] Rivendell v2.16.0

2017-06-02 Thread Fred Gleason

On behalf of the entire Rivendell development team, I'm pleased to announce the 
availability of Rivendell v2.16.0.  Rivendell is a full-featured radio 
automation system targeted for use in professional broadcast environments. It 
is available under the GNU General Public License.

From the NEWS file:
*** snip snip ***
Changes:
   Audio Store Hashing. Rivendell now automatically generates a SHA1 hash
   for each file in the audio store and records this value in the database,
   thus permitting automated recovery of audio in the event of loss or damage
   to the audio store's filesystem directory. See the --relink-audio option
   in the rddbcheck(8) man page for details.

   Kernel GPIO. Added switcher support for Kernel GPIO devices, such as
   the GPIO interface on the Raspberry Pi 2 and 3.

   Modbus TCP. Added switcher support for Modbus TCP devices.

   RDConvert. Added an rdconvert(1) utility,

   User Authentication. It is now possible to delegate authentication of
   Rivendell users by means of a PAM module, thus permitting 'single sign-on'
   integration with systems such as ActiveDirectory and FreeIPA.

   Web API. Added various methods to the Rivendell Web API to permit
   integration with external audio and log editors.

   Various other bug fixes.  See the ChangeLog for details.   

Database Update:
   This version of Rivendell uses database schema version 263, and will
   automatically upgrade any earlier versions.  To see the current schema
   version prior to upgrade, see RDAdmin->SystemInfo.

   As always, be sure to run RDAdmin immediately after upgrading to allow 
   any necessary changes to the database schema to be applied.

*** snip snip ***

Further information, screenshots and download links are available at:

http://www.rivendellaudio.org 

Cheers!


|--|
| Frederick F. Gleason, Jr. |  Chief Developer |
|   |  Paravel Systems |
|--|
|  I look at it this way:  if the station doesn't receive at least one |
|  bomb threat a week, it means that we're not reaching our audience.  |
| -- Keith Leach   |
|--|

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

[RDD] Rivendell v2.16.0 SQL issue (follow up of the Rivendell v2.16.0 topic)

Re: [RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

[RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

Re: [RDD] Rivendell v2.16.0

[RDD] Rivendell v2.16.0

17 matches

Site Navigation

Mail list logo

Footer information