removable hdd caddy specs

2002-04-03 Thread Hereward Cooper

Hi there,

I thought that people on this list are the most likley to use removable
drives, so here goes.

Is there a standard specification for drive caddies? i.e. should i be
able to take my drive out and put into another machine, even though the
bays are made by different people?

-- 
Thanks,
-- -0)
Hereward CooperBeing Alone Draws Attention  Somerset, UK /\\
[EMAIL PROTECTED] GPG: 1E1D0C80 zadok.ddts.net   _\_v
--



msg05979/pgp0.pgp
Description: PGP signature


Raid 1 Newbie

2002-04-03 Thread Hereward Cooper

Hi there,

I'm a newbie to raid, and want clarification on some issues.
I'm setting up a Raid 1 consisting of 2 IDE 40Gb seagate drives. I've
read through http://linuxdoc.org/HOWTO/Software-RAID-HOWTO-4.html are am
a bit lost. [Also I don't want to risk playing around since there is
important stuff on this machine]. What do I need to do, if I can, to
boot off a raid1? Currently I have partitions of /, /var, /home, /boot.

-- 
Thanks,
-- -0)
Hereward CooperBeing Alone Draws Attention  Somerset, UK /\\
[EMAIL PROTECTED] GPG: 1E1D0C80 zadok.ddts.net   _\_v
--



msg05980/pgp0.pgp
Description: PGP signature


Netscape Roaming Access

2002-04-03 Thread Tamara Wowczuk




Hi!
I've installed slapd 2.0.23-2 on linux debian with apt-get install.
After that I edited the configuration files and a netscape-profile.schema.
Then I edited entrys into the database with ou=People and ou=roaming.
It works well.
Subsequent I enable the Roaming Access for Netscape and set the
server information.
I selectet the items Bookmarks, Cookies, Mail Filters, Adress Book,
user Preferences and History to transferred to the database.
After I restarted Netscape Comunicator I login with my LDAP - Password
but when I shutdown the comunicator, the database dosen't
save my Bookmarks, Cookies, etc.
Any ideas what is wrong?
Thanks in advance,
Tamara
Here a copy from my slapd.conf, Netscape-Profile.schema and my entrys
for ou=people and ou=raoming
# Schema and objectClass definitions
include /etc/ldap/schema/core.schema
include /etc/ldap/schema/corba.schema
include /etc/ldap/schema/cosine.schema
include /etc/ldap/schema/inetorgperson.schema
include /etc/ldap/schema/java.schema
include /etc/ldap/schema/krb5-kdc.schema
include /etc/ldap/schema/misc.schema
include /etc/ldap/schema/nadf.schema
include /etc/ldap/schema/netscape-profile.schema
include /etc/ldap/schema/nis.schema
include /etc/ldap/schema/openldap.schema
# Schema check allows for forcing entries to
# match schemas for their objectClasses's
schemacheck on
..
...
...
# The backend type, ldbm, is the default standard
database ldbm
# The base of your directory
suffix "dc=test,dc=de"
rootdn "cn=admin,
dc=test, dc=de"
rootpw seacret

# Where the database file are physically stored
directory "/var/lib/ldap"
# Save the time that the entry gets modified
lastmod on
# For Netscape Roaming support, each user gets a roaming
# profile for which they have write access to
access to dn=".*,ou=roaming,dc=gis,dc=de"
 by dnattr=owner write
:

# Where clients are refered to if no

