Re: [RDD] Mysql Workbench

Hello, I don't typically use MySQL Workbench but same difference to using the MySQL CLI which I've used with the riv database. I wouldn't think there's a reason why it couldn't access the database specifically. Possibly try accessing the database from the same host using the mysql command to

[RDD] Mysql Workbench

Good Evening, Has Anyone have had any success with accessing the Database with MySQL Workbench. I am working on some backend scripting. Thanks ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mail

[RDD] Mysql Connector

Good Afternoon, I was wondering if any one has any luck in connecting to Rivendell Database with the MySQL Database connector. I am trying see if we can do backups this way. If is possible Does anyone know how to assess The database with a password. Thanks for any suggestions

Re: [RDD] MySQL issues?

Ryan, go through your events and check the 'Services' button. Default is 'Production' you may have another name in there. It may be in there twice. Delete both close. Save Event reopen Services tab arrow over service you want Close Save Exit repeat rinse etc Clocks should behave. There is

[RDD] MySQL issues?

I'm having an odd time with Clocks and not saving my event changes Even though I press save but it doen't save, it deletes every other event I tried to make a clock on a different pc (virtualized version connected to my server) and it saved just fine but I only had 2 or 3 events in it

Re: [RDD] MySQL(Maria) issue

On Oct 4, 2019, at 12:25, Jamie Dominey wrote: > It is networked, but I am getting the same issue running RDAirPlay on my > backup server as a test, with no network connections. Thanks. As a test, go into RDAdmin->ManageHosts, and for every host list *except* the one that hosts MariaDB, untic

Re: [RDD] MySQL(Maria) issue

It is networked, but I am getting the same issue running RDAirPlay on my backup server as a test, with no network connections. On 2019-10-04 1:21 p.m., Fred Gleason wrote: On Oct 3, 2019, at 08:07, Jamie Dominey > wrote: I'm still trying to find a solution to this

Re: [RDD] MySQL(Maria) issue

On Oct 3, 2019, at 08:07, Jamie Dominey wrote: > I'm still trying to find a solution to this issue and I am running out of > ideas. When I do a show processlist; I get a bunch of the following > connections. > > | 223 | rduser | rdmusic:51230 | Rivendell | Query | 7 | Waiting >

Re: [RDD] MySQL(Maria) issue

I'm still trying to find a solution to this issue and I am running out of ideas.  When I do a show processlist; I get a bunch of the following connections. |  223 | rduser | rdmusic:51230   | Rivendell | Query   | 7 | Waiting for table level lock | delete from STACK_SCHED_CODES where

[RDD] MySQL(Maria) issue

Hi, I have developed an issue since upgrading to v3.  Basically what is happening is that the number of current database connections keeps increasing until it hits the maximum connections, and any currently open Rivendell programs will keep running, but nothing new will open until a currently

Re: [RDD] mysql errors

I ran into this recently in a non-Rivendell MySQL situation. The issue is in the server's MySQL configuration. This error message is the clue: "this is incompatible with sql_mode=only_full_group_by" Here's a page from Stack Exchange that explains how to fix it: https://craftcms.stackexchange.com/q

[RDD] mysql errors

Just installed Mint 19.1 with xfce on a Averatec laptop and compiled Rivendell using http://wiki.rivendellaudio.org/index.php/Debian9.  Having problems with RDLibrary and RDCatch.  After installing and running create with rddbconfig, RDLibrary is empty but the test tone is accessible in RDLogEd

Re: [RDD] MySQL Encryption?

On Thu, 07 Feb 2019 07:49:52 -0500 Fred Gleason wrote: > Rather than attempting to harden each data service individually, I > would *strongly* recommend establishing a VPN tunnel between the sites > and pass everything through that. And I would strongly concur ! Even if you harden/encrypt MyS

Re: [RDD] MySQL Encryption?

