Re: bin files in var/log/mysql

2006-05-18 Thread Michael Schurter

Brent Clark wrote:

I saw all a few bin files in var/log/mysql.

trinity:/var/log/mysql# ls -la
total 5760
drwxr-s---  2 mysql adm4096 2006-05-18 07:47 .
drwxr-xr-x 13 root  root   4096 2006-05-18 08:13 ..
-rw-rw  1 mysql adm  145221 2006-05-13 07:35 mysql-bin.000133
-rw-rw  1 mysql adm  178978 2006-05-14 07:35 mysql-bin.000134
-rw-rw  1 mysql adm   99868 2006-05-15 07:58 mysql-bin.000135
-rw-rw  1 mysql adm   97529 2006-05-16 07:52 mysql-bin.000136
-rw-rw  1 mysql adm   73481 2006-05-17 07:52 mysql-bin.000137
-rw-rw  1 mysql adm  422265 2006-05-18 07:47 mysql-bin.000138
-rw-rw  1 mysql adm  248005 2006-05-18 14:07 mysql-bin.000139
-rw-rw  1 mysql adm 800 2006-05-18 07:47 mysql-bin.index

Could anyone please tell me what are these for, and I would like to know 
how come they dont get compress / rotated. It seem like files will just 
keep on getting created with out old files been deleted.


These files are for replication and recovery.  I believe there are 
settings in your my.cnf to configure their max size.  I'm not sure why 
they aren't rotated automatically.


For MySQL 4.x:
http://dev.mysql.com/doc/refman/4.1/en/binary-log.html

For MySQL 5.x:
http://dev.mysql.com/doc/refman/5.1/en/binary-log.html

Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: smartd message

2006-05-13 Thread Michael Schurter

Christian Christmann wrote:

Hi,

smartd generates permanently the following e-mail (sent to root) on my
Debian Etch system:


[snip]


The following warning/error was logged by the smartd daemon:

Device: /dev/hda, 1 Offline uncorrectable sectors



I'd get a new HD.  In my experience SMART errors only show up when a 
drive is on its way out.


Michael


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: good anti-virus software to use?

2006-04-21 Thread Michael Schurter

Kamaraju Kusumanchi wrote:

On Friday 21 April 2006 04:19, Johannes Wiedersich wrote:

Also linux viruses occur only very seldom -- probably because of linux's
different security approach.


Could it be because there are less number of desktop users using Linux than
windows?


While Linux is more secure-by-design than Microsoft, there is some truth 
to the idea that Windows is a bigger target because its more popular.


Think of it this way: if you were a virus/spyware/malware writer who 
would you target?  95% of the market or 5% of the market?


Also, Linux users tend to be more technically minded and able to 
correctly administer their own computers.


My point is that even if Linux *weren't* significantly more secure than 
Windows (which I believe it *is*), you still would not see many (or any) 
viruses/spyware/malware for it.


Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: SATA RAID 0 in Debian [solved]

2006-04-19 Thread Michael Schurter

listrcv wrote:

Michael Schurter wrote:

The drives were setup on an old motherboard that died, and I can't 
seem to find a way to get the crappy Windows SATA RAID utility to 
recognize the drives as an existing RAID array.



Your screwed unless you can find a board that has the same IDE 
controller on it


Actually, I found a great Ubuntu forum on the topic, and the command 
"dmraid -ay" autodetected the RAID without problems.  Quite 
impressive!  I was able to copy files off of the RAID and then I'm 
going to set it back up in Windows so both Windows and Linux can see it.


Huh? How does that work? Did you set it up as Windoze software RAID on 
the old board (independant of the controller on that board), and Ubuntu 
features access to such a RAID?


Windows requires software to see the RAID, however I'm not sure if it 
was a software RAID.  Sorry for lack of detail, but its a point on which 
I'm still unclear myself.


I do know there's a very simple RAID setup screen you can access after 
BIOS during boot, so the motherboard has some innate RAID capabilities. 
 Obviously I'm not an expert in the ways of RAID arrays.  :)  All I 
