Re: Recovering mysql data - mysqlbinlog

2008-05-02 Thread Matthew Seaman

Mel wrote:

On Thursday 01 May 2008 22:24:33 Paul Schmehl wrote:

--On Thursday, May 01, 2008 21:52:05 +0200 Mel

[EMAIL PROTECTED] wrote:

On Thursday 01 May 2008 21:13:41 John wrote:

Thank you Mel and Paul for the suggestions.  From what I understand the
general query log is more for debugging and the binary log is for point
in time recovery and replication.  I'll be adding a my.cnf file (using
the my-large.cnf as a skeleton) soon.  I'm glad the issue was caught
earlier on and now I'm the wiser thanks to you guys.  I wonder why the
default is no. I can't think of anyone who wouldn't find the binary
logging beneficial.

I can think of a reason for FreeBSD. The binary logs are never deleted
and upon every server restart a new one is created. If you're like me,
developing on a laptop with a webenvironment including 'Mysql server',
shutting down your laptop daily, you quickly find yourself having full
/var partition.

That can be alleviated by adding the logs to newsyslog.conf and gzipping
and rotating them regularly.
If you don't restart mysql much, something like this would work:

/var/db/mysql/[hostname]-bin.*mysql:mysql  660  7 *  $W6D0 JBG
/var/db/mysql/[FQHN].pid

If you're restarting it daily, something like this should work:

/var/db/mysql/[hostname]-bin.*mysql:mysql 660 25 * $D0  JBG
/var/db/mysql/[FQHN].pid

Adjust the counts and the rotation schedule to your liking and, of course,
use your own hostname and fully qualified hostname.


Ummm... actually this is not a particularly good idea.  MySQL keeps an internal
list of all the binlogs it has available, and doing this will break that.  The
best method is to cron a script that will run eg.

   PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 7 DAY);

for whatever interval suits you.  binlogs can absorb a lot of space for very
little return, especially on a busy server.  There's really no point in keeping
binlogs from before the earliest full database dump in your backup cycle,
and even keeping that many is probably a little OTT for most purposes.

You are regularly dumping the database aren't you?

Yes, in this particular case it can, not changing hostnames is a plus then (as 
in, getting hostname from your dhcp server) ;)
Actually, I think you can use a fixed name, but it's been a while since I 
looked at the bin-log related variables.


However if you're using the bin-log, to recover accidental deletes or 
replications, then you need to use the mysql provided SQL commands for it. 
It's scriptable (periodic/crontab), but not for use in newsyslog.




MySQL recommends that you use a fixed name for binary logs nowadays.
mysql-bin.NNN typically.  The reasoning seems to be that it makes it
easier to deal with replication -- although relay logs are all still labeled
by the hostname of the master server.

Cheers,

Matthew

--
Dr Matthew J Seaman MA, D.Phil.   7 Priory Courtyard
 Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
 Kent, CT11 9PW



signature.asc
Description: OpenPGP digital signature


Re: handling stale dependencies

2008-05-02 Thread Aryeh M. Friedman

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Zbigniew Szalbot wrote:
| Hello,
|
| I will appreciate your advice about how to best handle stale 
dependencies. Today I wanted to upgrade phpMyAdmin and I got a number of 
questions about stale dependencies. I eventually deleted all of them, 
but does this mean I need to upgrade ports which used this dependency 
(mailgraph-1.14_1, netpbm-10.26.52, p5-FuzzyOcr-devel-3.4.2_1, 
php5-gd-5.2.5_1, and rrdtool-1.2.26)?


I am not sure what your asking... if your asking do you need png for 
phpMyAdmin the short answer is no... the long answer is yes because if 
you want to maintain the ports it depends on then they need png.


Portupgrade uses an external DB (not the same one as pkg_* uses) and 
this is the one that pkgdb maintains.   Which means that until you run 
pkgdb portupgrade will use the old depends... now if you not using 
portupgrade this is not an issue but since you are you need to make sure 
the two are in sync.