# An OpenLDAP schema for storing Netscape Roaming Profiles
#
# Version: 0.1
# Hacked up by: David E. Storey [EMAIL PROTECTED]>
# Created: Sometime in Septmber, 2000
# Last Updated: December 1st, 2000
#
# ns-core
attributetype ( 2.16.840.1.113730.3.1.70 NAME 'serverRoot'
 SYNTAX 1.3.6.1.4.1.1466.115.121.1.26
)
attributetype ( 2.16.840.1.113730.3.1.76 NAME 'serverHostName'
 SYNTAX 1.3.6.1.4.1.1466.115.121.1.26
)
attributetype ( 2.16.840.1.113730.3.1.280 NAME 'nsServerPort'
 SYNTAX 1.3.6.1.4.1.1466.115.121.1.27
)
# ns-mcd-li
# Attributes
attributetype ( 2.16.840.1.113730.3.1.399 NAME 'nsLIPtrURL'
 EQUALITY caseExactMatch
 SYNTAX 1.3.6.1.4.1.1466.115.121.1.26
)
attributetype ( 2.16.840.1.113730.3.1.400 NAME 'nsLIPrefs'
 EQUALITY caseExactMatch
 SYNTAX 1.3.6.1.4.1.1466.115.121.1.26
)
attributetype ( 2.16.840.1.113730.3.1.401 NAME 'nsLIProfileName'
 EQUALITY caseIgnoreMatch
 SYNTAX 1.3.6.1.4.1.1466.115.121.1.26
)
attributetype ( 2.16.840.1.113730.3.1.402 NAME 'nsLIData'
 SYNTAX 1.3.6.1.4.1.1466.115.121.1.5
)
attributetype ( 2.16.840.1.113730.3.1.403 NAME 'nsLIElementType'
 EQUALITY caseIgnoreMatch
 SYNTAX 1.3.6.1.4.1.1466.115.121.1.26
)
attributetype ( 2.16.840.1.113730.3.1.404 NAME 'nsLIServerType'
 EQUALITY caseIgnoreMatch
 SYNTAX 1.3.6.1.4.1.1466.115.121.1.26
)
attributetype ( 2.16.840.1.113730.3.1.405 NAME 'nsLIVersion'
 SYNTAX 1.3.6.1.4.1.1466.115.121.1.27
)
# Objectclasses
objectclass ( 2.16.840.1.113730.3.2.74 NAME 'nsLIPtr' SUP top
 AUXILIARY MAY ( nsLIPtrURL
$ owner ) )
objectclass ( 2.16.840.1.113730.3.2.75 NAME 'nsLIProfile' SUP top
 STRUCTURAL MUST ( nsLIProfileName
)
 MAY ( nsLIPrefs $ uid $
owner ) )
objectclass ( 2.16.840.1.113730.3.2.76 NAME 'nsLIProfileElement' SUP
top
 STRUCTURAL MUST ( nsLIElementType
)
 MAY ( owner $ nsLIData $
nsLIVersion ) )
objectclass ( 2.16.840.1.113730.3.2.77 NAME 'nsLIServer' SUP top
 AUXILIARY MUST ( serverHostName
)
 MAY ( description $ cn $
nsServerPort $ nsLIServerType $ serverRoot ) )
-
dn: uid=tamara, ou=people, dc=test, dc=de
uid: tamara
cn: T.W
userpassword: {crypt}75kfumCLIa63.
homeDirectory: /home/tamara
uidNumber: 1772
gidNumber: 100
objectclass: top
objectclass: account
objectclass: posixAccount
dn: nsLIProfileName=tamara, ou=roaming, dc=test, dc=de
nsLIProfileName: tamara
owner: uid=tamara, ou=people, dc=test, dc=de
objectclass: top
objectclass: nsLIProfile
--
Tamara Wowczuk

Global Information Services
Steindamm 132, D-24145 Kiel

Telefon +49 (0)431 7164191
Telefax +49 (0)431 7164192

E-mail [EMAIL PROTECTED]
___



Problem with apc and apachectl

2002-04-03 Thread Andres Junge Mac-Evoy

Hello:

I have installed apc (php4-apc 1.1.0pl1-5), and it seems to work very well. 
The scripts get loaded 200% times faster (very impressive).

The only problem I have is when i try to use 'apachectl configtest' i get 
the following error:

apc_sem_create: semget(0,...) failed: No space left on device

The disk empty as df -k says:
df -k
Filesystem   1k-blocks  Used Available Use% Mounted on
/dev/hda5   482217 82434374884  19% /
/dev/hda2   124427   783117220   1% /boot
/dev/hda6 12294200784904  10884772   7% /usr
/dev/hda7 12294200117224  11552452   2% /var
/dev/hda8 12286552   1440144  1088  13% /home

