[mythtv-users] Mythweb error {Solved}

[Nathan A. Smith]

On Wed, 2006-02-01 at 10:46 -0500, Derek Battams wrote:
> Quoting "Nathan A. Smith" <nasa01 at comcast.net>:
> 
> > Hi again,
> >
> > Continuing my quest to get all this working....
> >
> > I am getting the below error when trying to use mythweb:
> >
> > Warning at /var/www/html/mythweb/mythweb/includes/init.php, line 54:
> > mysql_connect() [function.mysql-connect]: Lost connection to MySQL
> > server during query
> > ________________________________________________________________________
> >
> > ________________________________________________________________________
> > Fatal Error at /var/www/html/mythweb/mythweb/includes/init.php, line 55:
> > Can't connect to the database server. Did you use the correct settings
> > in config/conf.php?
> >
> > The system administrator has been notified and the problem will be
> > remedied shortly.
> >
> >
> > I followed step to install from both
> > http://www.mythtv.org/docs/mythtv-HOWTO-14.html
> > and the included README...
> >
> > I installed from rpms' on my Mandriva system.
> 
> I believe this error is caused when MySQL is not setup to allow network 
> connections to the server.  Ensure networking is enabled in your my.cnf 
> file then restart MySQL.
> 
>   - Derek
Thanks Derek, 

Your observation (very close) did help point me in the right direction.
I did a google search to better understand what you were eluding to and
discovered this:

a default install of mysql on a 'Mandriva 2005' distribution.
By default, the file /etc/sysconfig/mysqld contains the following line:
MYSQLD_OPTIONS="--skip-networking"
I had to remove this.

I just commented it out -- and that did the trick.

Nasa

> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users