Hey Michael,
On 3/29/21 22:12, you wrote:
> Hi Robert,
>
> I should have mentioned this but the rd.conf does point to the correct server.
> We have also tested pointing to our production environment and the client
> connects just fine.
>
> Thanks,
> Mike
>
My guess is that the MariaDB server is not accepting connections or
logins from systems other than "localhost".
You can check this in a terminal window on the server:
sudo mysql -u root -p mysql
Enter your mysql "root" password here, not the Linux "root" password. On
successful authentication, you'll be running the mysql "shell" (command
interpreter), and you can enter arbitrary SQL queries.
Enter the following query to list all instances of the "rduser" MariaDB
user:
select distinct user,host from user where user='rduser';
(That's a lot of `users', but basically, you're asking MariaDB to list
all the Rivendell database "users" named "rduser", and the host names
from which they are permitted to access the database.)
You should see something like this:
+--------+-----------+
| user | host |
+--------+-----------+
| rduser | % |
| rduser | localhost |
+--------+-----------+
2 rows in set (0.00 sec)
If you don't see something like the first "rduser" line, you can add the
proper entry with this SQL statement:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
LOCK TABLES ON `Rivendell`.* TO 'rduser'@'%';
FLUSH PRIVILEGES;
The '%' is a SQL wildcard (kind of like '*' in the shell) that grants
"rduser" access from any IP address or hostname. (The FLUSH statement
[which may not be needed] tells the MariadDB server to reload its
in-memory privileges table.)
To be a bit more more secure, you could substitute the actual IP address
of the client workstation, or something like '192.168.1.%' (or your LAN
IP network range) to limit access to IP addresses on the 192.168.1.0
private network.
Hope this helps!
~David Klann
Broadcast Tool & Die
> ──────────
> *Michael Vasile*
> Chief Engineer
> WITR-FM 89.7
> [email protected] <mailto:[email protected]>
>
>
> On Mon, Mar 29, 2021 at 9:26 PM Robert Jeffares <[email protected]
> <mailto:[email protected]>> wrote:
>
> Hi Michael,
>
> the client machine needs to have /etc/rd.conf amended to point to the
> server
> machine
>
> here is one from my setup
>
> [mySQL]
> ; The connection parameters for the MySQL server.
> Hostname=192.168.1.110 #localhost
> Loginname=rduser
> Password=********
> Database=Rivendell
> Driver=QMYSQL3
>
> regards
>
> Robert
>
>
>
> On 30/03/21 9:37 am, Michael Vasile wrote:
>> Hi there,
>>
>> We're setting up a development environment to test migrating from
>> Rivendell 2.9.10 to 3.5. We've set up two RHEL 7 machines, with one being
>> the server, and one being the client. RD was installed on both using the
>> script, with the appropriate flags.
>>
>> For some reason, when trying connect to the server from the client via
>> rdadmin, we keep getting errors saying "Unable to connect to mySQL!"; the
>> server has MariaDB running, etc. We are able to access the server via the
>> mysql command line utility.
>>
>> Does anyone have any ideas as to what's going on?
>>
>> Thanks,
>> Mike Vasile
>>
>> ──────────
>> *Michael Vasile*
>> Chief Engineer
>> WITR-FM 89.7
>> [email protected] <mailto:[email protected]>
>>
>> _______________________________________________
>> Rivendell-dev mailing list
>> [email protected]
>> <mailto:[email protected]>
>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>> <http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev>
> _______________________________________________
> Rivendell-dev mailing list
> [email protected]
> <mailto:[email protected]>
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
> <http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev>
>
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