So i really don´t know what is the problem.
In php.ini i have the following configuration:
zend_extension=/usr/lib/php4/extensions/zend/php_apc.so
apc.mode=shm
apc.check_mtime=1
#apc.ttl=20
apc.regex=apcinfo.php:apc

Any idea?
Thanx in advance.

Salu2
Andres

Other useful (maybe) data:
php4-apc  1.1.0pl1-5
php4  4.1.1-1
apache1.3.22-5



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




Re: [Apc-cache] Problem with apc and apachectl

2002-04-03 Thread Steve Meyers

You're leaking semaphores, APC doesn't seem to always clean up after
itself gracefully.

Do an apachectl stop, then execute the following command:

ipcs -s -t | cut -f 1 -d   | egrep ^[0-9]+$ | xargs ipcrm sem

WARNING: if you have anything else on your system that uses semaphores,
this could be trouble!  On my system it works fine, but on yours it
might not.

Never do an apachectl restart or apachectl configtest, as these seem
to be guaranteed to leak semaphores.  I think if you do apachectl stop
and wait a few seconds, it actually cleans up properly.  You have to get
a clean slate first though, so stop apache and run the above command to
clean up the mess, and from now on always stick to start and stop, never
restart.

That's my experience, anyway... I haven't looked at the code for it, so
I don't know exactly what's going on in there.

On Wed, 2002-04-03 at 09:00, Andres Junge Mac-Evoy wrote:
 Hello:
 
 I have installed apc (php4-apc 1.1.0pl1-5), and it seems to work very well. 
 The scripts get loaded 200% times faster (very impressive).
 
 The only problem I have is when i try to use 'apachectl configtest' i get 
 the following error:
 
 apc_sem_create: semget(0,...) failed: No space left on device
 
 The disk empty as df -k says:
 df -k
 Filesystem   1k-blocks  Used Available Use% Mounted on
 /dev/hda5   482217 82434374884  19% /
 /dev/hda2   124427   783117220   1% /boot
 /dev/hda6 12294200784904  10884772   7% /usr
 /dev/hda7 12294200117224  11552452   2% /var
 /dev/hda8 12286552   1440144  1088  13% /home
 
 So i really don´t know what is the problem.
 In php.ini i have the following configuration:
 zend_extension=/usr/lib/php4/extensions/zend/php_apc.so
 apc.mode=shm
 apc.check_mtime=1
 #apc.ttl=20
 apc.regex=apcinfo.php:apc
 
 Any idea?
 Thanx in advance.
 
 Salu2
 Andres
 
 Other useful (maybe) data:
 php4-apc  1.1.0pl1-5
 php4  4.1.1-1
 apache1.3.22-5
 
 
 
 ___
 Apc-cache mailing list
 [EMAIL PROTECTED]
 http://lists.communityconnect.com/mailman/listinfo/apc-cache
 
-- 
Advertising copy: Where sentences are replaced by participle phrases. 
Noun phrases. And dangling conjunctions.


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




Re: [Apc-cache] Problem with apc and apachectl

2002-04-03 Thread Andres Junge Mac-Evoy

Thanx, it works great
The question i have now is, what is the long term solution for this? 
Upgrade APC?

Salu2
Andres

At 09:50 am 03/04/02 -0700, you wrote:

From:  Steve Meyers [EMAIL PROTECTED] on 03-04-2002 09:50 MST

To:Andres Junge Mac-Evoy [EMAIL PROTECTED]
cc:[EMAIL PROTECTED], [EMAIL PROTECTED]
Subject:Re: [Apc-cache] Problem with apc and apachectl


You're leaking semaphores, APC doesn't seem to always clean up after
itself gracefully.

Do an apachectl stop, then execute the following command:

ipcs -s -t | cut -f 1 -d   | egrep ^[0-9]+$ | xargs ipcrm sem

WARNING: if you have anything else on your system that uses semaphores,
this could be trouble!  On my system it works fine, but on yours it
might not.

