Hello,
I am having trouble authenticating httpd users against a PostgreSQL
database. Maybe someone here is using that module and can help me?
The error_log shows only the following message. It doesn't matter if the
user/pass actually exists or not:
[Tue Nov 30 12:06:51 2010] [error] access to /path failed for
xxx.xxx.xxx.xxx, reason: mod_auth_pgsql: Password for user test not
found (PG-Authoritative)
The config file contains the following:
AuthName "secured"
AuthType basic
Auth_PG_host pgsql-server
Auth_PG_port 5432
Auth_PG_user httpd_auth
Auth_PG_pwd **********
Auth_PG_database httpd_auth
Auth_PG_pwd_table gallery_user
Auth_PG_uid_field user
Auth_PG_pwd_field pass
Auth_PG_encrypted Off
Auth_PG_log_table gallery_log
Auth_PG_log_uname_field user
Auth_PG_log_pwd_field pass
Auth_PG_log_date_field date
Auth_PG_log_addrs_field addr
Auth_PG_log_uri_field request
require valid-user
Of cause, user and password exists in the database table, the password
is unencrypted, as specified above.
The initial connection seems to be just fine, because when I CHANGE
Auth_PG_pwd, httpd complains about it:
[Tue Nov 30 12:44:47 2010] [error] (36)Operation now in progress: access
to /path failed for xxx.xxx.xxx.xxx, reason: PGSQL 1: FATAL: password
authentication failed for user "httpd_auth"\nFATAL: password
authentication failed for user "httpd_auth"\n
What I don't get either, is why the Auth_PG_log_table isn't filled with
any failed login attempts either. It also prints no error message
indicating why there are no logging messages inserted to the table.
I would be happy if anyone could help me. If furthrt information is
needed I will happily provide it. :-)
Thanks in advance,
Michael
console is /p...@1e,600000/i...@7/ser...@0,3f8
Copyright (c) 1982, 1986, 1989, 1991, 1993
The Regents of the University of California. All rights reserved.
Copyright (c) 1995-2010 OpenBSD. All rights reserved.
http://www.OpenBSD.org
OpenBSD 4.8-current (GENERIC.MP) #108: Thu Sep 16 09:29:16 MDT 2010
dera...@sparc64.openbsd.org:/usr/src/sys/arch/sparc64/compile/GENERIC.MP
real mem = 8589934592 (8192MB)
avail mem = 8444133376 (8052MB)
mainbus0 at root: Sun Fire V440
cpu0 at mainbus0: SUNW,UltraSPARC-IIIi (rev 2.4) @ 1062 MHz
cpu0: physical 32K instruction (32 b/l), 64K data (32 b/l), 1024K
external (64 b/l)
cpu1 at mainbus0: SUNW,UltraSPARC-IIIi (rev 2.4) @ 1062 MHz
cpu1: physical 32K instruction (32 b/l), 64K data (32 b/l), 1024K
external (64 b/l)
cpu2 at mainbus0: SUNW,UltraSPARC-IIIi (rev 2.4) @ 1062 MHz
cpu2: physical 32K instruction (32 b/l), 64K data (32 b/l), 1024K
external (64 b/l)
cpu3 at mainbus0: SUNW,UltraSPARC-IIIi (rev 2.4) @ 1062 MHz
cpu3: physical 32K instruction (32 b/l), 64K data (32 b/l), 1024K
external (64 b/l)
"memory-controller" at mainbus0 not configured
"memory-controller" at mainbus0 not configured
"memory-controller" at mainbus0 not configured
"memory-controller" at mainbus0 not configured
schizo0 at mainbus0: "Tomatillo", version 4, ign 700, bus A 0 to 0
schizo0: dvma map c0000000-dfffffff
pci0 at schizo0
cas0 at pci0 dev 2 function 0 "Sun Cassini" rev 0x20: ivec 0x718,
address 00:03:ba:66:75:d1
brgphy0 at cas0 phy 1: BCM5421 10/100/1000baseT PHY, rev. 1
"ppm" at mainbus0 not configured
schizo1 at mainbus0: "Tomatillo", version 4, ign 740, bus B 0 to 0
schizo1: dvma map c0000000-dfffffff
pci1 at schizo1
mpi0 at pci1 dev 2 function 0 "Symbios Logic 53c1030" rev 0x08: ivec 0x740
scsibus0 at mpi0: 16 targets, initiator 7
schizo2 at mainbus0: "Tomatillo", version 4, ign 780, bus A 0 to 0
schizo2: dvma map c0000000-dfffffff
pci2 at schizo2
ebus0 at pci2 dev 7 function 0 "Acer Labs M1533 ISA" rev 0x00
"flashprom" at ebus0 addr 0-fffff, 290-290 not configured
rtc0 at ebus0 addr 70-71: m5819p
pcfiic0 at ebus0 addr 320-321 ivec 0x1b
iic0 at pcfiic0
"SUNW,i2c-imax" at iic0 addr 0xb not configured
"SUNW,i2c-imax" at iic0 addr 0xc not configured
admtemp0 at iic0 addr 0x18: max1617
"pca9555" at iic0 addr 0x21 not configured
"pca9555" at iic0 addr 0x22 not configured
"pca9555" at iic0 addr 0x23 not configured
"pca9555" at iic0 addr 0x24 not configured
"adm1026" at iic0 addr 0x2e not configured
admtemp1 at iic0 addr 0x32: max1617
admtemp2 at iic0 addr 0x40: max1617
admtemp3 at iic0 addr 0x48: max1617
lmtemp0 at iic0 addr 0x4e: lm75
"spd" at iic0 addr 0x5b not configured
"spd" at iic0 addr 0x5c not configured
"spd" at iic0 addr 0x5d not configured
"spd" at iic0 addr 0x5e not configured
"spd" at iic0 addr 0x63 not configured
"spd" at iic0 addr 0x64 not configured
"spd" at iic0 addr 0x65 not configured
"spd" at iic0 addr 0x66 not configured
"spd" at iic0 addr 0x6b not configured
"spd" at iic0 addr 0x6c not configured
"spd" at iic0 addr 0x6d not configured
"spd" at iic0 addr 0x6e not configured
"spd" at iic0 addr 0x73 not configured
"spd" at iic0 addr 0x74 not configured
"spd" at iic0 addr 0x75 not configured
"spd" at iic0 addr 0x76 not configured
"ics951601" at iic0 addr 0x69 not configured
power0 at ebus0 addr 800-82f ivec 0x1a
com0 at ebus0 addr 3f8-3ff ivec 0x22: ns16550a, 16 byte fifo
com0: console
com1 at ebus0 addr 2e8-2ef ivec 0x22: ns16550a, 16 byte fifo
"rmc-comm" at ebus0 addr 3e8-3ef ivec 0x22 not configured
cas1 at pci2 dev 2 function 0 "NS Saturn" rev 0x30: ivec 0x78c, address
00:14:4f:1e:d6:b4
gentbi0 at cas1 phy 0: Generic ten-bit interface, rev. 0
machfb0 at pci2 dev 4 function 0 "ATI Rage XL" rev 0x27
machfb0: SUNW,370-4362, 1152x900
wsdisplay0 at machfb0 mux 1
wsdisplay0: screen 0 added (std, sun emulation)
alipm0 at pci2 dev 6 function 0 "Acer Labs M7101 Power" rev 0x00: 223KHz
clock
iic1 at alipm0
ohci0 at pci2 dev 10 function 0 "Acer Labs M5237 USB" rev 0x03: ivec
0x7a1, version 1.0, legacy support
ohci1 at pci2 dev 11 function 0 "Acer Labs M5237 USB" rev 0x03: ivec
0x7a5, version 1.0, legacy support
pciide0 at pci2 dev 13 function 0 "Acer Labs M5229 UDMA IDE" rev 0xc4:
DMA, channel 0 configured to native-PCI, channel 1 configured to native-PCI
pciide0: using ivec 0x7a6 for native-PCI interrupt
atapiscsi0 at pciide0 channel 0 drive 0
scsibus1 at atapiscsi0: 2 targets
cd0 at scsibus1 targ 0 lun 0: <TOSHIBA, DVD-ROM SD-C2612, 1011> ATAPI
5/cdrom removable
cd0(pciide0:0:0): using PIO mode 4, Ultra-DMA mode 2
pciide0: channel 1 disabled (no drives)
usb0 at ohci0: USB revision 1.0
uhub0 at usb0 "Acer Labs OHCI root hub" rev 1.00/1.00 addr 1
usb1 at ohci1: USB revision 1.0
uhub1 at usb1 "Acer Labs OHCI root hub" rev 1.00/1.00 addr 1
"ppm" at mainbus0 not configured
schizo3 at mainbus0: "Tomatillo", version 4, ign 7c0, bus B 0 to 0
schizo3: dvma map c0000000-dfffffff
pci3 at schizo3
cas2 at pci3 dev 1 function 0 "Sun Cassini" rev 0x20: ivec 0x7dc,
address 00:03:ba:66:75:d2
brgphy1 at cas2 phy 1: BCM5421 10/100/1000baseT PHY, rev. 1
mpi1 at pci3 dev 2 function 0 "Symbios Logic 53c1030" rev 0x07: ivec 0x7e3
scsibus2 at mpi1: 16 targets, initiator 7
sd0 at scsibus2 targ 0 lun 0: <LSILOGIC, 1030 IM IM, 1000> SCSI2
0/direct fixed
sd0: 34732MB, 512 bytes/sec, 71131136 sec total
sd1 at scsibus2 targ 2 lun 0: <ModusLnk, MXJ3073SC800600X, 5704> SCSI3
0/direct fixed
sd1: 70136MB, 512 bytes/sec, 143638992 sec total
sd2 at scsibus2 targ 3 lun 0: <ModusLnk, MXJ3073SC800600X, 5704> SCSI3
0/direct fixed
sd2: 70136MB, 512 bytes/sec, 143638992 sec total
mpi1: target 2 Sync at 160MHz width 16bit offset 127 QAS 1 DT 1 IU 1
mpi1: target 3 Sync at 160MHz width 16bit offset 127 QAS 1 DT 1 IU 1
mpi1: phys disk 1 Sync at 160MHz width 16bit offset 127 QAS 1 DT 1 IU 1
mpi1: phys disk 0 Sync at 160MHz width 16bit offset 127 QAS 1 DT 1 IU 1
mpi2 at pci3 dev 2 function 1 "Symbios Logic 53c1030" rev 0x07: ivec 0x7e4
scsibus3 at mpi2: 16 targets, initiator 7
"i2c" at mainbus0 not configured
softraid0 at root
softraid0: sd3 was not shutdown properly
scsibus4 at softraid0: 1 targets
sd3 at scsibus4 targ 0 lun 0: <OPENBSD, SR RAID 1, 004> SCSI2 0/direct fixed
sd3: 70135MB, 512 bytes/sec, 143636843 sec total
bootpath: /p...@1f,700000/s...@2,0/d...@0,0
root on sd0a swap on sd0b dump on sd0b
