Your message dated Wed, 03 Feb 2016 22:09:16 +0000
with message-id <[email protected]>
and subject line Bug#810858: fixed in php-horde-db 2.3.1-1
has caused the Debian Bug report #810858,
regarding webmail-install and horde try to create db schema multiple times +
wrong schema version
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
810858: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=810858
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: php-horde-webmail
Version: 5.2.11-1
I had to fresh reinstall horde on Debian testing.
It was installed several months ago on the same machine and it was
working, it passed through a series of updates and I just had to update
the DB schema of some components.
Now with the same package version that were previously working fine and
coming from a series of upgrades I can't get a fresh install working.
I did
1) createuser -E -P horde
2) createdb -O horde horde "Horde DB"
3) webmail-install
it creates and populate a bunch of tables then it fail when it tries to
recreate imp_schema_info.
Duplicate table: 7 ERROR: relation "imp_schema_info" already exists
Still connecting to horde with the browser somehow works... I keep
generating conf.php files for the various application (horde included).
Statuses change to "Application is ready."
The SQL Shell works and it is able to connect to my DB but still all
columns in "Database" says "DB access is not configured".
log out, log in again it tries once more to create imp_schema_info table.
Dropped the DB, run horde-db-migrate. It successfully build the DB with
no error this time but again, when I log into horde it tries again to
create imp_schema_info table.
After I log in and refresh the page in it doesn't try to recreate tables
(getMigrator get called just on login) but still I can't get it work
properly.
I still see "DB access is not configured", in "portal" it says User ivan
is not authorized for Mail (Host: gloom.home.webthatworks.it).
And I get:
SQLSTATE[42703]: Undefined column: 7 ERROR: column "event_timezone" does
not exist LINE 1: ...endees, event_title, event_recurcount, event_url,
event_time... ^
So possibly this indicates that there is not just a problem of horde
trying to create multiple times tables, but some table get created with
a different schema than the one expected by the rest of the program.
imp_schema_info is not the only table that horde tries to create
multiple times. If I drop it from pgsql there is another one that
produce the same error, if I drop those 2, there is another one that
cause the error, so apparently it is trying to recreate twice the whole
schema.
Up to my understanding at every login it feels it has to update the
schema no matter what in getMigrator().
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--- End Message ---
--- Begin Message ---
Source: php-horde-db
Source-Version: 2.3.1-1
We believe that the bug you reported is fixed in the latest version of
php-horde-db, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Mathieu Parent <[email protected]> (supplier of updated php-horde-db package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Wed, 03 Feb 2016 21:03:13 +0100
Source: php-horde-db
Binary: php-horde-db
Architecture: source all
Version: 2.3.1-1
Distribution: unstable
Urgency: medium
Maintainer: Horde Maintainers <[email protected]>
Changed-By: Mathieu Parent <[email protected]>
Description:
php-horde-db - ${phppear:summary}
Closes: 810858
Changes:
php-horde-db (2.3.1-1) unstable; urgency=medium
.
* New upstream version 2.3.1
- Improve getting tables and indexes from PostgreSQL servers
(Closes: #810858)
Checksums-Sha1:
e39d02027ae1f2bddca5e5a6cd732665469bb922 1983 php-horde-db_2.3.1-1.dsc
4f14019fcc6fbf64633f1f87d4c45f2395b54c0d 93943 php-horde-db_2.3.1.orig.tar.gz
13e4e70bcd1c91ce454b2ed93169b9549cb4960e 3632
php-horde-db_2.3.1-1.debian.tar.xz
12bd5a034e7d072e90a0e75eb3d6ee3339b58574 70572 php-horde-db_2.3.1-1_all.deb
Checksums-Sha256:
8a800ca9b9df8fc5febe8ad3684ea70aa6a4b46cc0ee59a9e13de1289e7dc88b 1983
php-horde-db_2.3.1-1.dsc
836ddefbc6b02bdcf82aef6d82f98cd12b0da245fe4b72238b8647f47d1f6f05 93943
php-horde-db_2.3.1.orig.tar.gz
9be04325163aa407be53cfe8daf84c0181eb403d57984a4409cc278eeb455c77 3632
php-horde-db_2.3.1-1.debian.tar.xz
74515f434303614c651a1de86a1ac3d63a908af0055b29cb0b4c6bedb872008e 70572
php-horde-db_2.3.1-1_all.deb
Files:
c04ee69b3b175cd020b7001dc5dcc2bb 1983 php extra php-horde-db_2.3.1-1.dsc
768131569c1b540766d4a0824b9bacd6 93943 php extra php-horde-db_2.3.1.orig.tar.gz
7b64dbc1b5982c7563d3a30588ef8901 3632 php extra
php-horde-db_2.3.1-1.debian.tar.xz
5e876d785bbf6da6a9035d8c0193171f 70572 php extra php-horde-db_2.3.1-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iQIcBAEBCAAGBQJWsl7QAAoJEK4DmARmaB+lPuIP/jS1oHs1feOBFaFdwbkXpRu+
ExY6CSBa33hgQWdmxaU1sX6A0Uz3AP1Ye9UlgfuhLu6wW2XQjSthpMB5ddwww0Uv
lEON6jiLj/kQalXW4HPIZ030gT0JWcD8FnlNfaevJK3NalvFK5e2yKIkcZgOLlhI
uxFcPOywKbvNrP/o7UA0yS7Lp6NOfLNobQr33ti8wA0rK6nD4feH9mrRvnyPFnIQ
S9iloa4Zot7/brdqevw8scWg7Srby1IU69ALEwh8x5Z17ECr7XhQP2gij+B1GhKH
7Cl6qpNl4CgwZUiexuNji5elegb8caugwvzMupLg7qPvXxCsAA6t+MwrOIAg2xuq
SOuJuVHZgqB12slYKvPnSCCtG5ysf/GWdbzrMz9ONNw44YoQOfozl+9J+Tr7b/lW
yxm/hZvmnRGr8xiGbh2HJAcJWIxXBdqkDKp77EuNBu4Gc+5ufZlbNTpB3J2i65aT
uImAww/vaba5ZoHaNG/cFuC1pSzNgBtgwvDVqpQGX8jtl5ovGzjqq3PWmJx7pAAx
C4xpHUK6O9M3VHukRZvzET3BJrchgDCpbW904mAupHqY3LNIDaK0c/bAlYhEdk0K
eUPDb1V+XVJ2hLLEbMMREp+b7QjyK8I9qTAH0lykJlvsw2qZNl6MUsPkUf+Um++r
PSodoNUKH7ugPKD8/W3i
=Ck9l
-----END PGP SIGNATURE-----
--- End Message ---