Never do an apachectl restart or apachectl configtest, as these seem
to be guaranteed to leak semaphores.  I think if you do apachectl stop
and wait a few seconds, it actually cleans up properly.  You have to get
a clean slate first though, so stop apache and run the above command to
clean up the mess, and from now on always stick to start and stop, never
restart.

That's my experience, anyway... I haven't looked at the code for it, so
I don't know exactly what's going on in there.

On Wed, 2002-04-03 at 09:00, Andres Junge Mac-Evoy wrote:
  Hello:
 
  I have installed apc (php4-apc 1.1.0pl1-5), and it seems to work very
well.
  The scripts get loaded 200% times faster (very impressive).
 
  The only problem I have is when i try to use 'apachectl configtest' i get
  the following error:
 
  apc_sem_create: semget(0,...) failed: No space left on device
 
  The disk empty as df -k says:
  df -k
  Filesystem   1k-blocks  Used Available Use% Mounted on
  /dev/hda5   482217 82434374884  19% /
  /dev/hda2   124427   783117220   1% /boot
  /dev/hda6 12294200784904  10884772   7% /usr
  /dev/hda7 12294200117224  11552452   2% /var
  /dev/hda8 12286552   1440144  1088  13% /home
 
  So i really don´t know what is the problem.
  In php.ini i have the following configuration:
  zend_extension=/usr/lib/php4/extensions/zend/php_apc.so
  apc.mode=shm
  apc.check_mtime=1
  #apc.ttl=20
  apc.regex=apcinfo.php:apc
 
  Any idea?
  Thanx in advance.
 
  Salu2
  Andres
 
  Other useful (maybe) data:
  php4-apc  1.1.0pl1-5
  php4  4.1.1-1
  apache1.3.22-5
 
 
 
  ___
  Apc-cache mailing list
  [EMAIL PROTECTED]
  http://lists.communityconnect.com/mailman/listinfo/apc-cache
 
--
Advertising copy: Where sentences are replaced by participle phrases.
Noun phrases. And dangling conjunctions.


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




Re: [HELP] RAID5 IN DEBIAN

2002-04-03 Thread Russell Coker

On Wed, 3 Apr 2002 11:45, axacheng wrote:
 it is very good URL for Linux RAID
 http://www.linuxdoc.org/HOWTO/Software-RAID-HOWTO-4.html

rjc@lyta:/tmp$ dpkg -S Software-RAID | head
doc-linux-html: /usr/share/doc/HOWTO/en-html/Software-RAID-0.4x-HOWTO-1.html
doc-linux-html: /usr/share/doc/HOWTO/en-html/Software-RAID-0.4x-HOWTO-2.html
doc-linux-html: /usr/share/doc/HOWTO/en-html/Software-RAID-0.4x-HOWTO-3.html
doc-linux-html: /usr/share/doc/HOWTO/en-html/Software-RAID-0.4x-HOWTO-4.html
doc-linux-html: /usr/share/doc/HOWTO/en-html/Software-RAID-0.4x-HOWTO-5.html
doc-linux-html: /usr/share/doc/HOWTO/en-html/Software-RAID-0.4x-HOWTO-6.html
doc-linux-html: /usr/share/doc/HOWTO/en-html/Software-RAID-0.4x-HOWTO-7.html
doc-linux-html: /usr/share/doc/HOWTO/en-html/Software-RAID-0.4x-HOWTO-10.html
doc-linux-html: /usr/share/doc/HOWTO/en-html/Software-RAID-0.4x-HOWTO-8.html
doc-linux-html: /usr/share/doc/HOWTO/en-html/Software-RAID-0.4x-HOWTO-11.html

-- 
If you send email to me or to a mailing list that I use which has 4 lines
of legalistic junk at the end then you are specifically authorizing me to do
whatever I wish with the message and all other messages from your domain, by
posting the message you agree that your long legalistic sig is void.


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




Re: Multiple Ascend connections

2002-04-03 Thread Jean-Francois Dive

you'll then have to serailize/buffer it somewhere, probably at the web server
side if there is only one or on another machine..