know is the result was pretty miraculous.


Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: SATA RAID 0 in Debian [solved]

2006-04-18 Thread Michael Schurter

listrcv wrote:

Michael Schurter wrote:

The drives were setup on an old motherboard that died, and I can't 
seem to find a way to get the crappy Windows SATA RAID utility to 
recognize the drives as an existing RAID array.


Your screwed unless you can find a board that has the same IDE 
controller on it because the format in which the data has been stored is 
unique to the type of controller on the broken board.


If you want RAID, use a decent and true hardware RAID controller. 
_Never_ use the fake onboard-controllers!


Actually, I found a great Ubuntu forum on the topic, and the command 
"dmraid -ay" autodetected the RAID without problems.  Quite impressive! 
 I was able to copy files off of the RAID and then I'm going to set it 
back up in Windows so both Windows and Linux can see it.


Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: Printer for linux?

2006-04-17 Thread Michael Schurter

Daniel Webb wrote:

On Mon, Apr 17, 2006 at 11:32:40PM +0100, Doofus wrote:

I'm in the market for a printer and would appreciate any 
recommendations. I should think this is an oft asked question, but since 
the printer market seems to move at a rapier like pace, thought it ok to 
ask again for any recent experiences.


I'd like a networked monochrome laser printer with duplex printing.


Not sure about new printers or duplex printers, but I love the old HP printers
(versions III through 5).  They just keep running.

I did buy a new HP printer that was complete junk on accident with grant
money, now I can't remember the model number, but some labmates have a
different new HP that's great.  I guess you have to watch out for the HP
models that are trying to compete on price, they are as junky as all the other
brands out there.


HP LaserJet 2600n - Full color, network ready, blah blah blah -- It 
looks like a steal at $300, but its complete junk.  I've had to get 2 
replacements for the 1 I've purchased.  Also the consumables are more 
expensive to replace than the printer itself.  Completely ridiculous.



At home, I'm still using an HP Laserjet IIIP, which is nearly as old as I
am.


At work we use a 5P which may be slow, but shows no sign of ever dying.

Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: SATA RAID 0 in Debian

2006-04-14 Thread Michael Schurter

chris roddy wrote:

Michael Schurter wrote:
Let me rephrase: how do I setup SATA RAID 0 in Debian? 


Were these set up using a hardware RAID controller? You may need to plug
them into a controller of the exact same model to get to the data. The
on-disk format is frequently not interchangeable from one RAID
controller to the next.


Hm.  This sounds bad as it was a builtin motherboard controller - Via 
maybe?  Don't have it in front of me.  I'm not even sure if it was a 
hardware or software RAID because Windows required drivers to see it, 
and (obviously) I never mounted it in Debian.  This is a very humbling 
experience indeed...



I suppose you could attempt to set up a Linux software RAID and present
these drives to it. I wouldn't count on it working, though. The Software
RAID Howto is a good place to start:
http://www.tldp.org/HOWTO/Software-RAID-HOWTO.html


Thanks for the link!  It seems a bit outdated (like so many HOWTOs), and 
I can't tell if any of the instructions would work for "importing" an 
existing array because of statements like the following:
"This should initialize the superblocks and start the raid device." 
(section 5.5)


Basically, I want to be able to mount 2 NTFS formatted disks readonly as 
a RAID 0 array with 64kb chunks.


Thanks, for the help!
Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: SATA RAID 0 in Debian

2006-04-14 Thread Michael Schurter

Michael Schurter wrote:
I've never worked with SATA RAID's in Debian (or Linux in general), so 
I'm sorry if this is a stupid question.


Let me rephrase: how do I setup SATA RAID 0 in Debian?


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




SATA RAID 0 in Debian

2006-04-14 Thread Michael Schurter
I've never worked with SATA RAID's in Debian (or Linux in general), so 
I'm sorry if this is a stupid question.


I have 2 striped (RAID 0) 80 GB SATA drives that were setup in Windows 
XP that I want to mount (read-only) in Debian to copy the data.