That being said once you answered yes/all to Delete this? then any 
mention of the depend in pkgdb will be removed and if you had already 
done a make deinstall or pkg_delete then your fine all the way around 
(and by definition you already have because you will not get that 
question unless the port/package doesn't exist in the /var/db/pkg hierachy)

|
| Stale dependency: mailgraph-1.14_1 - png-1.2.27 (graphics/png):
| Delete this? ([y]es/[n]o/[a]ll) [yes]
| Deleted.
| Stale dependency: netpbm-10.26.52 - png-1.2.27 (graphics/png):
| Delete this? ([y]es/[n]o/[a]ll) [yes]
| Deleted.
| Stale dependency: p5-FuzzyOcr-devel-3.4.2_1 - png-1.2.27 (graphics/png):
| Delete this? ([y]es/[n]o/[a]ll) [yes]
| Deleted.
| Stale dependency: pear-Image_Color-1.0.2_1 - png-1.2.27 (graphics/png):
| Delete this? ([y]es/[n]o/[a]ll) [yes]
| Deleted.
| Stale dependency: pecl-pdflib-2.1.5 - png-1.2.27 (graphics/png):
| Delete this? ([y]es/[n]o/[a]ll) [yes]
| Deleted.
| Stale dependency: php5-gd-5.2.5_1 - png-1.2.27 (graphics/png):
| Delete this? ([y]es/[n]o/[a]ll) [yes]
| Deleted.
| Stale dependency: phpMyAdmin-2.11.5 - png-1.2.27 (graphics/png):
| Delete this? ([y]es/[n]o/[a]ll) [yes]
| Deleted.
| Stale dependency: rrdtool-1.2.26 - png-1.2.27 (graphics/png):
| Delete this? ([y]es/[n]o/[a]ll) [yes]
| Deleted.
|
| I am not even sure png is installed.
| $ pkg_info -Ix png
| pkg_info: no packages match pattern(s)
|
| $ cat /usr/ports/graphics/png/distinfo
| MD5 (libpng-1.2.28.tar.bz2) = c981a7014fc695e354d2f2cac3a6742e
| SHA256 (libpng-1.2.28.tar.bz2) = 
041c11048ea812f56d7042fbdfc3d7025c97a81f07ab20ebd0f50aecb47baccc

| SIZE (libpng-1.2.28.tar.bz2) = 788156
|
| Many thanks in advance!
|

-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.9 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkgasOUACgkQk8GFzCrQm4B5nQCdGTC1J9VxQ6q2+bOZFvuOxVvk
cFkAn0VNZMqA0Z2RLGoyMMlpfPkHMhAb
=bEax
-END PGP SIGNATURE-

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: 7.0-RELEASE + newer kernel

2008-05-02 Thread Anselm Strauss

On May 1, 2008, at 13:34 , Mel wrote:


On Thursday 01 May 2008 13:17:03 Anselm Strauss wrote:



The reasons why I hesitate to upgrade to 7.0-STABLE are:

- freebsd-update won't work anymore. How do I then get informed about
security updates?


Using your favorite RSS reader and subscribe to:
http://www.freebsd.org/security/advisories.rdf


Ok, I already subscribed to the freebsd-security-notifications list, I  
assume that should do the same.



- Can't install distributions with sysinstall anymore. Do I just
compile everything from source?


Yes (to distributions, no to ports), but you have to upgrade by source
to -STABLE to begin with, unless you want to go the hard way and  
bake a new

CD/DVD.


Since compiling is no problem for me, I think I will stick with the  
source, since you also can install parts of the source, e.g. install  
the manual pages afterwards.



- How do I actually update from release to stable? I have to compile
everything myself from the sources, right? As well as for any update?


The handbook has an entire section for this:
http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/cutting-edge.html


Yes, I saw that once, but forgot it again. Worked perfectly for me.


--
Mel

Problem with today's modular software: they start with the modules
   and never get to the software part.


Thanks,
Anselm

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


KDE3 Error

2008-05-02 Thread Ruel Luchavez
Hi,
Why is it when i install KDE3 in my server I always got an error, this is
the command when i install it

-cd /usr/ports/x11/kde3
-make install

*and this is the reply of the server:*
-Attempting to fetch from
ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/KDE/.
-fetch://
ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/KDE/qt-x11-free-3.3.6.tar.bz2:Fileunavailable
(e.g., file not found, no access)
-Couldn't fetch ot-please try to retreive this
-port manually into /usr/ports/distfiles/KDE and try again.
***Error code 1

Stop in usr/ports/x11-toolkits/qt33/
*** Error code 1

Stop in /usr/ports/x11-toolkits/qt33
Stop in usr/ports/x11-toolkits/qt33/
*** Error code 1

Did i miss something??? Please HELP here...

Thanks in advance...:(
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


measure traffic caused by pppd (UMTS)

2008-05-02 Thread Matthias Apitz

Hello,

Sometimes when I travel around and can't see any usable WLAN I'm using
the UMTS and PPPD, which works well but of course one must pay for this;

Is there some tool which I could put into /etc/ppp/ip_down script which
logs the traffic done into some file; I see /usr/ports/net/ppptraf which
comes without any documentation and is curses based :-(
any other ideas?

I'm not interested in any analysis about to which location the traffic
goes or about speed and bandwidth; just

- cmd line based with output to a file or stdout
- the amount of bytes/megabytes in and out;

thx in advance

matthias
-- 
Matthias Apitz
Manager Technical Support - OCLC GmbH
Gruenwalder Weg 28g - 82041 Oberhaching - Germany
t +49-89-61308 351 - f +49-89-61308 399 - m +49-170-4527211
e [EMAIL PROTECTED] - w http://www.oclc.org/ http://www.UnixArea.de/
b http://gurucubano.blogspot.com/
Don't top-post, read RFC1855 http://www.faqs.org/rfcs/rfc1855.html
A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on Usenet and in e-mail?
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


FreeBSD Server Settings Consult

2008-05-02 Thread Free BSD
We've been having some problems with our server and I was wondering if
someone had any advice or suggestions for our current system settings.

# cat /etc/sysctl.conf

kern.ipc.maxsockbuf=1048576
net.inet.tcp.sendspace=65536
net.inet.tcp.recvspace=65536
net.local.stream.recvspace=65536
net.local.stream.sendspace=65536
net.inet.udp.recvspace=65536
net.inet.udp.maxdgram=65535
kern.ipc.somaxconn=8192
kern.maxvnodes=132072
kern.maxfiles=65535
kern.maxfilesperproc=65536
net.inet.tcp.msl=7500
net.inet.tcp.mssdflt=1460
security.bsd.see_other_uids=0
security.bsd.see_other_gids=0
kern.fallback_elf_brand=3
net.inet.tcp.newreno=1
net.inet.tcp.rfc1323=1
net.inet.tcp.delayed_ack=0
net.inet.ip.check_interface=0
vfs.vmiodirenable=1
net.inet.ip.portrange.randomized=1
net.inet.icmp.bmcastecho=0
net.inet.icmp.maskrepl=0
net.inet.icmp.icmplim=500
kern.randompid=89061
net.inet.icmp.drop_redirect=1
net.inet.icmp.log_redirect=0
net.inet.ip.random_id=89061
net.inet.ip.rtexpire=2
net.inet.ip.rtmaxcache=256
net.inet.ip.rtminexpire=2
net.inet.tcp.blackhole=2
net.inet.tcp.icmp_may_rst=0
net.inet.tcp.inflight.enable=0
net.inet.tcp.log_in_vain=0
net.inet.tcp.sack.enable=1
net.inet.udp.blackhole=1
net.inet.udp.log_in_vain=0
net.link.ether.inet.log_arp_wrong_iface=0
net.link.ether.inet.max_age=1200


# cat /boot/loader.conf

kern.ipc.maxsockets=32768
kern.ipc.nmbclusters=32768
kern.ipc.nmbufs=131072
kern.ipc.shm_use_phys=1
kern.maxproc=8192
net.inet.tcp.tcbhashsize=16384
kern.maxfiles=65535
kern.maxfilesperproc=65536

# cat /etc/rc.conf (minus networking)

clear_tmp_enable=YES
update_motd=NO
tcp_extensions=YES
firewall_enable=YES
firewall_script=/etc/ipfw.rules
linux_enable=YES
sshd_enable=NO
usbd_enable=NO

fsck_y_enable=YES
oidentd_enable=YES
pureftpd_enable=no

syslogd_enable=YES
syslogd_flags=-ss

ntpd_enable=YES
ntpd_flags=-4 -p/var/run/ntpd.pid
tcp_keepalive=YES
icmp_bmcastecho=NO
icmp_bandlim==YES

portmap_enable=NO
icmp_drop_redirect=YES
quota_enable=YES
check_quotas=YES
#accounting_enable=YES
named_program=/usr/sbin/named
named_flags=-u bind -c /etc/namedb/named.conf
named_enable=YES
local_startup=/usr/local/etc/rc.d
openssh_enable=YES
openssh_flags=-4 -f/etc/ssh/sshd_config
openssh_pidfile=/var/run/sshd.pid
sendmail_enable=NO
network_interfaces=rl0 lo0
webmin_enable=YES
dumpdev=AUTO
dumpdir=/var/crash
courier_imap_imapd_enable=YES
courier_imap_imapd_ssl_enable=YES
courier_imap_pop3d_enable=YES
courier_imap_pop3d_ssl_enable=YES
courier_authdaemond_enable=YES
tor_enable=NO
chkservd_enable=YES
apop3d_enable=NO
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


handling mysql binlog data

2008-05-02 Thread Zbigniew Szalbot

Hello,

Following a recent thread I would like to ask if it is safe to remove 
old binlog data. From the below I understand that the current binlog is 
mysql-bin.07 and the previous ones (from 01-06) are not 
written to any more. I just need confirmation before I take any action. 
By asking whether it is safe, I only mean if deleting them will not 
affect mysql operation. I do backups of mysql data anyway.


-rw-rw  1 mysql  mysql61956466 Apr 16 08:44 mysql-bin.01
-rw-rw  1 mysql  mysql   697756219 Apr 17 14:26 mysql-bin.02
-rw-rw  1 mysql  mysql1056 Apr 17 14:29 mysql-bin.03
-rw-rw  1 mysql  mysql  1073745860 Apr 24 05:49 mysql-bin.04
-rw-rw  1 mysql  mysql   620489997 Apr 27 10:48 mysql-bin.05
-rw-rw  1 mysql  mysql   229357379 Apr 28 15:55 mysql-bin.06
-rw-rw  1 mysql  mysql   869964294 May  2 14:15 mysql-bin.07

Do I understand correctly that removing mysql-bin.07 would result in 
mysql not writing any data to mysql-bin file until the server gets 
restarted?


Many thanks for sharing!
--
Zbigniew Szalbot
www.lc-words.com


smime.p7s
Description: S/MIME Cryptographic Signature


Re: ACPI can only be compiled into the kernel on the amd64 and ia64 platforms

2008-05-02 Thread Mario Lobo
On Thursday 01 May 2008 20:41:49 alexus wrote:
 sorry, this is amd64

 On Thu, May 1, 2008 at 6:14 PM, Mario Lobo [EMAIL PROTECTED] wrote:
  On Thursday 01 May 2008 18:43:17 alexus wrote:
   why are you compiling under i386 when your system is
   detected as amd64 or ia64 ?
 
  You didn't answer this one.
 
  uname -a can help.
  --
  Mario Lobo
  http://www.mallavoodoo.com.br
  FreeBSD since version 2.2.8 [not Pro-Audio YET!!] (99,7% winedows
  FREE) ___
  freebsd-questions@freebsd.org mailing list
  http://lists.freebsd.org/mailman/listinfo/freebsd-questions
  To unsubscribe, send any mail to
  [EMAIL PROTECTED]

Then you should:

cd /usr/src/sys/amd64/conf
copy/edit GENERIC dd 
/usr/sbin/config dd
cd ../compile/dd
make cleandepend;make depend;make;make 
make install

this should work
-- 
Mario Lobo
http://www.mallavoodoo.com.br
FreeBSD since version 2.2.8 [not Pro-Audio YET!!] (99,7% winedows FREE)
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Compiling in Debugging Flags

2008-05-02 Thread Chris Maness
How do I compile in debugging into apache using ports?  There is no 
configmenu when one begins to install/compile the port.  I'm still having 
trouble with apache crashing on a recently upgraded server.  (after I have 
rebuilt all of the ports).  I was having the same problem with apache on a 
sandbox server after upgrade to 7.0-RELEASE.  I wasn't ever able to figure 
it out.  I have just upgraded apache on a production server, and I am not 
able to cut over until apache working.  I get no errors in log files no 
errors on std out, and no core dump either.  If I attache to GDB, I get no 
messages either.  Wierd.


Thanks,

Chris Maness
(909) 223-9179
http://www.chrismaness.com
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Compiling in Debugging Flags

2008-05-02 Thread Bill Moran
In response to Chris Maness [EMAIL PROTECTED]:

 How do I compile in debugging into apache using ports?  There is no 
 configmenu when one begins to install/compile the port.  I'm still having 
 trouble with apache crashing on a recently upgraded server.  (after I have 
 rebuilt all of the ports).  I was having the same problem with apache on a 
 sandbox server after upgrade to 7.0-RELEASE.  I wasn't ever able to figure 
 it out.  I have just upgraded apache on a production server, and I am not 
 able to cut over until apache working.  I get no errors in log files no 
 errors on std out, and no core dump either.  If I attache to GDB, I get no 
 messages either.  Wierd.

First, put WITH_DEBUG=absolutely in /etc/make.conf.  This will cause all
ports that are built to have debug symbols.  I believe you need to save
the /usr/ports/*/[portname]/work directory after installing, so don't do
a make clean until you've archived that somewhere.

Then, ensure the sysctls in the kernel are all frobbed to allow coredumps.
Specifically:
kern.coredump: 1
kern.sugid_coredump: 1

Then, make sure the www user has write access to wherever it's trying to
dump to.  Personally, I prefer to tweak kern.corefile to be
/usr/local/corefiles/%N.%P.core.  I can then ensure that directory exists
and that all users have write access to it (probably not the best idea
on a production server, however)

From there, you should be getting usable coredumps.

-- 
Bill Moran
http://www.potentialtech.com
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: handling mysql binlog data

2008-05-02 Thread Matthew Seaman
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160

Zbigniew Szalbot wrote:
 Hello,
 
 Following a recent thread I would like to ask if it is safe to remove
 old binlog data. From the below I understand that the current binlog is
 mysql-bin.07 and the previous ones (from 01-06) are not
 written to any more. I just need confirmation before I take any action.
 By asking whether it is safe, I only mean if deleting them will not
 affect mysql operation. I do backups of mysql data anyway.

The reason for keeping binlog files is so that you can replay any SQL
queries that modify the database contents.  You may want this for auditing
or for performance analysis, but the most usual reason is as a way 
of recoverng the database contents right up to the very latest point
possible.

In that case, if you're making regular database dumps, you only need the
binlog data written after the database dump.  (Depending on how paranoid
you are, you might have several database dumps, and keep binlogs between
the oldest dump you have and the present, but that's probably more than
is strictly necessary)

 -rw-rw  1 mysql  mysql61956466 Apr 16 08:44 mysql-bin.01
 -rw-rw  1 mysql  mysql   697756219 Apr 17 14:26 mysql-bin.02
 -rw-rw  1 mysql  mysql1056 Apr 17 14:29 mysql-bin.03
 -rw-rw  1 mysql  mysql  1073745860 Apr 24 05:49 mysql-bin.04
 -rw-rw  1 mysql  mysql   620489997 Apr 27 10:48 mysql-bin.05
 -rw-rw  1 mysql  mysql   229357379 Apr 28 15:55 mysql-bin.06
 -rw-rw  1 mysql  mysql   869964294 May  2 14:15 mysql-bin.07
 
 Do I understand correctly that removing mysql-bin.07 would result in
 mysql not writing any data to mysql-bin file until the server gets
 restarted?

MySQL maintains an open file descriptor on the current binlog file -- if
you delete that file while MySQL is running, you'll clear the directory
entry for the file, but the file data will still exist and be writable
for MySQL.  Of course, as soon as MySQL closes the descriptor, the last
link to the data will be lost, and the OS will feel free to recycle that
chunk of disk space.

Cheers,

Matthew

- -- 
Dr Matthew J Seaman MA, D.Phil.   Flat 3
  7 Priory Courtyard
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
  Kent, CT11 9PW, UK
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.9 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEAREDAAYFAkgbLBwACgkQ3jDkPpsZ+VZJRACgqRwhCfQcV/HV7XUe89w1UGDs
3lMAoIHm4elc4s/ACuhWQRt8hKnvvI+i
=10Os
-END PGP SIGNATURE-
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: handling mysql binlog data

2008-05-02 Thread Chris Pratt


On May 2, 2008, at 5:27 AM, Zbigniew Szalbot wrote:


Hello,

Following a recent thread I would like to ask if it is safe to  
remove old binlog data. From the below I understand that the  
current binlog is mysql-bin.07 and the previous ones (from  
01-06) are not written to any more. I just need  
confirmation before I take any action. By asking whether it is  
safe, I only mean if deleting them will not affect mysql operation.  
I do backups of mysql data anyway.


-rw-rw  1 mysql  mysql61956466 Apr 16 08:44 mysql-bin.01
-rw-rw  1 mysql  mysql   697756219 Apr 17 14:26 mysql-bin.02
-rw-rw  1 mysql  mysql1056 Apr 17 14:29 mysql-bin.03
-rw-rw  1 mysql  mysql  1073745860 Apr 24 05:49 mysql-bin.04
-rw-rw  1 mysql  mysql   620489997 Apr 27 10:48 mysql-bin.05
-rw-rw  1 mysql  mysql   229357379 Apr 28 15:55 mysql-bin.06
-rw-rw  1 mysql  mysql   869964294 May  2 14:15 mysql-bin.07

Do I understand correctly that removing mysql-bin.07 would  
result in mysql not writing any data to mysql-bin file until the  
server gets restarted?




I recently removed all logs prior to the one shown as current
without any problems. I would not think you would want to
remove the one currently in use or problems would result.

The procedure for this is here:
http://dev.mysql.com/doc/refman/5.1/en/purge-master-logs.html
for 5.1 and here:
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
for 5.0

Simply doing an rm on the files you know are no longer in use
is probably not a good idea because they are known within mysql
data files. Using the above will make sure they are removed in
an orderly manner. According to the docs, if you use the process
as shown, the active file will be skipped even if you accidently
try to remove it.



Many thanks for sharing!
--
Zbigniew Szalbot
www.lc-words.com


___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: mailcap documentation?

2008-05-02 Thread Frank Shute
On Thu, May 01, 2008 at 05:44:04PM -0400, Dan Mahoney, System Admin wrote:

 Hello all,
 
 There's apparently an RFC-standard file called /etc/mailcap (as well as 
 .mailcap), but I can't find any docs on this file.
 
 Would it be worthwhile to rework the RFC into a manpage (I am willing to 
 do it), or should I bother the providers of ports that use it (such as, 
 say, alpine (and possibly others)?  The problem is, they likely don't 
 bundle it because other OSes have it already.
 
 It's a fairly standard file, but FreeBSD doesn't ship with an MUA that 
 uses it (I *think*).  I know mail(1) does not.
 

I'd like a manpage for mailcap. Even though it doesn't exist in
FreeBSD quite a lot of ports use it as you say e.g mutt which comes
with a very short example mailcap.

I think there should be an example mailcap in base too. I can't see
what harm it would do.

You're probably best raising this on docs though.

Regards,

-- 

 Frank 


 Contact info: http://www.shute.org.uk/misc/contact.html 

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Compiling in Debugging Flags

2008-05-02 Thread Chris Maness

Then, ensure the sysctls in the kernel are all frobbed to allow coredumps.
Specifically:
kern.coredump: 1
kern.sugid_coredump: 1



What is frobbed?

Chris
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: FreeBSD Server Settings Consult

2008-05-02 Thread Bob Hall
On Fri, May 02, 2008 at 07:28:44AM -0400, Free BSD wrote:
 We've been having some problems with our server and I was wondering if
 someone had any advice or suggestions for our current system settings.

You'll probably get more help if you post the problems and any
diagnostic info. :)
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


ipf fails after cvsup

2008-05-02 Thread Randy Schultz

Heya,

Running a fresh install of 7.0-RELEASE.  I've cvsup'd the sources, done the
standard updating, e.g.
 make buildworld
 make buildkernel
 make installkernel
 (reboot)
 mergemaster -p
 make installworld
 mergemaster
 (reboot)

But now ipf gives me ye olde
 Root Dude ? /sbin/ipf -Fa -f /etc/ipf.rules
 open device: No such file or directory
 User/kernel version check failed

The ipf version is:
 Root Dude ? ipf -V
 ipf: IP Filter: v4.1.28 (512)
 open device: No such file or directory


My supfile is pretty standard, with
 *default release=cvs tag=RELENG_7
 src-all

I've had this before when I've spaced out the make installworld.  I've never
gotten this *after* the sync/build.

Have I missed a bit of documentation somewhere?

--
 Randy([EMAIL PROTECTED])  765.983.1283 *

Love with your heart, think with your head;  not the other way around.

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: handling mysql binlog data

2008-05-02 Thread Zbigniew Szalbot

Hello,

Chris Pratt pisze:


On May 2, 2008, at 5:27 AM, Zbigniew Szalbot wrote:


Hello,

Following a recent thread I would like to ask if it is safe to  
remove old binlog data. From the below I understand that the  
current binlog is mysql-bin.07 and the previous ones (from  
01-06) are not written to any more. I just need  
confirmation before I take any action. By asking whether it is  
safe, I only mean if deleting them will not affect mysql operation.  
I do backups of mysql data anyway.


-rw-rw  1 mysql  mysql61956466 Apr 16 08:44 mysql-bin.01
-rw-rw  1 mysql  mysql   697756219 Apr 17 14:26 mysql-bin.02
-rw-rw  1 mysql  mysql1056 Apr 17 14:29 mysql-bin.03
-rw-rw  1 mysql  mysql  1073745860 Apr 24 05:49 mysql-bin.04
-rw-rw  1 mysql  mysql   620489997 Apr 27 10:48 mysql-bin.05
-rw-rw  1 mysql  mysql   229357379 Apr 28 15:55 mysql-bin.06
-rw-rw  1 mysql  mysql   869964294 May  2 14:15 mysql-bin.07

Do I understand correctly that removing mysql-bin.07 would  
result in mysql not writing any data to mysql-bin file until the  
server gets restarted?




I recently removed all logs prior to the one shown as current
without any problems. I would not think you would want to
remove the one currently in use or problems would result.

The procedure for this is here:
http://dev.mysql.com/doc/refman/5.1/en/purge-master-logs.html
for 5.1 and here:
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
for 5.0


Thanks a lot! It did help me get rid of a few files in a safe way. I 
only wonder now how to set up a cron job to do it on a permanent basis?


1/ I would probably be better off setting this mysql query (URGE {MASTER 
| BINARY} LOGS BEFORE 'date') in a separate file an run it from cron?


2/ Even if I do that, I would still have to change the 'date' value each 
month... hmm... as non-programmer I will probably do best to simply 
enter a task in a calendar to run this manually... each month :)


Thank you anyway - this was very helpful and I instantly saved a lot of 
space on a shrinking /var partition!


--
Zbigniew Szalbot
www.lc-words.com


smime.p7s
Description: S/MIME Cryptographic Signature


Re: handling mysql binlog data

2008-05-02 Thread Chris Pratt


On May 2, 2008, at 8:58 AM, Zbigniew Szalbot wrote:




The procedure for this is here:
http://dev.mysql.com/doc/refman/5.1/en/purge-master-logs.html
for 5.1 and here:
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
for 5.0


Thanks a lot! It did help me get rid of a few files in a safe way.  
I only wonder now how to set up a cron job to do it on a permanent  
basis?


1/ I would probably be better off setting this mysql query (URGE  
{MASTER | BINARY} LOGS BEFORE 'date') in a separate file an run it  
from cron?


2/ Even if I do that, I would still have to change the 'date' value  
each month... hmm... as non-programmer I will probably do best to  
simply enter a task in a calendar to run this manually... each  
month :)


Thank you anyway - this was very helpful and I instantly saved a  
lot of space on a shrinking /var partition!




I find it most comfortable to do this manually so I can check
my backups first. There is an example in the reply comments
below the documentation on the 5.0 version of the mysql
doc page that shows a unix way to set up a cron script
and automate the process. I've not tried it.

Shrinking /var partition?: I found the ports setup of mysql to
be overly restrictive by using the /var method. It was simple
to install, shutdown mysqld, copy the contents of the /var
database files (preserving the appropriate ownership and
permissions). I then added (assuming /usr is your large
partition)

mysql_dbdir=/usr/mysql
mysql_datadir=/usr/mysql

to /etc/rc.conf and restarted. It is an outage but it helped given
I'd never have thought to size /var anywhere near what a
medium size database required.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: FreeBSD Server Settings Consult

2008-05-02 Thread Free BSD
Well from bad experience that goes no where, due-to rare issue and no
supporting logs/core dumps... Therefore that be a complete no :(

On Fri, May 2, 2008 at 11:30 AM, Bob Hall [EMAIL PROTECTED] wrote:

 On Fri, May 02, 2008 at 07:28:44AM -0400, Free BSD wrote:
  We've been having some problems with our server and I was wondering if
  someone had any advice or suggestions for our current system settings.

 You'll probably get more help if you post the problems and any
 diagnostic info. :)
 ___
 freebsd-questions@freebsd.org mailing list
 http://lists.freebsd.org/mailman/listinfo/freebsd-questions
 To unsubscribe, send any mail to 
 [EMAIL PROTECTED]

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: handling mysql binlog data

2008-05-02 Thread Zbigniew Szalbot

Hi Chris,

Chris Pratt pisze:

Thank you anyway - this was very helpful and I instantly saved a  
lot of space on a shrinking /var partition!




I find it most comfortable to do this manually so I can check
my backups first. There is an example in the reply comments
below the documentation on the 5.0 version of the mysql
doc page that shows a unix way to set up a cron script
and automate the process. I've not tried it.

Shrinking /var partition?: I found the ports setup of mysql to
be overly restrictive by using the /var method. It was simple
to install, shutdown mysqld, copy the contents of the /var
database files (preserving the appropriate ownership and
permissions). I then added (assuming /usr is your large
partition)

mysql_dbdir=/usr/mysql
mysql_datadir=/usr/mysql

to /etc/rc.conf and restarted. It is an outage but it helped given
I'd never have thought to size /var anywhere near what a
medium size database required.



Yeah, I am in the same boat so to say... I guess copying mysql data 
using cp -p will preserve all the file attributes?


Will any future upgrade (by means of portupgrade) not change the custom 
mysql location back to /var/db/mysql?


Thanks again Chris!


--
Zbigniew Szalbot
www.lc-words.com


smime.p7s
Description: S/MIME Cryptographic Signature


Re: KDE3 Error

2008-05-02 Thread Valeriu Mutu
On Fri, May 02, 2008 at 05:09:42PM +0800, Ruel Luchavez wrote:
 Hi,
 Why is it when i install KDE3 in my server I always got an error, this is
 the command when i install it
 
 -cd /usr/ports/x11/kde3
 -make install
 
 *and this is the reply of the server:*
 -Attempting to fetch from
 ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/KDE/.
 -fetch://
 ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/KDE/qt-x11-free-3.3.6.tar.bz2:Fileunavailable
 (e.g., file not found, no access)
 -Couldn't fetch ot-please try to retreive this
 -port manually into /usr/ports/distfiles/KDE and try again.
 ***Error code 1
 
 Stop in usr/ports/x11-toolkits/qt33/
 *** Error code 1
 
 Stop in /usr/ports/x11-toolkits/qt33
 Stop in usr/ports/x11-toolkits/qt33/
 *** Error code 1
 
 Did i miss something??? Please HELP here...
 
 Thanks in advance...:(
 ___
 freebsd-questions@freebsd.org mailing list
 http://lists.freebsd.org/mailman/listinfo/freebsd-questions
 To unsubscribe, send any mail to [EMAIL PROTECTED]

Hi Ruel,

Can you please verify that:
1. Internet is accessible. Try:
ftp ftp.iasi.roedu.net

2. Your ports tree is up to date. 

After this is done, remove the directory /usr/ports/distfiles/KDE/ .

Then do:

cd /usr/ports/x11-toolkits/qt33/
make fetch

If this still results in an error, try this instead of make fetch:
make 
MASTER_SITE_OVERRIDE=ftp://ftp.iasi.roedu.net/mirrors/ftp.trolltech.com/qt/source/
 fetch
or
make MASTER_SITE_OVERRIDE=ftp://ftp.fu-berlin.de/unix/X11/gui/Qt/source/ fetch

These are mirrors taken from /usr/ports/Mk/bsd.siteis.mk . Search for 
MASTER_SITE_QT in that file.

-- 
Valeriu Mutu
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


The Complete FreeBSD: errata and addenda

2008-05-02 Thread Greg Lehey
The trouble with books is that you can't update them the way you can a web page
or any other online documentation.  The result is that most leading edge
computer books are out of date almost before they are printed.  Unfortunately,
The Complete FreeBSD, published by O'Reilly, is no exception.  Inevitably, a
number of bugs and changes have surfaced.

The Complete FreeBSD has been through a total of five editions, including its
predecessor Installing and Running FreeBSD.  Two of these have been reprinted
with corrections.  I maintain a series of errata pages.  Start at
http://www.lemis.com/errata-4.html to find out how to get the errata
information.

Note also that the book has now been released for free download in PDF
form.  Instead of downloading the changed pages, you may prefer to
download the entire book.  See http://www.lemis.com/grog/Documentation/CFBSD/ 
for more information.

Have you found a problem with the book, or maybe something confusing?
Please let me know: I'm no longer constantly updating it, but I may be
able to help

Greg
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


How to get best results from FreeBSD-questions

2008-05-02 Thread Greg Lehey

How to get the best results from FreeBSD questions.
===

Last update $Date: 2005/08/10 02:21:44 $

This is a regular posting to the FreeBSD questions mailing list.  If
you got it in answer to a message you sent, it means that the sender
thinks that at least one of the following things was wrong with your
message:

- You left out a subject line, or the subject line was not appropriate.
- You formatted it in such a way that it was difficult to read.
- You asked more than one unrelated question in one message.
- You sent out a message with an incorrect date, time or time zone.
- You sent out the same message more than once.
- You sent an 'unsubscribe' message to FreeBSD-questions.

If you have done any of these things, there is a good chance that you
will get more than one copy of this message from different people.
Read on, and your next message will be more successful.

This document is also available on the web at
http://www.lemis.com/questions.html.

=

Contents:

I:Introduction
II:   How to unsubscribe from FreeBSD-questions
III:  Should I ask -questions or -hackers?
IV:   How to submit a question to FreeBSD-questions
V:How to answer a question to FreeBSD-questions

I: Introduction
===

This is a regular posting aimed to help both those seeking advice from
FreeBSD-questions (the newcomers), and also those who answer the
questions (the hackers).

   Note that the term hacker has nothing to do with breaking
   into other people's computers.  The correct term for the latter
   activity is cracker, but the popular press hasn't found out
   yet.  The FreeBSD hackers disapprove strongly of cracking
   security, and have nothing to do with it.

In the past, there has been some friction which stems from the
different viewpoints of the two groups.  The newcomers accused the
hackers of being arrogant, stuck-up, and unhelpful, while the hackers
accused the newcomers of being stupid, unable to read plain English,
and expecting everything to be handed to them on a silver platter.  Of
course, there's an element of truth in both these claims, but for the
most part these viewpoints come from a sense of frustration.

In this document, I'd like to do something to relieve this frustration
and help everybody get better results from FreeBSD-questions.  In the
following section, I recommend how to submit a question; after that,
we'll look at how to answer one.

II:  How to unsubscribe from FreeBSD-questions
==

When you subscribed to FreeBSD-questions, you got a welcome message
from [EMAIL PROTECTED]  In this message, amongst
other things, it told you how to unsubscribe.  Here's a typical
message:

  Welcome to the freebsd-questions@freebsd.org mailing list!

If you ever want to unsubscribe or change your options (eg, switch to
or from digest mode, change your password, etc.), visit your
subscription page at:

  http://lists.freebsd.org/mailman/options/freebsd-questions/[EMAIL PROTECTED]
  
(obviously, substitute your mail address for [EMAIL PROTECTED]).  You can
also make such adjustments via email by sending a message to:

  [EMAIL PROTECTED]
  
with the word 'help' in the subject or body (don't include the
quotes), and you will get back a message with instructions.

You must know your password to change your options (including
changing the password, itself) or to unsubscribe.
  
Normally, Mailman will remind you of your freebsd.org mailing list
passwords once every month, although you can disable this if you
prefer.  This reminder will also include instructions on how to
unsubscribe or change your account options.  There is also a button on
your options page that will email your current password to you.

  Here's the general information for the list you've
  subscribed to, in case you don't already have it:

  FREEBSD-QUESTIONS   User questions
  This is the mailing list for questions about FreeBSD.  You should not
  send how to questions to the technical lists unless you consider the
  question to be pretty technical.

Normally, unsubscribing is even simpler than the message suggests: you
don't need to specify your mail ID unless it is different from the one
which you specified when you subscribed.

If Majordomo replies and tells you (incorrectly) that you're not on
the list, this may mean one of two things:

  1.  You have changed your mail ID since you subscribed.  That's where
  keeping the original message from majordomo comes in handy.  For
  example, the sample message above shows my mail ID as
  [EMAIL PROTECTED]  Since then, I have changed it to
  [EMAIL PROTECTED]  If I were to try to remove [EMAIL PROTECTED] from
  the list, it would fail: I would have to specify the name with
  which I joined.

  2.  You're subscribed to a mailing list which is subscribed to
  

Re: Compiling in Debugging Flags

2008-05-02 Thread Bill Moran
In response to Chris Maness [EMAIL PROTECTED]:

  Then, ensure the sysctls in the kernel are all frobbed to allow coredumps.
  Specifically:
  kern.coredump: 1
  kern.sugid_coredump: 1
 
 What is frobbed?

http://en.wikipedia.org/wiki/Frob

You need to learn important things like this if you're going to get
anywhere in this business ...

-- 
Bill Moran
http://www.potentialtech.com
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: handling mysql binlog data

2008-05-02 Thread Chris Pratt


On May 2, 2008, at 9:28 AM, Zbigniew Szalbot wrote:


Hi Chris,

Chris Pratt pisze:

Thank you anyway - this was very helpful and I instantly saved a   
lot of space on a shrinking /var partition!



I find it most comfortable to do this manually so I can check
my backups first. There is an example in the reply comments
below the documentation on the 5.0 version of the mysql
doc page that shows a unix way to set up a cron script
and automate the process. I've not tried it.
Shrinking /var partition?: I found the ports setup of mysql to
be overly restrictive by using the /var method. It was simple
to install, shutdown mysqld, copy the contents of the /var
database files (preserving the appropriate ownership and
permissions). I then added (assuming /usr is your large
partition)
mysql_dbdir=/usr/mysql
mysql_datadir=/usr/mysql
to /etc/rc.conf and restarted. It is an outage but it helped given
I'd never have thought to size /var anywhere near what a
medium size database required.



Yeah, I am in the same boat so to say... I guess copying mysql data  
using cp -p will preserve all the file attributes?



I didn't do that so I can't say. I actually tarred and untarred.

Will any future upgrade (by means of portupgrade) not change the  
custom mysql location back to /var/db/mysql?




I ran through portupgrade on both systems twice but
I can't recall if mysql was updated. Given the change
is in /etc/rc.conf, the upgrade shouldn't have an impact.
If an upgrade uses a supplied script to alter the installation
I'd presume it would be an issue. Usually you can provide
these directories as command line options on scripts
provided with mysql.

The saving grace is that since you are not hurting your
original installation, a trial run is rather simple, falling back
is as pretty much a vi /etc/rc.conf and a reboot.


Thanks again Chris!


--
Zbigniew Szalbot
www.lc-words.com


___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Compiling in Debugging Flags

2008-05-02 Thread Chris Maness

Bill Moran wrote:

In response to Chris Maness [EMAIL PROTECTED]:

  

Then, ensure the sysctls in the kernel are all frobbed to allow coredumps.
Specifically:
kern.coredump: 1
kern.sugid_coredump: 1
  

What is frobbed?



http://en.wikipedia.org/wiki/Frob

You need to learn important things like this if you're going to get
anywhere in this business ...

  

sysctl -a | grep core
kern.corefile: %N.core
kern.nodump_coredump: 0
kern.coredump: 1
kern.sugid_coredump: 0
6pid 36665 (conftest), uid 0: exited on signal 11 (core dumped)
6pid 97013 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 48143 (conftest), uid 0: exited on signal 12 (core dumped)
6pid 69261 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 30477 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 17468 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 72511 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 88618 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 91921 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 48962 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 96510 (httpd), uid 0: exited on signal 11 (core dumped)
debug.elf32_legacy_coredump: 0

How do I change the the values?  Also, where do the files go by default?
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: FreeBSD Server Settings Consult

2008-05-02 Thread Mel
On Friday 02 May 2008 13:28:44 Free BSD wrote:
 We've been having some problems with our server and I was wondering if
 someone had any advice or suggestions for our current system settings.

Would help to know, at minimum:
- ammount of ram
- ammount of cpu's
- platform (uname -m )
- pciconf -lv|grep ^none
- dmesg output that complains about hardware
- what's different about your kernel with respect to GENERIC

What the problems are:
- from the sysctl variables, I'm guessing you want more network performance
- you mention core dumps, does the kernel crash?

Some background:
- what's the primary purpose of the machine
- why are things like ipc tuned?


 kern.maxfilesperproc=65536

The above will only work with programs that use open(2) exclusively and not 
fopen, because fopen is limited to SHRT_MAX, being 32767.


-- 
Mel

Problem with today's modular software: they start with the modules
and never get to the software part.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: handling stale dependencies

2008-05-02 Thread Mel
On Friday 02 May 2008 07:20:30 Zbigniew Szalbot wrote:
 Hello,

 I will appreciate your advice about how to best handle stale
 dependencies. Today I wanted to upgrade phpMyAdmin and I got a number of
 questions about stale dependencies. I eventually deleted all of them,
 but does this mean I need to upgrade ports which used this dependency
 (mailgraph-1.14_1, netpbm-10.26.52, p5-FuzzyOcr-devel-3.4.2_1,
 php5-gd-5.2.5_1, and rrdtool-1.2.26)?

 Stale dependency: mailgraph-1.14_1 - png-1.2.27 (graphics/png):
 Delete this? ([y]es/[n]o/[a]ll) [yes]
 Deleted.

Something went wrong earlier on, and portupgrade screwed up. It tried to 
upgrade png, got as far as uninstalling it, failed to install it and then 
failed to restore the backup and for some reason also thinks that rrdtool 
does not depend on graphics/png, while it does, unconditionally.
Best thing to do when you see pkgdb mentioning stale dependencies is hit 
ctrl-c hard, fast and often. Then scroll up to see what it did wrong and try 
to figure out how to correct it's mess.

What is at present the png version installed on your system and could you show 
the output of:
grep 'DEPORIGIN: graphics/png' /var/db/pkg/*/+CONTENTS

-- 
Mel

Problem with today's modular software: they start with the modules
and never get to the software part.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Compiling in Debugging Flags

2008-05-02 Thread Chris Maness

Chris Maness wrote:

Bill Moran wrote:

In response to Chris Maness [EMAIL PROTECTED]:

 
Then, ensure the sysctls in the kernel are all frobbed to allow 
coredumps.

Specifically:
kern.coredump: 1
kern.sugid_coredump: 1
  

What is frobbed?



http://en.wikipedia.org/wiki/Frob

You need to learn important things like this if you're going to get
anywhere in this business ...

  

sysctl -a | grep core
kern.corefile: %N.core
kern.nodump_coredump: 0
kern.coredump: 1
kern.sugid_coredump: 0
6pid 36665 (conftest), uid 0: exited on signal 11 (core dumped)
6pid 97013 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 48143 (conftest), uid 0: exited on signal 12 (core dumped)
6pid 69261 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 30477 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 17468 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 72511 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 88618 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 91921 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 48962 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 96510 (httpd), uid 0: exited on signal 11 (core dumped)
debug.elf32_legacy_coredump: 0

How do I change the the values?  Also, where do the files go by default?


Never mind, I figured it out.  Stay tuned, and I'll have some output.

Chris
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Compiling in Debugging Flags

2008-05-02 Thread Chris Maness

Chris Maness wrote:

Chris Maness wrote:

Bill Moran wrote:

In response to Chris Maness [EMAIL PROTECTED]:

 
Then, ensure the sysctls in the kernel are all frobbed to allow 
coredumps.

Specifically:
kern.coredump: 1
kern.sugid_coredump: 1
  

What is frobbed?



http://en.wikipedia.org/wiki/Frob

You need to learn important things like this if you're going to get
anywhere in this business ...

  

sysctl -a | grep core
kern.corefile: %N.core
kern.nodump_coredump: 0
kern.coredump: 1
kern.sugid_coredump: 0
6pid 36665 (conftest), uid 0: exited on signal 11 (core dumped)
6pid 97013 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 48143 (conftest), uid 0: exited on signal 12 (core dumped)
6pid 69261 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 30477 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 17468 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 72511 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 88618 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 91921 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 48962 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 96510 (httpd), uid 0: exited on signal 11 (core dumped)
debug.elf32_legacy_coredump: 0

How do I change the the values?  Also, where do the files go by default?


Never mind, I figured it out.  Stay tuned, and I'll have some output.

Chris

Is it choking on:

/libexec/ld-elf.so.1

or

/libexec/ld-elf.so.1

GNU gdb 6.1.1 [FreeBSD]
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain 
conditions.

Type show copying to see the conditions.
There is absolutely no warranty for GDB.  Type show warranty for details.
This GDB was configured as i386-marcel-freebsd...
Core was generated by `httpd'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /lib/libcrypt.so.4...done.
Loaded symbols for /lib/libcrypt.so.4
Reading symbols from /usr/local/lib/libexpat.so.6...done.
Loaded symbols for /usr/local/lib/libexpat.so.6
Reading symbols from /lib/libc.so.7...done.
Loaded symbols for /lib/libc.so.7
Reading symbols from /usr/local/libexec/apache/mod_mmap_static.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_mmap_static.so
Reading symbols from /usr/local/libexec/apache/mod_vhost_alias.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_vhost_alias.so
Reading symbols from /usr/local/libexec/apache/mod_env.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_env.so
Reading symbols from /usr/local/libexec/apache/mod_log_config.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_log_config.so
Reading symbols from /usr/local/libexec/apache/mod_mime_magic.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_mime_magic.so
Reading symbols from /usr/local/libexec/apache/mod_mime.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_mime.so
Reading symbols from /usr/local/libexec/apache/mod_negotiation.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_negotiation.so
Reading symbols from /usr/local/libexec/apache/mod_status.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_status.so
Reading symbols from /usr/local/libexec/apache/mod_info.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_info.so
Reading symbols from /usr/local/libexec/apache/mod_include.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_include.so
Reading symbols from /usr/local/libexec/apache/mod_autoindex.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_autoindex.so
Reading symbols from /usr/local/libexec/apache/mod_dir.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_dir.so
Reading symbols from /usr/local/libexec/apache/mod_cgi.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_cgi.so
Reading symbols from /usr/local/libexec/apache/mod_asis.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_asis.so
Reading symbols from /usr/local/libexec/apache/mod_imap.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_imap.so
Reading symbols from /usr/local/libexec/apache/mod_actions.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_actions.so
Reading symbols from /usr/local/libexec/apache/mod_speling.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_speling.so
Reading symbols from /usr/local/libexec/apache/mod_userdir.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_userdir.so
Reading symbols from /usr/local/libexec/apache/mod_alias.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_alias.so
Reading symbols from /usr/local/libexec/apache/mod_rewrite.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_rewrite.so
Reading symbols from /usr/local/libexec/apache/mod_access.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_access.so
Reading symbols from /usr/local/libexec/apache/mod_auth.so...done.
Loaded symbols for 

Re: Firewalls

2008-05-02 Thread Zane C.B.
On Tue, 29 Apr 2008 09:51:29 -0700
perikillo [EMAIL PROTECTED] wrote:

 On Mon, Apr 28, 2008 at 12:50 PM, Bruce Cran [EMAIL PROTECTED]
 wrote:
 
  Doug Hardie wrote:
 
   FreeBSD supports 3 firewalls:  IPF, IPFW, and PF.  Some time ago
   (perhaps years) I seem to recall some discussion that one or
   more of those was better maintained and higher quality than the
   others.  I don't see any indications of this in the handbook.
   Several years ago I needed to do traffic shaping and used IPFW
   with dummynet.  It worked but the need eventually went away.
   More recently I needed to incorporate spamd which defaults to
   PF so I used that.  However, now I am back to needing traffic
   shaping again.  I suspect trying to use both PF and IPFW
   simultaneously will not be a good approach.  In addition, there
   now are instructions for using spamd with IPFW so it appears
   that either PF or IPFW will do what I need. Is there any
   additional information available to assist in selecting between
   those?  Thanks.
  
 
  As I understand it pf is often found to be easiest to use and has
  lots of features like altq and os fingerprinting but is quite a
  bit slower than ipfw.
 
  --
  Bruce
 
  ___
  freebsd-questions@freebsd.org mailing list
  http://lists.freebsd.org/mailman/listinfo/freebsd-questions
  To unsubscribe, send any mail to 
  [EMAIL PROTECTED]
 
 
  Reading this post, i have some doubt, how is IPFW support for VoIP
 packets, can do traffic shaping?, i read that PF can do that, I'm
 right?

What exactly are you looking to do in this area?
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Firewalls

2008-05-02 Thread Zane C.B.
On Mon, 28 Apr 2008 20:50:06 +0100
Bruce Cran [EMAIL PROTECTED] wrote:

 Doug Hardie wrote:
  FreeBSD supports 3 firewalls:  IPF, IPFW, and PF.  Some time ago 
  (perhaps years) I seem to recall some discussion that one or more
  of those was better maintained and higher quality than the
  others.  I don't see any indications of this in the handbook.
  Several years ago I needed to do traffic shaping and used IPFW
  with dummynet.  It worked but the need eventually went away.
  More recently I needed to incorporate spamd which defaults to PF
  so I used that.  However, now I am back to needing traffic
  shaping again.  I suspect trying to use both PF and IPFW
  simultaneously will not be a good approach.  In addition, there
  now are instructions for using spamd with IPFW so it appears that
  either PF or IPFW will do what I need.  Is there any additional
  information available to assist in selecting between those?
  Thanks.
 
 As I understand it pf is often found to be easiest to use and has
 lots of features like altq and os fingerprinting but is quite a bit
 slower than ipfw.

There is one thing that IPFW has that PF does not that I have found
to be very handy at times. It can be used to setup firewall rules
that only affect a specific group or user.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Firewalls

2008-05-02 Thread Luke Dean



On Fri, 2 May 2008, Zane C.B. wrote:


On Mon, 28 Apr 2008 20:50:06 +0100
Bruce Cran [EMAIL PROTECTED] wrote:


Doug Hardie wrote:

FreeBSD supports 3 firewalls:  IPF, IPFW, and PF.  Some time ago
(perhaps years) I seem to recall some discussion that one or more
of those was better maintained and higher quality than the
others.  I don't see any indications of this in the handbook.
Several years ago I needed to do traffic shaping and used IPFW
with dummynet.  It worked but the need eventually went away.
More recently I needed to incorporate spamd which defaults to PF
so I used that.  However, now I am back to needing traffic
shaping again.  I suspect trying to use both PF and IPFW
simultaneously will not be a good approach.  In addition, there
now are instructions for using spamd with IPFW so it appears that
either PF or IPFW will do what I need.  Is there any additional
information available to assist in selecting between those?
Thanks.


As I understand it pf is often found to be easiest to use and has
lots of features like altq and os fingerprinting but is quite a bit
slower than ipfw.


There is one thing that IPFW has that PF does not that I have found
to be very handy at times. It can be used to setup firewall rules
that only affect a specific group or user.


PF can do this too.
There were threading/locking/crashing issues when last I tried to use
that feature of PF back in FreeBSD 5.x, but that was a very long time
ago.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Compiling in Debugging Flags

2008-05-02 Thread Chris Maness

Chris Maness wrote:

Chris Maness wrote:

Chris Maness wrote:

Bill Moran wrote:

In response to Chris Maness [EMAIL PROTECTED]:

 
Then, ensure the sysctls in the kernel are all frobbed to allow 
coredumps.

Specifically:
kern.coredump: 1
kern.sugid_coredump: 1
  

What is frobbed?



http://en.wikipedia.org/wiki/Frob

You need to learn important things like this if you're going to get
anywhere in this business ...

  

sysctl -a | grep core
kern.corefile: %N.core
kern.nodump_coredump: 0
kern.coredump: 1
kern.sugid_coredump: 0
6pid 36665 (conftest), uid 0: exited on signal 11 (core dumped)
6pid 97013 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 48143 (conftest), uid 0: exited on signal 12 (core dumped)
6pid 69261 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 30477 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 17468 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 72511 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 88618 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 91921 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 48962 (httpd), uid 0: exited on signal 11 (core dumped)
6pid 96510 (httpd), uid 0: exited on signal 11 (core dumped)
debug.elf32_legacy_coredump: 0

How do I change the the values?  Also, where do the files go by 
default?



Never mind, I figured it out.  Stay tuned, and I'll have some output.

Chris

Is it choking on:

/libexec/ld-elf.so.1

or

/libexec/ld-elf.so.1

GNU gdb 6.1.1 [FreeBSD]
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and 
you are
welcome to change it and/or distribute copies of it under certain 
conditions.

Type show copying to see the conditions.
There is absolutely no warranty for GDB.  Type show warranty for 
details.

This GDB was configured as i386-marcel-freebsd...
Core was generated by `httpd'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /lib/libcrypt.so.4...done.
Loaded symbols for /lib/libcrypt.so.4
Reading symbols from /usr/local/lib/libexpat.so.6...done.
Loaded symbols for /usr/local/lib/libexpat.so.6
Reading symbols from /lib/libc.so.7...done.
Loaded symbols for /lib/libc.so.7
Reading symbols from /usr/local/libexec/apache/mod_mmap_static.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_mmap_static.so
Reading symbols from /usr/local/libexec/apache/mod_vhost_alias.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_vhost_alias.so
Reading symbols from /usr/local/libexec/apache/mod_env.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_env.so
Reading symbols from /usr/local/libexec/apache/mod_log_config.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_log_config.so
Reading symbols from /usr/local/libexec/apache/mod_mime_magic.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_mime_magic.so
Reading symbols from /usr/local/libexec/apache/mod_mime.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_mime.so
Reading symbols from /usr/local/libexec/apache/mod_negotiation.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_negotiation.so
Reading symbols from /usr/local/libexec/apache/mod_status.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_status.so
Reading symbols from /usr/local/libexec/apache/mod_info.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_info.so
Reading symbols from /usr/local/libexec/apache/mod_include.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_include.so
Reading symbols from /usr/local/libexec/apache/mod_autoindex.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_autoindex.so
Reading symbols from /usr/local/libexec/apache/mod_dir.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_dir.so
Reading symbols from /usr/local/libexec/apache/mod_cgi.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_cgi.so
Reading symbols from /usr/local/libexec/apache/mod_asis.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_asis.so
Reading symbols from /usr/local/libexec/apache/mod_imap.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_imap.so
Reading symbols from /usr/local/libexec/apache/mod_actions.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_actions.so
Reading symbols from /usr/local/libexec/apache/mod_speling.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_speling.so
Reading symbols from /usr/local/libexec/apache/mod_userdir.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_userdir.so
Reading symbols from /usr/local/libexec/apache/mod_alias.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_alias.so
Reading symbols from /usr/local/libexec/apache/mod_rewrite.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_rewrite.so
Reading symbols from /usr/local/libexec/apache/mod_access.so...done.
Loaded symbols for /usr/local/libexec/apache/mod_access.so
Reading symbols from