JeF
On Tue, Apr 02, 2002 at 11:46:14AM -0500, Sean Porth wrote:
 
 
 Hi, 
 
 I have a little problem that i'm hoping Debian can solve.
 
 I have a website that needs to send text to an ascend box and the ascend
 box needs to dial out into another ascend box and transfer that
 information.  I can do it one at a time via telnet, but you can only
 have one telnet session open at a time.  Was hoping someone knows of any
 software that could be used to implement this.  Have read through the
 ascend terminal server docs and can't find any information on having
 multiple sessions,  any help would be appreciated.
 
 -- 
 Sean Porth
 Systems Admin
 
 
 Tortus Technologies
 1686 Riverdale Street
 West Springfield, MA 01089
 http://www.tortus.com
 Phone: 413-788-5080 Fax: 413-785-1901
 
 
 
 -- 
 To UNSUBSCRIBE, email to [EMAIL PROTECTED]
 with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
 

-- 
- Jean-Francois Dive
-- [EMAIL PROTECTED]


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




Re: Is mysql 3.2x stable enough for HA requirement?

2002-04-03 Thread Jean-Francois Dive

i totally agree. I used postgres in prod in several cases and it never
fall, got stucked or anything. Especially if you need transaction, i think
postgres is the way to go.., otherwise, text files is a very solid approach
;) 

JeF

On Mon, Apr 01, 2002 at 07:20:02PM +1200, Dave Watkins wrote:
 Hi Patrick
 
 MySQL replication is only one way in 3.2x so all writes have to be sent to 
 the master server, but the reads can be done from the slaves. If you loose 
 a slave then no big deal round robin DNS alone should take care of that 
 with very little impact, but if you loose the master then you can't perform 
 any writes until it's back up and running.
 
 If you can't live with the risk of data loss then question 2 is really 
 irrelevent, and so if most of question 3. InnoDB is the only transaction 
 capable DB format MySQL supports so even if it is slower, what choice do 
 you have? The only question left is: Is it reliable enough for a production 
 environment? Usually when faced with that question I use PostgreSQL.
 
 Dave
 
 At 14:23 1/04/2002 +0800, Patrick Hsieh wrote:
 Hello,
 
 I am planing to have some woody with mysql-server running on a
 mission-critical environment. My criteria is:
 
 
 1. HA requirement:
 By using mysql built-in replication, I'd like to have a load-balancing
 and fail-over mysql clusters
 
 2. minimal data loss risk
 How much can mysql 3.2x guarentee the minimization of data loss?
 
 3. InnoDB and MyISAM impact on performance and management?
 Since we need transaction, InnoDB is the only choice. Is there any
 performance or management impact between InnoDB and MyISAM?
 Is InnoDB reliable enough for productive environment?
 
 Any experience highly appreciated.
 
 
 
 --
 Patrick Hsieh [EMAIL PROTECTED]
 
 GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg
 
 
 --
 To UNSUBSCRIBE, email to [EMAIL PROTECTED]
 with a subject of unsubscribe. Trouble? Contact 
 [EMAIL PROTECTED]
 
 
 -- 
 To UNSUBSCRIBE, email to [EMAIL PROTECTED]
 with a subject of unsubscribe. Trouble? Contact 
 [EMAIL PROTECTED]
 

-- 
- Jean-Francois Dive
-- [EMAIL PROTECTED]


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




Re: Multiple Ascend connections

2002-04-03 Thread cfm

On Thu, Apr 04, 2002 at 08:13:24AM +1000, Jean-Francois Dive wrote:
 you'll then have to serailize/buffer it somewhere, probably at the web server
 side if there is only one or on another machine..
 
 JeF
 On Tue, Apr 02, 2002 at 11:46:14AM -0500, Sean Porth wrote:
  
  
  Hi, 
  
  I have a little problem that i'm hoping Debian can solve.
  
  I have a website that needs to send text to an ascend box and the ascend
  box needs to dial out into another ascend box and transfer that
  information.  I can do it one at a time via telnet, but you can only
  have one telnet session open at a time.  Was hoping someone knows of any
  software that could be used to implement this.  Have read through the
  ascend terminal server docs and can't find any information on having
  multiple sessions,  any help would be appreciated.

