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