* 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.
