Has there been a change with respect to how it works with chrooted Apache, compared to 3.8 ?
I referred to the fabulous hints found at http://openbsdsupport.org/mysql.htm and start mysql successfully with su -c _mysql root -c '/usr/local/bin/mysqld_safe &' > /dev/null & echo -n ' mysql' in rc.local In 3.8 I used rm -Rf /var/run/mysql rm -Rf /var/www/var/run/mysql/* ln -s /var/www/var/run/mysql /var/run/mysql sleep 1 /usr/bin/sudo -c _mysql -u _mysql /usr/local/bin/mysqld_safe --user=_mysql --log=/var/log/mysql & with success. If I do that here, by the way, I can reproduce a segfault on the fresh pkg_add: mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | +--------------------+ Segmentation fault (core dumped) , but that's not the major problem. Only for those proposing a similar solution. I short: Can someone please hit me with a clue on what is missing here to connect to the databases through Apache ? (I have checked, it is okay on the box; I can mysql -u user -p; so I guess the missing link is the one into chroot) Uwe The php testpage shows mysql: MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 5.0.24a MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/run/mysql/mysql.sock MYSQL_INCLUDE -I/usr/local/include/mysql MYSQL_LIBS -L/usr/local/lib -lmysqlclient OpenBSD 4.0 (GENERIC.MP) #0: Mon Nov 27 18:31:04 SGT 2006 [EMAIL PROTECTED]:/usr/src/sys/arch/amd64/compile/GENERIC.MP real mem = 2147033088 (2096712K) avail mem = 1835143168 (1792132K) using 22937 buffers containing 214913024 bytes (209876K) of memory mainbus0 (root) bios0 at mainbus0: SMBIOS rev. 2.3 @ 0xec000 (62 entries) bios0: HP ProLiant ML350 G4 mainbus0: Intel MP Specification (Version 1.4) (HP PROLIANT ) cpu0 at mainbus0: apid 0 (boot processor) cpu0: Intel(R) Xeon(TM) CPU 3.00GHz, 3000.45 MHz cpu0: FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,SBF,SSE3,LONG cpu0: 1MB 64b/line 8-way L2 cache cpu0: apic clock running at 200MHz cpu1 at mainbus0: apid 6 (application processor) cpu1: Intel(R) Xeon(TM) CPU 3.00GHz, 3000.11 MHz cpu1: FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,SBF,SSE3,LONG cpu1: 1MB 64b/line 8-way L2 cache mpbios: bus 0 is type PCI mpbios: bus 1 is type PCI mpbios: bus 2 is type PCI mpbios: bus 5 is type PCI mpbios: bus 6 is type PCI mpbios: bus 9 is type PCI mpbios: bus 13 is type PCI mpbios: bus 16 is type PCI mpbios: bus 32 is type ISA ioapic0 at mainbus0 apid 8 pa 0xfec00000, version 20, 24 pins ioapic1 at mainbus0 apid 9 pa 0xfec10000, version 20, 24 pins ioapic1: misconfigured as apic 0, remapped to apid 9 ioapic2 at mainbus0 apid 10 pa 0xfec80000, version 20, 24 pins ioapic3 at mainbus0 apid 11 pa 0xfec80400, version 20, 24 pins pci0 at mainbus0 bus 0: configuration mode 1 pchb0 at pci0 dev 0 function 0 "Intel E7520 MCH" rev 0x0c ppb0 at pci0 dev 2 function 0 "Intel MCH PCIE" rev 0x0c pci1 at ppb0 bus 5 ppb1 at pci1 dev 0 function 0 "Intel PCIE-PCIE" rev 0x09 pci2 at ppb1 bus 6 ppb2 at pci1 dev 0 function 2 "Intel PCIE-PCIE" rev 0x09 pci3 at ppb2 bus 9 ppb3 at pci0 dev 4 function 0 "Intel MCH PCIE" rev 0x0c pci4 at ppb3 bus 13 ppb4 at pci0 dev 6 function 0 "Intel MCH PCIE" rev 0x0c pci5 at ppb4 bus 16 ppb5 at pci0 dev 28 function 0 "Intel 6300ESB PCIX" rev 0x02 pci6 at ppb5 bus 2 mpi0 at pci6 dev 3 function 0 "Symbios Logic 53c1030" rev 0x08: apic 9 int 0 (irq 5) scsibus0 at mpi0: 16 targets sd0 at scsibus0 targ 0 lun 0: <COMPAQ, BF14686842, HPB4> SCSI3 0/direct fixed sd0: 140014MB, 41991 cyl, 10 head, 682 sec, 512 bytes/sec, 286749488 sec total sd1 at scsibus0 targ 2 lun 0: <COMPAQ, BF03688284, HPB3> SCSI3 0/direct fixed sd1: 34732MB, 50824 cyl, 2 head, 699 sec, 512 bytes/sec, 71132000 sec total mpi0: target 0 Sync at 160MHz width 16bit offset 127 QAS 1 DT 1 IU 1 mpi0: target 2 Sync at 160MHz width 16bit offset 63 QAS 1 DT 1 IU 1 mpi1 at pci6 dev 3 function 1 "Symbios Logic 53c1030" rev 0x08: apic 9 int 1 (irq 5) scsibus1 at mpi1: 16 targets uhci0 at pci0 dev 29 function 0 "Intel 6300ESB USB" rev 0x02: apic 8 int 16 (irq 3) usb0 at uhci0: USB revision 1.0 uhub0 at usb0 uhub0: Intel UHCI root hub, rev 1.00/1.00, addr 1 uhub0: 2 ports with 2 removable, self powered uhci1 at pci0 dev 29 function 1 "Intel 6300ESB USB" rev 0x02: apic 8 int 19 (irq 7) usb1 at uhci1: USB revision 1.0 uhub1 at usb1 uhub1: Intel UHCI root hub, rev 1.00/1.00, addr 1 uhub1: 2 ports with 2 removable, self powered "Intel 6300ESB WDT" rev 0x02 at pci0 dev 29 function 4 not configured "Intel 6300ESB APIC" rev 0x02 at pci0 dev 29 function 5 not configured ehci0 at pci0 dev 29 function 7 "Intel 6300ESB USB" rev 0x02: apic 8 int 23 (irq 7) usb2 at ehci0: USB revision 2.0 uhub2 at usb2 uhub2: Intel EHCI root hub, rev 2.00/1.00, addr 1 uhub2: 4 ports with 4 removable, self powered ppb6 at pci0 dev 30 function 0 "Intel 82801BA AGP" rev 0x0a pci7 at ppb6 bus 1 bge0 at pci7 dev 2 function 0 "Broadcom BCM5705K" rev 0x03, BCM5705 A3 (0x3003): apic 8 int 17 (irq 7), address 00:13:21:ae:65:65 brgphy0 at bge0 phy 1: BCM5705 10/100/1000baseT PHY, rev. 2 vga1 at pci7 dev 3 function 0 "ATI Rage XL" rev 0x27 wsdisplay0 at vga1 mux 1: console (80x25, vt100 emulation) wsdisplay0: screen 1-5 added (80x25, vt100 emulation) vendor "Compaq", unknown product 0x00d7 (class system subclass miscellaneous, rev 0x01) at pci7 dev 4 function 0 not configured pcib0 at pci0 dev 31 function 0 "Intel 6300ESB LPC" rev 0x02 pciide0 at pci0 dev 31 function 1 "Intel 6300ESB IDE" rev 0x02: DMA, channel 0 configured to compatibility, channel 1 configured to compatibility pciide0: channel 0 disabled (no drives) atapiscsi0 at pciide0 channel 1 drive 0 scsibus2 at atapiscsi0: 2 targets cd0 at scsibus2 targ 0 lun 0: <HL-DT-ST, RW/DVD GCC-4481B, 2.05> SCSI0 5/cdrom removable cd0(pciide0:1:0): using PIO mode 4, Ultra-DMA mode 2 isa0 at pcib0 isadma0 at isa0 com0 at isa0 port 0x3f8/8 irq 4: ns16550a, 16 byte fifo com0: console pckbc0 at isa0 port 0x60/5 pckbd0 at pckbc0 (kbd slot) pckbc0: using irq 1 for kbd slot wskbd at pckbd0 not configured pcppi0 at isa0 port 0x61 midi0 at pcppi0: <PC speaker> spkr0 at pcppi0 fdc0 at isa0 port 0x3f0/6 irq 6 drq 2 fd0 at fdc0 drive 0: 1.44MB 80 cyl, 2 head, 18 sec ugen0 at uhub1 port 1 ugen0: American Power Conversion Back-UPS RS 1000 FW:7.g8 .I USB FW:g8, rev 1.10/1.06, addr 2 dkcsum: sd0 matches BIOS drive 0x80 dkcsum: sd1 matches BIOS drive 0x81 root on sd0a rootdev=0x400 rrootdev=0xd00 rawdev=0xd02