On Wed, 2019-02-06 at 21:08 -0500, Rich Gattie wrote: > Is the MySQL that is configured on the Appliance DVD setup with SSL > encryption installed? Not that I know of. > I'm looking at ways to connect from outside my network for someone to > remote access the system securely. Rather than attem

[RDD] MySQL Encryption?

Is the MySQL that is configured on the Appliance DVD setup with SSL encryption installed? I'm looking at ways to connect from outside my network for someone to remote access the system securely. -- -=:{ Rich Gattie, KB2MOB }:=- Email: mob...@gmail.com Web: http://x1radio.net __

Re: [RDD] Mysql Question

If you only want to back up the Rivendell database you can use the user/password in the rd.conf file as the credentials for the MySQL request. You should code those on your mysql backup command. On Thu, Dec 27, 2018 at 10:14 AM wrote: > > I have been making backups with myssql Dump > > I have t

Re: [RDD] Mysql Question

On Thu, 27 Dec 2018 13:13:01 -0500 ija...@jamcorbroadcast.com wrote: > Or can share how to create automated process that works. We all have preferences. Mine is Webmin an HTML based interface to just about any and everything that can be administered on a *nix system. It will allow direct edit

[RDD] Mysql Question

I have been making backups with myssql Dump I have to be login in as super user to see the databases. If be login as Super User get or I get an error. Error 1045 (28000): Access denied for user 'myuser'@'localhost' (using password: YES) Second I have to try a few times to get to make the

Re: [RDD] mysql query to file report

If you use this join instead of the one I suggested earlier, you will get the play count for the cut that was actually played, rather than the first one in the cart - assuming it hasn't been deleted since it was played. LEFT JOIN cuts ON CONCAT(LPAD(played.CART_NUMBER, 6, '0'), "_", LPAD(played.CU

Re: [RDD] mysql query to file report

