Bug#595536: fails to install, error during dbconfig step

[Marc Dequènes (Duck)]

severity 595536 important
thanks


Coin,

Sorry, i was a bit busy.

Quoting David Prévot <da...@tilapin.org>:

I'm not sure if it has any influence, but I'm not well aware of this
part of the package's scripts. You may try to build the package from the
VCS or directly install the one I just built [1] in order to make sure
that your problem is orthogonal with this issue.

[1] http://debian.tilapin.org/phpbb3_3.0.7-PL1-3_all.deb

This solves the first error, but the access denied error is still there.

Happily, purging the package is not affected by the broken install, and it is quite easy to reproce at will :-).

Thanks a lot, please try:
        PB3DEBUG=maint dpkg -i phpbb3_3.0.7-PL1-3_all.deb

Here it is:
-----------------------------------------------------------------------
[r...@toushirou ~]# PB3DEBUG=maint dpkg -i phpbb3_3.0.7-PL1-3_all.deb
Selecting previously deselected package phpbb3.
(Reading database ... 108679 files and directories currently installed.)
Unpacking phpbb3 (from phpbb3_3.0.7-PL1-3_all.deb) ...
Setting up phpbb3 (3.0.7-PL1-3) ...
[maint] /var/lib/dpkg/info/phpbb3.postinst configure
[maint] /var/lib/dpkg/info/phpbb3.config configure
/var/lib/dpkg/info/phpbb3.config:83
/var/lib/dpkg/info/phpbb3.config:83
[dbc] phpbb3/dbconfig-install true
[dbc] phpbb3/dbconfig-upgrade true
[dbc] phpbb3/dbconfig-reinstall false
[dbc] phpbb3/dbconfig-remove
[maint] /var/lib/dpkg/info/phpbb3.postinst configure
/var/lib/dpkg/info/phpbb3.postinst:83
[dbc] phpbb3/dbconfig-install true
[dbc] phpbb3/dbconfig-upgrade true
[dbc] phpbb3/dbconfig-reinstall false
[dbc] phpbb3/dbconfig-remove
dbconfig-common: writing config to /etc/dbconfig-common/phpbb3.conf

Creating config file /etc/dbconfig-common/phpbb3.conf with new version

Creating config file /etc/phpbb3/database.inc.php with new version
granting access to database phpbb3 for php...@localhost: success.
verifying access for php...@localhost: success.
creating database phpbb3: success.
verifying database phpbb3 exists: success.
populating database via sql...  done.
dbconfig-common: flushing administrative password
Setting admin password

dpkg: error processing phpbb3 (--install):
-----------------------------------------------------------------------

The end of PB3DEBUG=sh:
-----------------------------------------------------------------------

+ case $dbc_dbtype in

++ mysql -u phpbb3 -pEIYt949BjfH4 phpbb3 -s

-----------------------------------------------------------------------

(half an hour later...)




Thanks a lot for your help.

Regards.

--
Marc Dequènes (Duck)

ERROR 1045 (28000): Access denied for user 'phpbb3'@'Toushirou.duckcorp.org' (using password: YES) + local 'sql=UPDATE phpbb_users SET user_password='\''ea961c973e357f31978deb575b1a118c'\'' WHERE username='\''admin'\'';' ++ echo UPDATE phpbb_users SET 'user_password='\''ea961c973e357f31978deb575b1a118c'\''' WHERE 'username='\''admin'\'';' ERROR 1045 (28000): Access denied for user 'phpbb3'@'Toushirou.duckcorp.org' (using password: YES) Ok, i'm looked around at the reason why mysql was using the network, and the FQDN, instead of the UNIX socket, and after some time found a "host=" directive in the "client" part of my.cnf. Dunno why i added this directive initially, but it has been here for ages. It is now installing well; so, this is my fault, but as i had no problem with other apps, i did not pay attention. I really think the host should be enforced with "-h localhost" in the run_sql function when $dbc_dbserver is empty, to ensure it will work in all cases, independently of the local settings. I'm leaving this to your final decision, and downgrading severity.

pgpkcfktOv0Jl.pgp
Description: PGP Digital Signature