Re: text format
On Tue, 12 Jun 2012 16:32:40 -0500 (CDT), Lars Eighner wrote: On Tue, 12 Jun 2012, pwnedomina wrote: On 12-06-2012 08:22, Polytropon wrote: On Tue, 12 Jun 2012 09:06:07 +0100, i pwn wrote: on groff i've used this cmd to format the text groff -Tascii normal.txt | sed 's/^//'$1 formatted.txt on nroff what would be the cmd? Depending on your input data, I'd say the same command: groff -Tascii normal.txt formatted.txt. But you need to test this yourself with your input text format. See man nroff for details. For using roff macros, man 7 mdoc has a nice summary. im only asking what cmd should i use to format an ascii text to be identical to that one, centered and aligned.. Depending on what your actual text input is (no markup, plain ASCII text), this _should_ work: groff -Tascii normal.txt formatted.txt But _you_ need to try yourself and _maybe_ adjust your input accordingly. Also consider using the fmt program as it has been suggested for document preparation. I do not believe there is one. It seems to me there were some DOS amusement programs that would do this, and you might find one and run it in dosbox. I know that Context Pro can do this. Also WordStar or TP are able to apply margins and align text to justify (solid column). There is very little demand for fully justified monospaced text because it is extremely ugly, hard to read, and error prone. Nonetheless, OpenOffice appears able to do this and so can MS-Word. I suspect many others can without the necessity of writing your own macro. There may be modules in perl and other scripting languages that might be helpful. It's even possible to search the web for a simple LaTeX enclosing and put it into that, but then we leave the domain of ASCII text in the output. -- Polytropon Magdeburg, Germany Happy FreeBSD user since 4.0 Andra moi ennepe, Mousa, ... ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
P5-FuzzyOcr port
Pkg_add -r can't find a package for this; I presume this is deliberate because of the unmaintained status of fuzzyocr? Brian ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Lost /var/db/pkg
On 13/06/2012 02:03, William Orr wrote: I had a hard disk failure some time ago, and I ended up losing /var/db/pkg/ and everything under it (before you say I should've been backing it up, I know, I was actually doing an initial full when this happened). Is there a way I can restore it, or at least manually add entries I know for sure about? Reinstall all the ports on your system? Since you've lost /var/db/pkg, you won't have a handy record of what the necessary packages are. You can get a long way by starting with ports you want directly (eg. firefox) and reinstalling all of their dependencies. It's unlikely to be completely accurate, and the system will probably have odd little issues with normal ports maintenance going on. Perhaps the most effective procedure would be to wipe out the contents of /usr/local and /compat/linux and just start again from scratch. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey signature.asc Description: OpenPGP digital signature
Re: P5-FuzzyOcr port
On Tue, 12 Jun 2012 23:17:08 -0700, Brian W. wrote: Pkg_add -r can't find a package for this; I presume this is deliberate because of the unmaintained status of fuzzyocr? Seems there is no precompiled package (see the package location ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-8-stable/All/ or whatever matches your platform and OS version). But the ports p5-FuzzyOcr and p5-FuzzyOcr-devel are still present (at least in my not up-to-date ports tree) - have you tried installing from a port instead? -- Polytropon Magdeburg, Germany Happy FreeBSD user since 4.0 Andra moi ennepe, Mousa, ... ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Many open branches = excess FreeBSD project work?
We talk about release dates and always slippage and effect on downstream in other thread. But maybe some causes and even just related efficiency thing is: FreeBSD officially maintaining right now [1]: - G HEAD - G RELENG_9 - S RELENG_9_0 - G RELENG_8 - S RELENG_8_3 - S RELENG_8_2 - S RELENG_8_1 - G RELENG_7 - S RELENG_7_4 Woah!?!? Seem a lot of [G]eneral dev and [S]ecurity branches open at once. It seem crazy, and much extra work for whole FreeBSD project. Maybe some ways out there to reduce number of open trees/work? And enhance quality of releases or something in result. Suggest maybe making just two rolling RELENG (features, stable). Features be good for adopters and fine polishing post dev teams. Stable be amazing good production quality all downstream want. Then short live security/bug (only maintain till next from branch) releases from both (these be the formal releases). Focus be on quality level and first row left to right movement (timing) of feature sets. Second row past Xs1 be just closed snaps in time. HEAD - Features -- Stable +- Fs1 x Fs2 x Fs3 +- Ss1 x Ss2 x Ss3 Similar to: Do a horizontal collapse two below rows into formal branches... 2.2.x, 4.x, 8.x = good (stable) other branch.x = intermediate, not maintain worthy (features) Today FreeBSD think it have to maintain nine trains (aka: rly, wtf)? I say with some focus tuning tomorrow it does not :) And just document another project ways (not make any imply from it): https://www.youtube.com/watch?v=i7pkyDUX5uM [1] http://www.freebsd.org/releng/index.html ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Lost /var/db/pkg
El día Wednesday, June 13, 2012 a las 07:16:44AM +0100, Matthew Seaman escribió: On 13/06/2012 02:03, William Orr wrote: I had a hard disk failure some time ago, and I ended up losing /var/db/pkg/ and everything under it (before you say I should've been backing it up, I know, I was actually doing an initial full when this happened). Is there a way I can restore it, or at least manually add entries I know for sure about? Reinstall all the ports on your system? Since you've lost /var/db/pkg, you won't have a handy record of what the necessary packages are. You can get a long way by starting with ports you want directly (eg. firefox) and reinstalling all of their dependencies. It's unlikely to be completely accurate, and the system will probably have odd little issues with normal ports maintenance going on. Perhaps the most effective procedure would be to wipe out the contents of /usr/local and /compat/linux and just start again from scratch. The later is the only way: wipe out /usr/local and /compat/linux because many ports during the intent of 'make install' will check for files there and do nothing for ports they depend on because they 'think' that the port on which they depend on is installed already. Without this you will never ever get a correct /var/db/pkg. matthias -- Matthias Apitz e g...@unixarea.de - w http://www.unixarea.de/ UNIX since V7 on PDP-11, UNIX on mainframe since ESER 1055 (IBM /370) UNIX on x86 since SVR4.2 UnixWare 2.1.2, FreeBSD since 2.2.5 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: P5-FuzzyOcr port
On 13/06/2012 07:17, Brian W. wrote: Pkg_add -r can't find a package for this; I presume this is deliberate because of the unmaintained status of fuzzyocr? Not directly. As many pkgs as possible are built from ports, irrespective of who the maintainers are. An unmaintained port is however less likely to have any issues attended to promptly. If you want to see exactly why no pkg exists, use portsmon: http://portsmon.freebsd.org/portoverview.py?category=mailportname=p5-FuzzyOcr and the reason is that the graphics/giflib port -- one of the dependencies -- failed to work properly. On 9.0-RELEASE it shows the problem is to do with XML validation, and there's an open PR about that which is assigned to the graphics/giflib maintainer. There should be a fix fairly soon. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate JID: matt...@infracaninophile.co.uk Kent, CT11 9PW signature.asc Description: OpenPGP digital signature
Re: Making a bootable backup (hard)disk... how?
On Sunday 10 June 2012 23:14:57 Ronald F. Guilmette wrote: Well, nevermind about that. I get the general idea, i.e. that dumping at level N causes dumping of everything that has changed since the last dump at level N-1. A point to be aware of is that if you restore from a full backup followed by one or more incrementals then you will restore ALL files which were present when each dump was made - including any files which have been intentionally deleted since the dump was created. This isn't normally a problem but there might be some obscure situations where it could be. -- Mike Clarke ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: how to allow by MAC
On Mon, 11 Jun 2012 15:18:18 -0700, Randal L. Schwartz wrote: Bill == Bill Yuan byc...@gmail.com writes: Bill I want to create a white list MAC address, Only the machine which it's MAC Bill in the white list will be allowed, all others will be blocked. Bad idea. Since (a) every MAC address that *is* allowed is transmitted in the clear and (b) it's trivial to spoof a MAC address. This. is. no. security. Indeed, that's right Randal. But I got the impression from Bill's mails that this is more likely just something inside his internal network. Please stop even trying. Well I don't think learning how to use ipfw properly at layer2 is a bad idea in itself, and I wouldn't want to discourage anyone from that. For some years I ran a filtering transparent bridge with ipfw + dummynet for a small network of about 20 mostly W98, XP and Mac boxes sharing one slow ADSL gateway between various assorted community groups (talk about herding cats! :) and MAC filtering was one of the handiest tools when some box or other got owned (again!) by some virus and started spewing spam, provider complains and/or cuts access .. you know the deal. In that sort of environment, none of the punters had any clue about forging MACs or anything vaguely like that, and it stopped people randomly plugging boxes into the network. Horses for courses. I replied in more detail to another from Bill privately, copy follows. cheers, Ian ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: IPMI SoL oddity on 9.0
I've managed to get SoL to work. Turned out the IPMI is utilizing uart2 on my box so modified loader.conf so uart2 is configured to be the serial console port. hint.uart.0.flags=0x0 hint.uart.2.at=isa hint.uart.2.port=0x3E8 hint.uart.2.irq=10 hint.uart.2.flags=0x10 The handbook does not seem to indicate this very clearly but well, now that it's working, I'm a happy man. ihsan On Jun 13, 2012, at 5:53 AM, Ihsan Junaidi Ibrahim wrote: Folks, I'm hitting a roadblock on getting IPMI SoL up and running on my Supermicro box. It's a X9SCL-F with a dedicated IPMI LAN. I've installed ipmitool and set the necessary console redirects (COM1, COM2 and SoL) in the BIOS. The new AMI BIOS does not seem to indicate the SoL is sharing resources with either one of the two COM ports. All 3 redirect speed is 9600. Serial console works, as far as COM ports are concerned. The BIOS, the boot, loader, kernel messages and TTY are all redirected to the COMs. However SoL only works with the BIOS, boot and reading loader defaults. It will get stuck once it enters the spinning kernel boot and it will stay there. I've tried playing with 0x10 uart flags in device.hints alternating between uart0 and uart1 also to no available in hoping that the SoL port is sharing with either one of the two COMs. Regardless SoL simply will not work entering the kernel onwards. Attached are what I believe the configs relevant to my problem. inf02-kul# cat /boot.config -P inf02-kul# cat /boot/loader.conf autoboot_delay=1 console=comconsole boot_serial= boot_multicons= inf02-kul# grep uart /var/run/dmesg.boot uart0: 16550 or compatible port 0x3f8-0x3ff irq 4 flags 0x10 on acpi0 uart0: console (9600,n,8,1) uart1: 16550 or compatible port 0x2f8-0x2ff irq 3 on acpi0 uart2: 16550 or compatible port 0x3e8-0x3ef irq 10 on acpi0 inf02-kul# grep ttyu /etc/ttys ttyu0 /usr/libexec/getty std.9600 vt100 on secure ttyu1 /usr/libexec/getty std.9600 vt100 on secure ttyu2 /usr/libexec/getty std.9600 vt100 on secure ttyu3 /usr/libexec/getty std.9600 dialup off secure inf02-kul# ipmitool sol info Set in progress : set-complete Enabled : true Force Encryption: false Force Authentication: false Privilege Level : USER Character Accumulate Level (ms) : 5 Character Send Threshold: 1 Retry Count : 0 Retry Interval (ms) : 0 Volatile Bit Rate (kbps): 9.6 Non-Volatile Bit Rate (kbps): 9.6 Payload Channel : 1 (0x01) Payload Port: 623 inf02-kul# cat /var/run/dmesg.boot Copyright (c) 1992-2012 The FreeBSD Project. Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994 The Regents of the University of California. All rights reserved. FreeBSD is a registered trademark of The FreeBSD Foundation. FreeBSD 9.0-RELEASE-p3 #0: Tue Jun 12 02:52:29 UTC 2012 r...@amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC amd64 CPU: Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz (3292.59-MHz K8-class CPU) Origin = GenuineIntel Id = 0x306a9 Family = 6 Model = 3a Stepping = 9 Features=0xbfebfbffFPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CLFLUSH,DTS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE Features2=0x77bae3ffSSE3,PCLMULQDQ,DTES64,MON,DS_CPL,VMX,SMX,EST,TM2,SSSE3,CX16,xTPR,PDCM,PCID,SSE4.1,SSE4.2,x2APIC,POPCNT,TSCDLT,AESNI,XSAVE,AVX,F16C,b30 AMD Features=0x28100800SYSCALL,NX,RDTSCP,LM AMD Features2=0x1LAHF TSC: P-state invariant, performance statistics real memory = 8589934592 (8192 MB) avail memory = 8219156480 (7838 MB) Event timer LAPIC quality 600 ACPI APIC Table: SUPERM SMCI--MB FreeBSD/SMP: Multiprocessor System Detected: 8 CPUs FreeBSD/SMP: 1 package(s) x 4 core(s) x 2 SMT threads cpu0 (BSP): APIC ID: 0 cpu1 (AP): APIC ID: 1 cpu2 (AP): APIC ID: 2 cpu3 (AP): APIC ID: 3 cpu4 (AP): APIC ID: 4 cpu5 (AP): APIC ID: 5 cpu6 (AP): APIC ID: 6 cpu7 (AP): APIC ID: 7 ioapic0 Version 2.0 irqs 0-23 on motherboard kbd1 at kbdmux0 acpi0: SUPERM SMCI--MB on motherboard acpi0: Power Button (fixed) acpi0: reservation of 67, 1 (4) failed Timecounter ACPI-fast frequency 3579545 Hz quality 900 acpi_timer0: 24-bit timer at 3.579545MHz port 0x408-0x40b on acpi0 cpu0: ACPI CPU on acpi0 cpu1: ACPI CPU on acpi0 cpu2: ACPI CPU on acpi0 cpu3: ACPI CPU on acpi0 cpu4: ACPI CPU on acpi0 cpu5: ACPI CPU on acpi0 cpu6: ACPI CPU on acpi0 cpu7: ACPI CPU on acpi0 pcib0: ACPI Host-PCI bridge port 0xcf8-0xcff on acpi0 pci0: ACPI PCI bus on pcib0 pcib1: ACPI PCI-PCI bridge irq 16 at device 1.0 on pci0 pci1: ACPI PCI bus on pcib1 pcib2: ACPI PCI-PCI bridge irq 16 at device 1.1 on pci0 pci2: ACPI PCI bus on pcib2 igb0: Intel(R) PRO/1000 Network Connection version - 2.2.5 port 0xe020-0xe03f mem
Re: Lost /var/db/pkg
Matthew Seaman writes: I had a hard disk failure some time ago, and I ended up losing /var/db/pkg/ and everything under it (before you say I should've been backing it up, I know, I was actually doing an initial full when this happened). Is there a way I can restore it, or at least manually add entries I know for sure about? Reinstall all the ports on your system? Since you've lost /var/db/pkg, you won't have a handy record of what the necessary packages are. You can get a long way by starting with ports you want directly (eg. firefox) and reinstalling all of their dependencies. It's unlikely to be completely accurate, and the system will probably have odd little issues with normal ports maintenance going on. Perhaps the most effective procedure would be to wipe out the contents of /usr/local and /compat/linux and just start again from scratch. Only that's going to eradicate anything in /usr/local that a) one wants/uses and b) wasn't put there by ports. (Tell me you don't have a handful of scripts which have been working happily away since you wrote them in the early Devonian. :-) A less drastic path would be to wipe out /usr/local/{lib, libexec}, /compat/linux, and whatever directory has port-installed docs. Check /usr/local/bin, /usr/local/etc (especially rc.d/), and /usr/local/share; many files there are named for their ports. Grep bin/ for anything whose first line is #! /bin/sh, and figure out where it came from. _Now_ start with major prograns you know were installed - on my system that would be emacs, FireFox, Java, LibreOffice, ImageMagick, and mplayer - and get out your copy of very long pretentious novel - because even on a fast system you're talking days to put everything back. Robert learned the hard way Huff ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
hwpstate0 set frequency err 6
Hi FreeBSD - This is the fourth time I have installed FreeBSD while learning the in's and out's. I have a new mainboard this time (ASUS M5A97 EVO + AMD FX 8120.) I have set up dual booting because of a few legacy apps. When the boot of OS gets to the login prompt I begin to get the error message 'hwpstate0 set frequency err 6' During installation my super-workstation started to run as though it were getting the absolutely maximum stress test. The fans on my new Corsair H80 started to whine as well. The 'stress test' effect starts the three next times I have booted so I am not booting into FreeBSD at the moment. Any advice? Thanks Lynn Steven Killingsworth ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: P5-FuzzyOcr port
I was migrating from v7 to v8 when I saw this a few nights ago. The upgrade was going speedily well till I hit that. Like I said I was able to get through it by building the port. On Jun 13, 2012 12:25 AM, Matthew Seaman m.sea...@infracaninophile.co.uk wrote: On 13/06/2012 07:17, Brian W. wrote: Pkg_add -r can't find a package for this; I presume this is deliberate because of the unmaintained status of fuzzyocr? Not directly. As many pkgs as possible are built from ports, irrespective of who the maintainers are. An unmaintained port is however less likely to have any issues attended to promptly. If you want to see exactly why no pkg exists, use portsmon: http://portsmon.freebsd.org/portoverview.py?category=mailportname=p5-FuzzyOcr and the reason is that the graphics/giflib port -- one of the dependencies -- failed to work properly. On 9.0-RELEASE it shows the problem is to do with XML validation, and there's an open PR about that which is assigned to the graphics/giflib maintainer. There should be a fix fairly soon. Cheers, Matthew -- Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate JID: matt...@infracaninophile.co.uk Kent, CT11 9PW ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Many open branches = excess FreeBSD project work?
On Wed, 13 Jun 2012 02:08:12 -0500, grarp...@gmail.com wrote: - S RELENG_8_2 - S RELENG_8_1 - G RELENG_7 - S RELENG_7_4 These are all going away soon. Don't worry. :-) ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
freebsd-update problem
Hi, Hopefully a simple problem with a simple solution. Trying to update a server using freebsd-update, but when I try I get the following: # freebsd-update fetch install Looking up update.FreeBSD.org mirrors... 3 mirrors found. Fetching metadata signature for 8.3-RELEASE from update5.FreeBSD.org... invalid signature. Fetching metadata signature for 8.3-RELEASE from update4.FreeBSD.org... invalid signature. Fetching metadata signature for 8.3-RELEASE from update3.FreeBSD.org... invalid signature. No mirrors remaining, giving up. FreeBSD 8.3-RELEASE FreeBSD 8.3-RELEASE #0: Mon Apr 9 21:23:18 UTC 2012 r...@mason.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC amd64 root mount ZFS I used freebsd-update to upgrade from 8.2 to 8.3 so it's worked in the past, and 4 other servers (running different versions) updated successfully. The key in my conf file is the same as the other servers and I don't have anything in the log files to indicate a problem. Probably missing something stupid but, any suggestions? Thanks in advance! Sean. Sean Page Network Analyst, Internet Services Information Technology Services Edmonton Public Schools Phone: (780) 429-8206 http://its.epsb.ca BLOCKED::http://its.epsb.ca/ Supporting teaching and learning through the effective use of Technology. smime.p7s Description: S/MIME cryptographic signature
FreeBSD 8.3 + MySQL 5.0.95
Hi, I upgrade to FreeBSD 8.3-p3 and installed MySQL 5.0.95 from ports. It runs fine until it dies silently. Does anyone run a heavy loaded MySQL under such setup? how can I troubleshoot this? I could never compile a stable MySQL server from the ports and always relied on MySQL community server binaries but there is no binary for latest 5.0.xx Thank you! Simon ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Possible but extremely unlikely, I always had issues whenever I tried to build MySQL server myself. The hardware where this is running has been very stable. I don't have any issues whatsoever making world, etc... There is no segfault which is what usually happens when you have memory issues. And why would MySQL community server run stable if it was somehow my hardware? Bottom line, if this was hardware issue, the server would have paniced long ago. I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. -Simon On Wed, 13 Jun 2012 11:36:48 -0700, Chuck Swiger wrote: On Jun 13, 2012, at 11:34 AM, Simon wrote: I upgrade to FreeBSD 8.3-p3 and installed MySQL 5.0.95 from ports. It runs fine until it dies silently. Does anyone run a heavy loaded MySQL under such setup? how can I troubleshoot this? I could never compile a stable MySQL server from the ports and always relied on MySQL community server binaries but there is no binary for latest 5.0.xx This sounds like marginal hardware which is failing under load. Make sure you can run something like memtest86 or prime95 overnight without errors Regards, -- -Chuck ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
On Jun 13, 2012, at 11:43 AM, Simon wrote: Possible but extremely unlikely, I always had issues whenever I tried to build MySQL server myself. That by itself is interesting. The hardware where this is running has been very stable. I don't have any issues whatsoever making world, etc... A make world is a decent stress test, but it doesn't take long enough on modern hardware to reliably uncover problems. There is no segfault which is what usually happens when you have memory issues. And why would MySQL community server run stable if it was somehow my hardware? Bottom line, if this was hardware issue, the server would have paniced long ago. I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. By all means-- while I'm quite familiar with busy databases, folks aren't running MySQL for that kind of TPS load. Regards, -- -Chuck ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Many open branches = excess FreeBSD project work?
On Wed, 13 Jun 2012, Mark Felder wrote: On Wed, 13 Jun 2012 02:08:12 -0500, grarp...@gmail.com wrote: - S RELENG_8_2 - S RELENG_8_1 - G RELENG_7 - S RELENG_7_4 These are all going away soon. Don't worry. :-) I hope that does not mean we will not be able to [re]build older versions. No one [me anyway] would expect older branches to be maintained but I do hope they would remain available. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. By all means-- while I'm quite familiar with busy databases, folks aren't running MySQL for that kind of TPS load. Why not? it is designed precisely for this. Like I said, whenever I used MySQL project community server built binaries, I never had it crash. Right now I'm thinking: 1. the port build of 5.0.95 does something incorrectly. 2. it's running out of memory (FreeBSD's kernel still does not report out of memory errors for processes if it kills them; there is no way to know if kernel killed a process due to memory limit, it does not log this) 3. it's hitting some kind of 5.0.95 bug Maybe I'm contacting wrong mailling list, I can't seem to get ahold of ISP/hosting guys on this list. Truly amazing that for a server OS, there is so little input for something like MySQL server. Perhaps everyone else is still using text files, does 10TPS, or runs linux, don't know what to make of it :\ -Simon ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
On Wed, 13 Jun 2012, Simon wrote: I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. By all means-- while I'm quite familiar with busy databases, folks aren't running MySQL for that kind of TPS load. Why not? it is designed precisely for this. Like I said, whenever I used MySQL project community server built binaries, I never had it crash. Right now I'm thinking: 1. the port build of 5.0.95 does something incorrectly. 2. it's running out of memory (FreeBSD's kernel still does not report out of memory errors for processes if it kills them; there is no way to know if kernel killed a process due to memory limit, it does not log this) 3. it's hitting some kind of 5.0.95 bug Maybe I'm contacting wrong mailling list, I can't seem to get ahold of ISP/hosting guys on this list. Truly amazing that for a server OS, there is so little input for something like MySQL server. Perhaps everyone else is still using text files, does 10TPS, or runs linux, don't know what to make of it :\ try my...@lists.mysql.com - when I was an utter newbie they were quite helpful and tolerant. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
On Jun 13, 2012, at 11:34 AM, Simon wrote: I upgrade to FreeBSD 8.3-p3 and installed MySQL 5.0.95 from ports. It runs fine until it dies silently. Does anyone run a heavy loaded MySQL under such setup? how can I troubleshoot this? I could never compile a stable MySQL server from the ports and always relied on MySQL community server binaries but there is no binary for latest 5.0.xx This sounds like marginal hardware which is failing under load. Make sure you can run something like memtest86 or prime95 overnight without errors Regards, -- -Chuck ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Maybe I'm contacting wrong mailling list, I can't seem to get ahold of ISP/hosting guys on this list. Truly amazing that for a server OS, there is so little input for something like MySQL server. Perhaps everyone else is still using text files, does 10TPS, or runs linux, don't know what to make of it :\ -Simon Yes you too are using the wrong list. The questions@ list was created to catch FreeBSD newbies, somewhere to point /etc/motd at. ( It's evolved to also deal with _some_ more complex issues 'cos some on questions@ failed to move on, post more complex non beginner issues to the maybe 50+ or more specialist lists. ) Examples for this topic might include: freebsd-...@freebsd.org freebsd-datab...@freebsd.org freebsd-hack...@freebsd.org freebsd-performa...@freebsd.org See http://lists.freebsd.org/mailman/listinfo Just 2 clicks from http://freebsd.org/ Sad how many people don't look, dump all on questions@, breaking the whole point of having 50+ different themed FreeBSD lists. Those only using questions@ _Please_ realise there are other lists. http://lists.freebsd.org/mailman/listinfo Read the remits of the other lists subscribe /or post those lists that match your topic. Cheers, Julian -- Julian Stacey, BSD Unix Linux C Sys Eng Consultants Munich http://berklix.com Reply below not above, cumulative like a play script, indent with . Format: Plain text. Not HTML, multipart/alternative, base64, quoted-printable. Mail from @yahoo dumped @berklix. http://berklix.org/yahoo/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
On Jun 13, 2012, at 12:24 PM, Simon wrote: I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. By all means-- while I'm quite familiar with busy databases, folks aren't running MySQL for that kind of TPS load. Why not? it is designed precisely for this. That depends on workload. Table-level or page-level locking is fine for read-only or read-mostly; it wasn't until InnoDB storage that MySQL had row-level locking, which is kinda important when you *aren't* read-mostly. Like I said, whenever I used MySQL project community server built binaries, I never had it crash. But the process from these community server built binaries went away, right? Right now I'm thinking: 1. the port build of 5.0.95 does something incorrectly. 2. it's running out of memory (FreeBSD's kernel still does not report out of memory errors for processes if it kills them; there is no way to know if kernel killed a process due to memory limit, it does not log this) 3. it's hitting some kind of 5.0.95 bug The program termination ought to log something, at least if you enable logging or have a monitor in place which can see mysqld's error status; even mysqld_safe ought to take --log-error flag Maybe I'm contacting wrong mailling list, I can't seem to get ahold of ISP/hosting guys on this list. Truly amazing that for a server OS, there is so little input for something like MySQL server. Perhaps everyone else is still using text files, does 10TPS, or runs linux, don't know what to make of it :\ That's likely to be a valid point; freebsd-ports would be appropriate for discussing the build problems with mysql port. freebsd-isp has a different population oriented towards hosting provider issues etc that you've mentioned. However, I can assure you that some folks here on freebsd-questions do deal with more than 10TPS. :-) Regards, -- -Chuck ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Yes you too are using the wrong list. The questions@ list was created to catch FreeBSD newbies, somewhere to point /etc/motd at. ( It's evolved to also deal with _some_ more complex issues 'cos some on questions@ failed to move on, post more complex non beginner issues to the maybe 50+ or more specialist lists. ) Examples for this topic might include: freebsd-...@freebsd.org freebsd-datab...@freebsd.org freebsd-hack...@freebsd.org freebsd-performa...@freebsd.org See http://lists.freebsd.org/mailman/listinfo Just 2 clicks from http://freebsd.org/ Sad how many people don't look, dump all on questions@, breaking the whole point of having 50+ different themed FreeBSD lists. Those only using questions@ _Please_ realise there are other lists. http://lists.freebsd.org/mailman/listinfo Read the remits of the other lists subscribe /or post those lists that match your topic. Cheers, Julian -- Thanks Julian. The reason for freebsd-questions is because when I looked thru isp, database, and performance, and few others, they had one or two threads a month with barely much input. I figured I would reach more people on this list. The reason why I didn't use freebsd-hackers is because I thought perhaps this was somewhat trivial, like I was overlooking something, but I guess not. Next time I'll just use that list instead. I think it would be my best bet. -Simon ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Can you repeat this issue with MariaDB? ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Those only using questions@ _Please_ realise there are other lists. http://lists.freebsd.org/mailman/listinfo Read the remits of the other lists subscribe /or post those lists that match your topic. PS All credit thanks to a few highly skilled informed people on questions@ who regularly contribute good advice helping newcomers. Just that many Was-once-a-beginner should start to think: I've been using FreeBSD a while now, I'm no longer just a newbie to cluelessly use just questions@, I should look at what other FreeBSD lists there are. Cheers, Julian -- Julian Stacey, BSD Unix Linux C Sys Eng Consultants Munich http://berklix.com Reply below not above, cumulative like a play script, indent with . Format: Plain text. Not HTML, multipart/alternative, base64, quoted-printable. Mail from @yahoo dumped @berklix. http://berklix.org/yahoo/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Hi Simon Thanks Julian. The reason for freebsd-questions is because when I looked thru isp, database, and performance, and few others, they had one or two threads a month with barely much input. Yup, isp@ is quiet, some other lists too, doesn't necessarily mean there'snot good people listening, though I suspect total sub. # on isp@ might be low. I figured I would reach more people on this list. Certainly lots, but some specialist lists have good people listening, less troll noise than lately on questions@. The reason why I didn't use freebsd-hackers is because I thought perhaps this was somewhat trivial, like I was overlooking something, but I guess not. Next time I'll just use that list instead. I think it would be my best bet. Welcome to hackers@ the rest :-) PS The one list I periodicaly notice is not quite there, or a handbook entry either I think, is something for all of us who periodically suspect a machine is maybe a bit sick, want to give it a damn good thrashing to test it. Well, complex issue, how long is a piece of string ? but there's performance@ ports@ for ideas tools etc. Good luck. Cheers, Julian -- Julian Stacey, BSD Unix Linux C Sys Eng Consultants Munich http://berklix.com Reply below not above, cumulative like a play script, indent with . Format: Plain text. Not HTML, multipart/alternative, base64, quoted-printable. Mail from @yahoo dumped @berklix. http://berklix.org/yahoo/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Lost /var/db/pkg
William Orr will at worrbase.com writes: Hello, I had a hard disk failure some time ago, and I ended up losing /var/db/pkg/ and everything under it (before you say I should've been backing it up, I know, I was actually doing an initial full when this happened). Is there a way I can restore it, or at least manually add entries I know for sure about? forums.freebsd.org/showthread.php?t=6466 The application themselves are still installed and will keep functioning, you just removed the records of their installation. When you later install newer versions, you may have to use a force flag to overwrite files (the port thinks it is uninstalled after all). The new port installations will get recorded in /var/db/pkg again.' jb ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Hello. 2012/06/13 14:43:29 -0400 Simon si...@optinet.com = To Chuck Swiger : S There is no segfault which is what usually happens when you have memory then there is the daemon's log... -- Peter Vereshagin pe...@vereshagin.org (http://vereshagin.org) pgp: A0E26627 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Lost /var/db/pkg
On 13 June 2012 12:17, jb jb.1234a...@gmail.com wrote: William Orr will at worrbase.com writes: Hello, I had a hard disk failure some time ago, and I ended up losing /var/db/pkg/ and everything under it (before you say I should've been backing it up, I know, I was actually doing an initial full when this happened). Is there a way I can restore it, or at least manually add entries I know for sure about? forums.freebsd.org/showthread.php?t=6466 The application themselves are still installed and will keep functioning, you just removed the records of their installation. When you later install newer versions, you may have to use a force flag to overwrite files (the port thinks it is uninstalled after all). The new port installations will get recorded in /var/db/pkg again.' jb This will work if you need minimal downtime, but *will* come back to bite you some time down the line. -- Eitan Adler ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
`ls -l` shows size of file other than of the folder?
Hello. I have the directory in the file system with 2 regular files each of which is sized as 700M according to 'ls -l'. But the torrent client and 'du -s' and 'ls -l's 'total' show that the directory size is 300M. How can that be? Are there different file sizes stored on a ufs1 in their metadata? ot the least how could I see the 'real' size of each of those files, both ~150M actulally, with a system command? Thank you. -- Peter Vereshagin pe...@vereshagin.org (http://vereshagin.org) pgp: A0E26627 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Chromium 19 core dumps on launch...
George Liaskos geo.lias...@gmail.com writes: On Mon, Jun 11, 2012 at 3:04 AM, Keith Seyffarth w...@weif.net wrote: Friday I installed Chromium again because it would be nice to have a browser to test in other than Firefox and Opera. It was installed using portinstall -R chromium, which *appeared* to function properly. However, trying to run chrome results in: pid 50993 (chrome), uid 1001: exited on signal 11 (core dumped) From what I found online, it looked like I may have been encountering an issue with devel/google-perftools, but on reinstall was able to confirm that this is building with gcc not clang. I have also removed my ~/.config/chromium directory with no change in behavior. Not sure if it's relevant, but the last version of Chromium that was *functional* for me was 12. Versions 13-16 didn't support loading web pages (the browser would launch, but if I entered a URL in the address bar, I could leave the browser running overnight and it still wouldn't have started loading a page). Then when 17 and 18 wouldn't even compile (marked ignore), I just removed package. Please try 19.0.1084.56_1, devel/google-perftools is not a dependency of chromium anymore. Thanks, George. Upgrading from chromium-19.0.1084.52_2 to chromium-19.0.1084.56_1 (and removing google-perftools) will allow Chromium to launch. However, it can't load many pages. For example: http://tools.google.com/chrome/intl/en/welcome.html http://www.alexa.com/ https://support.google.com/chrome/bin/answer.py?hl=enanswer=1270364p=e_deadjim http://www.atlatl.com/ https://support.google.com/chrome/bin/answer.py?hl=enanswer=95669p=e_awsnap chrome://chrome/settings/ and http://www.mariahschallenge.com/ eventually give a the page has become unresponsive error. But pages like: http://www.amazon.com/ http://www.google.com/ http://www.firsttankguide.net/ and http://www.visitphilipsburg.com/ load right away. Also, when you close the browser, either by closing the last tab, closing the window, or selecting Exit from the tools menu, it doesn't release memory or terminate the process, it just gets rid of the window... It looks like the process hangs around until you kill it. I've tried deleting the profile files again as well, with the same response. Any further ideas? Keith ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: `ls -l` shows size of file other than of the folder?
Hi-- On Jun 13, 2012, at 1:23 PM, Peter Vereshagin wrote: I have the directory in the file system with 2 regular files each of which is sized as 700M according to 'ls -l'. But the torrent client and 'du -s' and 'ls -l's 'total' show that the directory size is 300M. How can that be? Are there different file sizes stored on a ufs1 in their metadata? It's very likely that these are sparse files. Your torrent client creates a file of the appropriate size via fseek()/lseek() or similar, but the space isn't actually consumed until it writes the data it is obtaining from the network Random link: http://www.unixguide.net/unix/sparse_file.shtml Regards, -- -Chuck ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Lost /var/db/pkg
On Wed, Jun 13, 2012 at 2:26 PM, Eitan Adler li...@eitanadler.com wrote: On 13 June 2012 12:17, jb jb.1234a...@gmail.com wrote: William Orr will at worrbase.com writes: Hello, I had a hard disk failure some time ago, and I ended up losing /var/db/pkg/ and everything under it (before you say I should've been backing it up, I know, I was actually doing an initial full when this happened). Is there a way I can restore it, or at least manually add entries I know for sure about? forums.freebsd.org/showthread.php?t=6466 The application themselves are still installed and will keep functioning, you just removed the records of their installation. When you later install newer versions, you may have to use a force flag to overwrite files (the port thinks it is uninstalled after all). The new port installations will get recorded in /var/db/pkg again.' jb This will work if you need minimal downtime, but *will* come back to bite you some time down the line. -- Eitan Adler ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org you could cross reference the package .tbz files with what's on your system. ie, tar -ztvf apache-2.2.22_5.tbz shows you what's in /usr/local/bin, etc. Might even be able to focus on man pages only to get an xref index. I believe the files for /var/db/pkg are in the tbz files. if you didn't keep your system up to date it might be trouble matching versions, but you could get the list and see what's what, or at least have a good idea of what _was_ installed. I haven't tried but you could stick the 'current' files for /var/db/pkg from tbz, matching what's installed - regardless of the 'new' version and actual version installed, then to a pkg_delete --force then pkg_add .tbz . it might complain about missing files but will 'prolly function. If you have like 700-1000+ packages it might be worth the trouble. A thought :) Waitman Gobble San Jose California USA ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Lost /var/db/pkg
On 06/13/2012 16:10, Waitman Gobble wrote: On Wed, Jun 13, 2012 at 2:26 PM, Eitan Adler li...@eitanadler.com wrote: On 13 June 2012 12:17, jb jb.1234a...@gmail.com wrote: William Orr will at worrbase.com writes: Hello, I had a hard disk failure some time ago, and I ended up losing /var/db/pkg/ and everything under it (before you say I should've been backing it up, I know, I was actually doing an initial full when this happened). Is there a way I can restore it, or at least manually add entries I know for sure about? forums.freebsd.org/showthread.php?t=6466 The application themselves are still installed and will keep functioning, you just removed the records of their installation. When you later install newer versions, you may have to use a force flag to overwrite files (the port thinks it is uninstalled after all). The new port installations will get recorded in /var/db/pkg again.' jb This will work if you need minimal downtime, but *will* come back to bite you some time down the line. -- Eitan Adler ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org you could cross reference the package .tbz files with what's on your system. ie, tar -ztvf apache-2.2.22_5.tbz shows you what's in /usr/local/bin, etc. Might even be able to focus on man pages only to get an xref index. I believe the files for /var/db/pkg are in the tbz files. if you didn't keep your system up to date it might be trouble matching versions, but you could get the list and see what's what, or at least have a good idea of what _was_ installed. I haven't tried but you could stick the 'current' files for /var/db/pkg from tbz, matching what's installed - regardless of the 'new' version and actual version installed, then to a pkg_delete --force then pkg_add .tbz . it might complain about missing files but will 'prolly function. If you have like 700-1000+ packages it might be worth the trouble. A thought :) Waitman Gobble San Jose California USA ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org locate /var/db/pkg Might show you what was there recently... ls /usr/ports/distfiles might also go a long way toward showing you what you once had installed. apologies if these were previously mentioned. -- Dave Robison Sales Solution Architect II FIS Banking Solutions 510/621-2089 (w) 530/518-5194 (c) 510/621-2020 (f) da...@vicor.com david.robi...@fisglobal.com _ The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: `ls -l` shows size of file other than of the folder?
On 13 June 2012 16:23, Peter Vereshagin pe...@vereshagin.org wrote: Hello. I have the directory in the file system with 2 regular files each of which is sized as 700M according to 'ls -l'. But the torrent client and 'du -s' and 'ls -l's 'total' show that the directory size is 300M. How can that be? Are there different file sizes stored on a ufs1 in their metadata? ot the least how could I see the 'real' size of each of those files, both ~150M actulally, with a system command? The -s flag to ls(1) will show you the actual number of blocks in use (I believe it honours BLOCKSIZE, though you might want to check). -- -- ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Newbie question: Why aren't my cron jobs running?
On Tue, 12 Jun 2012 12:21:31 -0500, Dan Lists wrote: The syntax of his crontab file is correct. Vixie cron does care about leading spaces, tabs, extra spaces, or leading zeros. Earlier versions of cron are much pickier about the crontab file. The cron logs show that it is starting his jobs at the correct times. It is far more likely that there is a problem with the scripts. A very common cause of problems with scripts run from cron is that they do not inherit your environment. Do the scripts run from the command line? If the do, then the problem is most likely something in your environment that the scripts need. I'm a complete idiot, and I feel embarrassed. Everything was fine, except that I had missed out '/bin' in the paths of the jobs. I had: /home/walterh/exports.sh /home/walterh/backup_etc.sh /home/walterh/systemcheck.sh /home/walterh/backup_bsd.sh which should of course have been: /home/walterh/bin/exports.sh /home/walterh/bin/backup_etc.sh /home/walterh/bin/systemcheck.sh /home/walterh/bin/backup_bsd.sh What a stupid mistake! Thanks for all the replies, but I must say sorry for wasting your time. Sorry! WH ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: FreeBSD 8.3 + MySQL 5.0.95
Simon wrote: Hint: Please learn to not top post. It makes it more difficult to arrange answers coherently. Possible but extremely unlikely, I always had issues whenever I tried to build MySQL server myself. The hardware where this is running has been very stable. I don't have any issues whatsoever making world, etc... There is no segfault which is what usually happens when you have memory issues. And why would MySQL community server run stable if it was somehow my hardware? Bottom line, if this was hardware issue, the server would have paniced long ago. I wish I could get some input from someone running MySQL server with 300+ queries a second and what MySQL version/build they are running. -Simon On Wed, 13 Jun 2012 11:36:48 -0700, Chuck Swiger wrote: On Jun 13, 2012, at 11:34 AM, Simon wrote: I upgrade to FreeBSD 8.3-p3 and installed MySQL 5.0.95 from ports. It runs fine until it dies silently. Does anyone run a heavy loaded MySQL under such setup? how can I troubleshoot this? I could never compile a stable MySQL server from the ports and always relied on MySQL community server binaries but there is no binary for latest 5.0.xx This sounds like marginal hardware which is failing under load. Make sure you can run something like memtest86 or prime95 overnight without errors I don't know about 300+ queries per second, but I have been running MySQL since version 3.x.x, and so on, without much difficulty. It has been very stable for me for many years. Hardware related problems can be a cause of general flakiness one person can see while many, many others do not experience. Can be things such as old, weak, under rated power supply that has poor regulation and excessive ripple under load. This can actually resemble RAM problems at times, because with things like memtest there will be failures. It can be other things as well, such as a disk controller running a driver that has a bug. Rather than ramble through myriad possibilities, a general rule I've noticed over many years of dealing with computers: Hardware is often involved when the problem is very random, while when you can reproduce a specific error condition repeatedly by executing a set of commands or instructions in particular and specific order it is software related. I also question why you would want to run such an old version. Particularly I am aware that versions 5.0.50 and 5.0.51 contain several serious bugs. I run the latest version of the 5.1.xx branch, with an eye to moving towards 5.5.xx very soon. I have always compiled from the ports system. I have also tuned my.cnf according to the examples and the documentation recommendations. One of the first things you should look at is what about the compilation process on your machine is producing your flaky, crashy binaries. Using a GCC from ports?, CLANG?, remove any so-called 'optimizations' from your make.conf, etc. In the make config for building MySQL do _not_ select the 'build optimized binaries' choice (which sets -O3 optimization) and see if that makes a difference. I have used the -O3 in my builds for many years and never had a problem. Circle outwards in looking at OS tuning. An example would be vmstat -i, looking for a piece of hardware with a run away interrupt storm. Other things like IPC, SYSVSHM, Semaphores, and other such structure pools looking for resource starvation. If hardware proves not to be central to the problem, see if you can arrange a way to _not_ load it so heavily. If it runs at a lower load without crashing it might indicate you need some tuning. I would look at the hardware very hard. I would look at how you are building the compilation. I would also _not_ use this version, but rather at least 5.1.x and preferably (especially if this is a new start up) look at trying the latest in the 5.5.xx series. The 5.5.xx is supposed to offer better performance, and maybe with your 300+ per second query rate maybe you should focus on the version with the best performance. Bottom line: Many thousands of people and companies have run MySQL for many years and had it work just fine. Your particular situation is an aberration of some form. -Mike ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Lost /var/db/pkg
On Wed, 13 Jun 2012 19:17:20 + (UTC) jb wrote: William Orr will at worrbase.com writes: Hello, I had a hard disk failure some time ago, and I ended up losing /var/db/pkg/ and everything under it (before you say I should've been backing it up, I know, I was actually doing an initial full when this happened). Is there a way I can restore it, or at least manually add entries I know for sure about? forums.freebsd.org/showthread.php?t=6466 The application themselves are still installed and will keep functioning, you just removed the records of their installation. When you later install newer versions, you may have to use a force flag to overwrite files (the port thinks it is uninstalled after all). The new port installations will get recorded in /var/db/pkg again.' I wouldn't do that, it's not as simple as that post suggests. It's likely to lead to a lot of files being orphaned, which may lead to build or runtime errors in the future, or vulnerabilities that portaudit can't detect. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Lost /var/db/pkg
On 12 June 2012 18:03, William Orr w...@worrbase.com wrote: Hello, I had a hard disk failure some time ago, and I ended up losing /var/db/pkg/ and everything under it (before you say I should've been backing it up, I know, I was actually doing an initial full when this happened). Is there a way I can restore it, or at least manually add entries I know for sure about? look in /var/db/pkgdb.bak.tbz -- Eitan Adler ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Lost /var/db/pkg
On Wed, 13 Jun 2012, Eitan Adler wrote: On 12 June 2012 18:03, William Orr w...@worrbase.com wrote: Hello, I had a hard disk failure some time ago, and I ended up losing /var/db/pkg/ and everything under it (before you say I should've been backing it up, I know, I was actually doing an initial full when this happened). Is there a way I can restore it, or at least manually add entries I know for sure about? look in /var/db/pkgdb.bak.tbz ^^^ ITYM /var/backups/pkgdb.bak.tbz. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Newbie question: Why aren't my cron jobs running?
On 6/13/2012 6:23 PM, Walter Hurry wrote: On Tue, 12 Jun 2012 12:21:31 -0500, Dan Lists wrote: The syntax of his crontab file is correct. Vixie cron does care about leading spaces, tabs, extra spaces, or leading zeros. Earlier versions of cron are much pickier about the crontab file. The cron logs show that it is starting his jobs at the correct times. It is far more likely that there is a problem with the scripts. A very common cause of problems with scripts run from cron is that they do not inherit your environment. Do the scripts run from the command line? If the do, then the problem is most likely something in your environment that the scripts need. I'm a complete idiot, and I feel embarrassed. Everything was fine, except that I had missed out '/bin' in the paths of the jobs. I had: /home/walterh/exports.sh /home/walterh/backup_etc.sh /home/walterh/systemcheck.sh /home/walterh/backup_bsd.sh which should of course have been: /home/walterh/bin/exports.sh /home/walterh/bin/backup_etc.sh /home/walterh/bin/systemcheck.sh /home/walterh/bin/backup_bsd.sh What a stupid mistake! Thanks for all the replies, but I must say sorry for wasting your time. Sorry! WH ... Damned those full path names. -- Keep well, Chris ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org