(I got help for this from searching postings on StackOverflow, which I highly recommend when looking for programming answers. Also, if you don't have something already, I highly recommend the free MySQL Workbench to explore and work with database queries such as this.) The simplest way to get the

Re: [RDD] mysql query to file report

First one. "Cut 001" or _001. Sent from my mobile device mIRCea > On 23 May 2018, at 02:35, Mike Carroll wrote: > > What have you already tried? Give us a hint so we don't waste time > duplicating your work. > > There can be many cuts in a cart. Which one do you want? > > >> On Tue, May 2

Re: [RDD] mysql query to file report

What have you already tried? Give us a hint so we don't waste time duplicating your work. There can be many cuts in a cart. Which one do you want? On Tue, May 22, 2018 at 9:41 AM Mircea Paun wrote: > Hi, > From previous posts and my additions I have reached this form of mysql > query: >

[RDD] mysql query to file report

Hi, From previous posts and my additions I have reached this form of mysql query: - SELECT Audio_SRT.EVENT_DATETIME,\ CART.TITLE,\ CART.ARTIST,\ CART.COMPOSER,\ TIME_FORMAT(SEC_TO_TIME(Audio_SRT.LENGTH/1000),"%i:%s"),\ TIME_FORMAT(SEC_TO_TIME(CART

Re: [RDD] Mysql Backup

Open a CentOS command line and enter "rdadmin". Try taking the backup. Look at the command line window for any SQL error messages. You might also check /var/log/messages on the workstation where you're trying the backup, and /var/log/mysqld.log on the MySQL server. You'll need superuser to acces

Re: [RDD] Mysql Backup

On Thursday 12 April 2018 01:16:39 pm ija...@jamcorbroadcast.com wrote: > It used to make backups on it own but after we loaded more songs in the > database It stopped making backups.any suggtions Unless you're familiar with command line MySQL, not from me. We have I don't even know how many e

[RDD] Mysql Backup

Anyone have any suggestions On Making MYSQL and Music Backups I have bee trying to make a backup of our system. No succes Yet I Can get to make a backup on Mysql CLI. I mounted a new drive on the machine to sent all the backups to. Would like to get suggestion on whe proper script in make the

Re: [RDD] Mysql Backup

Just Tried it and The error Is Unable to Create Backup. Is the file size of the Database. On 2018-04-10 14:16, Cowboy wrote: On Tue, 10 Apr 2018 13:01:42 -0400 ija...@jamcorbroadcast.com wrote: I have been trying to make backup of database. I have tries different ways to still no success.

Re: [RDD] Mysql Backup

Cowboy It used to make backups on it own but after we loaded more songs in the database It stopped making backups.any suggtions On 2018-04-10 14:16, Cowboy wrote: On Tue, 10 Apr 2018 13:01:42 -0400 ija...@jamcorbroadcast.com wrote: I have been trying to make backup of database. I have tries

Re: [RDD] Mysql Backup

On Tue, 10 Apr 2018 13:01:42 -0400 ija...@jamcorbroadcast.com wrote: > I have been trying to make backup of database. I have tries different > ways to still no success. Open rdadmin Click Backup Database Give it the filename you'd like. Click Save -- Cowboy Fine words! I wonder where you

[RDD] Mysql Backup

Here is what I have been doing I have been trying to make backup of database. I have tries different ways to still no success. I have not changes anything in the config Here is what I have don so far. 1. I Mounted a hardrive to the Machine Did a Mysquldump to a local folder. I have some instr

Re: [RDD] MySQL chatter

Hey Robert, I've seen this "chatter" going back to Rivendell version 2.10.3, and maybe even longer ago than that. I too am wary of it, but so far (in my experience) it has not caused any problems with importing audio. ~David On 04/10/2018 01:46 AM, Robert Jeffares wrote: > I have been getting

[RDD] MySQL chatter

I have been getting a lot of reports like this when injesting audio both in dropbox mode and with rdimport on the CentOS 6 Appliance 2.19.1/275 despite the chatter everything works fine Its just unnerving. invalid SQL or failed DB connection[MySQL server has gone away QMYSQL3: Unable to exec

[RDD] MySQL performance tweaking

Ran across this article the other day. Many of you probably know much of this already, but it was an interesting read for those of us who don't live as a db admin. https://www.infoworld.com/article/3234637/sql/7-keys-to-better-mysql-performance.html Yeah, it's written by a vendor for a monito

Re: [RDD] MySQL DB Creation

Thanks. This worked well. I now have Rivendell running on Debian 8. Cheers Kyle On 16/11/2016 23:34, Rob Landry wrote: > On Wed, 16 Nov 2016, Kyle Robbertze wrote: > >> The issue with downloading 2.15.1 is Qt3 as this is unavailable in >> Debian 8 or unstable. So I need to compile from github ma

Re: [RDD] MySQL DB Creation

On Wed, 16 Nov 2016, Kyle Robbertze wrote: The issue with downloading 2.15.1 is Qt3 as this is unavailable in Debian 8 or unstable. So I need to compile from github master, which has Qt4 support. However the master branch seems to have removed the functionality of creating the DB if it is not pr

Re: [RDD] MySQL DB Creation

Yes don't let QT3 scare you. I have some Ubuntu 16.04 scripts here but they should work for Debian. https://github.com/waynemerricks/rivendellubuntuxenial/blob/master/install/003.install_qt3.sh On 16/11/16 13:53, Kyle Robbertze wrote: Hi On 16/11/2016 15:30, Wayne Merricks wrote: OK that k

Re: [RDD] MySQL DB Creation

Hi, > The issue with stable is Qt3, which is not supported in > any Ubuntu or Debian release that is still supported by the respective > projects. Tryphon's Debian repo (http://debian.tryphon.eu/) provides qt3 dependencies for debian 8. I seem to recall having succesfully compiled and used (tes

Re: [RDD] MySQL DB Creation

On Wed, 16 Nov 2016 15:53:58 +0200 Kyle Robbertze wrote: > So I need to compile from github master, which has > Qt4 support. However the master branch seems to have removed the > functionality of creating the DB if it is not present. That's not the only thing missing from master ! Further, mas

Re: [RDD] MySQL DB Creation

Hi Fred, I am aware that master development is still on-going. In fact I am trying to get my head around it enough to contribute, but that is another matter. The issue with stable is Qt3, which is not supported in any Ubuntu or Debian release that is still supported by the respective projects. So

Re: [RDD] MySQL DB Creation

On Nov 16, 2016, at 08:53, Kyle Robbertze wrote: > The issue with downloading 2.15.1 is Qt3 as this is unavailable in > Debian 8 or unstable. So I need to compile from github master, which has > Qt4 support. However the master branch seems to have removed the > functionality of creating the DB if

Re: [RDD] MySQL DB Creation

Hey Kyle, The last update I recall seeing from Fred G. is that the master branch is known to compile, but all bets are off in actually getting it running. Unless you *need* QT4 or some other feature of the master branch, I'd recommend checking out the "stable" branch (which more or less represent

Re: [RDD] MySQL DB Creation

Hi On 16/11/2016 15:30, Wayne Merricks wrote: > OK that kind of makes sense. Kill/stop the rivendell services (caed, > rdcatchd, ripcd) then Drop the Rivendell database and also drop the > rduser user. Done > You might have to flush privileges too. Then just load rdadmin and it > will create t

Re: [RDD] MySQL DB Creation

OK that kind of makes sense. Kill/stop the rivendell services (caed, rdcatchd, ripcd) then Drop the Rivendell database and also drop the rduser user. You might have to flush privileges too. Then just load rdadmin and it will create the DB for you. If the database/user already exists (parti

Re: [RDD] MySQL DB Creation

Hi, On 16/11/2016 13:06, Wayne Merricks wrote: > Hi, > > Building from source is the same procedure. You just need to install > mysql-server before you run rdadmin and check you can connect to it with > root and whatever password you chose. I have mysql-server installed and in fact have been tr

Re: [RDD] MySQL DB Creation

Hi, Building from source is the same procedure. You just need to install mysql-server before you run rdadmin and check you can connect to it with root and whatever password you chose. I run/have ran Rivendell on Debian 6, 7, Ubuntu 12.04 and 14.04 for no other reason than I am more familiar

Re: [RDD] MySQL DB Creation

On 16/11/2016 00:43, Wayne Merricks wrote: > Hi, > > All you have to do is run rdadmin, it will prompt you for the db access > details. Assuming these work, it will create a database called > Rivendell and set up a user called rduser for the db. Great, thanks. This worked on the broadcast applia

Re: [RDD] MySQL DB Creation

Hi, All you have to do is run rdadmin, it will prompt you for the db access details. Assuming these work, it will create a database called Rivendell and set up a user called rduser for the db. By default it looks at localhost (/etc/rd.conf), change the conf file if it is not on the local ma

[RDD] MySQL DB Creation

Hi, Does anyone have a SQL dump/up-to-date DB creation script for Rivendell? I have recently tried to install Rivendell from source and from the appliance iso, but neither have an up-to-date DB structure. The creation script [1] in the github repo is not compatible with Rivendell v2.5.5 as distrib

[RDD] mysql question

I have an oddity in RDCatch. Don't know where the first 2 entries in the attached screen shot came from or when they appeared. Delete did not remove them nor creating a host of :OR and trying to delete. I found IDs 89 & 90 in mysql under RECORDINGS and ran these 2 scripts: mysql> delete fro

Re: [RDD] MySQL / MariaDB

Hello, Le 21/06/2016 à 21:30, Fred Gleason a écrit : >> Well, my plan is to switch to Fedora 24, and from what I read on this >> list, it seems that, as it ships with MariaDB as a replacement for >> MySQL, I might run into a lot of trouble... with the additional fact >> that the default storage en

Re: [RDD] MySQL / MariaDB

On Jun 21, 2016, at 12:54, Hoggins! wrote: > Well, my plan is to switch to Fedora 24, and from what I read on this > list, it seems that, as it ships with MariaDB as a replacement for > MySQL, I might run into a lot of trouble... with the additional fact > that the default storage engine is InnoD

[RDD] MySQL / MariaDB

Hello, I'm planning for a huge system upgrade this summer for our Rivendell installation. Our NFS and MySQL server runs Fedora 17, a fairly old version now, shipping all that is necessary for Rivendell to work properly. Well, my plan is to switch to Fedora 24, and from what I read on this list, i

[RDD] MySQL Audit Log Plugin

Has anyone had experience with the MySQL Audit Log Plugin used in conjunction with Rivendell? I want to keep track of changes made to Cart Fields such as Composer, User-Defined, etc. All comments welcome. Thanks, Rich Stivers KKUP-FM 91.5, Cupertino / San Jose, CA ___

Re: [RDD] MySQL version mismatch error?

All of your Rivendell systems that share a database must be at the same minor version level. For example, your servers are 2.10.3 ("10"), but if you've upgraded the clients they are now at 2.11.0 ("11"). That difference in minor versions means the structure of at least some of the tables in the d

[RDD] MySQL version mismatch error?

After rebuilding the clients that seemed to break after software updates, I kept getting an authentication error when switching between master and standby servers even though Rivendell seemed to work fine on the clients. On the servers I can no longer run RDAdmin: "Session management error: None o

Re: [RDD] MySQL

On 08/25/2015 05:28 PM, Ryan Kingham wrote: Can Rivendell's MySQL be redirected to an online database? Lots of good reasons not to, but none of them technical. If, in your world, ( much like windows ) "real time" means a day or two delay, then sure. -- Cowboy http://cowboy.cwf1.com SAGIT

Re: [RDD] MySQL

Hi, You can change /etc/rd.conf and point it to any MySQL database you have on the LAN or Internet. I don't think the Internet would be a good idea but I can't see a reason why it wouldn't work. Wayne Merricks The Voice Asia On 26/08/15 00:04, drew Roberts wrote: On Tue, Aug 25, 2015 at

[RDD] MySQL

Can Rivendell's MySQL be redirected to an online database? ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] MYSQL error in EDIT GRIDS in RDLOGMANAGER

Thanks Wayne, Did the trick, backup the database, made the change and voila. Appreciate the fast response. Regards, Richard On Sun, Oct 12, 2014 at 7:09 PM, Wayne Merricks < waynemerri...@thevoiceasia.com> wrote: > Hi, > > Easiest way is to change the services table to MyISAM > > ALTER TABLE `

Re: [RDD] MYSQL error in EDIT GRIDS in RDLOGMANAGER

Hi, Easiest way is to change the services table to MyISAM ALTER TABLE `SERVICES` ENGINE=MyISAM; In theory innodb is less likely to lose data during a power outage and you can do funky stuff with MariaDB and clustering if you use Innodb but in reality you can't really use Riv without MyISAM on

[RDD] MYSQL error in EDIT GRIDS in RDLOGMANAGER

I've configured RD to be able to import logs from a third party and it works well, with the following exception. I cannot get the any clock to stick in the grid from Thurs 1300 to Sun 2300. They refuse to stick whether I do them manually or a "Change All". I do get the following error in the syslog

Re: [RDD] MYSQL local access

Hi, Is it saying access denied as blah@my machine or is it not connecting at all? If its saying access denied its usually because you've not added a wildcard host user. If you log into mysql (as root) you can try the following: USE mysql; SELECT Host, User FROM user; You should see somet

[RDD] MYSQL local access

Setup my new system for remote access, but now have no local access to mysqlWhat did I miss? I have this working on my other system, but it's been three years since I set it up.. Basically followed instructions here: http://rivendell.tryphon.org/wiki/Remote_Client_Access But using web

Re: [RDD] mySQL Problem on Fresh Appliance Install

Thanks, Fred. I'm going to keep working with it and I'll update this with any further results. Ryan On Mon, Dec 23, 2013 at 11:10 AM, Fred Gleason wrote: > On Dec 20, 2013, at 12:05 41, Ryan Williams wrote: > > > Are there credentials I can enter to reconnect to the database? > > The default a

Re: [RDD] mySQL Problem on Fresh Appliance Install

On Dec 20, 2013, at 12:05 41, Ryan Williams wrote: > Are there credentials I can enter to reconnect to the database? The default admin credentials are ‘root’ with no password. The default user credentials are ‘rduser’ with a password of ‘letmein’. Cheers! |--

[RDD] mySQL Problem on Fresh Appliance Install

I just did a fresh install of the Appliance (v2). On the initial boot, Rivendell works. After doing a Software Update though I get the dreaded mySQL Admin grey box which says: "Unable to access the Rivendell Database! Please enter a login for an account with administrative rights on the mySQL serv

[RDD] mysql schema update

Greetings, when trying to update mysql schema to latest version I get the following error mysqldump: Got error: 1016: Can't open file: './Rivendell/Local0524_LOG.frm' (errno: 24) when using LOCK TABLES SQL: alter table VERSION add column LAST_ISCI_XREFERENCE datetime default "1970-01-01 00:00:00

Re: [RDD] mysql noncommunication

If I remember rightly MySQL does a DNS lookup on the connections before authenticating. If your DNS is causing problems you get delays like this (especially if the host isn't in DNS at all). You can disable this in the mysql config by adding: skip-name-resolve In the my.cnf. Regards, Way

Re: [RDD] mysql noncommunication

Thanks for the reply Cowboy, By "that machine" do you mean the server? By the way, when this happened this afternoon, I even tried rebooting the server, didn't help. On Thu, Dec 13, 2012 at 8:40 PM, Cowboy wrote: > On Thursday 13 December 2012 09:39:32 pm Tim Camp wrote: > > Any Ideas, where to

Re: [RDD] mysql noncommunication

On Thursday 13 December 2012 09:39:32 pm Tim Camp wrote: > Any Ideas, where to look, etc? On the console for that machine, what does top show you ? -- Cowboy http://cowboy.cwf1.com A candidate is a person who gets money from the rich and votes from the poor to protect them from each other.

[RDD] mysql noncommunication

Greetings, First of all let me say our stations have two audio servers and two mysql servers one main and one standby respectively. Twice in the past couple of weeks suddenly rivendell workstations can't maintain a solid connection to the mysql server to the point of failing to load new rivendell

Re: [RDD] Mysql syntax

So the complicating issue is the fact that the group is stored in the CART table where as the PLAY_COUNTER is associated with the CUTS table. The linking field is that NUMBER in CART is the CART_NUMBER in CUTS. The easiest way I know how to do this is by an UPDATE via INNER JOIN. So for your e

Re: [RDD] Mysql syntax

One more thing IN THE SCRIPT, edit before you save/run: Your host, user, and pass in: $sqlconnection = mysql_connect("your mysql host", "your username", "your password") or die(mysql_error()); "YOUR GROUP TITLE" in: $result = mysql_query("SELECT `Rivendell`.`CART`.`NUMBER` FROM `Rivendell`. `CART

Re: [RDD] Mysql syntax

NOTE this is a php script... I do not know how to do this purely by mysql... so you need to install php5 on your Linux system, save the following script in a .php file located at /this/path/you/choose.php and then in a terminal execute "php /this/path/you/choose.php" (without quotes... replace "/th

Re: [RDD] Mysql syntax

Hey hang on I have a query I actually use myself that does just that... although not specific group but specific scheduling code. On Wed, May 9, 2012 at 7:39 PM, Jimmy Stinson wrote: > My mysql script writing abilities are limited.  I found the script to > set the PLAY_COUNTER to 0 and would like

[RDD] Mysql syntax

My mysql script writing abilities are limited. I found the script to set the PLAY_COUNTER to 0 and would like to expand on it to set the counter to 0 only in one GROUP or by using a key in one of the CART values. Thanks for any help, Jimmy ___ Rivende

Re: [RDD] MYSQL Crashing

Awesome - glad it was a nice simple fix! Cheers, James Harrison On 26/02/2012 06:09, Lee Baker wrote: DOH! Why did I not think to check the logs 120226 12:34:24 [Note] Event Scheduler: Purging the queue. 0 events 120226 12:35:10 [Note] Plugin 'FEDERATED' is disabled. 120226 12:35:10 Inno

Re: [RDD] MYSQL Crashing

DOH! Why did I not think to check the logs 120226 12:34:24 [Note] Event Scheduler: Purging the queue. 0 events 120226 12:35:10 [Note] Plugin 'FEDERATED' is disabled. 120226 12:35:10 InnoDB: Started; log sequence number 0 44233 120226 12:35:11 [Note] Event Scheduler: Loaded 0 events 120226 12:

Re: [RDD] MYSQL Crashing

Check /var/log/mysql - if MySQL is crashing it'll be saying -something- in the logs which will help massively to debug this. Cheers, James Harrison On 26/02/2012 05:17, Lee Baker wrote: Hi All, I have a rather strange issue with mysql whereby it keeps crashing. I have a network environment

[RDD] MYSQL Crashing

Hi All, I have a rather strange issue with mysql whereby it keeps crashing. I have a network environment running and whenever other systems connect to the database the mysql server crashes. playout still works fine, but the database just crashes and none of the other systems con connect. can anyo

Re: [RDD] MySQL passwords

Robert, Thanks, I'll check it out. I'm working on some testing today and I depending on how far I get with that I'll check out the ethernet solution you've suggested. Right now I've worked around it. Bill Putney - KPTZ Port Townsend, WA On Sat, Feb 11, 2012 at 11:23 PM, Robert Jeffares wrote:

Re: [RDD] MySQL passwords

By the way, can you think of a reason why Broadcast Appliance doesn't support an Ethernet NIC that Centos 5.5 LiveCD does? The OS that is on the appliance CD does not have drivers for some on board NIC. This is no fault of Rivendell after lot of ferreting this is the solution thanks to ELRepo.o

Re: [RDD] MySQL passwords

On Feb 8, 2012, at 02:39 04, Bill Putney wrote: > Can you point me to a concise Lise of what needs to be done with 2.1.2 to > move change things from stand alone to client server? Is it the same as 1.7.2? It's pretty much the same, although of course you get some additional options with 2.x *vi

Re: [RDD] MySQL passwords

Thanks Fred. I replaced the one client that had a problem and I've got BA loaded on all the clients. Can you point me to a concise Lise of what needs to be done with 2.1.2 to move change things from stand alone to client server? Is it the same as 1.7.2? Bill Sent from my iPad On Feb 7, 2012,

Re: [RDD] MySQL passwords

On Feb 7, 2012, at 14:55 59, Bill Putney wrote: > By the way, can you think of a reason why Broadcast Appliance doesn't support > an Ethernet NIC that Centos 5.5 LiveCD does? RedHat must have backported the driver as part of one of the point updates. Cheers! |-

Re: [RDD] MySQL passwords

On Feb 7, 2012, at 15:36 30, Bill Putney wrote: > Is there any reason the server needs to run Broadcast Appliance? Does it just > need an NFS server and a MySQL server? So long as it's a 'pure' server --i.e. no Rivendell code running on it. Cheers! |---

Re: [RDD] MySQL passwords

On Feb 7, 2012, at 15:33 27, Bill Putney wrote: > Now I really need to get the ethernet drivers in Broadcast Appliance working Chances are good that Intel has these drivers already packaged that could be bootstrapped with the installation. The stock 'RedHat 5' packages should work fine. Cheer

Re: [RDD] MySQL passwords

Hi, Just a suggestion, you might want to consider using the rrabuntu install for the OS and then installing the 2.1.2 packages from Alban. See the followign post: http://lists.rivendellaudio.org/pipermail/rivendell-prog/2012-January/001684.html You already know that Ubuntu 10.04 (the version w

Re: [RDD] MySQL passwords

I think you need apache as well, but no you don't have to run the appliance, I do some contract work for a station that uses broadcast appliance on the workstations but is using an Ubuntu server...now they do other things on that server that have occasionally caused a problem but that's a diffe

Re: [RDD] MySQL passwords

Thanks Fred. By the way, can you think of a reason why Broadcast Appliance doesn't support an Ethernet NIC that Centos 5.5 LiveCD does? Bill Putney - KPTZ Port Townsend, WA On Feb 7, 2012, at 11:23, Fred Gleason wrote: > On Feb 7, 2012, at 14:00 38, Bill Putney wrote: > >> I tried using th

Re: [RDD] MySQL passwords

Fred, Is there any reason the server needs to run Broadcast Appliance? Does it just need an NFS server and a MySQL server? Bill On Tue, Feb 7, 2012 at 11:23 AM, Fred Gleason wrote: > On Feb 7, 2012, at 14:00 38, Bill Putney wrote: > > > I tried using the only password anyone has suggested for R

Re: [RDD] MySQL passwords

OK... Laboring under a delusion here. I was thinking that the v1.13 RRAbuntu was 2.1.2. I just got an eMail from Geoff Barkman and it turns out that the System Info comment is correct! RRAbuntu is NOT Rivendell 2.1.2! Now I really need to get the ethernet drivers in Broadcast Appliance working an

Re: [RDD] MySQL passwords

Thanks for the reminder. That got me in but things are still broken. :( Bill On Tue, Feb 7, 2012 at 12:21 PM, wrote: > I could be remembering incorrectly, but I think that the root MySQL > password on RRABuntu was set to be "rivendell" > unless you changed it. > > I can't recall if it was capi

Re: [RDD] MySQL passwords

I could be remembering incorrectly, but I think that the root MySQL password on RRABuntu was set to be "rivendell" unless you changed it. I can't recall if it was capitalized, so try: Rivendell and rivendell See if it works. ___ Rivendell-dev mailing

Re: [RDD] MySQL passwords

On Feb 7, 2012, at 14:00 38, Bill Putney wrote: > I tried using the only password anyone has suggested for Rivendell's root > MySQL password "mysql" and this is what I get; This will totally depend on what the underlying distro has configured as the default password. For Broadcast Appliance, i

Re: [RDD] MySQL passwords

If you did original linux install and included mysql server db in that install, it likely asked for a "mysql root user" password on install; if not u shud be able to use mysql command line interface or MySQLadmin/workbench GUI access to do it. it is mySQL ROOT PW is looking for i think as I re

Re: [RDD] MySQL passwords

Is there any of the RRAbuntu development folks around? I haven't seen Geoff or Frederick on the board for a while. Has anyone noticed that the System Info button in the RDAdmin screen still shows Rivendell version 1.7.1? I've loaded what I think is the most recent version RRAbuntu v1.13.iso. I tho

Re: [RDD] MySQL passwords

I tried using the only password anyone has suggested for Rivendell's root MySQL password "mysql" and this is what I get; root@auto-srv:~/etc# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) On Tue, Feb 7, 2012 at 9:28 AM, Kevin

Re: [RDD] MySQL passwords

I just loaded the RRAbuntu LiveCD. I haven't changed anything in MySQL. Here's what I get without a password; root@auto-srv:~/etc# mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) root@auto-srv:~/etc# On Tue, Feb 7, 2012 at 10:26 AM, Benjamin D. F

Re: [RDD] MySQL passwords

If the root password has not been set, then you would connect by typing: mysql -u root without the -p it will attempt to connect without a password. *Benjamin Fillmore *Fillmore Integrated Technical Services, Inc. 1011 Cherry Ave, Suite B Nashville, TN 37203 (615) 866-0674 office (949) 209-568

  1   2   >