Re: Help needed - RIPE database server


Below you can see the latest test report (the first part come from updlog.20040601, the second from acklog.20040601).
In the report you can see:
- the correct copy of e-mail sent to auto-dbm account;
- the automatic reply with the "sploiled" string.

Have you any idea????

Thanks.
Roberto

>>> time: Tue Jun  1 15:45:00 2004 MAIL UPDATE <<<

From roberto.recchia@localhost  Tue Jun  1 15:44:37 2004
Return-Path: <roberto.recchia@localhost
X-Original-To: auto-dbm@localhost
Delivered-To: auto-dbm@localhost
Received: from smtp-gw.csp.it (antares.csp.it [194.116.4.64])
       by server-qxn.qxn.it (Postfix) with ESMTP id 3387D1DC
for auto-dbm@localhost; Tue, 1 Jun 2004 15:44:37 +0200 (CEST)
Received: from 127.0.0.1 (localhost.csp.it [127.0.0.1])
       by dummy.domain.name (Postfix) with SMTP id 01FBED54D6
for auto-dbm@localhost; Tue, 1 Jun 2004 13:45:00 +0000 (GMT)
Received: from 127.0.0.1 (localhost.csp.it [127.0.0.1])
       by reinject.csp.it (Postfix) with SMTP id DB264D54D5
for auto-dbm@localhost; Tue, 1 Jun 2004 13:44:59 +0000 (GMT) Received: from andromeda.intranet.csp.it (andromeda.intranet.csp.it [192.168.68.68])
       by smtp-gw.csp.it (Postfix) with SMTP id 671A0D54D3
for auto-dbm@localhost; Tue, 1 Jun 2004 13:44:58 +0000 (GMT)
Received: (qmail 79256 invoked from network); 1 Jun 2004 13:44:58 -0000
Received: from recchia.csp.it (HELO csp.it) (130.192.64.3)
 by 0 with SMTP; 1 Jun 2004 13:44:58 -0000
Message-ID: <40BC885A.5050107@localhost
Date: Tue, 01 Jun 2004 15:44:58 +0200
From: Roberto Recchia <roberto.recchia@localhost
Organization: CSP
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: auto-dbm@localhost
Subject: E valentina paga la colazione!!!!!!
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on antares.csp.it
X-Spam-DCC: Servercave: antares.csp.it 1183; Body=2 Fuz1=2
X-Spam-Status: No, hits=-4.5 required=4.5 tests=AWL,BAYES_00,PLING_PLING
       autolearn=no version=2.63
X-Spam-Level:
Content-Transfer-Encoding: quoted-printable

password: spc-qxn
inetnum: 193.42.141.0 - 193.42.141.255
netname: SPC-NETWORK
descr: Sistema Pubblico di Connettivit=E0
country: IT
admin-c: GF1-SPC
tech-c: RR1-SPC
status: ASSIGNED PA
mnt-by: SPC-DBM-MNT
changed: roberto.recchia@localhost
source: SPC

>>> Time: Tue Jun  1 15:45:00 2004 MAIL UPDATE ACK <<<

From: csp@localhost
To: roberto.recchia@localhost
Subject: FAILED: E valentina paga la colazione!!!!!!
Reply-To: ripe-dbm@localhost



>  From:       Roberto Recchia <roberto.recchia@localhost
>  Subject:    E valentina paga la colazione!!!!!!
>  Date:       Tue, 01 Jun 2004 15:44:58 +0200
>  Reply-To:   roberto.recchia@localhost
>  Message-ID: <40BC885A.5050107@localhost


SUMMARY OF UPDATE:

Number of objects found:                   1
Number of objects processed successfully:  0
 Create:         0
 Modify:         0
 Delete:         0
 No Operation:   0
Number of objects processed with errors:   1
 Create:         0
 Modify:         0
 Delete:         0
 Syntax Errors:  1


DETAILED EXPLANATION:


***Warning: Invalid keyword(s) found: E, valentina, paga, la, colazione!!!!!!
***Warning: All keywords were ignored

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The following object(s) were found to have ERRORS:


