Re: [mythtv-users] Debian install: MySQL problem
On Tue, May 17, 2005 at 10:18:43PM +0200, Tim wrote: > > Did you reload the privs after you added the new user? Try restarting MySQL > > I'm *really* ashamed now. I did forget to reload the privileges *blush* > > So, probably the script needs a password for root, but I'm not even > sure anymore... > > > Thanks a lot for the help everyone, Don't worry about it. I've been using MySQL from the time it went OS, (in fact, I was the first mirror they had), and I still sometimes get in a rush and forget to do that. Now, whenever something doesn't work right, the first thing I do is flush everything. :) Tim -- >> Tim Sailer >< Coastal Internet, Inc. << >> Network and Systems Operations >< PO Box 726 << >> http://www.buoy.com >< Moriches, NY 11955 << >> [EMAIL PROTECTED]>< (631) 399-2910 (888) 924-3728 << ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
> > > > > How about /etc/mythtv/mysql.txt?
> > > >
> > > > In /etc/mythtv/mysql.txt:
> > > > same login and password as in row 6 (mythtv user in MySQL)
> > > Can you login with mysql from the command line with the username and
> > > password ?
> >
> > Yes, I can with the root account, but I can't with the mythtv account.
> >
> > I tried resetting the password in two ways:
> > SET PASSWORD FOR 'mythtv'@'%' = PASSWORD('mythical');
> > ERROR 1133: Can't find any matching row in the user table (documented bug)
> >
> > update mysql.user set password=password('mythical') where user='mythtv';
> >
> > but still I can't login with that account.
> >
> > This makes me think there's something wrong with my query or MySQL,
> > but I don't know which... Any ideas?
>
> Did you reload the privs after you added the new user? Try restarting MySQL
I'm *really* ashamed now. I did forget to reload the privileges *blush*
So, probably the script needs a password for root, but I'm not even
sure anymore...
Thanks a lot for the help everyone,
Tim
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
On Mon, May 16, 2005 at 08:19:09PM +0200, Tim wrote:
> > > > How about /etc/mythtv/mysql.txt?
> > >
> > > In /etc/mythtv/mysql.txt:
> > > same login and password as in row 6 (mythtv user in MySQL)
> > Can you login with mysql from the command line with the username and
> > password ?
>
> Yes, I can with the root account, but I can't with the mythtv account.
>
> I tried resetting the password in two ways:
> SET PASSWORD FOR 'mythtv'@'%' = PASSWORD('mythical');
> ERROR 1133: Can't find any matching row in the user table (documented bug)
>
> update mysql.user set password=password('mythical') where user='mythtv';
>
> but still I can't login with that account.
>
> This makes me think there's something wrong with my query or MySQL,
> but I don't know which... Any ideas?
Did you reload the privs after you added the new user? Try restarting MySQL
Tim
--
>> Tim Sailer >< Coastal Internet, Inc. <<
>> Network and Systems Operations >< PO Box 726 <<
>> http://www.buoy.com >< Moriches, NY 11955 <<
>> [EMAIL PROTECTED]>< (631) 399-2910 (888) 924-3728 <<
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
> > > How about /etc/mythtv/mysql.txt?
> >
> > In /etc/mythtv/mysql.txt:
> > same login and password as in row 6 (mythtv user in MySQL)
> Can you login with mysql from the command line with the username and
> password ?
Yes, I can with the root account, but I can't with the mythtv account.
I tried resetting the password in two ways:
SET PASSWORD FOR 'mythtv'@'%' = PASSWORD('mythical');
ERROR 1133: Can't find any matching row in the user table (documented bug)
update mysql.user set password=password('mythical') where user='mythtv';
but still I can't login with that account.
This makes me think there's something wrong with my query or MySQL,
but I don't know which... Any ideas?
Cheers,
Tim
___
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
On Monday 16 May 2005 16:53, Tim wrote: > > How about /etc/mythtv/mysql.txt? > > In /etc/mythtv/mysql.txt: > same login and password as in row 6 (mythtv user in MySQL) Can you login with mysql from the command line with the username and password ? Stef ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
> How about /etc/mythtv/mysql.txt? In /etc/mythtv/mysql.txt: same login and password as in row 6 (mythtv user in MySQL) I even tried putting root in /etc/mythtv/mysql.txt Cheers, Tim ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
On 5/16/05, Tim <[EMAIL PROTECTED]> wrote: > Are there any other places where login/password combinations can be stored? How about /etc/mythtv/mysql.txt? James. ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
> > > > Since I've got the following accounts in mysql.user: > > > > +---+--+--+ > > > > | host | user | password | > > > > +---+--+--+ > > > > | localhost | root | *** | > > > > | stewie| root | *** | > > > > | localhost | | | > > > > | stewie| | | > > > > | localhost | debian-sys-maint | *** | > > > > | localhost | mythtv | *** | > > > > +---+--+--+ > > > > > > What happens if you put localhost.localdomain (as that's what the > > > error message implies your connecting as) in the host > > column instead > > > of just localhost? > > > > I changed all records with host=localhost to > > localhost.localdomain, but still it doesn't make any > > difference... The error doesn't change either... > > > > > > Sorry, I didn't see the original thread, but if you change host to %, > you should be able to connect from anywhere. This could be a security > issue, but it may help you isolate the problem. Thanks for the tip. Strange enough, I still get the same error, so the problem can only be caused by the login/password combination, I guess. This is what I currently have: In MySQL ++--+--+ | host | user | password | ++--+--+ | % | root | *** | - 1 | pcname | root | *** | - 2 | % | | | - 3 | pcname | | | - 4 | % | debian-sys-maint | *** | - 5 | % | mythtv | *** | - 6 ++--+--+ In /etc/mythtv/mysql.txt: same login and password as in row 6 dpkg-reconfigure mythtv-database: same login and password as in row 1 and 2 Are there any other places where login/password combinations can be stored? Thanks, Tim ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
> > Since I've got the following accounts in mysql.user: > > +---+--+--+ > > | host | user | password | > > +---+--+--+ > > | localhost | root | *** | > > | stewie| root | *** | > > | localhost | | | > > | stewie| | | > > | localhost | debian-sys-maint | *** | > > | localhost | mythtv | *** | > > +---+--+--+ > > What happens if you put localhost.localdomain (as that's what the > error message implies your connecting as) in the host column instead > of just localhost? I changed all records with host=localhost to localhost.localdomain, but still it doesn't make any difference... The error doesn't change either... Thanks, Tim ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
On 5/16/05, Tim <[EMAIL PROTECTED]> wrote: > Since I've got the following accounts in mysql.user: > +---+--+--+ > | host | user | password | > +---+--+--+ > | localhost | root | *** | > | stewie| root | *** | > | localhost | | | > | stewie| | | > | localhost | debian-sys-maint | *** | > | localhost | mythtv | *** | > +---+--+--+ What happens if you put localhost.localdomain (as that's what the error message implies your connecting as) in the host column instead of just localhost? James. ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
> > Failed to connect to database: Host 'localhost.localdomain' is not > > allowed to connect to this MySQL server at -e line 5, <> line 1. > > Well there's your problem, always pays to actually read the error message ;) I agree, but I don't quite understand :-( Since I've got the following accounts in mysql.user: +---+--+--+ | host | user | password | +---+--+--+ | localhost | root | *** | | stewie| root | *** | | localhost | | | | stewie| | | | localhost | debian-sys-maint | *** | | localhost | mythtv | *** | +---+--+--+ I don't know why it wouldn't be possible to connect from localhost. I'm doing the same when starting the mysql client, no? > Check if skip-networking is present in your my.cnf, looking at mine I have: > > # > # Instead of skip-networking the default is now to listen only on > # localhost which is more compatible and is not less secure. > bind-address= 127.0.0.1 I have exactly the same... Thanks for the help. Cheers, Tim ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
On 5/16/05, Tim Hoebeek <[EMAIL PROTECTED]> wrote: > Failed to connect to database: Host 'localhost.localdomain' is not > allowed to connect to this MySQL server at -e line 5, <> line 1. Well there's your problem, always pays to actually read the error message ;) Check if skip-networking is present in your my.cnf, looking at mine I have: # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address= 127.0.0.1 James. ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
> > > Are there no more errors when you install or reconfigure mythtv > > > > Here is the full log: > > > > ~# dpkg-reconfigure --force mythtv-database > > [I put in root with an empty password for MySQL] > Mhh, maybe that's the problem. Can you give the root user in the mysql > database a password and try again ? It's not the first time that I see a > script going nuts if you give an empty password. For some scripts, an empty > password means reading from STDIN. I tried with a password at first, but changed back to an empty password (I read somewhere that that was the default for a mythtv install). I've tried again with a plain password (no special characters or anything), but the error remains the same... Thanks for the help! Cheers, Tim ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
Hi Tim, > I had a similar error when I upgraded to 0.18. Turned out that stopping > mysql prior to upgrade was not a good idea. Once I restarted mysql, the > re-install went fine... MySQL has been running all the time, so I'm afraid this won't make a difference in my case... Thanks, Tim ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
Hi Stef, Thanks for the reply. > Are there no more errors when you install or reconfigure mythtv Here is the full log: ~# dpkg-reconfigure mythtv /usr/sbin/dpkg-reconfigure: mythtv is broken or not fully installed ~# dpkg-reconfigure --force mythtv [returned nothing] ~# apt-get install mythtv Reading Package Lists... Done Building Dependency Tree... Done mythtv is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 26 not upgraded. 2 not fully installed or removed. Need to get 0B of archives. After unpacking 0B of additional disk space will be used. Setting up mythtv-database (0.18-1) ... Failed to connect to database: Host 'localhost.localdomain' is not allowed to connect to this MySQL server at -e line 5, <> line 1. Failed to create database (incorrect admin username/password?) If you supplied incorrect information, try: dpkg-reconfigure --force mythtv-database dpkg: error processing mythtv-database (--configure): subprocess post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mythtv: mythtv depends on mythtv-database (= 0.18-1); however: Package mythtv-database is not configured yet. dpkg: error processing mythtv (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mythtv-database mythtv E: Sub-process /usr/bin/dpkg returned an error code (1) ~# dpkg-reconfigure --force mythtv-database [I put in root with an empty password for MySQL] All ideas more than welcome. Cheers, Tim ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
Tim Hoebeek wrote: Hi everyone, I'm trying to install MythTV on Debian testing, but I run into some problems getting the mythtv and mythtv-database packages to install. When trying apt-get install mythtv, I get the following error: dpkg: error processing mythtv-database (--configure): subprocess post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mythtv: mythtv depends on mythtv-database (= 0.18-1); however: Package mythtv-database is not configured yet. dpkg: error processing mythtv (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mythtv-database mythtv E: Sub-process /usr/bin/dpkg returned an error code (1) Then I tried the following: ~# dpkg-reconfigure mythtv /usr/sbin/dpkg-reconfigure: mythtv is broken or not fully installed ~# dpkg-reconfigure mythtv-database /usr/sbin/dpkg-reconfigure: mythtv-database is broken or not fully installed Both aren't installed yet. dpgk-reconfigure --force doesn't make any difference either. This is my mysql.user table: +---+--+--+ | host | user | password | +---+--+--+ | localhost | root | | | pcname| root | | | localhost | | | | pcname| | | | localhost | debian-sys-maint | password | | localhost | mythtv | mythical | (same pswd as in /etc/mythtv/mysql.txt) +---+--+--+ The mythtv password is now plain text, since I wasn't sure if I was escaping the special characters correctly. I don't know what else to try :-( Thanks, Tim ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users I had a similar error when I upgraded to 0.18. Turned out that stopping mysql prior to upgrade was not a good idea. Once I restarted mysql, the re-install went fine... Tim ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Debian install: MySQL problem
On Sunday 15 May 2005 22:48, Tim Hoebeek wrote: > Hi everyone, > > I'm trying to install MythTV on Debian testing, but I run into some > problems getting the mythtv and mythtv-database packages to install. > > When trying apt-get install mythtv, I get the following error: > > dpkg: error processing mythtv-database (--configure): > subprocess post-installation script returned error exit status 1 > dpkg: dependency problems prevent configuration of mythtv: > mythtv depends on mythtv-database (= 0.18-1); however: > Package mythtv-database is not configured yet. > dpkg: error processing mythtv (--configure): > dependency problems - leaving unconfigured > Errors were encountered while processing: > mythtv-database > mythtv > E: Sub-process /usr/bin/dpkg returned an error code (1) > > Then I tried the following: > ~# dpkg-reconfigure mythtv > /usr/sbin/dpkg-reconfigure: mythtv is broken or not fully installed > ~# dpkg-reconfigure mythtv-database > /usr/sbin/dpkg-reconfigure: mythtv-database is broken or not fully > installed Both aren't installed yet. > dpgk-reconfigure --force doesn't make any difference either. > > This is my mysql.user table: > +---+--+--+ > > | host | user | password | > > +---+--+--+ > > | localhost | root | | > | pcname| root | | > | localhost | | | > | pcname| | | > | localhost | debian-sys-maint | password | > | localhost | mythtv | mythical | (same pswd as in > > /etc/mythtv/mysql.txt) > +---+--+--+ > > The mythtv password is now plain text, since I wasn't sure if I was > escaping the special characters correctly. > > I don't know what else to try :-( Are there no more errors when you install or reconfigure mythtv Stef ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
[mythtv-users] Debian install: MySQL problem
Hi everyone, I'm trying to install MythTV on Debian testing, but I run into some problems getting the mythtv and mythtv-database packages to install. When trying apt-get install mythtv, I get the following error: dpkg: error processing mythtv-database (--configure): subprocess post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mythtv: mythtv depends on mythtv-database (= 0.18-1); however: Package mythtv-database is not configured yet. dpkg: error processing mythtv (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mythtv-database mythtv E: Sub-process /usr/bin/dpkg returned an error code (1) Then I tried the following: ~# dpkg-reconfigure mythtv /usr/sbin/dpkg-reconfigure: mythtv is broken or not fully installed ~# dpkg-reconfigure mythtv-database /usr/sbin/dpkg-reconfigure: mythtv-database is broken or not fully installed Both aren't installed yet. dpgk-reconfigure --force doesn't make any difference either. This is my mysql.user table: +---+--+--+ | host | user | password | +---+--+--+ | localhost | root | | | pcname| root | | | localhost | | | | pcname| | | | localhost | debian-sys-maint | password | | localhost | mythtv | mythical | (same pswd as in /etc/mythtv/mysql.txt) +---+--+--+ The mythtv password is now plain text, since I wasn't sure if I was escaping the special characters correctly. I don't know what else to try :-( Thanks, Tim ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
