[mythtv-users] New install, can't restore database with mythconverg_restore.pl - mysql access denied

[Mark Perkins]

> On 8 Oct 2014, at 4:13 pm, "Kingsley Turner" <krt at krt.com.au> wrote:
> 
> Hi-yas,
> 
> I had so much trouble after a mythbuntu 12.04->14.04 update I've re-installed.
> 
> However I can't seem to get my database restored:
> 
>   # mythconverg_restore.pl --drop_database --create_database --directory . --filename mythconverg-1317-20141008051044.sql.gz
>   ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES)
>   ERROR: Cannot write to mysql, stopped at /home/kingsley/Bin/mythconverg_restore.pl line 1720, <BACKUP> line 793.
> 
> Huh?
> 
> It's just using the password out of /home/mythtv/.mythtv/config.xml AFAIK.
> (this is the same as the default user .mythtv/config.xml)

The verbose log says /home/kingsley/.mythtv/config.xml

> 
> any help much appreciated.
> 
> ta,
> -kt
> 
> 
> 
> PS> Verbose log follows:
> 
> 
> 
> 
> 
> 
> 
> 
> # mythconverg_restore.pl --drop_database --create_database --directory . --filename mythconverg-1317-20141008051044.sql.gz
> ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES)
> 
> ERROR: Cannot write to mysql, stopped at /home/kingsley/Bin/mythconverg_restore.pl line 1720, <BACKUP> line 793.
> kingsley at mediabox:~$ mythconverg_restore.pl --verbose --drop_database --create_database --directory . --filename mythconverg-1317-20141008051044.sql.gz
> 
> Configuring environment:
>  -    username: kingsley
>  -        HOME: /home/kingsley
>  - MYTHCONFDIR: /home/kingsley/.mythtv
> 
> Parsing configuration files:
>  - checking: /home/kingsley/.mythtv/config.xml
>     parsing: /home/kingsley/.mythtv/config.xml
>  - checking: /home/kingsley/.mythtv/backuprc
> 
> Applying command-line arguments.
> 
> Checking configuration.
> 
> Database Information:
>         DBHostName: localhost
>             DBPort: 3306
>         DBUserName: mythtv
>         DBPassword: XXX
>             DBName: mythconverg
>        DBSchemaVer:
>  DBBackupDirectory: .
>   DBBackupFilename: mythconverg-1317-20141008051044.sql.gz
>      drop_database: yes
>    create_database: yes
> 
> Executables:
>       mysql_client: mysql
>         uncompress: gzip -d
> 
> Miscellaneous:
>    partial_restore: no
>   restore_xmltvids: no
>    change_hostname: no
> 
> Checking database.
> 
> Preparing initial database.
> Dropping database.
> Creating database.
> Setting database character set.
> 
> Found 0 tables in the database.
> 
> Backup file is compressed.
> - Uncompressing backup file with IO::Uncompress::Gunzip.
> 
> Attempting to use supplied password for mysql command-line client.
> Any [client] or [mysql] password specified in the MySQL options file will
> take precedence.
> 
> Executing command:
> 'mysql' --defaults-extra-file='/tmp/s4VJCxmsai' --host='localhost' --port='3306' --user='mythtv' 'mythconverg'
> ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES)
> 
> ERROR: Cannot write to mysql, stopped at /home/kingsley/Bin/mythconverg_restore.pl line 1720, <BACKUP> line 793.
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org