The drives were setup on an old motherboard that died, and I can't seem 
to find a way to get the crappy Windows SATA RAID utility to recognize 
the drives as an existing RAID array.  So I wanted to boot into Linux to 
copy the data off before attempting to use the drives again in Windows.


Sorry if this question is a bit OT.

Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: default group ownership of a file

2006-04-06 Thread Michael Schurter

Albert Dengg wrote:
at least in my expirience if the user has write permisions in the diectory only 
because of a certain group membership (for example in /usr/src with the

src group) the gid of the file is set to respective group and not the
users primary group.


Excellent point.  Thanks for the clarification.

Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: default group ownership of a file

2006-04-06 Thread Michael Schurter

ChadDavis wrote:
Hello.  I need to know how the group ownership of a file is decided in 
debian.  Also, is it the same for all linux systems? 


All Linux (and probably Unix) filesystems store a group ID number (gid) 
on a per-file basis.  The gid is looked up in /etc/group to get the 
textual group name you're used to seeing.


All users have a primary group membership as well as any number of 
secondary group memberships.  (use the /usr/bin/id command to get that 
info)  When a user creates a file, that file's group owner is set to the 
users primary group.


You can change the group ownership of a file with the /usr/bin/chown or 
/usr/bin/chgrp commands.  You can change the group membership of a user 
with the /usr/sbin/usermod command.


Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: how do I stop my processor fan

2006-04-06 Thread Michael Schurter

Craig M. Houck wrote:

You don't want the processor fan to stop...at least I would never want fan
on top of the processor of ANY compuer I used to stop.


In laptops its very common to at least dramatically slow down system 
fans when they're not needed.  When modern laptops are in an idle or 
near idle state their processors use very little power and therefore 
generate very little heat.


Now I wouldn't ever try to slowdown the fan on an Intel P4 ... you can 
probably roast marshmallows over P4s.


Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Best Graphics Card for Multi-headed Linux

2006-03-31 Thread Michael Schurter

Hello all,

I was wondering if anyone could recommend good graphics cards to use on 
a multi-headed Linux installation.  I don't need 3D acceleration, 
although it would be nice.  I want to start with 3-4 stations per 
computer and hopefully get up to 6.


Any recommendations concerning setup would be appreciated as well: Sarge 
vs. Etch, X Windows version, etc.


Any tips are welcome, and I'll post my results when its setup.

Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: Removing AOL art files

2006-03-31 Thread Michael Schurter

[EMAIL PROTECTED] wrote:
I now have a very shrunken aol screen.  Since I often get a message that 
aol is removing some of the art files, I think that I have too much 
space being used up by art files.  Can I, and should I attempt to remove 
them?


You should probably contact AOL's support.  While the people on this 
mailing list are very helpful, I doubt many of them have much knowledge 
of AOL as it does not support Debian/GNU Linux.


I for one have never used AOL.

Good luck,
Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: ASP.NET on Debian

2006-03-31 Thread Michael Schurter

Øyvind Lode wrote:

Hello all!

http://www.mono-project.com/ASP.NET

Anyone on the list have some experience with mod_mono on Apache2 on Debian?
Does it work well?


I've used XSP and XSP2 some with success.  XSP seems to work quite well, 
and since its the engine behind mod_mono, I would expect good things 
from mod_mono as well.


However, XSP2 (ASP.NET 2.0) still has a ways to go.

Some of my users have asked me to install this module to support ASP.NET 
on my webserver.


Be careful with letting a large number of users run ASP.NET applications 
as I've heard reports of mod_mono/XSP slowly eating more and more memory 
without freeing it.  I think this is because Mono uses a very 
conservative garbage collector which should be improved in the near future.


Good luck,
Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: list port are listen

2006-03-27 Thread Michael Schurter

pedro lopez wrote:

how i do?
 
i need see what services are runing, how i can see de port listen on may 
systen? and new on linux.