uucp?


-- 

Christopher F. Miller, Publisher   [EMAIL PROTECTED]
MaineStreet Communications, Inc   208 Portland Road, Gray, ME  04039
1.207.657.5078 http://www.maine.com/
Content/site management, online commerce, internet integration, Debian linux


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




apache BASIC authentication w/large userbase

2002-04-03 Thread Jeff S Wheeler

I have a customer who requires BASIC authentication for their site. 
They have a fair amount of traffic as well as a very quickly growing
userbase.  They were on mod_auth_mysql before, but with hundreds of
apache children that is not very practical.

I suggested a change to a signed-session-cookie type system, but they
would not go for that because apparently a disproportionate number of
their end-users disable cookies in their web browser.  Stupid media
privacy paranoia.

The userbase is presently around 100K and growing 5K/day or so.  They
were having things go so slowly that users could not login.  In the
short term we replaced mod_auth_mysql with an apache module I whipped up
to send requests out via UDP to a specified host/port, and wait for a
reply (with a 3 second timeout).  Then I hacked out a quick Perl program
to handle those requests, hit mysql for actual user/password info, and
to cache the user information in ram for the duration of the daemon's
lifetime.

Obviously this won't work forever without a serious change to my caching
strategy, but before I put more work into this mechanism, what do other
folks on the list do for high-traffic, large-userbase BASIC authen?  I
know it's a poor limitation but *shrug* the customer knows their needs.

I figured DBM would be sluggish, and the customer already tried text
files, but moved to mod_auth_mysql when that ran out of steam.

Your Input Is Appreciated.

-- 
Jeff S Wheeler   [EMAIL PROTECTED]
Software DevelopmentFive Elements, Inc
http://www.five-elements.com/~jsw/



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




Re: Software Raid on root/boot, Woody

2002-04-03 Thread Eduard Bloch

#include hallo.h
Jason Lim wrote on Thu Mar 21, 2002 um 05:28:22PM:
 Don't we all wish there were these floppies... just like the ones Redhat
 has.
 
 Oh well... Debian's one big weakness that I see is in the installation
 procedure. No easy for newbies, not flexible for power-users.

Same FUD again and again...

Woody's BFs have been improved much. And power-users do not need a GUI
to setup Raid. 

Gruss/Regards,
Eduard.
-- 
Wenn ich einem Schwein eine RedHat-CD um den Hals binde und es trete 
kann man sagen, dass KDE  Co. auch ohne Ram schnell laufen. 
--Robin S. Socha in de.comp.os.unix.linux.newusers--



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




Re: Is mysql 3.2x stable enough for HA requirement?

2002-04-03 Thread Patrick Hsieh

Hello Jean-Francois Dive [EMAIL PROTECTED],

I have no problem with the robustness of PostgresSQL.
However, does PostgreSQL have built-in replication? If not, how do I
implement high-available PostgreSQL clusters?

In addition, since InnoDB has been stable in MySQL-3.23.49, is InnoDB
ready for production? Is there anyone having very bad experience about
InnoDB?



