[mythtv-users] trying to get mythtv-0.17 working

[Bryan Halter]

Don wrote:

> sys is AMD Athlon 1.7ghz, 512m ram
> 160g /dev/hda, 120g /dev/hdb
> cd/dvd-rw /dev/hdc, cd-rw /dev/hdd
> MDK 10.1, KDE 3.2 W98
> Hauppage PVR 350 TV card
> mythtv-0.17 installed via RPM's
>
> mythtv starts with a screen that reads:
> 'myth could not connect to database'
>
> [don at localhost don]$ mythtv
> 2005-03-20 07:30:43.911 Switching to square mode ()
> 2005-03-20 07:30:43.984 Unable to connect to database!
> 2005-03-20 07:30:43.984 Driver error was [1/2005]:
> QMYSQL3: Unable to connect
> Database error was:
> Unknown MySQL Server Host 'don at localhost' (1)
>
> couldn't open db
> 2005-03-20 07:30:43.985 Switching to square mode (blue)
> mythtv: could not connect to socket
> mythtv: No such file or directory
> lirc_init failed for mythtv, see preceding messages
> 2005-03-20 07:30:44.704 Joystick disabled.
> QSqlDatabaseManager::database: unable to open database: Can't connect 
> to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2): 
> QMYSQL3: Unable to connect
> 2005-03-20 07:30:49.160 User canceled database configuration
> couldn't open db
> [don at localhost don]$
>
> ~/.mythtv/mysql.txt:
> DBHostName=don at localhost
> DBUserName=don
> DBPassword=mythtv
> DBName=mythconverg
> DBType=QMYSQL3
>
> The screen that shows the error 'myth could not connect to database'
> has MySQL listed as the database where as ~/.mythtv/mysql.txt has 
> QMYSQL3.
> Haven't figure out how to change it yet.
>
> Database software is:
> MySQL-shared-4.11-1.i686.rpm
> libqt3-mysql-3.3.3-26mdk10.1.thac.i586.rpm
>
> I've used Linux since 98.
> I am a USER with some technical knowledge.
> I do not know diddly about databases.
> I have Dish Network.
> Signal goes from satillite box to 'vcr/dvd'
> then to TV and computer via a splitter.
> The PVR 350 has TV out but I haven't been
> able to get it working. (Reason for splitter)
> Eventually I want to run direct to computer
> from satillite box then to 'vcr/dvd' then TV.
> (I think.)
>
> Can someone help get mythtv up and running?
>
> dlw
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


When you installed the database did you go into mysql and set 
permissions on it?

Something like:

mysql -u root
 > grant all on mythconverg.* to don at localhost identified by mythtv;
<some server output>
 >quit

should do.

Also your DBHost name is not don at localhost its just localhost :) uppon 
further reflection I bet that's it.  Its trying to connecto to some 
machine called don at localhost and login as don.

--Bryan