netstat is the command you're looking for.  Check out "netstat -h" for a 
list of options.  "netstat -l" or "netstat -lt" are probably what you're 
most interested in.  If you prefer numeric port numbers to service 
names, add a "--numeric-ports" to the end.


Also, the "ps aux" command is commonly used to list running programs. 
It won't give you network information, but very useful none the less.


Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: nfs performance

2006-03-20 Thread Michael Schurter

Pol Hallen wrote:

Hi all :-)

i'd like known the performance of network file system

i have a debian stable in a server (p4, 1Gb ram. ethernet 10/100) and the same  
hardware in the client.


I use the client for burn my dvd data (with smbmount) but the speed of my dvd 
is 1,380Kbs :-((( this mean a lot of time per single disc :-(((


Using a server nfs is better or the same?!
With which performance?


Better.  You would have a hard time getting any network file system to 
run slower than burning a DVD.  SSH, FTP, HTTP, Samba, NFS -- they 
should all be quite a bit faster.



thank! ;-)

Pol



--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Best Linux Laptop

2006-03-13 Thread Michael Schurter
I know I've seen lots of posts on this before, so I'm sorry for asking 
the same questions over and over.


Someone just asked me what the ideal laptop would be to purchase to 
install Debian Linux onto.  The main thing is WiFi support and good 
quality.  Don't need lots of storage or a super fast processor, but 
basic 3D support would be nice.


I've seen lots of posts on here about wireless cards not working, so 
thats what I'm the most concerned about.


I've heard of lots of people running Linux on IBM Thinkpads, but I can't 
seem to purchase one from Lenovo without Windows.


Do any of the major laptop manufactures sell laptops without OSes installed?

Thanks in advance!

Michael Schurter

(For those who care these laptops will be donated to a school in 
Venezuela through the company I work for.)



--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: postgresql-common 42 fails to upgrade

2006-03-06 Thread Michael Schurter

Andrew Cady wrote:

On Thu, Mar 02, 2006 at 04:10:07PM -0600, Michael Schurter wrote:

I have a Debian Etch machine that I keep up to date.


[...]


Setting up postgresql-common (42) ...
dpkg: error processing postgresql-common (--configure):
 subprocess post-installation script returned error exit status 1


[...]

Any ideas why postgresql-common is failing to upgrade? 


You should find out, and report a bug.  Diagnosing this problem will no
doubt be very useful to the postgresql maintainer.


I submitted it, and now postgresql-common 43 installed beautifully!

Thanks for your help,

Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




postgresql-common 42 fails to upgrade

2006-03-02 Thread Michael Schurter
I have a Debian Etch machine that I keep up to date.  Recently when I 
tried to upgrade from (I believe) postgresql-common version 39 to 
postgresql-common version 42 in Synaptic, I received an error that a 
sub-process install had failed.  Like a fool I closed the window before 
copying down the original message.


Here's the output I get when running "aptitude reinstall 
postgresql-common" as root:

---
The following packages will be REINSTALLED:
  postgresql-common
0 packages upgraded, 0 newly installed, 1 reinstalled, 0 to remove and 
13 not upgraded.

Need to get 0B of archives. After unpacking 0B will be used.
Writing extended state information... Done
Setting up postgresql-common (42) ...
dpkg: error processing postgresql-common (--configure):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 postgresql-common
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install.  Trying to recover:
Setting up postgresql-common (42) ...
dpkg: error processing postgresql-common (--configure):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 postgresql-common
---


Here's the (partial) output I get when running "dpkg-query -l 
postgresql-common":

iF  postgresql-common 42

Any ideas why postgresql-common is failing to upgrade?  My Postgresql 
8.1 server is still operating fine, and I can install/upgrade other 
packages.  However, this error comes up whenever I run any apt related 
command.


Thanks in advance for any help!
Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: copying a 12GB file

2006-03-01 Thread Michael Schurter

. wrote:
how can I copy a 12GB file at reasonable speed over a 1000Mbit ethernet 
connection from one computer (mailserver) to another (SAMBA file server 
or my workstation) without going to lengths like installing an FTP 
server or the like on the mailserver?


FTP would probably be the fastest, but scp (file transfer over SSH) is 
probably already on both machines if they're both Linux.  PuTTY is an 
excellent SSH/SCP client for Windows (and Unix) if you need cross 
platform support.


You probably don't want to use SSH Compression as I've seen it actually 
slow down file transfers over fast LAN links.  The SSH encryption might 
slow down the transfer as well, so the transfer speed might depend on 
the speed of your CPUs.


File size limit is 2GB with smbmount; NFS will take about 14 hours(!) 
because copying fails after about 1--2 GB with an I/O error unless using 
sync mode.


This sucks ...


True.

Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: cvs for media files?

2006-02-28 Thread Michael Schurter

Matt Price wrote:

I'm going to be working on a collaborative audio documentary, probablay
using audacity.  I would love to do some kind of version control on
the project, sowe could all work on the documentary at home & then
merge (and accept/reeject) our changes somehow.  But probably this
will involve incremental changes to a significant number of media
files.  Does anyone know whether there's a version-control system which
can handle such changes to binary files easily and clearly?  I don't


Subversion (aka svn) does binary-differencing both when transmitting 
changes and storing them, so it should be much more efficient than CVS 
when dealing with binary files.  I have no idea how well it would handle 
a multi-gigabyte video file, but its worth a try.


However, the most important tool that AFAIK is missing, is a audio/video 
differencing tool - like diff for video.  Without an AV diff tool you 
cannot resolve conflicts if two people change the same revision of a 
video file.


If someone out there knows of some such tool - or thinks I'm way off - 
please respond!


Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: logrotate question

2006-02-23 Thread Michael Schurter

Chris Brandstetter wrote:

Also, on kind of a side note, I usually setup /var on a seperate
partition so that if it does become full you still have access to your
system, and it will mostly still function as normal.


While this is common practice, I question its usefulness because most 
variable system data is housed in /var.  So if a log file fills /var, it 
also crashes your database, mail, and the ability to properly startup 
services because /var/run will full.


I could see partitioning /var/log off on its own, but putting all of 
/var in one partition doesn't seem to solve all that much.



--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]




Re: apache config question - China IP's

2006-02-21 Thread Michael Schurter

Kevin Coyner wrote:


On Mon, Feb 20, 2006 at 09:41:42PM -0600, Jacob S wrote..


221.226.124.109 - - [20/Feb/2006:16:17:10 -0500] "GET
http://1-shops.com/prx.php?p=q1w2e3r4t5y6u7i8o9p0*a-b HTTP/1.1"
404 288 "http://www.google.com/intl/en-us/"; "Mozilla/4.0
(compatible; MSIE 6.0; Windows NT 5.0; Crazy Browser 1.0.5)"

So what is this?  They are not requesting pages that exist on my
server, but pages on other domains.  My server gives the proper
error code back - 404.

They're looking for open proxies. People that are lazy in
loading/configuring mod_proxy in apache can easily turn a
webserver into an open proxy. So they scan for one, similar to the
way we've all seen attempts at finding open smtp gateways or
easily crackable ssh passwords.



So aside from setting up some iptables 'drop' rules, is there any
other way from keeping this from occuring?  It's messing up my web
stats since these guys are requesting more non-existent pages that I
have real pages on the website.


You could exploit the fact that they're trying to access nonexistent 
domain names on your system by setting up your default virtual host to 
redirect them elsewhere (such as http://blackhole-1.iana.org/ or 
http://localhost/).


Or if they're really using a crawler called "Crazy Bowser" you could 
pretty easily block them with BrowserMatch in Apache.  Sorry I don't 
remember what the exact line should be, but spending a few minutes at 
http://httpd.apache.org/docs/ should help.


Using your firewall is probably the best way of blocking such traffic, 
but as a fellow sysadmin I understand that blocking entire IP ranges 
isn't really appealing.


Michael Schurter


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]