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

[Don]

Bryan Halter wrote:

> 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
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
Tried as user:
mysql -u root
bash: mysql: command not found

Tried as root:
mysql -u root
bash: mysql: command not found

Changed don at localhost to localhost:
DBHostName=localhost
DBUserName=don
DBPassword=mythtv
DBName=mythconverg
DBType=QMYSQL3

dlw