---
Update FAILED: [inetnum] 193.42.141.0 - 193.42.141.255
***Error: Syntax error in object

inetnum:  193.42.141.0 - 193.42.141.255
netname:  SPC-NETWORK
descr:  Sistema Pubblico di Connettivit.
country:  IT
admin-c:  GF1-SPC
tech-c:  RR1-SPC
status:  ASSIGNED PA
mnt-by:  SPC-DBM-MNT
changed:  roberto.recchiPU......WL(a@localhost
***Error: Syntax error in "roberto.recchiPU......WL(a@localhost"
source:  SPC

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


For assistance or clarification please contact:
SPC Database Administration csp@localhost


Katie Petrusha wrote:

On Tue, Jun 01, 2004 at 11:23:03AM +0200, Roberto Recchia wrote:

Dear Roberto,

Please have a look at the files
log/upd/updlog.<date>
and log/ack/acklog.date

These files have to be somewhere in your installation directory for the 
database software (see ACKLOG, UPDLOG variables from your rip.config file).

Try to find your update message in there (updlog) and its reply (acklog).
Make sure that updlog contains exactly what you have sent. It seems that your 
mailing software might have spoiled your update message.
Please also make sure you send messages in the plain text format (to clearly see that 
your "changed:" line is correct.

Katie Petrusha
RIPE NCC
Hello, I'm Roberto.

Following there is the text that I sent to our DB:

password: XXXXXX
inetnum: 193.42.141.0 - 193.42.141.255
netname: SPC-NETWORK
descr: Sistema Pubblico di Connettivit?
country: IT
admin-c: GF1-SPC
tech-c: RR1-SPC
status: ASSIGNED PA
mnt-by: SPC-DBM-MNT
changed: roberto.recchia@localhost
source: SPC

The e-mail address is valid and it is in ASCII mode.
The domain name is correct, but anyway we get always the same error.
The scenario is the same also when I sent another e-mail address.
It seems that the program find the string "PU......WL(" but this string doesn't exist on text email... Which is the system/application/script used by your db to transfer object email to sintax control application?
In the Whois configuration file there are special flags to set ?

Thanks in advance.
Roberto

Shane Kerr wrote:

Valentina Bruno wrote:

Hi,
we have installed and configured a RIPE Database server for private use. We have added mntner and person objects in the database by
email and it succeeded.
When we try to add new inetnum objects the creation failed even if the syntax check is passed.
The report is:
In this case...

---
Update FAILED: [inetnum] 193.42.141.0 - 193.42.141.255
***Error: Syntax error in object

inetnum:  193.42.141.0 - 193.42.141.255
netname:  SPC-NETWORK
descr:  Sistema Pubblico di Connettivit.
country:  IT
admin-c:  GF1-SPC
tech-c:  RR1-SPC
status:  ASSIGNED PA
mnt-by:  SPC-DBM-MNT
changed:  roberto.recchia@localhost......WL(csp.it
***Error: Syntax error in "roberto.recchia@localhost......WL(csp.it"
source:  SPC

-----------------------------------------------------------

Could you help me please?
The e-mail address on the "changed:" attribute is incorrect. It must be a valid e-mail address. Is it perhaps a non-ASCII domain name here?

--
Ing. Roberto RECCHIA
Network Manager & ICT Project Engineer

CSP s.c. a r.l. _______________________________________________
Via Livorno, 60 - 10144 Torino [IT]
Roberto.Recchia@localhost
Tel. +39 011 481 5112 - Mobile +39 348 6024505
Fax +39 011 481 5001 _______________________________________________







--
Ing. Roberto RECCHIA
Network Manager & ICT Project Engineer

CSP s.c. a r.l. _______________________________________________
Via Livorno, 60 - 10144 Torino [IT]
Roberto.Recchia@localhost
Tel. +39 011 481 5112 - Mobile +39 348 6024505
Fax +39 011 481 5001 _______________________________________________