Hello On Mon, May 23, 2005 at 08:55:39PM +0300, Riku Valli wrote: ... > > Name: horde2/databasemgr_server > Template: horde2/databasemgr_server > Value: localhost > Owners: horde2 > Flags: seen > > Name: horde2/databasemgr_type > Template: horde2/databasemgr_type > Value: PostgreSQL > Owners: horde2 > Flags: seen > ... > > Name: horde2/dbpgadmin > Template: horde2/dbpgadmin > Owners: horde2 > > Name: horde2/welcome > Template: horde2/welcome > Value: > Owners: horde2 > Flags: seen > > Above all debconf fields. I can't found horde2/dbadmpass > field at database config.dat, but it is in the templates.dat. > > Actually postgres don't ask any password for user postgres and after > read/check doc's postgres don't have password. You must used it with > su.
Yes and that is the procedure that is used too. It explains why you do not have a value for it. > Procedure from /usr/share/doc/horde2/examples/db/README.gz > > ----------------snip---------------------------- > PostgreSQL > ~~~~~~~~~~ > # su - postgres (or whatever your database runs as... usually postgres) > $ psql -d template1 -f pgsql_create.sql > This script will create a "horde" database and a "horde" user. You > should set a password for this user with this command (if you didn't > uncomment the one in pgsql_create.sql): > > $ psql -qc "ALTER USER horde WITH PASSWORD 'pass';" template1 postgres > > Then create the tables within the "horde" database: > > $ psql -d horde -f auth.sql > $ psql -d horde -f prefs.sql > $ psql -d horde -f category.sql > > These scripts will also grant the "horde" user the necessary privileges > to each of the tables. This is how the wwwconfig-common (that horde2 uses) do this. > ________________________snip__________________ > > These psql -d horde2 -f auth.sql etc commands fails. > > I made manually this procedures and changes database horde to horde2 and > manager name from horde to hordemgr. > > > > > As you have problem with postgres I can not really help you > > because I do not know postgres very well. You have to configure > > postgres to allow horde2/dbpgadmin (postgres) user to be able to > > manage the database. > > Yes i understand, but problem isn't that system not work. It's work > pretty well. I tried only give my cents for installation script. > It seems at now it need made partially manual or may be i made mistake > some where. > > I belive at i should edited pg_hba.conf before i tried install horde2, > when i have time i going to check it. Unfortunatly you have to do that yes. It should be enough to edit that file and then run dpkg-reconfigure horde2 and maybe change some values. There is postgres support on horde2 (at installation) but it is not perfect unfortunatly. I can recommend you to use horde3 by the way. :) Regards, // Ola > Regards, Riku > > > > > Regards, > > > > // Ola > > > > On Thu, May 19, 2005 at 09:06:38PM +0300, Riku Valli wrote: > > > On Thu, May 19, 2005 at 10:09:45AM +0200, Ola Lundqvist wrote: > > > > Hello > > > > > > > > On Wed, May 18, 2005 at 11:22:02PM +0300, Riku Valli wrote: > > > > > Package:horde2 > > > > > Version: 2.2.8-1 > > > > > > > > > > It seems at debconf don't install tables for horde2 (auth.sql, > > > > > category.sql and prefs.sql), > > > > > turba ( pgsql_create.sql). Them should manually installed by psql, > > > > > but > > > > > remember your debconf made database name horde2 and user hordemgr. > > > > > So > > > > > scripts must change, because default is horde for database and horde > > > > > for > > > > > manager. I means scripts under /usr/share/doc/"package" > > > > > > > > The turba problem is a known bug, but I do not know a solution. The > > > > horde2 > > > > > > 2005-05-18 10:46:27 [20342] LOG: connection authorized: user=hordemgr > > > database=horde2 > > > 2005-05-18 10:46:27 [20342] ERROR: permission denied for relation > > > turba_objects > > > > > > May be this gives some hint? I hope. > > > > > > > problem is unknown or actually I did not really understand you here. > > > > Did you provide the correct user and/or password? > > > > > > New installation... and answered debconfs questions... > > > database name horde and so on > > > snips from debconf database > > > > > > Name: horde2/database_name > > > Template: horde2/database_name > > > Value: horde2 > > > Owners: horde2 > > > Flags: seen > > > > > > Name: horde2/database_user > > > Template: horde2/database_user > > > Value: hordemgr > > > Owners: horde2 > > > Flags: seen > > > > > > snip from postgres.log > > > > > > 2005-05-17 14:20:22 [13063] LOG: connection authorized: user=postgres > > > database=horde2 > > > 2005-05-17 14:20:22 [13063] FATAL: database "horde2" does not exist > > > 2005-05-17 14:20:22 [13086] LOG: connection received: host=[local] > > > port= > > > 2005-05-17 14:20:22 [13086] LOG: connection authorized: user=postgres > > > database=template1 > > > 2005-05-17 14:20:22 [13110] LOG: connection received: host=[local] > > > port= > > > 2005-05-17 14:20:22 [13110] LOG: connection authorized: user=postgres > > > database=horde2 > > > 2005-05-17 14:20:22 [13145] LOG: connection received: host=[local] > > > port= > > > 2005-05-17 14:20:22 [13145] FATAL: IDENT authentication failed for user > > > "hordemgr" > > > __________________________________________________________________________ > > > Debconf ended i belive ..... > > > and > > > after read your documentation ...... > > > changed pg_hba.conf. > > > host all hordemgr 127.0.0.1 255.0.0.0 password > > > may be better is > > > host horde2 hordemgr 127.0.0.1 255.255.255.255 password > > > and > > > tried again ... > > > > > > 2005-05-17 15:23:06 [15869] LOG: connection authorized: user=hordemgr > > > database=horde2 > > > 2005-05-17 15:23:06 [15869] ERROR: relation "horde_prefs" does not > > > exist > > > 2005-05-17 15:23:06 [15869] ERROR: relation "horde_prefs" does not > > > exist > > > 2005-05-17 15:23:06 [15870] LOG: connection received: host=127.0.0.1 > > > port=340752005-05-17 15:23:06 [15870] LOG: connection authorized: > > > user=hordemgr database=horde2 > > > > > > I installed rest of stuff from /usr/share/doc/horde2/examples/db# and > > > these scripts assumed at your default database is horde and default user > > > name is horde too. > > > > > > It seems at you used user postgres only made horde2 database and tried > > > install rest of stuff with user hordemgr? This may be best explain for > > > this? > > > > > > > > > > > > sork-vacation is broke, you got message Can't parse your email > > > > > address, > > > > > but you can remove vacation, but not made new one. It seems at > > > > > /usr/share/horde2/vacation/lib/Driver.php is changed ;-) and > > > > > /usr/share/php/Mail/RFC822.php too. I roll back RFC822.php from > > > > > @version > > > > > $Revision: 1.12 $ to * @version $Revision: 1.11 $ and this gives back > > > > > functionality. I tried latest version 1.2 too, but seems at after > > > > > version 1.12 some think is changed. Forwards work maybe is possible > > > > > take > > > > > code from Forward Driver.php, but i am not familiar with php. > > > > > > > > Can you file a separate bug against this package, and if possible a > > > > patch? It would be really nice. > > > > > > I filed this again, but i am not familiar with php => no patch > > > i am really sorry about that, but if i found anythink i am going to > > > forward it for you and seems at > > > http://list.horde.org/archives/sork/Week-of-Mon-20050502/002166.html > > > tell more. > > > > > > > > > > > > It seems at ingo is going to replace sork packets, but it seems at > > > > > Debian packages don't include forward and vacation functions, pls > > > > > update > > > > > if possible. > > > > > > > > Please file a wishlist bug about this on ingo package. > > > > > > I filed this too. After check closer it seems at functionality is on > > > this package;-) /usr/share/horde3/ingo/config/prefs.php > > > Need RTFM > > > > > > Regards, > > > > > > -- Riku > > > > > > > > > > > Regards, > > > > > > > > // Ola > > > > > > > > > Thanks gor advance > > > > > > > > > > Regards, Riku > > > > > > > > > > -- System Information: > > > > > Debian Release: 3.1 > > > > > APT prefers testing > > > > > APT policy: (500, 'testing') > > > > > Architecture: i386 (i686) > > > > > Kernel: Linux 2.4.27-2-686-smp > > > > > Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) > > > > > > > > > > Versions of packages horde2 depends on: > > > > > ii apache2 2.0.54-3 next generation, > > > > > scalable, > > > > > extenda > > > > > ii apache2-mpm-prefork [httpd] 2.0.54-3 traditional model for > > > > > Apache2 > > > > > ii binutils 2.15-5 The GNU assembler, > > > > > linker > > > > > and bina > > > > > ii debconf 1.4.30.13 Debian configuration > > > > > management sy > > > > > ii gettext 0.14.1-10 GNU Internationalization > > > > > utilities > > > > > ii logrotate 3.7-2 Log rotation utility > > > > > ii make 3.80-9 The GNU version of the > > > > > "make" util > > > > > ii perl 5.8.4-8 Larry Wall's Practical > > > > > Extraction > > > > > ii php4 4:4.3.10-13 server-side, > > > > > HTML-embedded > > > > > scripti > > > > > ii php4-pear 4:4.3.10-13 PEAR - PHP Extension and > > > > > Applicati > > > > > ii php4-pear-log 1.6.0-1.1 Log module for PEAR > > > > > ii wwwconfig-common 0.0.43 Debian web auto > > > > > configuration > > > > > > > > > > Versions of packages sork-vacation depends on: > > > > > ii apache2-mpm-prefork [httpd] 2.0.54-3 traditional model for > > > > > Apache2 > > > > > ii gettext 0.14.1-10 GNU Internationalization > > > > > utilities > > > > > ii horde2 2.2.8-1 horde web application > > > > > suite > > > > > ii make 3.80-9 The GNU version of the > > > > > "make" util > > > > > ii php4 4:4.3.10-13 server-side, > > > > > HTML-embedded > > > > > scripti > > > > > ii turba 1.2.5-1 A web based contact > > > > > manager > > > > > > > > > > -- debconf information: > > > > > * horde2/database_user: hordemgr > > > > > * horde2/welcome: > > > > > * horde2/databasemgr_port: 5432 > > > > > * horde2/databasemgr_type: PostgreSQL > > > > > * horde2/database_name: horde2 > > > > > horde2/dbpgadmin: postgres > > > > > * horde2/databasemgr_server: localhost > > > > > horde2/dbmyadmin: root > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > --------------------- Ola Lundqvist --------------------------- > > > > / [EMAIL PROTECTED] Annebergsslingan 37 \ > > > > | [EMAIL PROTECTED] 654 65 KARLSTAD | > > > > | +46 (0)54-10 14 30 +46 (0)70-332 1551 | > > > > | http://www.opal.dhs.org UIN/icq: 4912500 | > > > > \ gpg/f.p.: 7090 A92B 18FE 7994 0C36 4FE4 18A1 B1CF 0FE5 3DD9 / > > > > --------------------------------------------------------------- > > > > > > > -- > > --- Ola Lundqvist systemkonsult --- M Sc in IT Engineering ---- > > / [EMAIL PROTECTED] Annebergsslingan 37 \ > > | [EMAIL PROTECTED] 654 65 KARLSTAD | > > | http://www.opal.dhs.org Mobile: +46 (0)70-332 1551 | > > \ gpg/f.p.: 7090 A92B 18FE 7994 0C36 4FE4 18A1 B1CF 0FE5 3DD9 / > > --------------------------------------------------------------- > -- --- Ola Lundqvist systemkonsult --- M Sc in IT Engineering ---- / [EMAIL PROTECTED] Annebergsslingan 37 \ | [EMAIL PROTECTED] 654 65 KARLSTAD | | http://www.opal.dhs.org Mobile: +46 (0)70-332 1551 | \ gpg/f.p.: 7090 A92B 18FE 7994 0C36 4FE4 18A1 B1CF 0FE5 3DD9 / --------------------------------------------------------------- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
