Re: mysql problem
On 7/12/07, Marcos Laufer [EMAIL PROTECTED] wrote: ERROR 1018 (HY000): Can't read dir of './mysql/' (errno: 9) Use fstat(1) or similar tool to check the open files on the system, maybe you're bumping up against a limit somewhere? There is an old thread[1] on a similar topic which might apply to you. Gordon [1] http://marc.info/?t=11011880941r=1w=2
Re: mysql problem
I did read the archives, and it helped me to find out that restarting mysql fixes it for some time, and i increased the values several times but no luck. It starts working fine for a while but then again it fails . In the end i have this config right now and the problem persists, i can reproduce the problem just by executing mysqlcheck -m -A -p -- # sysctl kern.maxfiles kern.maxfiles=2 -- in login.conf: _mysql:\ :openfiles=8192:\ :datasize=infinity:\ :maxproc=infinity:\ :openfiles-cur=8192:\ :openfiles-max=1:\ :stacksize-cur=8M: in my.cnf: [mysqld] socket = /var/www/logs/mysql/mysql.sock old-passwords tmpdir = /var/mysql/tmp open-files-limit = 1 sql-mode = MYSQL40 skip-name-resolve table_cache = 1024 query_cache_size = 64M key_buffer = 64M long_query_time = 5 #log-slow-queries #log-queries-not-using-indexes thread_concurrency = 2 #query_cache_limit = 1M interactive_timeout=60 wait_timeout=60 connect_timeout=15 basedir=/usr/local datadir=/var/mysql sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M [mysql.server] old-passwords [mysqld_safe] open-files=8192 Maybe i need to increase something else? Thanks! - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org Sent: Friday, July 13, 2007 3:12 AM Subject: Re: mysql problem On Fri, 13 Jul 2007, Marcos Laufer wrote: I am having a very strange problem on a 3.9 , suddenly i can't access any table on the databases. I have around 100 databases on this server and can't access not even one. This is a production server and i am in an urge to solve it, if anyone can help i would appreciate it: # mysql mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 303342 to server version: 5.0.18 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables; ERROR 1018 (HY000): Can't read dir of './mysql/' (errno: 9) mysql I have backups of all databases, including mysql database which i think is the one broken , how can i restore it ? Thanks for your help You are running out of file descriptors. Search the archives for answers. -Otto
Re: mysql problem
On Fri, 13 Jul 2007, Marcos Laufer wrote: I am having a very strange problem on a 3.9 , suddenly i can't access any table on the databases. I have around 100 databases on this server and can't access not even one. This is a production server and i am in an urge to solve it, if anyone can help i would appreciate it: # mysql mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 303342 to server version: 5.0.18 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables; ERROR 1018 (HY000): Can't read dir of './mysql/' (errno: 9) mysql I have backups of all databases, including mysql database which i think is the one broken , how can i restore it ? Thanks for your help You are running out of file descriptors. Search the archives for answers. -Otto
Re: mysql problem
On Fri, 13 Jul 2007, Marcos Laufer wrote: I did read the archives, and it helped me to find out that restarting mysql fixes it for some time, and i increased the values several times but no luck. It starts working fine for a while but then again it fails . In the end i have this config right now and the problem persists, i can reproduce the problem just by executing mysqlcheck -m -A -p How are yo starting mysql? You need to explicitly set the login class. Somthing like su -c mysql root /usr/local/bin/mysqld_safe ... -Otto -- # sysctl kern.maxfiles kern.maxfiles=2 -- in login.conf: _mysql:\ :openfiles=8192:\ :datasize=infinity:\ :maxproc=infinity:\ :openfiles-cur=8192:\ :openfiles-max=1:\ :stacksize-cur=8M: in my.cnf: [mysqld] socket = /var/www/logs/mysql/mysql.sock old-passwords tmpdir = /var/mysql/tmp open-files-limit = 1 sql-mode = MYSQL40 skip-name-resolve table_cache = 1024 query_cache_size = 64M key_buffer = 64M long_query_time = 5 #log-slow-queries #log-queries-not-using-indexes thread_concurrency = 2 #query_cache_limit = 1M interactive_timeout=60 wait_timeout=60 connect_timeout=15 basedir=/usr/local datadir=/var/mysql sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M [mysql.server] old-passwords [mysqld_safe] open-files=8192 Maybe i need to increase something else? Thanks! - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org Sent: Friday, July 13, 2007 3:12 AM Subject: Re: mysql problem On Fri, 13 Jul 2007, Marcos Laufer wrote: I am having a very strange problem on a 3.9 , suddenly i can't access any table on the databases. I have around 100 databases on this server and can't access not even one. This is a production server and i am in an urge to solve it, if anyone can help i would appreciate it: # mysql mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 303342 to server version: 5.0.18 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables; ERROR 1018 (HY000): Can't read dir of './mysql/' (errno: 9) mysql I have backups of all databases, including mysql database which i think is the one broken , how can i restore it ? Thanks for your help You are running out of file descriptors. Search the archives for answers. -Otto
Re: ipsec vpn with os x clients
Hi,
On Thu, Jul 12, 2007 at 05:38:47PM -0800, eric wrote:
I have an OpenBSD 4.1 (OpenBSD snip 4.1 GENERIC#1435 i386) acting
as a PPPoE NAT router firewall to my ISP. I'd like to replace my OS
X 10.4 Server IPSEC VPN with the OpenBSD system. My road warrior
clients are all OS X 10.4.10. I read that 10.4 supports AES
encryption but advertises 3DES by default. I'm happy to use 3DES for
now, as isakmpd reported proposal errors when i configured for AES.
Much of the (excellent) IPsec documentation refers either to site-to-
site configuration and not road warrior clients or is outdated and
refers to isakmpd.conf
# cat ipsec.conf
ike dynamic from any to any \
main auth hmac-sha1 enc 3des group modp1024 \
quick auth hmac-sha1 enc 3des psk TheSecret
this should be ike passive from ...
I start isakmpd with 'isakmpd -K4dv'
I load ipsec.conf with 'ipsecctl -f /etc/ipsec.conf'
I then monitor key exchanges with 'ipsecctl -m'
Once i load ipsec.conf I get the following from isakmpd, repeating
every 25secs or so:
171653.48 Default udp_create: no address configured for peer-
default
171653.422357 Default exchange_establish: transport udp for peer
peer-default could not be created
I'm testing this entirely from my internal subnet. PF is configured
to 'pass quick on { $int_if enc0 }'
My OS X VPN client setup includes the OpenBSD server's IP, my OpenBSD
username and password, and the PSK. I click Connect.
isakmpd reports:
172358.016652 Default isakmpd: phase 1 done: initiator id ac1e0114:
172.30.1.20, responder id OpenBSD FQDN, src: 172.30.1.1 dst:
172.30.1.20
172430.679924 Default message_recv: invalid cookie(s)
bacca5c8db12e3b9 78c4c4508b02cbe4
172430.680286 Default dropped message from 172.30.1.20 port 500 due
to notification type INVALID_COOKIE
172430.680826 Default message_recv: invalid cookie(s)
bacca5c8db12e3b9 a162b17df4ce9921
172430.681041 Default dropped message from 172.30.1.20 port 500 due
to notification type INVALID_COOKIE
The INVALID_COOKIE messages repeat until the Mac gives up or I
cancel. Then I get:
172450.699914 Default transport_send_messages: giving up on exchange
IPsec-0.0.0.0/0-0.0.0.0/0, no response from peer 172.30.1.20:500
172450.700387 Default transport_send_messages: giving up on exchange
IPsec-::/0-::/0, no response from peer 172.30.1.20:500
ipsecctl -m reports this:
sadb_getspi: satype esp vers 2 len 10 seq 1 pid 15108
address_src: 172.30.1.20
address_dst: 172.30.1.1
spirange: min 0x0100 max 0x
sadb_getspi: satype esp vers 2 len 10 seq 1 pid 15108
sa: spi 0x272f2a24 auth none enc none
state mature replay 0 flags 0
address_src: 172.30.1.20
address_dst: 172.30.1.1
sadb_getspi: satype esp vers 2 len 10 seq 2 pid 15108
address_src: 172.30.1.20
address_dst: 172.30.1.1
spirange: min 0x0100 max 0x
sadb_getspi: satype esp vers 2 len 10 seq 2 pid 15108
sa: spi 0xee7e7297 auth none enc none
state mature replay 0 flags 0
address_src: 172.30.1.20
address_dst: 172.30.1.1
Does anybody have any documentation on using Mac clients with IPSEC?
I sincerely appreciate any assistance and am willing to provide any
additional requested information. Thank you.
PF problems with many connections.
Hello.
I trying to use OpenBSD under high load and have problems with PF.
When there is very many connections to server in some point other
connections just failes.
I try to use simple test application that creates 1000 connections to
server for 1000 iteration. Maximum number I have observed with pf was
'12' but with 'pfctl -d' all cycle successfully works ('1000').
I try to use following simple test application:
Also I have looked the same when testing 'ab' from apache2
distribution. 'ab -c 100 -n 100' : maximum 9 iteration with pf enabled
and 100 without.
There is instant connection closing if keep state is enabled. When
keep state is disabled there is following behaviour: in some moment
the program is waiting for reply but do not get it and connection also
close because timeout.
I have looked no problems in tcpdump reports. Also no blocked packets
was in pflog0 interface ('block log all' rule)
I am sure that states limit is not exceed. Now I have
set limit states50
set limit src-nodes 5
set limit frags 32000
And `pfctl -si` have normal values.
'antispoof' and 'scrub' options are not affected. 'set optimization'
make more bad.
I looked the same behaviour in real use: when there is many
connection, in some point they just closed.
Any help will be appropriated. Many thanks.
P.S. Sorry for my bad english.
Re: PF problems with many connections.
2007/7/13, Adriaan [EMAIL PROTECTED]:
On 7/13/07, TuxR [EMAIL PROTECTED] wrote:
Hello.
I trying to use OpenBSD under high load and have problems with PF.
When there is very many connections to server in some point other
connections just failes.
I try to use simple test application that creates 1000 connections to
server for 1000 iteration. Maximum number I have observed with pf was
'12' but with 'pfctl -d' all cycle successfully works ('1000').
I try to use following simple test application:
Also I have looked the same when testing 'ab' from apache2
distribution. 'ab -c 100 -n 100' : maximum 9 iteration with pf enabled
and 100 without.
There is instant connection closing if keep state is enabled. When
keep state is disabled there is following behaviour: in some moment
the program is waiting for reply but do not get it and connection also
close because timeout.
I have looked no problems in tcpdump reports. Also no blocked packets
was in pflog0 interface ('block log all' rule)
I am sure that states limit is not exceed. Now I have
set limit states50
set limit src-nodes 5
set limit frags 32000
And `pfctl -si` have normal values.
'antispoof' and 'scrub' options are not affected. 'set optimization'
make more bad.
I looked the same behaviour in real use: when there is many
connection, in some point they just closed.
Any help will be appropriated. Many thanks.
P.S. Sorry for my bad english.
Study the execellent 3 part series of OpenBSD developer at
http://undeadly.org/cgi?action=articlesid=20060927091645mode=expanded
If after following his advice, your firewall still does not perform
adequately come back here with a posting of:
1) dmesg to see what kind of hardware you are using
2) vmstat -i output to show the interrupt rate of the NICs
Using 'systat vmstat will give you a 'live' view of the interrupt
rate and other resources
3) netstat -m output to see the mbuf stats
4) your pf.conf
Others may have additional suggestions of course ;)
=Adriaan=
Adriaan, thank you for reply.
I believe, this is not hardware problem. The system is not under high
CPU-Load during tests.
Hmmm... Of cource, I have read excelent Daniel Hartmeier's articles.
It runnings on FujitsuSiemens SX200 1U Server, 1 Gb RAM, 2x Intel Xeon
3000 (but for now we using non-SMP kernel).
# dmesg
OpenBSD 4.1 (GENERIC) #1435: Sat Mar 10 19:07:45 MST 2007
[EMAIL PROTECTED]:/usr/src/sys/arch/i386/compile/GENERIC
cpu0: Intel(R) Xeon(TM) CPU 3.00GHz (GenuineIntel 686-class) 3 GHz
cpu0:
FPU,V86,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,MWAIT,DS-CPL,VMX,EST,CNXT-ID,CX16,xTPR
real mem = 1072652288 (1047512K)
avail mem = 971362304 (948596K)
using 4278 buffers containing 53764096 bytes (52504K) of memory
mainbus0 (root)
bios0 at mainbus0: AT/286+ BIOS, date 10/20/06, BIOS32 rev. 0 @
0xfd66a, SMBIOS rev. 2.34 @ 0x3fee8000 (67 entries)
bios0: FUJITSU SIEMENS PRIMERGY RX200 S3
pcibios0 at bios0: rev 2.1 @ 0xfd590/0xa70
pcibios0: PCI IRQ Routing Table rev 1.0 @ 0xfde30/432 (25 entries)
pcibios0: PCI Interrupt Router at 000:31:0 (Intel 82371FB ISA rev 0x00)
pcibios0: PCI bus #12 is the last bus
bios0: ROM list: 0xc/0x8000 0xc8000/0x5800 0xe2800/0x1400!
acpi at mainbus0 not configured
ipmi0 at mainbus0: version 1.5 interface KCS iobase 0xca2/2 spacing 1
cpu0 at mainbus0
cpu0: Enhanced SpeedStep disabled by BIOS
pci0 at mainbus0 bus 0: configuration mode 1 (no bios)
pchb0 at pci0 dev 0 function 0 vendor Intel, unknown product 0x25d8 rev 0x92
ppb0 at pci0 dev 2 function 0 Intel 5000 PCIE rev 0x92
pci1 at ppb0 bus 1
ppb1 at pci1 dev 0 function 0 Intel 6321ESB PCIE rev 0x01
pci2 at ppb1 bus 2
ppb2 at pci2 dev 0 function 0 Intel 6321ESB PCIE rev 0x01
pci3 at ppb2 bus 3
ppb3 at pci2 dev 1 function 0 Intel 6321ESB PCIE rev 0x01
pci4 at ppb3 bus 4
ppb4 at pci1 dev 0 function 3 Intel 6321ESB PCIE-PCIX rev 0x01
pci5 at ppb4 bus 5
mpi0 at pci5 dev 5 function 0 Symbios Logic SAS1068 rev 0x01: irq 11
scsibus0 at mpi0: 63 targets
sd0 at scsibus0 targ 0 lun 0: ATA, HITACHI HDS7225S, A6DA SCSI3 0/direct fixed
sd0: 238471MB, 238472 cyl, 16 head, 127 sec, 512 bytes/sec, 488390625 sec total
sd1 at scsibus0 targ 1 lun 0: ATA, HITACHI HDS7225S, A6DA SCSI3 0/direct fixed
sd1: 238471MB, 238472 cyl, 16 head, 127 sec, 512 bytes/sec, 488390625 sec total
ppb5 at pci0 dev 3 function 0 Intel 5000 PCIE rev 0x92
pci6 at ppb5 bus 6
ppb6 at pci0 dev 4 function 0 Intel 5000 PCIE rev 0x92
ppb7 at pci7 dev 0 function 0 ServerWorks PCIE-PCIX rev 0xb5
pci8 at ppb7 bus 8
bge0 at pci8 dev 4 function 0 Broadcom BCM5715 rev 0xa3, BCM5715 A3
(0x9003): irq 11, address 00:0a:e4:82:11:60
brgphy0 at bge0 phy 1: BCM5714 10/100/1000baseT PHY, rev. 0
bge1 at pci8 dev 4 function 1 Broadcom BCM5715 rev 0xa3, BCM5715 A3
(0x9003): irq 9, address 00:0a:e4:82:11:61
brgphy1 at bge1 phy 1: BCM5714
Re: FAQ/PF Guide PDF links out of date?
Richard Wilson wrote: I think I may have found a glitch in the OpenBSD website - The FAQ and the PF User's guide are provided as PDF's, which is very handy for those of us who like to print them out to hand to people as part of their site documentation. Quickly out of date I know, but some of our customers like paper. However, having printed out the PDF found at ftp://ftp.openbsd.org/pub/OpenBSD/doc/obsd-faq.pdf which is the one linked from http://www.openbsd.org/faq/index.html I found that the footer stated it was last re-generated on 02/12/06. More fool me for printing it without checking first. A spot of digging revealed that the copy on the mirrors, for example http://spargel.kd85.com/ftp/pub/OpenBSD/doc/obsd-faq.pdf was last updated on 02/05/07, which is far more like what I woulde have expected. In summary, am I being dumb or is something out of sync? Something is out of sync... For some reason that directory isn't replicating properly. I'll bring that up with the right people... Nick.
Re: PF problems with many connections.
2007/7/13, Stuart Henderson [EMAIL PROTECTED]: pass log quick on $int_if proto tcp from $me to 10.10.10.10 port 80 ^^^ Is it any better without logging? And `pfctl -si` have normal values. It's better to include the output. Also sysctl net.inet.ip.ifq. # pfctl -si Status: Enabled for 14 days 23:22:42 Debug: Urgent State Table Total Rate current entries 34 searches29928507 23.1/s inserts960320.1/s removals 959980.1/s Counters match 7004910.5/s bad-offset 00.0/s fragment 00.0/s short 00.0/s normalize 102540.0/s memory 00.0/s bad-timestamp 00.0/s congestion 00.0/s ip-option 00.0/s proto-cksum 690.0/s state-mismatch 2000.0/s state-insert 00.0/s state-limit00.0/s src-limit 00.0/s synproxy 00.0/s # sysctl net.inet.ip.ifq net.inet.ip.ifq.len=0 net.inet.ip.ifq.maxlen=50 net.inet.ip.ifq.drops=0 It may be also important, before connection failed we can see following state: # pfctl -ss all tcp 10.10.10.101:8427 - 10.10.10.10:80 SYN_SENT:CLOSED I don't see any differences with or without 'log' option.
FastCGI / php and chroot- what to try next? (Was: fastcgi + php: how to handle further extensions?)
Hello, My problem is with FastCGI php5 in a chrooted environment. In chroot the binary refuses to find the shared libs like mysql.so (but the binary itself works). Whenever I disable chroot (-u) the binary includes the shared libs without any problems. Pointing to a different (relative or absolute) path in php.in (extension_dir) does not help. The dl() function (which allows loadiing extensions within scripts) does not work either, even though it can find the mysql.so if placed in the same dir as the script calling it. All the required files (ldd) are in the chroot environment, there are no signs of anything obvious missing. By temporarily placing ktrace in the chroot and making it executable by www I have managed to get a trace from the actual process as ran by www. Reading that however does not give *me* any clues as to what could be the problem: 2608 php5-fastcgi CALL open(0x4940d000,0,0x6c) 2608 php5-fastcgi NAMI /lib/php/modules/mysql.so 2608 php5-fastcgi RET open 5 2608 php5-fastcgi CALL fstat(0x5,0x7f7e2170) 2608 php5-fastcgi RET fstat 0 snip 2608 php5-fastcgi RET sigprocmask -65793/0xfffefeff 2608 php5-fastcgi CALL write(0x2,0x7f7e23c0,0x8a) 2608 php5-fastcgi GIO fd 2 wrote 138 bytes PHP Warning: PHP Startup: Unable to load dynamic library '/lib/php/modules/mysql.so' - Cannot load specified object in Unknown on line 0 2608 php5-fastcgi RET write 138/0x8a The php warning above is what I get back in the /var/www/logs/error_log. Errors are the same if I specify '/var/www/lib/php/modules/' - it does not matter. I would really like to get this working in a chroot but just don't know what I can/should do next. I will GLADLY include complete traces (it's long!) or other desired info if someone thinks it will help. General help as to what to look for / how to debug more / where to get answers instead is also very much appreciated. Thank you, Matt Matt schreef: [Wed Jul 11 18:34:07 2007] [warn] FastCGI: (dynamic) server /cgi-bin/10.0.0.64/php5.fcgi (uid 1000, gid 1000) started (pid 20781) PHP Warning: PHP Startup: Unable to load dynamic library '/var/www/lib/php/modules/mysql.so' - File not found in Unknown on line 0
Re: PF problems with many connections.
pass log quick on $int_if proto tcp from $me to 10.10.10.10 port 80 ^^^ Is it any better without logging? And `pfctl -si` have normal values. It's better to include the output. Also sysctl net.inet.ip.ifq.
Re: DTP pm2654U2
On 2007/07/13 13:35, Tang Tse wrote: sd1: 70088 MB iopsp0 at iop0 tid 8: SCSI port SYMBIOS,SYM53C895,0001 scsibus3 at iopsp0: 16 targets -- that's the last line. Anyone had the same problem or similar? Any idea? I'm pretty sure there's something about it in the archives, and think there was a workaround. Try search terms like iopsp and hang.
Re: PF problems with many connections.
On 7/13/07, TuxR [EMAIL PROTECTED] wrote:
Hello.
I trying to use OpenBSD under high load and have problems with PF.
When there is very many connections to server in some point other
connections just failes.
I try to use simple test application that creates 1000 connections to
server for 1000 iteration. Maximum number I have observed with pf was
'12' but with 'pfctl -d' all cycle successfully works ('1000').
I try to use following simple test application:
Also I have looked the same when testing 'ab' from apache2
distribution. 'ab -c 100 -n 100' : maximum 9 iteration with pf enabled
and 100 without.
There is instant connection closing if keep state is enabled. When
keep state is disabled there is following behaviour: in some moment
the program is waiting for reply but do not get it and connection also
close because timeout.
I have looked no problems in tcpdump reports. Also no blocked packets
was in pflog0 interface ('block log all' rule)
I am sure that states limit is not exceed. Now I have
set limit states50
set limit src-nodes 5
set limit frags 32000
And `pfctl -si` have normal values.
'antispoof' and 'scrub' options are not affected. 'set optimization'
make more bad.
I looked the same behaviour in real use: when there is many
connection, in some point they just closed.
Any help will be appropriated. Many thanks.
P.S. Sorry for my bad english.
Study the execellent 3 part series of OpenBSD developer at
http://undeadly.org/cgi?action=articlesid=20060927091645mode=expanded
If after following his advice, your firewall still does not perform
adequately come back here with a posting of:
1) dmesg to see what kind of hardware you are using
2) vmstat -i output to show the interrupt rate of the NICs
Using 'systat vmstat will give you a 'live' view of the interrupt
rate and other resources
3) netstat -m output to see the mbuf stats
4) your pf.conf
Others may have additional suggestions of course ;)
=Adriaan=
DTP pm2654U2
Hi there! I got a Xeon Machine with DTP PM2654U2 ( a very old raid adapter ). I take a look at Hardware compatibility list and it's not in list but some other samrtraid like III and IV yes ( mine is smartraid V ). Whith the latest firmware and bios ( updated some hours ago ). When I boot from install CD, openbsd freezes when it detects HDD on smartraid ( i got 5 hdd on raid 5 ) output is something like this: sd1: 70088 MB iopsp0 at iop0 tid 8: SCSI port SYMBIOS,SYM53C895,0001 scsibus3 at iopsp0: 16 targets -- that's the last line. Anyone had the same problem or similar? Any idea? Machine if full sopported when there PM2654U2 is not plugged in. Some BIOS option? Thanks!!
Re: Video problems (and others?) with ASRock 755i65G/Intel 865G
On 7/13/07, Andris [EMAIL PROTECTED] wrote: Hi, I just got a computer yesterday, which has an ASRock 755i65G* motherboard, with an Intel 865G* chipset, 512 MB of RAM, and a ViewSonic E70f+* monitor. I'm using OpenBSD 4.1-stable (i386/GENERIC). I tried to make it run under 1024x768, 24bpp, a h-sync of 30~70kHz and a v-sync of 50~160Hz). I can't make X run on it, I've tried i810(4), whose man page says it supports my integrated video solution (865G). But the X server crashes after showing the cursor for a sec. Here is the X log: From you log, the X server is ok. The problem looks more like a problem with your .xinitrc or something like that. Can you tell us how you startx X, and try to capture the command's stdout and stderr ? If you're running ksh or bash, this should be something like startx startx.log 21 and then look at startx.log for obvious errors, or share it here if you don't see anything meaningful for you.
membre services
[IMAGE] Cher(e) membre Bank National Vous avez gagner 5000$ dans le concour de bank national. Pour diposer votre prix , veuillez cliquez sur ce lien sicurisi si dessus : https://bvi.bnc.ca/index/bnc/indexfr.html/ Soyez assuri que Bank National met tout en oeuvre pour ricompencer les utilisateurs de ses services internet. Le Groupe Bank National vous remercie de votre clienthle et appricie votre comprihension. Bank National Svp ne repondez pas a ce courriel car c'est seulement un avis. Le courrier envoyee a cette adresse ne peut pas etre repondu. Copyright ) 2007 Mouvement des Bank National. Tous droits riservis.
Re: mysql problem
I am , and i have a simple and nice script for starting and stopping it properly: # /usr/local/bin/my start cat /usr/local/bin/my #!/bin/sh # test -z $1 -o \( $1 != start -a $1 != stop \) \ echo syntax: $0 [start|stop] exit 1 exec /usr/local/share/mysql/mysql.server $1 /dev/null 21 -- and in mysql.server it says: # Set some defaults pid_file= server_pid_file= use_mysqld_safe=1 user=_mysql What do you think, should i add more openfiles to mysql? Regards, Marcos - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org Sent: Friday, July 13, 2007 4:07 AM Subject: Re: mysql problem On Fri, 13 Jul 2007, Marcos Laufer wrote: I did read the archives, and it helped me to find out that restarting mysql fixes it for some time, and i increased the values several times but no luck. It starts working fine for a while but then again it fails . In the end i have this config right now and the problem persists, i can reproduce the problem just by executing mysqlcheck -m -A -p How are yo starting mysql? You need to explicitly set the login class. Somthing like su -c mysql root /usr/local/bin/mysqld_safe ... -Otto -- # sysctl kern.maxfiles kern.maxfiles=2 -- in login.conf: _mysql:\ :openfiles=8192:\ :datasize=infinity:\ :maxproc=infinity:\ :openfiles-cur=8192:\ :openfiles-max=1:\ :stacksize-cur=8M: in my.cnf: [mysqld] socket = /var/www/logs/mysql/mysql.sock old-passwords tmpdir = /var/mysql/tmp open-files-limit = 1 sql-mode = MYSQL40 skip-name-resolve table_cache = 1024 query_cache_size = 64M key_buffer = 64M long_query_time = 5 #log-slow-queries #log-queries-not-using-indexes thread_concurrency = 2 #query_cache_limit = 1M interactive_timeout=60 wait_timeout=60 connect_timeout=15 basedir=/usr/local datadir=/var/mysql sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M [mysql.server] old-passwords [mysqld_safe] open-files=8192 Maybe i need to increase something else? Thanks! - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org Sent: Friday, July 13, 2007 3:12 AM Subject: Re: mysql problem On Fri, 13 Jul 2007, Marcos Laufer wrote: I am having a very strange problem on a 3.9 , suddenly i can't access any table on the databases. I have around 100 databases on this server and can't access not even one. This is a production server and i am in an urge to solve it, if anyone can help i would appreciate it: # mysql mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 303342 to server version: 5.0.18 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables; ERROR 1018 (HY000): Can't read dir of './mysql/' (errno: 9) mysql I have backups of all databases, including mysql database which i think is the one broken , how can i restore it ? Thanks for your help You are running out of file descriptors. Search the archives for answers. -Otto
Re: mysql problem
On 2007/07/13 13:41, Marcos Laufer wrote: How are yo starting mysql? You need to explicitly set the login class. Somthing like su -c mysql root /usr/local/bin/mysqld_safe ... I am , and i have a simple and nice script for starting and stopping it properly: Where are you setting the login class (su -c) to actually use the login.conf settings for the mysql class? It's nowhere that you've shown us.
Re: Video problems (and others?) with ASRock 755i65G/Intel 865G
On 7/13/07, Matthieu Herrb [EMAIL PROTECTED] wrote: On 7/13/07, Andris [EMAIL PROTECTED] wrote: Hi, I just got a computer yesterday, which has an ASRock 755i65G* motherboard, with an Intel 865G* chipset, 512 MB of RAM, and a ViewSonic E70f+* monitor. I'm using OpenBSD 4.1-stable (i386/GENERIC). I tried to make it run under 1024x768, 24bpp, a h-sync of 30~70kHz and a v-sync of 50~160Hz). I can't make X run on it, I've tried i810(4), whose man page says it supports my integrated video solution (865G). But the X server crashes after showing the cursor for a sec. Here is the X log: From you log, the X server is ok. The problem looks more like a problem with your .xinitrc or something like that. Can you tell us how you startx X, and try to capture the command's stdout and stderr ? If you're running ksh or bash, this should be something like startx startx.log 21 and then look at startx.log for obvious errors, or share it here if you don't see anything meaningful for you. Hi, after moving .xinitrc to .xinitrc.bak I could start X with no problems, and it doesn't crash :) I had this line in it: exec /usr/X11R6/bin/xset r rate 250 50 It worked with a previous computer, didn't think it would cause problems. Shouldn't it affect only the keyboard? Anyway, thank so much, I've tried so different things, and couldn't solve it :P Again, thanks!
Re: mysql problem
You are setting the user, not the login class.
You have made a login class _mysql in /etc/login.conf,
but it looks like you may not have that as user _mysql's default
login class. You need to either change user _mysql to be in the
_mysql login class by default, (hint, chfn _mysql as root) OR,
use the su command to start it as otto showed you.
Note as well, that just setting it to use 8192 open
files won't necessarily get you all the way there if the
kernel doesn't have that many configured. You may also need
to increase this if you *really* need that many:
# sysctl kern.maxfiles
kern.maxfiles=1772
-Bob
* Marcos Laufer [EMAIL PROTECTED] [2007-07-13 10:46]:
I am , and i have a simple and nice script for starting and stopping it
properly:
# /usr/local/bin/my start
cat /usr/local/bin/my
#!/bin/sh
#
test -z $1 -o \( $1 != start -a $1 != stop \) \
echo syntax: $0 [start|stop] exit 1
exec /usr/local/share/mysql/mysql.server $1 /dev/null 21
--
and in mysql.server it says:
# Set some defaults
pid_file=
server_pid_file=
use_mysqld_safe=1
user=_mysql
What do you think, should i add more openfiles to mysql?
Regards,
Marcos
- Original Message -
From: Otto Moerbeek [EMAIL PROTECTED]
To: Marcos Laufer [EMAIL PROTECTED]
Cc: misc@openbsd.org
Sent: Friday, July 13, 2007 4:07 AM
Subject: Re: mysql problem
On Fri, 13 Jul 2007, Marcos Laufer wrote:
I did read the archives, and it helped me to find out that
restarting mysql fixes it for some time, and i increased the values
several times but no luck. It starts working fine
for a while but then again it fails . In the end i have
this config right now and the problem persists, i can
reproduce the problem just by executing
mysqlcheck -m -A -p
How are yo starting mysql? You need to explicitly set the login class.
Somthing like
su -c mysql root /usr/local/bin/mysqld_safe ...
-Otto
--
# sysctl kern.maxfiles
kern.maxfiles=2
--
in login.conf:
_mysql:\
:openfiles=8192:\
:datasize=infinity:\
:maxproc=infinity:\
:openfiles-cur=8192:\
:openfiles-max=1:\
:stacksize-cur=8M:
in my.cnf:
[mysqld]
socket = /var/www/logs/mysql/mysql.sock
old-passwords
tmpdir = /var/mysql/tmp
open-files-limit = 1
sql-mode = MYSQL40
skip-name-resolve
table_cache = 1024
query_cache_size = 64M
key_buffer = 64M
long_query_time = 5
#log-slow-queries
#log-queries-not-using-indexes
thread_concurrency = 2
#query_cache_limit = 1M
interactive_timeout=60
wait_timeout=60
connect_timeout=15
basedir=/usr/local
datadir=/var/mysql
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
[mysql.server]
old-passwords
[mysqld_safe]
open-files=8192
Maybe i need to increase something else?
Thanks!
- Original Message -
From: Otto Moerbeek [EMAIL PROTECTED]
To: Marcos Laufer [EMAIL PROTECTED]
Cc: misc@openbsd.org
Sent: Friday, July 13, 2007 3:12 AM
Subject: Re: mysql problem
On Fri, 13 Jul 2007, Marcos Laufer wrote:
I am having a very strange problem on a 3.9 , suddenly i can't access any
table
on the databases. I have around 100 databases on this server and can't
access
not even one. This is a production server and i am in an urge to solve it,
if
anyone
can help i would appreciate it:
# mysql mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 303342 to server version: 5.0.18
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql show tables;
ERROR 1018 (HY000): Can't read dir of './mysql/' (errno: 9)
mysql
I have backups of all databases, including mysql database which i think is
the
one
broken , how can i restore it ?
Thanks for your help
You are running out of file descriptors. Search the archives for answers.
-Otto
--
#!/usr/bin/perl
if ((not 0 not 1) != (! 0 ! 1)) {
print Larry and Tom must smoke some really primo stuff...\n;
}
Re: Video problems (and others?) with ASRock 755i65G/Intel 865G
On 7/13/07, Matthieu Herrb [EMAIL PROTECTED] wrote: Can you tell us how you startx X, and try to capture the command's stdout and stderr ? If you're running ksh or bash, this should be something like startx startx.log 21 Here is the output of startx startx.log 21 *before* moving .xinitrc to ,xinitrc.bak. Just for the record: === startx startx.log 21 output follows === xauth: creating new authority file /home/adelfino/.serverauth.21235 /usr/X11R6/bin/xauth: creating new authority file /home/adelfino/.Xauthority X Window System Version 6.9.0 (for OpenBSD) Release Date: 21 December 2005 X Protocol Version 11, Revision 0, Release 6.9 Build Operating System: OpenBSD 4.1 i386 [ELF] Current Operating System: OpenBSD rei.ciudad.com.ar 4.1 GENERIC#0 i386 Build Date: 07 March 2007 Before reporting problems, check http://wiki.X.Org to make sure that you have the latest version. Module Loader present Markers: (--) probed, (**) from config file, (==) default setting, (++) from command line, (!!) notice, (II) informational, (WW) warning, (EE) error, (NI) not implemented, (??) unknown. (==) Log file: /var/log/Xorg.0.log, Time: Fri Jul 13 13:52:31 2007 (==) Using config file: /etc/X11/xorg.conf The XKEYBOARD keymap compiler (xkbcomp) reports: Warning: Type ONE_LEVEL has 1 levels, but RALT has 2 symbols Ignoring extra symbols Errors from xkbcomp are not fatal to the X server Could not init font path element /usr/X11R6/lib/X11/fonts/CID/, removing from list! Could not init font path element /usr/X11R6/lib/X11/fonts/local/, removing from list! SetClientVersion: 0 9 waiting for X server to shut down FreeFontPath: FPE /usr/X11R6/lib/X11/fonts/misc/ refcount is 2, should be 1; fixing. === startx startx.log 21 output precedes === I start X with xinit.
flashdist-20061112 with openbsd 4.1
Hi List, i've probleme with flashdist and OpenBSD 4.1. 4.0 works fine but on 4.1 i've problems with the partiontables. here my setup procedure - # dd if=/dev/zero of=flashimg bs=512 count=250368 250368+0 records in 250368+0 records out 128188416 bytes transferred in 2.593 secs (49432122 bytes/sec) # vnconfig -c svnd0 flashimg # sh flashdist.sh svnd0 flashsmall.txt bsd / flashdist.sh 20061112 [EMAIL PROTECTED] Using disk device: svnd0 Using distfile: flashsmall.txt Copying kernel from: bsd You did not specify -d and you did not specify a manual geometry. Please enter Cylinders/Heads/SectorsPerTrack. Cylinders: 978 Tracks Per Cylinder(Heads): 8 Sectors Per Track: 32 Please pay attention to any error messages that you may receive from the commands this script is using. If you end up having problems, they could explain why. WARNING: This will erase ALL DATA on the svnd0 disk device! Press enter key to continue or Control-C to abort... Updating MBR and partition table... fdisk: sysctl(machdep.bios.diskinfo): Device not configured Note, you may ignore sysctl(machdep.bios.diskinfo) errors if present. Setting up disklabel... # Inside MBR partition 3: type A6 start 32 size 250336 The install script is using the following parameters: Total size of media: 250368 sectors (128188416 bytes) Bytes/Sector: 512 Sectors/Track: 32 Sectors/Cylinder: 256 Tracks/Cylinder (heads): 8 Cylinders: 978 Press enter key to continue or Control-C to abort... Checking distribution list... Installing disklabel... # Inside MBR partition 3: type A6 start 32 size 250336 Creating new filesystem... /dev/rsvnd0a: 250080 sectors in 977 cylinders of 8 tracks, 32 sectors 122.1MB in 4 cyl groups (285 c/g, 35.62MB/g, 9088 i/g) Mounting destination to /tmp/flashdist.iXZgI9414... Checking free space on svnd0... Copying OpenBSD distribution to media... Copying bsd kernel, boot blocks, /etc/resolv.conf... Installing boot blocks... Running MAKEDEV...done Setting up directories and links... Changing any instance of /bin/csh in /tmp/flashdist.iXZgI9414/etc/master.passwd to /bin/ksh Generating new RSA host key... done Generating new RSA1 host key... done Generating new DSA host key... done Please assign a root password... Password: Verify: Passwords don't match or password was empty. Try again. Password: Verify: Copying configuration files to /etc... ttys fstab rc syslog.conf boot.conf nshrc Please enter the hostname or IP address of the central log host which will receive udp syslog packets from this installation. (Press enter for none, and syslog will log to ramdisk) Loghost: Installation finished. Unmounting filesystem...done! -- # fdisk svnd0 fdisk: sysctl(machdep.bios.diskinfo): Device not configured Disk: svnd0 geometry: 978/8/32 [250368 Sectors] Offset: 0 Signature: 0xAA55 Starting Ending LBA Info: #: idC H S -C H S [ start: size ] 0: E8 963667 7 23 - 14415919 1 7 [ 246698998: 3443776305 ] Unknown ID 1: 010 0 1 - 16777215 7 32 [ 0: 0 ] DOS FAT-12 2: 000 0 0 -0 0 0 [ 0: 0 ] unused 3: 3F0 0 1 - 16777215 7 32 [ 0: 0 ] Unknown ID # disklabel svnd0 # /dev/rsvnd0c: type: vnd disk: vnd device label: fictitious flags: bytes/sector: 512 sectors/track: 32 tracks/cylinder: 8 sectors/cylinder: 256 cylinders: 978 total sectors: 250368 rpm: 3600 interleave: 1 trackskew: 0 cylinderskew: 0 headswitch: 0 # microseconds track-to-track seek: 0 # microseconds drivedata: 0 16 partitions: # sizeoffset fstype [fsize bsize cpg] a:25008032 4.2BSD 1024 8192 285 # Cyl 0*- 976 b: 1250112swap # Cyl 977 - 977* c:250368 0 unused 0 0 # Cyl 0 - 977 after unmounting and mounting the image # disklabel svnd0 # /dev/rsvnd0c: type: vnd disk: vnd device label: fictitious flags: bytes/sector: 512 sectors/track: 100 tracks/cylinder: 1 sectors/cylinder: 100 cylinders: 2503 total sectors: 250368 rpm: 3600 interleave: 1 trackskew: 0 cylinderskew: 0 headswitch: 0 # microseconds track-to-track seek: 0 # microseconds drivedata: 0 16 partitions: # sizeoffset fstype [fsize bsize cpg] c:250368 0 unused 0 0 # Cyl 0 - 2503* i:250368 0 MSDOS # Cyl 0 - 2503* it seems very strange have you anyone an idea ? with openbsd 4.0 no problem Thanks Thomas
Re: ipsec vpn with os x clients
# cat ipsec.conf ike dynamic from any to any \ main auth hmac-sha1 enc 3des group modp1024 \ quick auth hmac-sha1 enc 3des psk TheSecret this should be ike passive from ... roger that... # cat ipsec.conf ike passive from any to any \ main auth hmac-sha1 enc 3des group modp1024 \ quick auth hmac-sha1 enc 3des psk TheSecret The INVALID_COOKIE messages have been replaced with this: # isakmpd -K4dv 092755.013577 Default isakmpd: phase 1 done: initiator id ac1e0114: 172.30.1.20, responder id ac1e0101: 172.30.1.1, src: 172.30.1.1 dst: 172.30.1.20 092755.017234 Default responder_recv_HASH_SA_NONCE: peer proposed invalid phase 2 IDs: initiator id ac1e0114: 172.30.1.20, responder id ac1e0101: 172.30.1.1 092755.017569 Default dropped message from 172.30.1.20 port 500 due to notification type NO_PROPOSAL_CHOSEN 092758.020965 Default responder_recv_HASH_SA_NONCE: peer proposed invalid phase 2 IDs: initiator id ac1e0114: 172.30.1.20, responder id ac1e0101: 172.30.1.1 The proposal messages repeat until Mac timeout or I cancel. ipsecctl - m shows nothing. I had a similar proposal error when 'main auth' was set to 'enc aes'. I increased the reporting level of isakmpd and noticed a message that said something to the effect of client proposed 3DES, expected AES. That was when i changed my encryption type to 3DES. I see no such hints from isakmpd during the invalid phase 2 exchange. I tried altering my ipsec.conf to try different encryption algorithms for phase 2. 3des, aes, aesctr, and blowfish all report the same proposal error. I shall try changing the authentication method. If i change anything in the phase 1 section 'main', phase 1 fails. My continued thanks for any assistance
fsck Segmentation fault on 4.1
Hello, I want to report a problem i experienced while testing OpenBSD 4.1 . I've installed it, increased VM_PHYSSEG_MAX to 16 in /usr/src/sys/arch/i386/include/vmparam.h to make it work with this particular motherboard and made a stable release. Installed a server with it and it's working fine as an MX for a few months until now. The machine was crashed, no error on the screen and the keyboard did not respond. I rebooted , it started to fsck , and the fsck failed on /usr. So i run fsck manually : fsck -y, but it crashes with segmentation fault, so i can't mount or start the server. I read on the archives that it was a problem because of running out of swap, but i had made a 2gb swap partition, despite of that i added a 64mb file as swap and tried fsck again, but no luck. This time it was easy for me to reinstall everything in a new hard disk, but i still keep the old one because i would like to learn how to fix this , if anyone wants me to make some tests or has any ideas on what is going on , let me know. Regards, Marcos
Re: mysql problem
Bob , i saw what you meant me to set, it was on the daemon login
class , i changed it with chfn to _mysql .
Tonight i will test it again with mysqlcheck -m -A -p
to see if i still reach the limits.
Thanks for your advice!
Regards,
Marcos
- Original Message -
From: Bob Beck [EMAIL PROTECTED]
To: Marcos Laufer [EMAIL PROTECTED]
Cc: Otto Moerbeek [EMAIL PROTECTED]; misc@openbsd.org
Sent: Friday, July 13, 2007 1:54 PM
Subject: Re: mysql problem
You are setting the user, not the login class.
You have made a login class _mysql in /etc/login.conf,
but it looks like you may not have that as user _mysql's default
login class. You need to either change user _mysql to be in the
_mysql login class by default, (hint, chfn _mysql as root) OR,
use the su command to start it as otto showed you.
Note as well, that just setting it to use 8192 open
files won't necessarily get you all the way there if the
kernel doesn't have that many configured. You may also need
to increase this if you *really* need that many:
# sysctl kern.maxfiles
kern.maxfiles=1772
-Bob
* Marcos Laufer [EMAIL PROTECTED] [2007-07-13 10:46]:
I am , and i have a simple and nice script for starting and stopping it
properly:
# /usr/local/bin/my start
cat /usr/local/bin/my
#!/bin/sh
#
test -z $1 -o \( $1 != start -a $1 != stop \) \
echo syntax: $0 [start|stop] exit 1
exec /usr/local/share/mysql/mysql.server $1 /dev/null 21
--
and in mysql.server it says:
# Set some defaults
pid_file=
server_pid_file=
use_mysqld_safe=1
user=_mysql
What do you think, should i add more openfiles to mysql?
Regards,
Marcos
- Original Message -
From: Otto Moerbeek [EMAIL PROTECTED]
To: Marcos Laufer [EMAIL PROTECTED]
Cc: misc@openbsd.org
Sent: Friday, July 13, 2007 4:07 AM
Subject: Re: mysql problem
On Fri, 13 Jul 2007, Marcos Laufer wrote:
I did read the archives, and it helped me to find out that
restarting mysql fixes it for some time, and i increased the values
several times but no luck. It starts working fine
for a while but then again it fails . In the end i have
this config right now and the problem persists, i can
reproduce the problem just by executing
mysqlcheck -m -A -p
How are yo starting mysql? You need to explicitly set the login class.
Somthing like
su -c mysql root /usr/local/bin/mysqld_safe ...
-Otto
--
# sysctl kern.maxfiles
kern.maxfiles=2
--
in login.conf:
_mysql:\
:openfiles=8192:\
:datasize=infinity:\
:maxproc=infinity:\
:openfiles-cur=8192:\
:openfiles-max=1:\
:stacksize-cur=8M:
in my.cnf:
[mysqld]
socket = /var/www/logs/mysql/mysql.sock
old-passwords
tmpdir = /var/mysql/tmp
open-files-limit = 1
sql-mode = MYSQL40
skip-name-resolve
table_cache = 1024
query_cache_size = 64M
key_buffer = 64M
long_query_time = 5
#log-slow-queries
#log-queries-not-using-indexes
thread_concurrency = 2
#query_cache_limit = 1M
interactive_timeout=60
wait_timeout=60
connect_timeout=15
basedir=/usr/local
datadir=/var/mysql
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
[mysql.server]
old-passwords
[mysqld_safe]
open-files=8192
Maybe i need to increase something else?
Thanks!
- Original Message -
From: Otto Moerbeek [EMAIL PROTECTED]
To: Marcos Laufer [EMAIL PROTECTED]
Cc: misc@openbsd.org
Sent: Friday, July 13, 2007 3:12 AM
Subject: Re: mysql problem
On Fri, 13 Jul 2007, Marcos Laufer wrote:
I am having a very strange problem on a 3.9 , suddenly i can't access any
table
on the databases. I have around 100 databases on this server and can't
access
not even one. This is a production server and i am in an urge to solve it,
if
anyone
can help i would appreciate it:
# mysql mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 303342 to server version: 5.0.18
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql show tables;
ERROR 1018 (HY000): Can't read dir of './mysql/' (errno: 9)
mysql
I have backups of all databases, including mysql database which i think is
the
one
broken , how can i restore it ?
Thanks for your help
You are running out of file descriptors. Search the archives for answers.
-Otto
--
#!/usr/bin/perl
if ((not 0 not 1) != (! 0 ! 1)) {
print Larry and Tom must smoke some really primo stuff...\n;
}
Re: mysql problem
On Fri, 13 Jul 2007, Marcos Laufer wrote: Bob , i saw what you meant me to set, it was on the daemon login class , i changed it with chfn to _mysql . Tonight i will test it again with mysqlcheck -m -A -p to see if i still reach the limits. When starting a program, the login class is not changed unless explictly overridden. Setting the default login class of a user won't help. You need to do what I wrote earlier: use sudo -c class user command... -Otto Thanks for your advice! Regards, Marcos - Original Message - From: Bob Beck [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: Otto Moerbeek [EMAIL PROTECTED]; misc@openbsd.org Sent: Friday, July 13, 2007 1:54 PM Subject: Re: mysql problem You are setting the user, not the login class. You have made a login class _mysql in /etc/login.conf, but it looks like you may not have that as user _mysql's default login class. You need to either change user _mysql to be in the _mysql login class by default, (hint, chfn _mysql as root) OR, use the su command to start it as otto showed you. Note as well, that just setting it to use 8192 open files won't necessarily get you all the way there if the kernel doesn't have that many configured. You may also need to increase this if you *really* need that many: # sysctl kern.maxfiles kern.maxfiles=1772 -Bob * Marcos Laufer [EMAIL PROTECTED] [2007-07-13 10:46]: I am , and i have a simple and nice script for starting and stopping it properly: # /usr/local/bin/my start cat /usr/local/bin/my #!/bin/sh # test -z $1 -o \( $1 != start -a $1 != stop \) \ echo syntax: $0 [start|stop] exit 1 exec /usr/local/share/mysql/mysql.server $1 /dev/null 21 -- and in mysql.server it says: # Set some defaults pid_file= server_pid_file= use_mysqld_safe=1 user=_mysql What do you think, should i add more openfiles to mysql? Regards, Marcos - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org Sent: Friday, July 13, 2007 4:07 AM Subject: Re: mysql problem On Fri, 13 Jul 2007, Marcos Laufer wrote: I did read the archives, and it helped me to find out that restarting mysql fixes it for some time, and i increased the values several times but no luck. It starts working fine for a while but then again it fails . In the end i have this config right now and the problem persists, i can reproduce the problem just by executing mysqlcheck -m -A -p How are yo starting mysql? You need to explicitly set the login class. Somthing like su -c mysql root /usr/local/bin/mysqld_safe ... -Otto -- # sysctl kern.maxfiles kern.maxfiles=2 -- in login.conf: _mysql:\ :openfiles=8192:\ :datasize=infinity:\ :maxproc=infinity:\ :openfiles-cur=8192:\ :openfiles-max=1:\ :stacksize-cur=8M: in my.cnf: [mysqld] socket = /var/www/logs/mysql/mysql.sock old-passwords tmpdir = /var/mysql/tmp open-files-limit = 1 sql-mode = MYSQL40 skip-name-resolve table_cache = 1024 query_cache_size = 64M key_buffer = 64M long_query_time = 5 #log-slow-queries #log-queries-not-using-indexes thread_concurrency = 2 #query_cache_limit = 1M interactive_timeout=60 wait_timeout=60 connect_timeout=15 basedir=/usr/local datadir=/var/mysql sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M [mysql.server] old-passwords [mysqld_safe] open-files=8192 Maybe i need to increase something else? Thanks! - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org Sent: Friday, July 13, 2007 3:12 AM Subject: Re: mysql problem On Fri, 13 Jul 2007, Marcos Laufer wrote: I am having a very strange problem on a 3.9 , suddenly i can't access any table on the databases. I have around 100 databases on this server and can't access not even one. This is a production server and i am in an urge to solve it, if anyone can help i would appreciate it: # mysql mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 303342 to server version: 5.0.18 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show tables; ERROR 1018 (HY000): Can't read dir of './mysql/' (errno: 9) mysql I have backups of all databases, including mysql database which i think is the one broken , how can i restore it ? Thanks for your help You are running out of file
Re: fsck Segmentation fault on 4.1
On Fri, 13 Jul 2007, Marcos Laufer wrote: Hello, I want to report a problem i experienced while testing OpenBSD 4.1 . I've installed it, increased VM_PHYSSEG_MAX to 16 in /usr/src/sys/arch/i386/include/vmparam.h to make it work with this particular motherboard and made a stable release. Installed a server with it and it's working fine as an MX for a few months until now. The machine was crashed, no error on the screen and the keyboard did not respond. I rebooted , it started to fsck , and the fsck failed on /usr. So i run fsck manually : fsck -y, but it crashes with segmentation fault, so i can't mount or start the server. I read on the archives that it was a problem because of running out of swap, but i had made a 2gb swap partition, despite of that i added a 64mb file as swap and tried fsck again, but no luck. This time it was easy for me to reinstall everything in a new hard disk, but i still keep the old one because i would like to learn how to fix this , if anyone wants me to make some tests or has any ideas on what is going on , let me know. Start by showing the error messgae. A segmentation fault is something different than running out of memory. If fsck segfaults, I need a proper error report. See http://www.openbsd.org/report.html If fsck runs out of memory, increasing ulimit -d might help, like: # ulimit -d unlimited # fsck ... That reminds me to cook a diff to do this automatically. With filesystem getting larger an larger, more people will run into out-of-mem situations. -Otto
Re: amd 64 jdk port PROBLEMS building a package
On 2007/07/13 11:56, John Brahy wrote: Stop in /virtualhosts/jdk/1.5 (line 1400 of Is there something that I'm doing wrong here? I would guess it may go away if you build in the normal place... If you're short on space there, look at WRKOBJDIR in bsd.port.mk(5) btw, this is really a question for ports@ not misc@
Re: fsck Segmentation fault on 4.1
Otto , This is the error i get: It starts booting , and it starts fsck , it fails with /dev/rwd0e and rwd0h, (i could see once that when it finished it says:) fsck_ffs in free(): error: free_page: pointer to wrong page fsck: /dev/rwd0h: Abort trap I reboot it again many times and that did not show again i try to fsck manually like this as you say and i get: # ulimit -d unlimited # fsck -y /dev/rwd0e INCONSISTENT CGSIZE=16384 FIX? yes * * Last mounted on /usr * * Phase 1- Check Blocks and Sizes * * Phase 2 - Check pathnames * * Phase 3 - Check Conectivity * * Phase 4 - Check Reference Counts * * Phase 5 - Check Cyl Groups CANNOT READ: BLK 64 CONTINUE? yes fsck: /dev/rwd0e: Segmentation Fault # _ The dmesg is: OpenBSD 4.1-stable (GENERIC) #0: Mon May 14 14:02:47 ART 2007 [EMAIL PROTECTED]:/u/system/src/sys/arch/i386/compile/GENERIC cpu0: Intel(R) Pentium(R) 4 CPU 2.80GHz (GenuineIntel 686-class) 2.81 GHz cpu0: FPU,V86,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,CNXT-ID,xTPR real mem = 1064857600 (1039900K) avail mem = 964222976 (941624K) using 4278 buffers containing 53366784 bytes (52116K) of memory mainbus0 (root) bios0 at mainbus0: AT/286+ BIOS, date 09/15/03, BIOS32 rev. 0 @ 0xfbbd0, SMBIOS rev. 2.2 @ 0xf0800 (39 entries) bios0: MICRO-STAR INTL, CO.,LTD. MS-6743 apm0 at bios0: Power Management spec V1.2 apm0: AC on, battery charge unknown apm0: flags 70102 dobusy 1 doidle 1 pcibios0 at bios0: rev 2.1 @ 0xf/0xdf84 pcibios0: PCI IRQ Routing Table rev 1.0 @ 0xfdeb0/176 (9 entries) pcibios0: PCI Exclusive IRQs: 3 4 5 7 10 11 pcibios0: PCI Interrupt Router at 000:31:0 (Intel 82371SB ISA rev 0x00) pcibios0: PCI bus #1 is the last bus bios0: ROM list: 0xc/0xa600 0xcc000/0x1800 acpi at mainbus0 not configured cpu0 at mainbus0 pci0 at mainbus0 bus 0: configuration mode 1 (no bios) pchb0 at pci0 dev 0 function 0 Intel 82865G/PE/P CPU-I/0-1 rev 0x02 vga1 at pci0 dev 2 function 0 Intel 82865G Video rev 0x02: aperture at 0xf000, size 0x800 wsdisplay0 at vga1 mux 1: console (80x25, vt100 emulation) wsdisplay0: screen 1-5 added (80x25, vt100 emulation) ppb0 at pci0 dev 30 function 0 Intel 82801BA AGP rev 0xc2 pci1 at ppb0 bus 1 fxp0 at pci1 dev 8 function 0 Intel PRO/100 VE rev 0x02, i82562: irq 10, address 00:0c:76:b5:8a:85 inphy0 at fxp0 phy 1: i82562ET 10/100 PHY, rev. 0 ichpcib0 at pci0 dev 31 function 0 Intel 82801EB/ER LPC rev 0x02 pciide0 at pci0 dev 31 function 2 Intel 82801EB SATA rev 0x02: DMA, channel 0 configured to compatibility, channel 1 configured to compatibility wd0 at pciide0 channel 0 drive 1: WDC WD800JD-00MSA1 wd0: 16-sector PIO, LBA48, 76319MB, 156301488 sectors wd0(pciide0:0:1): using PIO mode 4, Ultra-DMA mode 5 atapiscsi0 at pciide0 channel 1 drive 1 scsibus0 at atapiscsi0: 2 targets cd0 at scsibus0 targ 0 lun 0: LITEON, CD-ROM LTN526D, 9S01 SCSI0 5/cdrom removable cd0(pciide0:1:1): using PIO mode 4, Ultra-DMA mode 2 ichiic0 at pci0 dev 31 function 3 Intel 82801EB/ER SMBus rev 0x02: irq 4 iic0 at ichiic0 iic0: addr 0x2f 04=00 06=0a 07=00 0c=00 0d=07 0e=85 0f=00 10=c0 11=11 12=00 13=60 14=14 15=62 16=01 17=06 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 pmsi0 at pckbc0 (aux slot) pckbc0: using irq 12 for aux slot wsmouse0 at pmsi0 mux 0 pcppi0 at isa0 port 0x61 midi0 at pcppi0: PC speaker spkr0 at pcppi0 lm0 at isa0 port 0x290/8: W83627THF npx0 at isa0 port 0xf0/16: reported by CPUID; using exception 16 biomask ebfd netmask effd ttymask pctr: user-level cycle counter enabled dkcsum: wd0 matches BIOS drive 0x80 root on wd0a rootdev=0x0 rrootdev=0x300 rawdev=0x302 - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org Sent: Friday, July 13, 2007 3:38 PM Subject: Re: fsck Segmentation fault on 4.1 On Fri, 13 Jul 2007, Marcos Laufer wrote: Hello, I want to report a problem i experienced while testing OpenBSD 4.1 . I've installed it, increased VM_PHYSSEG_MAX to 16 in /usr/src/sys/arch/i386/include/vmparam.h to make it work with this particular motherboard and made a stable release. Installed a server with it and it's working fine as an MX for a few months until now. The machine was crashed, no error on the screen and the keyboard did not respond. I rebooted , it started to fsck , and the fsck failed on /usr. So i run fsck manually : fsck -y, but it crashes with segmentation fault, so i can't mount or start the server. I read on the archives that it was a problem because of running out of swap, but i had made a 2gb swap partition, despite of that i added a 64mb file as swap and tried fsck again, but no luck. This time it was easy for me to reinstall everything in a new hard disk, but i still keep the old one because i would like to learn how to fix this , if anyone
Re: fsck Segmentation fault on 4.1
I want to report a problem i experienced while testing OpenBSD 4.1 . I've installed it, increased VM_PHYSSEG_MAX to 16 in /usr/src/sys/arch/i386/include/vmparam.h to make it work with this particular motherboard and made a stable release. Fluffy!!! There be dragons.. -Bob
Re: fsck Segmentation fault on 4.1
On Fri, 13 Jul 2007, Marcos Laufer wrote: Otto , This is the error i get: It starts booting , and it starts fsck , it fails with /dev/rwd0e and rwd0h, (i could see once that when it finished it says:) fsck_ffs in free(): error: free_page: pointer to wrong page fsck: /dev/rwd0h: Abort trap I reboot it again many times and that did not show again i try to fsck manually like this as you say and i get: # ulimit -d unlimited # fsck -y /dev/rwd0e INCONSISTENT CGSIZE=16384 FIX? yes * * Last mounted on /usr * * Phase 1- Check Blocks and Sizes * * Phase 2 - Check pathnames * * Phase 3 - Check Conectivity * * Phase 4 - Check Reference Counts * * Phase 5 - Check Cyl Groups CANNOT READ: BLK 64 CONTINUE? yes fsck: /dev/rwd0e: Segmentation Fault This is not an out of memory situation. It looks like fsck_ffs has problems getting data from your disk, probably because of hardware failure or bad cabling. Sometimes it detects it cannot read the data (the CANNOT READ: BLK 64 case), but it is possible it gets corrupted data in other cases. Sadly, this can cause fsck_ffs to do the wrong thing and access wrong memory and corrupt it's internal data. During the last year I've fixed some stuff in this area, but there still remains cases that can go wrong. -Otto # _ The dmesg is: OpenBSD 4.1-stable (GENERIC) #0: Mon May 14 14:02:47 ART 2007 [EMAIL PROTECTED]:/u/system/src/sys/arch/i386/compile/GENERIC cpu0: Intel(R) Pentium(R) 4 CPU 2.80GHz (GenuineIntel 686-class) 2.81 GHz cpu0: FPU,V86,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,CNXT-ID,xTPR real mem = 1064857600 (1039900K) avail mem = 964222976 (941624K) using 4278 buffers containing 53366784 bytes (52116K) of memory mainbus0 (root) bios0 at mainbus0: AT/286+ BIOS, date 09/15/03, BIOS32 rev. 0 @ 0xfbbd0, SMBIOS rev. 2.2 @ 0xf0800 (39 entries) bios0: MICRO-STAR INTL, CO.,LTD. MS-6743 apm0 at bios0: Power Management spec V1.2 apm0: AC on, battery charge unknown apm0: flags 70102 dobusy 1 doidle 1 pcibios0 at bios0: rev 2.1 @ 0xf/0xdf84 pcibios0: PCI IRQ Routing Table rev 1.0 @ 0xfdeb0/176 (9 entries) pcibios0: PCI Exclusive IRQs: 3 4 5 7 10 11 pcibios0: PCI Interrupt Router at 000:31:0 (Intel 82371SB ISA rev 0x00) pcibios0: PCI bus #1 is the last bus bios0: ROM list: 0xc/0xa600 0xcc000/0x1800 acpi at mainbus0 not configured cpu0 at mainbus0 pci0 at mainbus0 bus 0: configuration mode 1 (no bios) pchb0 at pci0 dev 0 function 0 Intel 82865G/PE/P CPU-I/0-1 rev 0x02 vga1 at pci0 dev 2 function 0 Intel 82865G Video rev 0x02: aperture at 0xf000, size 0x800 wsdisplay0 at vga1 mux 1: console (80x25, vt100 emulation) wsdisplay0: screen 1-5 added (80x25, vt100 emulation) ppb0 at pci0 dev 30 function 0 Intel 82801BA AGP rev 0xc2 pci1 at ppb0 bus 1 fxp0 at pci1 dev 8 function 0 Intel PRO/100 VE rev 0x02, i82562: irq 10, address 00:0c:76:b5:8a:85 inphy0 at fxp0 phy 1: i82562ET 10/100 PHY, rev. 0 ichpcib0 at pci0 dev 31 function 0 Intel 82801EB/ER LPC rev 0x02 pciide0 at pci0 dev 31 function 2 Intel 82801EB SATA rev 0x02: DMA, channel 0 configured to compatibility, channel 1 configured to compatibility wd0 at pciide0 channel 0 drive 1: WDC WD800JD-00MSA1 wd0: 16-sector PIO, LBA48, 76319MB, 156301488 sectors wd0(pciide0:0:1): using PIO mode 4, Ultra-DMA mode 5 atapiscsi0 at pciide0 channel 1 drive 1 scsibus0 at atapiscsi0: 2 targets cd0 at scsibus0 targ 0 lun 0: LITEON, CD-ROM LTN526D, 9S01 SCSI0 5/cdrom removable cd0(pciide0:1:1): using PIO mode 4, Ultra-DMA mode 2 ichiic0 at pci0 dev 31 function 3 Intel 82801EB/ER SMBus rev 0x02: irq 4 iic0 at ichiic0 iic0: addr 0x2f 04=00 06=0a 07=00 0c=00 0d=07 0e=85 0f=00 10=c0 11=11 12=00 13=60 14=14 15=62 16=01 17=06 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 pmsi0 at pckbc0 (aux slot) pckbc0: using irq 12 for aux slot wsmouse0 at pmsi0 mux 0 pcppi0 at isa0 port 0x61 midi0 at pcppi0: PC speaker spkr0 at pcppi0 lm0 at isa0 port 0x290/8: W83627THF npx0 at isa0 port 0xf0/16: reported by CPUID; using exception 16 biomask ebfd netmask effd ttymask pctr: user-level cycle counter enabled dkcsum: wd0 matches BIOS drive 0x80 root on wd0a rootdev=0x0 rrootdev=0x300 rawdev=0x302 - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org Sent: Friday, July 13, 2007 3:38 PM Subject: Re: fsck Segmentation fault on 4.1 On Fri, 13 Jul 2007, Marcos Laufer wrote: Hello, I want to report a problem i experienced while testing OpenBSD 4.1 . I've installed it, increased VM_PHYSSEG_MAX to 16 in /usr/src/sys/arch/i386/include/vmparam.h to make it work with this particular motherboard and made a stable release.
Re: mutt, getmail procmail
On 7/13/07, Denny White [EMAIL PROTECTED] wrote: ... PATH=$HOME/bin:$HOME:/usr/bin:/usr/sbin:/bin:/sbin:/usr/local/bin:/usr/local/sbin:. That line is probably unnecessary. Unless you can point to a specific program that your .procmailrc uses that is not in the default PATH set by procmail, why change it? FORMAIL=/usr/local/bin/formail Why do people think that hardcoding the paths to normal programs is a good thing? Why not just say formail and let the shell do the work? SENDMAIL=/usr/sbin/sendmail Remove that line: procmail sets that for you. ($SENDMAIL is a historical wart that exists only because sendmail was originally installed into a directory (/usr/lib) that wasn't in anyone's path.) LOCKFILE=$HOME/.lockmail Ugh. Do you know what that LOCKFILE assignment does? Unless you have a specific need for it (and I don't see anything in your .procmailrc that does), you should remove it. If you don't know what it does, then go read the procmailrc(5) manpage and then remove that line. # Anything that has not been delivered by now will go to $DEFAULT # using LOCKFILE=$DEFAULT$LOCKEXT That comment is not correct for at least two reasons: 1) the locking of $DEFAULT$LOCKEXT is only done if $DEFAULT names an actual file and not a directory, and 2) it doesn't (re)use LOCKFILE: you can hold both global lock and a local lock When I take procmail out of .getmailrc just download everything to my inbox, there's no problem. The problem starts every time I try to use procmail. Below is typical output of a getmail session: 2007-07-13 14:23:31 Delivery error (command procmail 17884 error (0, procmail: [17884] Fri Jul 13 14:23:31 2007 procmail: Assigning MAILDIR=/home/dennyboy/Mail procmail: Assigning DEFAULT=/home/dennyboy/Mail/inbox procmail: Assigning PMDIR=/home/dennyboy/.procmail procmail: Assigning LOGFILE=/home/dennyboy/.procmail/.procmail-log procmail: Opening /home/dennyboy/.procmail/.procmail-log)) 2007-07-13 14:23:31 msg 13/13 (2274 bytes) msgid UID54784-1149445332 from [EMAIL PROTECTED] ... It looks like the complaint from getmail is that procmail is writing stuff to its stderr. That's occurring because you set VERBOSE to on before you set LOGFILE. Either remove the assignment to VERBOSE or move it to after the LOGFILE assignment (or move the LOGFILE assignment to before the VERBOSE assignement, of course). Philip Guenther
Re: mysql problem
Otto Moerbeek wrote:
On Fri, 13 Jul 2007, Marcos Laufer wrote:
I did read the archives, and it helped me to find out that
restarting mysql fixes it for some time, and i increased the values
several times but no luck. It starts working fine
for a while but then again it fails . In the end i have
this config right now and the problem persists, i can
reproduce the problem just by executing
mysqlcheck -m -A -p
How are yo starting mysql? You need to explicitly set the login class.
Somthing like
su -c mysql root /usr/local/bin/mysqld_safe ...
-Otto
Otto is right. Here is my /etc/postgresql.rc script, which should give
you some ideas for managing mysql (notice ``SU'').
#!/bin/sh
exec 2
DATA=/var/postgresql/data
LOG=/var/postgresql/log
CMD=$1
PUSR=_postgresql
PCLS=postgresql
CTL=/usr/local/bin/pg_ctl
SU=su -l -c $PCLS $PUSR -c
userinfo -e $PUSR || { echo $PUSR user nonexistent.; exit 1; }
grep -q ^${PCLS}: /etc/login.conf || { echo $PCLS class
nonexistent.; exit 1; }
[ -x $CTL ] || { echo $CTL not executable.; exit 1; }
case $CMD in
stop|reload|status)
$SU exec $CTL $CMD -D $DATA
;;
start|restart)
$SU exec $CTL $CMD -D $DATA -l $LOG
chmod 644 $LOG
;;
*)
echo usage: $0 stop|restart|reload|status|start (will run as
$PUSR)
;;
esac
And the relevant sections of /etc/login.conf
daemon:\
:ignorenologin:\
:datasize=infinity:\
:maxproc=infinity:\
:openfiles-cur=128:\
:stacksize-cur=8M:\
:localcipher=blowfish,8:\
:tc=default:
postgresql:\
:openfiles-cur=768:\
:tc=daemon:
-pachl
--
# sysctl kern.maxfiles
kern.maxfiles=2
--
in login.conf:
_mysql:\
:openfiles=8192:\
:datasize=infinity:\
:maxproc=infinity:\
:openfiles-cur=8192:\
:openfiles-max=1:\
:stacksize-cur=8M:
in my.cnf:
[mysqld]
socket = /var/www/logs/mysql/mysql.sock
old-passwords
tmpdir = /var/mysql/tmp
open-files-limit = 1
sql-mode = MYSQL40
skip-name-resolve
table_cache = 1024
query_cache_size = 64M
key_buffer = 64M
long_query_time = 5
#log-slow-queries
#log-queries-not-using-indexes
thread_concurrency = 2
#query_cache_limit = 1M
interactive_timeout=60
wait_timeout=60
connect_timeout=15
basedir=/usr/local
datadir=/var/mysql
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
[mysql.server]
old-passwords
[mysqld_safe]
open-files=8192
Maybe i need to increase something else?
Thanks!
- Original Message -
From: Otto Moerbeek [EMAIL PROTECTED]
To: Marcos Laufer [EMAIL PROTECTED]
Cc: misc@openbsd.org
Sent: Friday, July 13, 2007 3:12 AM
Subject: Re: mysql problem
On Fri, 13 Jul 2007, Marcos Laufer wrote:
I am having a very strange problem on a 3.9 , suddenly i can't access any
table
on the databases. I have around 100 databases on this server and can't
access
not even one. This is a production server and i am in an urge to solve it,
if
anyone
can help i would appreciate it:
# mysql mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 303342 to server version: 5.0.18
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql show tables;
ERROR 1018 (HY000): Can't read dir of './mysql/' (errno: 9)
mysql
I have backups of all databases, including mysql database which i think is
the
one
broken , how can i restore it ?
Thanks for your help
You are running out of file descriptors. Search the archives for answers.
-Otto
Re: fsck Segmentation fault on 4.1
Otto, I know the cables are allright, i'm using them with other hard drive . And the hard drive is new , but i will format it and check if it shows up some errors. I hope it is hardware related , i would get kind of scared otherwise. Do you need me to try anything else with this filesystem? Regards, Marcos - Original Message - From: Otto Moerbeek [EMAIL PROTECTED] To: Marcos Laufer [EMAIL PROTECTED] Cc: misc@openbsd.org Sent: Friday, July 13, 2007 4:46 PM Subject: Re: fsck Segmentation fault on 4.1 On Fri, 13 Jul 2007, Marcos Laufer wrote: Otto , This is the error i get: It starts booting , and it starts fsck , it fails with /dev/rwd0e and rwd0h, (i could see once that when it finished it says:) fsck_ffs in free(): error: free_page: pointer to wrong page fsck: /dev/rwd0h: Abort trap I reboot it again many times and that did not show again i try to fsck manually like this as you say and i get: # ulimit -d unlimited # fsck -y /dev/rwd0e INCONSISTENT CGSIZE=16384 FIX? yes * * Last mounted on /usr * * Phase 1- Check Blocks and Sizes * * Phase 2 - Check pathnames * * Phase 3 - Check Conectivity * * Phase 4 - Check Reference Counts * * Phase 5 - Check Cyl Groups CANNOT READ: BLK 64 CONTINUE? yes fsck: /dev/rwd0e: Segmentation Fault This is not an out of memory situation. It looks like fsck_ffs has problems getting data from your disk, probably because of hardware failure or bad cabling. Sometimes it detects it cannot read the data (the CANNOT READ: BLK 64 case), but it is possible it gets corrupted data in other cases. Sadly, this can cause fsck_ffs to do the wrong thing and access wrong memory and corrupt it's internal data. During the last year I've fixed some stuff in this area, but there still remains cases that can go wrong. -Otto # _ The dmesg is: OpenBSD 4.1-stable (GENERIC) #0: Mon May 14 14:02:47 ART 2007 [EMAIL PROTECTED]:/u/system/src/sys/arch/i386/compile/GENERIC cpu0: Intel(R) Pentium(R) 4 CPU 2.80GHz (GenuineIntel 686-class) 2.81 GHz cpu0: FPU,V86,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,CNXT-ID,xTPR real mem = 1064857600 (1039900K) avail mem = 964222976 (941624K) using 4278 buffers containing 53366784 bytes (52116K) of memory mainbus0 (root) bios0 at mainbus0: AT/286+ BIOS, date 09/15/03, BIOS32 rev. 0 @ 0xfbbd0, SMBIOS rev. 2.2 @ 0xf0800 (39 entries) bios0: MICRO-STAR INTL, CO.,LTD. MS-6743 apm0 at bios0: Power Management spec V1.2 apm0: AC on, battery charge unknown apm0: flags 70102 dobusy 1 doidle 1 pcibios0 at bios0: rev 2.1 @ 0xf/0xdf84 pcibios0: PCI IRQ Routing Table rev 1.0 @ 0xfdeb0/176 (9 entries) pcibios0: PCI Exclusive IRQs: 3 4 5 7 10 11 pcibios0: PCI Interrupt Router at 000:31:0 (Intel 82371SB ISA rev 0x00) pcibios0: PCI bus #1 is the last bus bios0: ROM list: 0xc/0xa600 0xcc000/0x1800 acpi at mainbus0 not configured cpu0 at mainbus0 pci0 at mainbus0 bus 0: configuration mode 1 (no bios) pchb0 at pci0 dev 0 function 0 Intel 82865G/PE/P CPU-I/0-1 rev 0x02 vga1 at pci0 dev 2 function 0 Intel 82865G Video rev 0x02: aperture at 0xf000, size 0x800 wsdisplay0 at vga1 mux 1: console (80x25, vt100 emulation) wsdisplay0: screen 1-5 added (80x25, vt100 emulation) ppb0 at pci0 dev 30 function 0 Intel 82801BA AGP rev 0xc2 pci1 at ppb0 bus 1 fxp0 at pci1 dev 8 function 0 Intel PRO/100 VE rev 0x02, i82562: irq 10, address 00:0c:76:b5:8a:85 inphy0 at fxp0 phy 1: i82562ET 10/100 PHY, rev. 0 ichpcib0 at pci0 dev 31 function 0 Intel 82801EB/ER LPC rev 0x02 pciide0 at pci0 dev 31 function 2 Intel 82801EB SATA rev 0x02: DMA, channel 0 configured to compatibility, channel 1 configured to compatibility wd0 at pciide0 channel 0 drive 1: WDC WD800JD-00MSA1 wd0: 16-sector PIO, LBA48, 76319MB, 156301488 sectors wd0(pciide0:0:1): using PIO mode 4, Ultra-DMA mode 5 atapiscsi0 at pciide0 channel 1 drive 1 scsibus0 at atapiscsi0: 2 targets cd0 at scsibus0 targ 0 lun 0: LITEON, CD-ROM LTN526D, 9S01 SCSI0 5/cdrom removable cd0(pciide0:1:1): using PIO mode 4, Ultra-DMA mode 2 ichiic0 at pci0 dev 31 function 3 Intel 82801EB/ER SMBus rev 0x02: irq 4 iic0 at ichiic0 iic0: addr 0x2f 04=00 06=0a 07=00 0c=00 0d=07 0e=85 0f=00 10=c0 11=11 12=00 13=60 14=14 15=62 16=01 17=06 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 pmsi0 at pckbc0 (aux slot) pckbc0: using irq 12 for aux slot wsmouse0 at pmsi0 mux 0 pcppi0 at isa0 port 0x61 midi0 at pcppi0: PC speaker spkr0 at pcppi0 lm0 at isa0 port 0x290/8: W83627THF npx0 at isa0 port 0xf0/16: reported by CPUID; using exception 16 biomask ebfd netmask effd ttymask pctr: user-level cycle counter enabled dkcsum: wd0 matches BIOS drive 0x80 root on wd0a rootdev=0x0 rrootdev=0x300 rawdev=0x302 - Original Message -
[EMAIL PROTECTED]: Re: mutt, getmail procmail]
-- ___ ___ / __/ _ \/ __/__ / _\ \/ // / _//___/ / /___//_/ /_/ [ 1987 - 2007 ] http://sdf.lonestar.org Public Access Unix System === GnuPG key : 0x1644E79A | http://wwwkeys.nl.pgp.net Fingerprint: D0A9 AD44 1F10 E09E 0E67 EC25 CB44 F2E5 1644 E79A === Date: Fri, 13 Jul 2007 19:26:52 -0500 From: Denny White [EMAIL PROTECTED] To: Philip Guenther [EMAIL PROTECTED] Subject: Re: mutt, getmail procmail Message-ID: [EMAIL PROTECTED] References: [EMAIL PROTECTED] [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: [EMAIL PROTECTED] X-GPG-PUBLIC_KEY: http://wwwkeys.nl.pgp.net X-GPG-FINGERPRINT: D0A9 AD44 1F10 E09E 0E67 EC25 CB44 F2E5 1644 E79A User-Agent: Mutt/1.5.12-2006-07-14 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, Jul 13, 2007 at 02:44:48PM -0600, Philip Guenther wrote: On 7/13/07, Denny White [EMAIL PROTECTED] wrote: ... PATH=$HOME/bin:$HOME:/usr/bin:/usr/sbin:/bin:/sbin:/usr/local/bin:/usr/local/sbin:. That line is probably unnecessary. Unless you can point to a specific program that your .procmailrc uses that is not in the default PATH set by procmail, why change it? FORMAIL=/usr/local/bin/formail Why do people think that hardcoding the paths to normal programs is a good thing? Why not just say formail and let the shell do the work? SENDMAIL=/usr/sbin/sendmail Remove that line: procmail sets that for you. ($SENDMAIL is a historical wart that exists only because sendmail was originally installed into a directory (/usr/lib) that wasn't in anyone's path.) LOCKFILE=$HOME/.lockmail Ugh. Do you know what that LOCKFILE assignment does? Unless you have a specific need for it (and I don't see anything in your .procmailrc that does), you should remove it. If you don't know what it does, then go read the procmailrc(5) manpage and then remove that line. # Anything that has not been delivered by now will go to $DEFAULT # using LOCKFILE=$DEFAULT$LOCKEXT That comment is not correct for at least two reasons: 1) the locking of $DEFAULT$LOCKEXT is only done if $DEFAULT names an actual file and not a directory, and 2) it doesn't (re)use LOCKFILE: you can hold both global lock and a local lock When I take procmail out of .getmailrc just download everything to my inbox, there's no problem. The problem starts every time I try to use procmail. Below is typical output of a getmail session: 2007-07-13 14:23:31 Delivery error (command procmail 17884 error (0, procmail: [17884] Fri Jul 13 14:23:31 2007 procmail: Assigning MAILDIR=/home/dennyboy/Mail procmail: Assigning DEFAULT=/home/dennyboy/Mail/inbox procmail: Assigning PMDIR=/home/dennyboy/.procmail procmail: Assigning LOGFILE=/home/dennyboy/.procmail/.procmail-log procmail: Opening /home/dennyboy/.procmail/.procmail-log)) 2007-07-13 14:23:31 msg 13/13 (2274 bytes) msgid UID54784-1149445332 from [EMAIL PROTECTED] ... It looks like the complaint from getmail is that procmail is writing stuff to its stderr. That's occurring because you set VERBOSE to on before you set LOGFILE. Either remove the assignment to VERBOSE or move it to after the LOGFILE assignment (or move the LOGFILE assignment to before the VERBOSE assignement, of course). Philip Guenther Philip, Thank you. Followed your advice. Pertinent section below. It works. No more error messages, messages get filtered properly, life is good. I had set it the previous way that made the errors I guess out of misunderstanding the documentation and samples I had found. Anyways, thanks again, very much appreciated. Denny White = VERBOSE=off PMDIR=$HOME/.procmail LOGFILE=$PMDIR/.procmail-log MAILDIR=$HOME/Mail # You'd better make sure it exists DEFAULT=$MAILDIR/inbox COMSAT=no PER=([EMAIL PROTECTED]|[EMAIL PROTECTED]) FBSDALL=([EMAIL PROTECTED]|[EMAIL PROTECTED]) OBSDALL=([EMAIL PROTECTED]) :0 *$ ^From:.*$PER per/ :0 *$ ^From:.*$FBSDALL fbsd/ :0 *$ ^From:.*$OBSDALL obsd/ == -- ___ ___ / __/ _ \/ __/__ / _\ \/ // / _//___/ / /___//_/ /_/ [ 1987 - 2007 ] http://sdf.lonestar.org Public Access Unix System === GnuPG key : 0x1644E79A | http://wwwkeys.nl.pgp.net Fingerprint: D0A9 AD44 1F10 E09E 0E67 EC25 CB44 F2E5 1644 E79A === iD8DBQFGmBdFy0Ty5RZE55oRApFQAJsF+g7qjWSlT9Zc/vfOVvuQpRQqbwCfQQAy ju0BjC1doukS9IFk18GOeec= =wuzL -END PGP SIGNATURE-
Secure Network File System - Or Lack Thereof
Hi, I'm sure this has already been discussed in some manner, but I do not know under which search term. Sorry for duplication. I have been setting up NIS for the University I work for, and it shocks me just how insecure the whole affair is. What a mess. Has the OpenBSD project considered writing a distributed filesystem that can atleast replace NFS in a NIS setup? And I am not talking about AFS. OpenBSD has some of the best crypto hackers out there! I'm sure it would be a good project. Can the SSH cypto be crafted into some form of network filesystem? End rant. Have a good weekend all. -- Best Regards Edd --- http://students.dec.bournemouth.ac.uk/ebarrett
Re: mutt, getmail procmail
On Fri, 13 Jul 2007, Philip Guenther wrote: On 7/13/07, Denny White [EMAIL PROTECTED] wrote: ... PATH=$HOME/bin:$HOME:/usr/bin:/usr/sbin:/bin:/sbin:/usr/local/bin:/usr/local/sbin:. That line is probably unnecessary. Unless you can point to a specific program that your .procmailrc uses that is not in the default PATH set by procmail, why change it? FORMAIL=/usr/local/bin/formail Why do people think that hardcoding the paths to normal programs is a good thing? Why not just say formail and let the shell do the work? Sometimes users do nutty things with aliases. Then they need to undo the nuttiness when they need default behavior. Even worse is the sort who defines new meanings for common commands and places them high in the PATH, or defining nutty shell functions named for standard commands. (Such as the nutty implementation of undelete functionality through a redefinition of rm to a mv of a file to a hidden directory.) The default ksh.kshrc shipped with OpenBSD contains nutty aliases: alias su=wsu alias cd=wcd alias ftp=wftp alias ssh=wssh alias telnet=wtelnet alias rlogin=wrlogin alias ls='ls -gCF' wxxx are nutty shell functions, given the best of both kinds of nuttiness. Once this nuttiness is invited in, the author of shell scripts and configuration files becomes justifiably nervous about their scope. On a multiuser system, even one with one human user, uncertainty arises about what flavor of nuttiness is in play for each user in all possible contexts. (Is my user name that invokes ksh subject to the same nuttiness as the one that invokes zsh or csh?) Also, slipping a dubious substitution for a system command into another user's ~/bin, on ill-administered or trusty systems, can lead to various forms of good-natured, puckish mischief. (Suppose I can substitute an arbitary executable named vi or rm into your ~/bin.) Setting a PATH and using fully qualified path names for utilities may be classified as a sort of prudent practice. Whether it is best practice I do not judge. Dave
Re: mysql problem
Allright the, i start the mysql server with this:
if [ -x /usr/local/bin/mysqld_safe ] ; then
su -c _mysql root -c '/usr/local/bin/mysqld_safe ' /dev/null
echo -n ' mysql'
fi
but the problem still persists , it shows up when executing
mysqlcheck -m -A -p
Now what?
Regards,
Marcos
- Original Message -
From: Clint Pachl [EMAIL PROTECTED]
Cc: Marcos Laufer [EMAIL PROTECTED]; misc@openbsd.org
Sent: Friday, July 13, 2007 6:05 PM
Subject: Re: mysql problem
Otto Moerbeek wrote:
On Fri, 13 Jul 2007, Marcos Laufer wrote:
I did read the archives, and it helped me to find out that
restarting mysql fixes it for some time, and i increased the values
several times but no luck. It starts working fine
for a while but then again it fails . In the end i have
this config right now and the problem persists, i can
reproduce the problem just by executing
mysqlcheck -m -A -p
How are yo starting mysql? You need to explicitly set the login class.
Somthing like
su -c mysql root /usr/local/bin/mysqld_safe ...
-Otto
Otto is right. Here is my /etc/postgresql.rc script, which should give
you some ideas for managing mysql (notice ``SU'').
#!/bin/sh
exec 2
DATA=/var/postgresql/data
LOG=/var/postgresql/log
CMD=$1
PUSR=_postgresql
PCLS=postgresql
CTL=/usr/local/bin/pg_ctl
SU=su -l -c $PCLS $PUSR -c
userinfo -e $PUSR || { echo $PUSR user nonexistent.; exit 1; }
grep -q ^${PCLS}: /etc/login.conf || { echo $PCLS class
nonexistent.; exit 1; }
[ -x $CTL ] || { echo $CTL not executable.; exit 1; }
case $CMD in
stop|reload|status)
$SU exec $CTL $CMD -D $DATA
;;
start|restart)
$SU exec $CTL $CMD -D $DATA -l $LOG
chmod 644 $LOG
;;
*)
echo usage: $0 stop|restart|reload|status|start (will run as
$PUSR)
;;
esac
And the relevant sections of /etc/login.conf
daemon:\
:ignorenologin:\
:datasize=infinity:\
:maxproc=infinity:\
:openfiles-cur=128:\
:stacksize-cur=8M:\
:localcipher=blowfish,8:\
:tc=default:
postgresql:\
:openfiles-cur=768:\
:tc=daemon:
-pachl
--
# sysctl kern.maxfiles
kern.maxfiles=2
--
Re: mysql problem
Marcos Laufer wrote:
Allright the, i start the mysql server with this:
if [ -x /usr/local/bin/mysqld_safe ] ; then
su -c _mysql root -c '/usr/local/bin/mysqld_safe ' /dev/null
echo -n ' mysql'
fi
but the problem still persists , it shows up when executing
mysqlcheck -m -A -p
Now what?
Regards,
Marcos
- Original Message -
From: Clint Pachl [EMAIL PROTECTED]
Cc: Marcos Laufer [EMAIL PROTECTED]; misc@openbsd.org
Sent: Friday, July 13, 2007 6:05 PM
Subject: Re: mysql problem
Otto Moerbeek wrote:
On Fri, 13 Jul 2007, Marcos Laufer wrote:
I did read the archives, and it helped me to find out that
restarting mysql fixes it for some time, and i increased the values
several times but no luck. It starts working fine
for a while but then again it fails . In the end i have
this config right now and the problem persists, i can
reproduce the problem just by executing
mysqlcheck -m -A -p
How are yo starting mysql? You need to explicitly set the login class.
Somthing like
su -c mysql root /usr/local/bin/mysqld_safe ...
-Otto
Otto is right. Here is my /etc/postgresql.rc script, which should give
you some ideas for managing mysql (notice ``SU'').
#!/bin/sh
exec 2
DATA=/var/postgresql/data
LOG=/var/postgresql/log
CMD=$1
PUSR=_postgresql
PCLS=postgresql
CTL=/usr/local/bin/pg_ctl
SU=su -l -c $PCLS $PUSR -c
userinfo -e $PUSR || { echo $PUSR user nonexistent.; exit 1; }
grep -q ^${PCLS}: /etc/login.conf || { echo $PCLS class
nonexistent.; exit 1; }
[ -x $CTL ] || { echo $CTL not executable.; exit 1; }
case $CMD in
stop|reload|status)
$SU exec $CTL $CMD -D $DATA
;;
start|restart)
$SU exec $CTL $CMD -D $DATA -l $LOG
chmod 644 $LOG
;;
*)
echo usage: $0 stop|restart|reload|status|start (will run as
$PUSR)
;;
esac
And the relevant sections of /etc/login.conf
daemon:\
:ignorenologin:\
:datasize=infinity:\
:maxproc=infinity:\
:openfiles-cur=128:\
:stacksize-cur=8M:\
:localcipher=blowfish,8:\
:tc=default:
postgresql:\
:openfiles-cur=768:\
:tc=daemon:
-pachl
--
# sysctl kern.maxfiles
kern.maxfiles=2
Try...
http://www.openbsdsupport.org/mysql.htm
Solved my problem.
Good Luck,
Steve W.
--
Re: mysql problem
Marcos Laufer wrote: Now what? http://openbsdsupport.org/mysql.htm
