|
[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]
|
RE: [PLUG] MySQL3 and Fedora Core 3
|
Are you following Jarod's guide? http://wilsonet.com/mythtv/fcmyth.php
Do you see anything in the mysql log files?
> -----Original Message-----
> From: plug-bounces@lists.phillylinux.org
> [mailto:plug-bounces@lists.phillylinux.org] On Behalf Of ChrisB.
> Sent: Thursday, February 03, 2005 10:17 AM
> To: 'Joseph Kovach'
> Cc: plug@lists.phillylinux.org
> Subject: RE: [PLUG] MySQL3 and Fedora Core 3
>
> The only reason I am running mysql3 is because I did this
> entire install using apt-get and it automagically gave me
> mysql3. It installed more then a few components perfectly but
> I guess what we give up for automation is the ability to
> focus on each install one at a time.
>
> I will manually install mysql4 and give it a shot. Thanks for
> the info Joe, Ill let you all know how it goes.
>
> I need my MythTV up and running by Sunday so I can record the
> Eagles winning their first Championship in 50 years!
>
> Chris.
>
> -----Original Message-----
> From: Joseph Kovach [mailto:joe@singlewire.com]
> Sent: Thursday, February 03, 2005 10:13 AM
> To: chris@chrisbovasso.com
> Cc: plug@lists.phillylinux.org
> Subject: RE: [PLUG] MySQL3 and Fedora Core 3
>
> i don't think mysql3 has a TEMP TABLES permission. that's
> why it's failing.
> MYSQL 4 definitely does.
>
> i'd give mysql4 a try. did you mention why you're using 3?
> i have and do run FC3 with mysql4 and SELINUX with no problems.
> i like 4 because it defaults to InnoDB tables, and you don't
> have to mess with allocating space for them to set up.
>
> Joe
>
>
> Quoting "ChrisB." <chris@chrisbovasso.com>:
>
> > Actually I left out a piece of the puzzle. I tried to run the mysql
> > script that they offer but I kept getting syntax errors. So
> I tried to
> > just type
> in
> > the commands manually (its only a few lines) and it errors
> on the line:
> >
> > 'TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost
> IDENTIFIED BY
> > "mythtv"'
> >
> > The interesting part is that I know the password fix for
> MySQL4 is to
> > correct the password for the users using
> OLD_PASSWORD('newpasswd') but
> > I
> am
> > not running MySQL4. Unless Myth is running a MySQL4 client?
> >
> > Argh...
> >
> > -----Original Message-----
> > From: Joseph Kovach [mailto:joe@singlewire.com]
> > Sent: Thursday, February 03, 2005 10:01 AM
> > To: chris@chrisbovasso.com; Philadelphia Linux User's Group
> Discussion
> List
> > Subject: Re: [PLUG] MySQL3 and Fedora Core 3
> >
> > Chris B,
> > did you 'flush privileges' in mysql?
> > btw i always misspell privileges, so double check when
> you're typing
> > it yourself.
> >
> > Joe
> >
> >
> >
> >
> > Quoting "ChrisB." <chris@chrisbovasso.com>:
> >
> > > Everyone,
> > >
> > > So I bit the bullet on Tuesday and installed Fedora Core
> 3 for the
> > > first time. I have never used a RedHat product before and
> I was very
> > > impressed
> > at
> > > how easy it was to install. Apt-get, yum and rpm are truly god
> > > sends. I
> > have
> > > to admit though that I felt very naked without my trusty
> ./configure
> > > at
> my
> > > side.
> > >
> > > But I digress, I am trying to build a MythTV box and everything
> > > seemed
> to
> > go
> > > fine but I can not connect to the mysql service running.
> At first I
> > thought
> > > it was just a MythTV issue but I was unable to connect to
> the MySQL
> > through
> > > PHP as well. I keep getting the same error (see below) now I know
> > > that
> > > MySQL4 has issues with user password authentication but I am using
> MySQL3
> > > still, I read up on FC3 and the SELinux giving MySQL issues, so I
> disabled
> > > it but yet the issue persists.
> > >
> > > So as great as apt-get, yum and rpm are, it leaves me in the
> > > position of knowing next to nothing of FC3 inner workings even
> > > *after* I have successfully installed it. I am not too
> sure what to
> > > try next. Does the error strike anyone?
> > >
> > > Thanks in advance,
> > >
> > >
> > > Chris.
> > >
> > >
> > > MySQL connection error:
> > >
> > >
> > > FYI: I tried all the obvious things, password is the same,
> > > permissions,
> > etc.
> > > I can connect to MySQL through the console without an
> error but when
> > > an application tries to connect I get basically the same error
> > > 'access
> > denied'.
> > >
> > >
> > > +++++++++++++++++++++++++++
> > > Unable to connect to database!
> > > Driver error was [1/1045]:
> > > QMYSQL3: Unable to connect
> > > Database error was:
> > > Access denied for user: 'mythtv@localhost' (Using password: YES)
> > >
> > > Unable to open database:
> > > Driver error was:
> > > QMYSQL3: Unable to connect
> > > Database error was:
> > > Access denied for user: 'mythtv@localhost' (Using password: YES)
> > > +++++++++++++++++++++++++++
> > >
> > >
> > >
> > >
> > >
> > >
> >
> ______________________________________________________________
> _____________
> > > Philadelphia Linux Users Group --
> > http://www.phillylinux.org
> > > Announcements -
> > http://lists.phillylinux.org/mailman/listinfo/plug-announce
> > > General Discussion --
> > http://lists.phillylinux.org/mailman/listinfo/plug
> > >
> >
> >
> >
> >
> >
>
>
>
>
> ______________________________________________________________
> _____________
> Philadelphia Linux Users Group --
> http://www.phillylinux.org
> Announcements -
> http://lists.phillylinux.org/mailman/listinfo/plug-announce
> General Discussion --
> http://lists.phillylinux.org/mailman/listinfo/plug
>
>
___________________________________________________________________________
Philadelphia Linux Users Group -- http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion -- http://lists.phillylinux.org/mailman/listinfo/plug
|
|