Try this, it works in chrooted Apache ;) Season to taste... rc.local ### MySQL rm -R /var/www/var/run/mysql mkdir -p /var/www/var/run/mysql && \ chown -R _mysql._mysql /var/run/mysql /usr/local/bin/mysqld_safe --user=_mysql --open-files=1000 -log & sleep 10 ln /var/run/mysql/mysql.sock /var/www/var/run/mysql/mysql.sock
rc.shutdown ### MySQL /usr/local/share/mysql/mysql.server stop -- ~Allie D. On Sun, November 19, 2006 10:50, Otto Moerbeek wrote: > On Sun, 19 Nov 2006, Gaby Vanhegan wrote: > >> I'm really having an incredibly painful time with MySQL on 3.9. Has >> anybody had a problem getting MySQL 4 or 5 to play happy? I've read >> these pages: >> >> http://www.openbsdsupport.org/mysql.htm >> http://monkey.org/openbsd/archive/misc/0411/msg03296.html >> http://marc.theaimsgroup.com/?l=openbsd-misc&m=111881975209858&w=2 >> http://marc.theaimsgroup.com/?l=openbsd-misc&m=111887588311627&w=2 >> >> And applied it to MySQL 5, both from ports, and the latest 4.x >> release built from source. I still get the database basically >> locking under moderate load, or failing to do a mysqlcheck. The >> errors I get (from the .err file) are along these lines: >> >> 061119 18:03:31 [ERROR] /usr/local/libexec/mysqld: Can't find file: >> './condor5/user.frm' (errno: 9) >> 061119 18:03:31 [ERROR] /usr/local/libexec/mysqld: Can't find file: >> './condor5/user_in_group.frm' (errno: 9) >> 061119 18:03:31 [ERROR] /usr/local/libexec/mysqld: Can't find file: >> './condor5/user_in_group.frm' (errno: 9) >> (using 4.x) >> >> Or these when doing the suggested mysqlcheck command: >> >> mysql.columns_priv OK >> mysql.db OK >> mysql.func >> error : File './mysql/func.MYD' not found (Errcode: 9) >> mysql.help_category >> error : File './mysql/help_category.MYD' not found (Errcode: 9) >> mysql.help_keyword >> error : File './mysql/help_keyword.MYD' not found (Errcode: 9) >> mysql.help_relation >> error : File './mysql/help_relation.MYD' not found (Errcode: 9) >> mysql.help_topic >> error : File './mysql/help_topic.MYD' not found (Errcode: 9) >> >> I've followed all the instructions on the relevant pages, and >> instructions form the mail archives but to no avail. I have a theory >> that it doesn't hold up under the load of dspam using MySQL as it's >> back end, and I'll be trying that running under something else but >> for the moment, normal every day databases just stop working after a >> while. What have you had to do to get MySQL up and running properly? > > How do you start mysql? It's essential you start it with the proper > login class, like: > > su -c _mysql root ... > > -Otto > >> >> # sysctl kern.maxfiles >> kern.maxfiles=13666 >> # cat /etc/login.conf >> ... >> # >> # MySQL daemon >> # >> _mysql:\ >> :datasize=infinity:\ >> :maxproc=infinity:\ >> :openfiles-cur=2048:\ >> :openfiles-max=8192:\ >> :stacksize-cur=8M:\ >> :localcipher=blowfish,8:\ >> :tc=default: >> # userinfo _mysql >> login _mysql >> passwd ************* >> uid 502 >> groups _mysql >> change NEVER >> class _mysql >> gecos MySQL Account >> dir /nonexistent >> shell /sbin/nologin >> expire NEVER >> # cat /etc/my.cnf | grep files >> open_files_limit = 2048 >> # dmesg >> OpenBSD 3.9 (GENERIC.MP) #598: Thu Mar 2 02:37:06 MST 2006 >> [EMAIL PROTECTED]:/usr/src/sys/arch/i386/compile/GENERIC.MP >> cpu0: Intel(R) Pentium(R) D CPU 2.66GHz ("GenuineIntel" 686-class) >> 2.68 GHz >> cpu0: >> FPU,V86,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36, >> CFLUSH,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,SBF,SSE3,MWAIT,TM2,CNXT-ID >> real mem = 2146541568 (2096232K) >> avail mem = 1952505856 (1906744K) >> using 4278 buffers containing 107429888 bytes (104912K) of memory >> mainbus0 (root) >> bios0 at mainbus0: AT/286+(00) BIOS, date 10/30/05, BIOS32 rev. 0 @ >> 0xf0010 >> apm0 at bios0: Power Management spec V1.2 >> apm0: AC on, battery charge unknown >> apm0: flags 30102 dobusy 0 doidle 1 >> pcibios at bios0 function 0x1a not configured >> bios0: ROM list: 0xc0000/0x8000 0xc8000/0x2200 >> mainbus0: Intel MP Specification (Version 1.1) (INTEL Premium ) >> cpu0 at mainbus0: apid 0 (boot processor) >> cpu0: apic clock running at 133 MHz >> cpu1 at mainbus0: apid 1 (application processor) >> cpu1: Intel(R) Pentium(R) D CPU 2.66GHz ("GenuineIntel" 686-class) >> 2.68 GHz >> cpu1: >> FPU,V86,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36, >> CFLUSH,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,SBF,SSE3,MWAIT,TM2,CNXT-ID >> mainbus0: bus 0 is type PCI >> mainbus0: bus 1 is type PCI >> mainbus0: bus 2 is type PCI >> mainbus0: bus 3 is type PCI >> mainbus0: bus 4 is type PCI >> mainbus0: bus 5 is type ISA >> ioapic0 at mainbus0: apid 2 pa 0xfec00000, version 20, 24 pins >> pci0 at mainbus0 bus 0: configuration mode 1 (no bios) >> pchb0 at pci0 dev 0 function 0 "Intel 82955X MCH" rev 0x81 >> ppb0 at pci0 dev 28 function 0 "Intel 82801GB PCIE" rev 0x01 >> pci1 at ppb0 bus 4 >> ppb1 at pci0 dev 28 function 4 "Intel 82801G PCIE" rev 0x01 >> pci2 at ppb1 bus 3 >> em0 at pci2 dev 0 function 0 "Intel PRO/1000MT (82573L)" rev 0x00: >> apic 2 int 16 (irq 11), address 00:15:f2:c8:8e:10 >> ppb2 at pci0 dev 28 function 5 "Intel 82801G PCIE" rev 0x01 >> pci3 at ppb2 bus 2 >> "CMD Technology SiI3132 SATA" rev 0x01 at pci3 dev 0 function 0 not >> configured >> uhci0 at pci0 dev 29 function 0 "Intel 82801GB USB" rev 0x01: apic 2 >> int 20 (irq 10) >> 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 82801GB USB" rev 0x01: apic 2 >> int 17 (irq 10) >> 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 >> uhci2 at pci0 dev 29 function 2 "Intel 82801GB USB" rev 0x01: apic 2 >> int 18 (irq 3) >> usb2 at uhci2: USB revision 1.0 >> uhub2 at usb2 >> uhub2: Intel UHCI root hub, rev 1.00/1.00, addr 1 >> uhub2: 2 ports with 2 removable, self powered >> uhci3 at pci0 dev 29 function 3 "Intel 82801GB USB" rev 0x01: apic 2 >> int 19 (irq 5) >> usb3 at uhci3: USB revision 1.0 >> uhub3 at usb3 >> uhub3: Intel UHCI root hub, rev 1.00/1.00, addr 1 >> uhub3: 2 ports with 2 removable, self powered >> ppb3 at pci0 dev 30 function 0 "Intel 82801BA AGP" rev 0xe1 >> pci4 at ppb3 bus 1 >> vga1 at pci4 dev 1 function 0 "ATI Mach64 GU" rev 0x9a >> wsdisplay0 at vga1 mux 1: console (80x25, vt100 emulation) >> wsdisplay0: screen 1-5 added (80x25, vt100 emulation) >> ami0 at pci4 dev 2 function 0 "Symbios Logic MegaRAID" rev 0x01: apic >> 2 int 23 (irq 5) LSI 523 64b/lhc >> ami0: FW 713N, BIOS vG119, 64MB RAM >> ami0: 1 channels, 0 FC loops, 1 logical drives >> scsibus0 at ami0: 40 targets >> sd0 at scsibus0 targ 0 lun 0: <AMI, Host drive #00, > SCSI2 0/direct >> fixed >> sd0: 478736MB, 478736 cyl, 64 head, 32 sec, 512 bytes/sec, 980451328 >> sec total >> scsibus1 at ami0: 16 targets >> "ITExpress IT8211F" rev 0x11 at pci4 dev 4 function 0 not configured >> skc0 at pci4 dev 5 function 0 "Marvell Yukon 88E8001/8003/8010" rev >> 0x13, Marvell Yukon Lite (0x9): apic 2 int 21 (irq 10) >> sk0 at skc0 port A, address 00:15:f2:c8:88:32 >> eephy0 at sk0 phy 0: Marvell 88E1011 Gigabit PHY, rev. 5 >> ichpcib0 at pci0 dev 31 function 0 "Intel 82801GB LPC" rev 0x01: PM >> disabled >> pciide0 at pci0 dev 31 function 1 "Intel 82801GB IDE" rev 0x01: DMA, >> channel 0 configured to compatibility, channel 1 configured to >> compatibility >> atapiscsi0 at pciide0 channel 0 drive 0 >> scsibus2 at atapiscsi0: 2 targets >> cd0 at scsibus2 targ 0 lun 0: <SAMSUNG, CD-ROM SC-148F, PS06> SCSI0 5/ >> cdrom removable >> cd0(pciide0:0:0): using PIO mode 4, DMA mode 2 >> pciide0: channel 1 disabled (no drives) >> pciide1 at pci0 dev 31 function 2 "Intel 82801GB SATA" rev 0x01: DMA, >> channel 0 configured to native-PCI, channel 1 configured to native-PCI >> pciide1: using apic 2 int 23 (irq 5) for native-PCI interrupt >> ichiic0 at pci0 dev 31 function 3 "Intel 82801GB SMBus" rev >> 0x01pci_intr_map: no mapping for pin B >> : polling >> iic0 at ichiic0 >> isa0 at ichpcib0 >> isadma0 at isa0 >> pckbc0 at isa0 port 0x60/5 >> pckbd0 at pckbc0 (kbd slot) >> pckbc0: using irq 1 for kbd slot >> wskbd0 at pckbd0: console keyboard, using wsdisplay0 >> pcppi0 at isa0 port 0x61 >> midi0 at pcppi0: <PC speaker> >> spkr0 at pcppi0 >> lpt0 at isa0 port 0x378/4 irq 7 >> lm0 at isa0 port 0x290/8: unknown Winbond chip (ID 0xa1) >> npx0 at isa0 port 0xf0/16: using exception 16 >> pccom0 at isa0 port 0x3f8/8 irq 4: ns16550a, 16 byte fifo >> fdc0 at isa0 port 0x3f0/6 irq 6 drq 2 >> fd0 at fdc0 drive 0: 1.44MB 80 cyl, 2 head, 18 sec >> biomask 0 netmask 0 ttymask 0 >> pctr: user-level cycle counter enabled >> apm0: disconnected >> dkcsum: sd0 matches BIOS drive 0x80 >> root on sd0a >> rootdev=0x400 rrootdev=0xd00 rawdev=0xd02 >> >> Gaby >> >> -- >> Junkets for bunterish lickspittles since 1998! >> http://www.playr.co.uk/sudoku/ >> http://weblog.vanhegan.net/