On Thu, 4 Apr 2002 08:16:29 +1000
Jean-Francois Dive [EMAIL PROTECTED] wrote:

 i totally agree. I used postgres in prod in several cases and it never
 fall, got stucked or anything. Especially if you need transaction, i think
 postgres is the way to go.., otherwise, text files is a very solid approach
 ;) 
 
 JeF
 
 On Mon, Apr 01, 2002 at 07:20:02PM +1200, Dave Watkins wrote:
  Hi Patrick
  
  MySQL replication is only one way in 3.2x so all writes have to be sent to 
  the master server, but the reads can be done from the slaves. If you loose 
  a slave then no big deal round robin DNS alone should take care of that 
  with very little impact, but if you loose the master then you can't perform 
  any writes until it's back up and running.
  
  If you can't live with the risk of data loss then question 2 is really 
  irrelevent, and so if most of question 3. InnoDB is the only transaction 
  capable DB format MySQL supports so even if it is slower, what choice do 
  you have? The only question left is: Is it reliable enough for a production 
  environment? Usually when faced with that question I use PostgreSQL.
  
  Dave
  
  At 14:23 1/04/2002 +0800, Patrick Hsieh wrote:
  Hello,
  
  I am planing to have some woody with mysql-server running on a
  mission-critical environment. My criteria is:
  
  
  1. HA requirement:
  By using mysql built-in replication, I'd like to have a load-balancing
  and fail-over mysql clusters
  
  2. minimal data loss risk
  How much can mysql 3.2x guarentee the minimization of data loss?
  
  3. InnoDB and MyISAM impact on performance and management?
  Since we need transaction, InnoDB is the only choice. Is there any
  performance or management impact between InnoDB and MyISAM?
  Is InnoDB reliable enough for productive environment?
  
  Any experience highly appreciated.
  
  
  
  --
  Patrick Hsieh [EMAIL PROTECTED]
  
  GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg
  
  
  --
  To UNSUBSCRIBE, email to [EMAIL PROTECTED]
  with a subject of unsubscribe. Trouble? Contact 
  [EMAIL PROTECTED]
  
  
  -- 
  To UNSUBSCRIBE, email to [EMAIL PROTECTED]
  with a subject of unsubscribe. Trouble? Contact 
  [EMAIL PROTECTED]
  
 
 -- 
 - Jean-Francois Dive
 -- [EMAIL PROTECTED]

-- 
Patrick Hsieh [EMAIL PROTECTED]

GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg



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




Re: apache BASIC authentication w/large userbase

2002-04-03 Thread Craig Sanders

On Wed, Apr 03, 2002 at 06:35:22PM -0500, Jeff S Wheeler wrote:
 I have a customer who requires BASIC authentication for their site.
 They have a fair amount of traffic as well as a very quickly growing
 userbase.  They were on mod_auth_mysql before, but with hundreds of
 apache children that is not very practical.

 [...]

 The userbase is presently around 100K and growing 5K/day or so.  They
 were having things go so slowly that users could not login.  

my rule of thumb is:

any site that requires 1000 username:password pairs uses AuthUserFile
and plain text .htpasswd files.  any larger site uses AuthDBUserFile,
with username:password pairs in a hashed db (which is generated from the
plain text file).  a hashed db is ideally suited to this task, it's a
simple key/value (i.e. username/password) fast, indexed lookup.

using AuthDBUserFile is a lot faster, and a lot less overhead (memory,
file handles, etc) than the mysql or pgsql authentication modules.

apache comes with a program called dbmmanage which can be used to manage
hashed db files.  see the man page for more details.  it's pretty slow,
though, because it's a general purpose tool.  if all you need to do is
convert a plain text .htpasswd file into a corresponding .db file then a
5-10 line perl script could do the job many times faster.

e.g. something like:

#! /usr/bin/perl

use DB_File;
$filename=passwd.db;

# create the .db in a temporary file and rename it when it's done.
# rename is an atomic operation.
tie %passwd, 'DB_File', $filename.tmp, O_RDWR|O_CREAT, 0644, $DB_HASH ;

while () {
chomp ;
($key,$value) = split /:/;
$passwd{$key} = $value;
};

# untie the handle, close the file and flush all records to disk.
untie %passwd;

# move the .db file into place.  
rename $filename.tmp, $filename;



on a busy P3-450 webserver, this script takes about 14 seconds to
convert a .htpasswd file with 35,000 entries into a hashed db file.
apache's dbmmanage takes over 90 seconds to do the same job.


craig

-- 
craig sanders [EMAIL PROTECTED]

Fabricati Diem, PVNC.
 -- motto of the Ankh-Morpork City Watch


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




Re: Is mysql 3.2x stable enough for HA requirement?

2002-04-03 Thread Raúl Alexis Betancort Santana

