[Dbmail] mirroring dbmail mySQL database

2004-04-28 Thread Kenneth Oncinian
Hi list, ALthough this sounds like more of an MySQL question, my knowledge in MySQL is very limited as of now so please bear with me :). In one of my server, I used the command: mysql -u root -p < sql/mysql/create_tables.mysql to create the mysql database. I would like to mirror that in one o

Re: [Dbmail] mirroring dbmail mySQL database

2004-04-28 Thread Ilja Booij
You should probably read the MySQL manual on this. There's a chapter on replication there, which might have some info on mixing InnoDB and MyISAM tables. Ilja On Wed, 2004-04-28 at 03:02, Kenneth Oncinian wrote: > Hi list, > ALthough this sounds like more of an MySQL question, my knowledge in >

RE: [Dbmail] ERROR 1067 at line 7: Invalid defaultvaluefor'alias_idnr'

2004-04-28 Thread Ilja Booij
On Tue, 2004-04-27 at 17:42, Jesse Norell wrote: > Hello, > > A fix for 1.2.x is in order, but for 2.x, having already ditched the > custom build.sh, wouldn't it make sense to ditch install-dbmail.sh too, > and just have a little smarter makefile? Use buildtools/install-sh > to put things in pl

Re: [Dbmail] mirroring dbmail mySQL database

2004-04-28 Thread Kenneth Oncinian
Thanks Ilja, Yes, I'm reading the MySQL manual at this very moment. Thanks again. regards, Kenneth Ilja Booij wrote: You should probably read the MySQL manual on this. There's a chapter on replication there, which might have some info on mixing InnoDB and MyISAM tables. Ilja On Wed, 2004-0

SV: [Dbmail] mirroring dbmail mySQL database

2004-04-28 Thread Mikael Syska
Hey Kenneth Could be great if you posted the solution when/if you find it Soon I will also be looking for the same to replicate the mysql db. Regards Mikael > -Oprindelig meddelelse- > Fra: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] På vegne af Kenneth Oncinian > Sendt: 28. apri

Re: [Dbmail] SHA1 encryption

2004-04-28 Thread Ilja Booij
> I thought the -dev list might be the right place, but I am still unable > to join > the dbmail-dev list. I think I mentioned it already in my very first > post here, but > when I visit https://mailman.fastxs.nl/mailman/listinfo/dbmail-dev and > enter my > info, I get sent to twister.fastxs.n

Re: [Dbmail] SHA1 encryption

2004-04-28 Thread Ilja Booij
On Wed, 2004-04-28 at 09:54, Ilja Booij wrote: > > I thought the -dev list might be the right place, but I am still unable > > to join > > the dbmail-dev list. I think I mentioned it already in my very first > > post here, but > > when I visit https://mailman.fastxs.nl/mailman/listinfo/dbmail-dev

[Dbmail] ./install-dbmail.sh

2004-04-28 Thread Jan-Kees Fels
Hi there, Yesterday, I installed successfully dbmail on freebsd 5. dbmail 1.2.7 was a fix to the problem I encountered as shown below. Today, I am doing the install over again, this time on the production version of freebsd (4.9). Although, I am using dbmail 1.2.7, I can't seem to get past th

Re: SV: [Dbmail] mirroring dbmail mySQL database

2004-04-28 Thread Kenneth Oncinian
Hi Mikael, Ok :) Although I dont know MySQL much...im still experimenting right now. Mikael Syska wrote: Hey Kenneth Could be great if you posted the solution when/if you find it Soon I will also be looking for the same to replicate the mysql db. Regards Mikael -Oprindelig meddelels

Re: [Dbmail] SHA1 encryption

2004-04-28 Thread Ilja Booij
On Tue, 2004-04-27 at 18:07, Jesse Norell wrote: > Hello, > > > > I've managed to add the sha1 algorithm as implemented in the OpenSSL > > > library to my dbmail, along with the '{sha1:}' and '{sha1}' password > > > prefixes in dbmail-adduser for mode "a". (I don't have SHA support in > > > mo

SV: SV: [Dbmail] mirroring dbmail mySQL database

2004-04-28 Thread Jocke
There is no problem mirroring databases between innoDB and MyISAM because all the really happens is that the slave runs the same queries as the master does. When replicating from innodb to MyISAM you will have no problem at all and you often gain some speed, which means that you have the safety of

Re: SV: SV: [Dbmail] mirroring dbmail mySQL database

2004-04-28 Thread Christian G. Warden
On Wed, Apr 28, 2004 at 11:32:23AM +0200, Jocke wrote: > If you want to set it all up, just make sure you start an update-log on your > master server and connect the slave to it.. then if you're running mysql 4.0 > or higher just issue the command "LOAD DATA FROM MASTER;" and the slave will > becom

[Dbmail] Small script if you want to know the users with multiple alias

2004-04-28 Thread Jacques Beaudoin
Hi all I wanted to know the users with multiple alias so i wrote this small script Maybe it can be of some help mysql -s -u root -e "SELECT deliver_to from dbmail.aliases WHERE deliver_to not like '[EMAIL PROTECTED]' GROUP BY deliver_to HAVING count(deliver_to)>1" > /tmp/001 while read CHOICE

RE: [Dbmail] ./install-dbmail.sh

2004-04-28 Thread Jan-Kees Fels
Hi, I believe you are right. I can't test right know, but I believe I got the bash 1 version. That also explain why I could successfully install it on the other machine, cause I had bash 2 for sure on the other. Thanks. Dbmail rocks! -Original Message- From: [EMAIL PROTECTED] [mailto:[EM

[Dbmail] mail forwarding

2004-04-28 Thread Leonel Nunez
Hello : All is working perfect! I have an email account [EMAIL PROTECTED] and I need to forward all the mail to [EMAIL PROTECTED] But keep a copy on [EMAIL PROTECTED] How can I do it ? Thanks leonel

Re: [Dbmail] mail forwarding

2004-04-28 Thread Jeff Brenton
Hello Leonel, LN> I have an email account LN> [EMAIL PROTECTED] LN> and I need to forward all the mail to LN> [EMAIL PROTECTED] LN> But keep a copy on [EMAIL PROTECTED] LN> How can I do it ? Set up a second alias for [EMAIL PROTECTED] that forwards to [EMAIL PROTECTED] . You can have multiple a

Re: [Dbmail] mail forwarding

2004-04-28 Thread Leonel Nunez
On Wed, 2004-04-28 at 14:50, Jeff Brenton wrote: > Hello Leonel, > > LN> I have an email account > LN> [EMAIL PROTECTED] > LN> and I need to forward all the mail to > LN> [EMAIL PROTECTED] > LN> But keep a copy on [EMAIL PROTECTED] > > LN> How can I do it ? > > Set up a second alias for [EMAIL

Re: [Dbmail] mail forwarding

2004-04-28 Thread Jesse Norell
> dbmail-adduser -f [EMAIL PROTECTED] [EMAIL PROTECTED] > > failed check log for details > > and in the log file: > > ERROR duplicate key violates unique contraint "aliases_alias_idx" Drop that unique key. I assume that's something you did yourself, not something from dbmail create script