[RDD] SQL problem upgrading an installation
41001140 at interpring.com
Mon May 8 09:15:07 EDT 2017
There are two distinct user names: the Linux one, which is 'rivendell' by
default; and the MySQL user name, which by default is 'rduser'.
'rivendell' is typically set up as a 'system' user; that is, it has no
login shell so you can't actually log in as, or su to, 'rivendell'. This
user should own /var/snd and all that is in it, and should be a member of
the 'audio' group and any other groups you may want it to belong to.
The MySQL 'rduser' by default has the password 'letmein'; it should have
unlimited rights to the 'Rivendell' database.
Both user names are defined in /etc/rd.conf.
Я там, где ребята толковые,
Я там, где плакаты "Вперёд",
Где песни рабочие новые
Страна трудовая поёт.
On Fri, 5 May 2017, John Edstrom wrote:
> Well, its a totally new machine, a sort of a sandbox, so the hostname is
> different. I fixed that so the hostname on the new machine is the same
> as the original. Didn't help though.
> But, I did figure out that the null query clause screwing up the queries
> was the RDUser name. For some reason the new rig isn't picking up the
> proper rd-user ID from my environment, or wherever its supposed to come
> from, so that all queries were running as if from an unprivileged user.
> Even though I do have the right credentials to run the RD tools, I don't
> have privs to do certain queries in mysql.
> Is there documentation anywhere discussing how the linux user's ID maps
> to rivendell user roles? I still don't have it quite right.
> On Fri, 2017-05-05 at 23:38 -0400, Rob Landry wrote:
>> On Wed, 3 May 2017, John Edstrom wrote:
>>> Some additional information, when I try to run the query from a
>>> terminal, I see the error message "QSqlQuery::value: not positioned on a
>>> valid record" five times, the number of letters in 'MUSIC', as it does a
>>> search for each letter entered.
>> Have you by any chance changed the host name? I've occasionally had that
>> cause problems.
>> Я там, где ребята толковые,
>> Я там, где плакаты "Вперёд",
>> Где песни рабочие новые
>> Страна трудовая поёт.
> John Edstrom <johnedstrom at firebare.org>
More information about the Rivendell-dev