El Thu, Apr 04, 2002 at 08:58:50AM +0800, Patrick Hsieh escribió:
 Hello Jean-Francois Dive [EMAIL PROTECTED],
 
 I have no problem with the robustness of PostgresSQL.
 However, does PostgreSQL have built-in replication? If not, how do I
 implement high-available PostgreSQL clusters?

 Umm, AFAIK, 7.X series of PostgreSQL have built-in support for table
replication, check de features page at their site to confirm.

 No matter if native supported or not .. there are some *load
balancing* daemons around Inet, that let you setup a group of psql
servers. Time ago I worked with one of that daemons and did this
config:

 Node A:Node B: Node 
C: Node D:
 psql   psql   
 psqlpsql
 Daemon setup:  Daemon Setup:   Daemon Setup:   Daemon Setup:
Rep. to B   Rep. to A   Rep. 
to A   Rep. to A
Rep. to C   Rep. to C   Rep. 
to B   Rep. to B
Rep. to D   Rep. to D   Rep. 
to D   Rep. to C

 It worked, but it's a big problem to have them perfecly in sync,
because if you use RR at the dns level to do another *load balancing*
task, uff, get harder to sync, beleive me.

 The best, if you target is HA and not Load Balancing is this one the
same as above, but not doing DNS RR, instead, DNS failover, if master
fails, slave get on running. Easier to keep in sync, because all the
sql statements goes from Master to Slaves, if master goes down, one of
the slaves becomes master and all contine running. In this aproach, a
*faster* solution is to do IP takeover, if master an slaves are on the
same subnet.

 Best Regards
-- 
   _   _
  // Raúl A. Betancort Santana/ A Dream is an answer to  __   \\   
 // [EMAIL PROTECTED] // question that we don't know  (oo)   \\  
// Dimensión Virtual S.L.   //  how to ask. / \/ \  //  
\ A Linux Solution Provider   /   `V__V' /   



msg05994/pgp0.pgp
Description: PGP signature


OFFTOPIC: LDAP AND SERVICES ISP

2002-04-03 Thread Ángel Carrasco
Title: Mensaje



Dear 
Sris:



I have to begin to 
design and to implement Services ISP as Web, FTP accounts, Email Services, Bind 
and others.
Iuse 
debian.

Do you know if 
exists any documentation or guide or similar to implement these services using 
LDAP or other systems?

What do you 
recommend me about the system, LDAP or MySQL or...?


Thank you very 
much.


Very best 
regards,

Ángel Carrasco





Re: apache BASIC authentication w/large userbase

2002-04-03 Thread Stephane Bortzmeyer

On Wed, Apr 03, 2002 at 06:35:22PM -0500,
 Jeff S Wheeler [EMAIL PROTECTED] wrote 
 a message of 39 lines which said:

 would not go for that because apparently a disproportionate number of
 their end-users disable cookies in their web browser.  Stupid media
 privacy paranoia.

You are wrong.
 
 short term we replaced mod_auth_mysql with an apache module I whipped up
 to send requests out via UDP to a specified host/port, and wait for a
 reply (with a 3 second timeout).  Then I hacked out a quick Perl program
 to handle those requests, hit mysql for actual user/password info, and

So you reinvented LDAP :-)

apt-get install libapache-auth-ldap 

A typical .htaccess:

AuthType Basic
AuthName LDAP@Netaktiv
AuthLDAPURL 
ldap://ldap.netaktiv.com/ou=People,dc=netaktiv,dc=com?uid?sub?(objectClass=*)
require valid-user



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




Re: OFFTOPIC: LDAP AND SERVICES ISP

2002-04-03 Thread Stephane Bortzmeyer

On Thu, Apr 04, 2002 at 06:15:18AM +0200,
 Ángel Carrasco [EMAIL PROTECTED] wrote 
 a message of 103 lines which said:

 Do you know if exists any documentation or guide or similar to implement
 these services using LDAP or other systems?

Documentation is scattered. You'll have to spend time digging in.
  
 What do you recommend me about the system, LDAP or MySQL or...?

You should first write down more requirments. The question is too
complex for a simple answer.







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