* This is the modus mailing list *
Hello Suneel,
I just went back and looked at the official script that creates the
SQL2000 quarantine database to see if we were missing anything. I am
going to need to rebuild our MySQL database to include the additional
indexes that the script creates. While I had the proper tables; I only had
the primary key and the foreign key, so maybe by having the additional
indexes it will change the results we are having. I'll let you know what
we find once I have made it exactly exact :-) with tables and indexes.
Thanks.
Lewis
----- Original Message -----
From: "Lewis Watson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 14, 2003 10:07 AM
Subject: [Modus] The Quarantine and MySQL Revisited
> * This is the modus mailing list *
>
> Hi Suneel,
> I'm so glad you asked :-) Below is a copy from the MySQL query log when
> Modus attempts to connect.
>
> 031114 11:01:35 27 Connect [EMAIL PROTECTED] on Vircom
> 27 Field List TBLMSGCATALOG
> 27 Quit
>
> While this is happening Modus gives a cannot connect to the database
> error. Hmm, I think it's connecting just fine but Modus is not getting
the
> response it's looking for so it fails.
>
> I would really like to see it work and technically based on what we have
> discussed it should be able to work but some it looks as if some
> preliminary checking done by Modus may keep this from happening unless
> it's process is changed. Also, it appears that Modus continues to run
this
> same command every 30 seconds, looking for SQL and the proper response
> before it begins using it as the quarantine.
>
> Any ideas at all short of asking Vircom to please change this behavior
:-)
> Thanks.
> Lewis
>
>
>
>
> ----- Original Message -----
> From: "Suneel Jhangiani" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, November 13, 2003 6:45 AM
> Subject: [Modus] The Quarantine and MySQL Revisited
>
>
> * This is the modus mailing list *
>
> Can you see if Modus is actually communicating with the MySQL server? If
> so you can analyze the requests made to see if those are causing the
> problems.
>
> ---
> "Nearly everything you read signed "from God" is just somebody putting
> their words in My mouth." - God
>
>
> (--------------------------------) {((((((
> ( Suneel Jhangiani ) /_ _ )
> ( Technical Director ) ( . . )
> ( Inter-Computer Technology Ltd. ) ( / )
> (----------------------------------oOOo------------oOOo----)
> ( 40 James Street Tel: +44 (0) 20 7486 9601 )
> ( London W1U 1EU Fax: +44 (0) 7050 678 978 )
> ( United Kingdom Email: [EMAIL PROTECTED] )
> ( Website: http://www.inctech.com )
> (----------------------------------------------------------)
>
>
>
>
> -----Original Message-----
> From: Lewis Watson [mailto:[EMAIL PROTECTED]
> Sent: 12 November 2003 18:18
> To: [EMAIL PROTECTED]
>
> * This is the modus mailing list *
>
> Hi Lapo,
> I am running MySQL ODBC 3.51 Driver DSN and 4.0.14 MySQL. The ODBC
> connection tests successfully and is actually the same one I use for POP
> Authentication (secondary DSN) successfully.
>
> Also, I used INNODB table type with the same table/index/foreign key
> structure as the M-soft quarantine DB. Please let me know of your
> progress
> if you begin attempting this too.
>
> It won't even begin to work. I wonder what checks Modus makes when first
> attempting to connect.
> Thanks,
> Lewis
>
>
>
> ----- Original Message -----
> From: "Lapo Nustrini" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, November 12, 2003 12:05 PM
> Subject: [Modus] The Quarantine and MySQL Revisited
>
>
> > * This is the modus mailing list *
> >
> > What version of MySQL are you running?
> > Also, what version of the MyODBC driver?
> >
> > I don't really have any ideas at this stage, but I'm quite keen to see
> > it work with MySQL myself...
> > Now that spam is no longer a major issue, I should have some time to
> > setup a test system and try getting Modus to talk to a MySQL or
> > PostgreSQL server.
> >
> > Thanks,
> > Lapo
> >
> >
> >
> >
> > On Wednesday, November 12, 2003, at 09:13 AM, Lewis Watson wrote:
> >
> > > * This is the modus mailing list *
> > >
> > > Hello,
> > > When we tried to test the Quarantine with MySQL Modus would not
> even
> > > recognize the connection to MySQL. It just complained about the
> > > connection
> > > settings. I double checked the connection settings and still no
> luck.
> > > We
> > > restarted the modusadm service several times with the same results.
> > > Here's
> > > the log
> > >
> > > ---- MODUSADM log entry made at 11/12/2003 10:32:28
> > > Mail Store error [0xE00E03E9]:
> > > ---- MODUSADM log entry made at 11/12/2003 10:32:58
> > > Mail Store error [0xE00E0032]:
> > > ---- MODUSADM log entry made at 11/12/2003 10:32:58
> > > Mail Store error [0xE00E03E9]:
> > > ---- MODUSADM log entry made at 11/12/2003 10:32:58
> > > Mail Store error [0xE00E03E9]:
> > >
> > > Any help with be greatly appreciated.
> > > Thanks.
> > > Lewis
> > >
> > >
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: "Suneel Jhangiani" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Monday, November 10, 2003 7:45 AM
> > > Subject: [Modus] The Quarantine and MySQL Revisited
> > >
> > >
> > > * This is the modus mailing list *
> > >
> > > Cascading Integrity is the only thing holding you back, and if the
> > > latest version does include this ability it shouldn't be a problem.
> I
> > > think the main reason is that Vircom only issues a delete from one
> off
> > > the tables and expects the records to be removed from both.
> > >
> > > Also, someone on this list wrote some triggers for MS SQL 7.0 to
> > > accomplish the same thing and this might be possible with MySQL (I'm
> > > not
> > > sure if MySQL supports Triggers).
> > >
> > > ---
> > > Semper Ubi Sub Ubi. - Always wear Underwear.
> > >
> > >
> > > (--------------------------------) {((((((
> > > ( Suneel Jhangiani ) /_ _ )
> > > ( Technical Director ) ( . . )
> > > ( Inter-Computer Technology Ltd. ) ( / )
> > > (----------------------------------oOOo------------oOOo----)
> > > ( 40 James Street Tel: +44 (0) 20 7486 9601 )
> > > ( London W1U 1EU Fax: +44 (0) 7050 678 978 )
> > > ( United Kingdom Email: [EMAIL PROTECTED] )
> > > ( Website: http://www.inctech.com )
> > > (----------------------------------------------------------)
> > >
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Lewis Watson [mailto:[EMAIL PROTECTED]
> > > Sent: 10 November 2003 06:42
> > > To: [EMAIL PROTECTED]
> > >
> > > * This is the modus mailing list *
> > >
> > > Also, MySQL 4.0.16 (latest production release) has foreign key
> > > capability
> > > which allows cascading deletes. So is there anything else? If not
> then
> > > perhaps there will not be any other potential problems.
> > > Thanks,
> > > Lewis
> > >
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: "Lewis Watson" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Monday, November 10, 2003 12:20 AM
> > > Subject: [Modus] The Quarantine and MySQL Revisited
> > >
> > >
> > >> * This is the modus mailing list *
> > >>
> > >> I have a question regarding the Quarantine and MySQL. Can someone
> > > (Suneel?
> > >> :-) please explain what functionality is needed that may keep MySQL
> > > from
> > >> being used. Also, I remember one of the issues being cascading
> > > deletions
> > >> ( cascading referential integrity constraints ). Is this the only
> > >> potential problem that is known or are there others as well? I am
> > > about
> > > to
> > >> test on a development machine but I would like to use any current
> > >> knowledge already established.
> > >> Thanks.
> > >> Lewis
> > >>
> > >>
> > >>
> > >> **
> > >> To unsubscribe, send an Email to: [EMAIL PROTECTED]
> > >> with the word "UNSUBSCRIBE" in the body or subject line.
> > >>
> > >
> > >
> > >
> > > **
> > > To unsubscribe, send an Email to: [EMAIL PROTECTED]
> > > with the word "UNSUBSCRIBE" in the body or subject line.
> > >
> > >
> > >
> > > **
> > > To unsubscribe, send an Email to: [EMAIL PROTECTED]
> > > with the word "UNSUBSCRIBE" in the body or subject line.
> > >
> > >
> > > **
> > > To unsubscribe, send an Email to: [EMAIL PROTECTED]
> > > with the word "UNSUBSCRIBE" in the body or subject line.
> > >
> >
> >
> > **
> > To unsubscribe, send an Email to: [EMAIL PROTECTED]
> > with the word "UNSUBSCRIBE" in the body or subject line.
>
>
> **
> To unsubscribe, send an Email to: [EMAIL PROTECTED]
> with the word "UNSUBSCRIBE" in the body or subject line.
>
>
>
> **
> To unsubscribe, send an Email to: [EMAIL PROTECTED]
> with the word "UNSUBSCRIBE" in the body or subject line.
>
>
> **
> To unsubscribe, send an Email to: [EMAIL PROTECTED]
> with the word "UNSUBSCRIBE" in the body or subject line.
**
To unsubscribe, send an Email to: [EMAIL PROTECTED]
with the word "UNSUBSCRIBE" in the body or subject line.
