<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><br>
</p>
<div class="moz-cite-prefix">On 6/21/24 10:52, James Abernathy
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CANFv2EmVaU97tVhzVYSRrdh62c2co296akEbQLyOLcaspPxCdw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Jun 20, 2024 at
6:11 PM James Abernathy <<a
href="mailto:jfabernathy@gmail.com" moz-do-not-send="true"
class="moz-txt-link-freetext">jfabernathy@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Jun 20, 2024
at 5:59 PM Mike Perkins <<a
href="mailto:mikep@randomtraveller.org.uk"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">mikep@randomtraveller.org.uk</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On
20/06/2024 22:46, James Abernathy wrote:<br>
> On Thu, Jun 20, 2024 at 7:09 AM James Abernathy
<<a href="mailto:jfabernathy@gmail.com"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">jfabernathy@gmail.com</a>><br>
> wrote:<br>
><br>
>> Not sure where I went wrong. On Debian 12
Bookworm, if I create the mythtv<br>
>> group and user before I install the .deb
packages I can get mythtv setup<br>
>> using Web App, but with some extra steps.
The backend works correctly. The<br>
>> problem shows up running mythfrontend as a
mythtv user permission issue.<br>
>><br>
>> If I don't create user mythtv and just
install the deb packages, Web App<br>
>> starts showing mythconverg already setup
completely. In this case<br>
>> mythfrontend works.<br>
>><br>
>> Jim A<br>
>><br>
><br>
> As a further test case I created a system on
Kubuntu 24.04 LTS and<br>
> installed maradb-server.<br>
><br>
> Next I created the mythtv group id 200 and mythtv
user id 200. I then<br>
> added my user, jim, to group mythtv.<br>
><br>
> Then I installed mythtv using the
<a class="moz-txt-link-freetext" href="ppa:mythbuntu/34">ppa:mythbuntu/34</a>. After installation, I<br>
> rebooted.<br>
><br>
> At this point the Web app came up with no issues.
The database was already<br>
> set up without further messing around.<br>
><br>
> So maybe the Debian mythtv packaging does
something funny if the user and<br>
> group mythtv is created before installing the
mythtv packages. I use the<br>
> Debian 12 packages for mythtv that I build
regularly on a VM and store in a<br>
> repo on my NAS.<br>
><br>
Please note that user/200 and group/200 are /still/ in
the system uid and gid range. The numbers in<br>
this range can be arbitrarily allocated to various
susbsytems in random order if and when they are<br>
installed. I do not know if the install mechanism has
any collision detection.<br>
<br>
It is possible that your previous attempt re-used a
uid or gid that had already been allocated.<br>
<br>
I always allocate the mythtv user and group before
installing any software. I make sure I put mine<br>
in the *user* range (> 1000), in my case 1006/1006.
This ensures no accidents or collisions.<br>
<br>
--<br>
<br>
Mike Perkins<br>
</blockquote>
<div><br>
</div>
<div>Thanks, I don't think it's a collision at this
point in either group our user is. However I just got
the same error with mythfrontend on Kubuntu 24.04 as I
got on Debian 12 with the user created before
installation.</div>
<div><br>
</div>
<div>Either way, I'll test with users> 1000 and see
what happens.</div>
<div><br>
</div>
<div>The error on mythfrontend is:</div>
<div><span style="font-family:monospace">2024-06-20
18:03:04.715443 I Start up testing connections. DB
localhost, BE , attempt 0, status dbAwake, Delay:
2000<br>
2024-06-20 18:03:05.248215 E [DBManager0] Unable to
connect to database!<br>
2024-06-20 18:03:05.248264 E Driver error was
[1/1045]:<br>
QMYSQL: Unable to connect<br>
Database error was:<br>
Access denied for user 'mythtv'@'localhost' (using
password: YES)</span></div>
<div><span style="font-family:monospace"><br>
</span></div>
<div><span style="font-family:arial,sans-serif">Jim A</span></div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>After more testing, I've found that this is not related
to whether you have mysql or mariadb as your database. It
appears that if you don't create your mythtv user/group
ahead of time. Debian 12 and Ubuntu create the database
properly and set up config.xml so that mythfrontend works.
I did find that on mysql database you get a Web App
warning/error about needing to have the timezones setup
correctly. It gives you the command to execute in a terminal
and that fixes it. On mariadb you don't get this error.</div>
<div><br>
</div>
<div>I have not found a way to setup the mythtv user and group
ahead of the mythtv installation that allows mythfrontend to
work without a permission problem. It appears that the
backend is working in these cases, but on my test VM I can't
test that without mythfrontend.</div>
<div><br>
</div>
<div>Jim A<br>
<br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
</blockquote>
<p>Is the backend on the same VM as the frontend and using the same
login user?<br>
</p>
<p>Unable to connect to database looks like a problem with the
config.xml. Perhaps this is only set up in the install script if
the mythtv user does not yet exist.</p>
<p>Peter<br>
</p>
<p>Peter<br>
</p>
</body>
</html>