[freeipdb-users] RIF: server error

[Giaretta Gerardo]

Thanks,
I put the link and now it's ok.
But I have another problem:
it seems admin.cgi doesn't load completly (I can see only the "Add a
specific Block" part). Probably it's a PostgreSQL error, but I'm not
sure.
During the installation I had this output (there's an error): 
 
$ cat SQL/Data_Types.txt | /usr/local/pgsql/bin/psql freeipdb
NOTICE:  CREATE TABLE will create implicit sequence 'regiontable_id_seq'
for SERIAL column 'regiontable.id'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
'regiontable_id_key' for table 'regiontable'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
'regiontable_name_key' for table 'regiontable'
CREATE
GRANT
GRANT
NOTICE:  CREATE TABLE will create implicit sequence 'ratable_id_seq' for
SERIAL column 'ratable.id'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
'ratable_id_key' for table 'ratable'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
'ratable_name_key' for table 'ratable'
CREATE
GRANT
GRANT
CREATE
GRANT
ERROR:  relation "locktable_id_seq" not found
NOTICE:  CREATE TABLE will create implicit sequence 'ipdb_id_seq' for
SERIAL column 'ipdb.id'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 'ipdb_id_key'
for table 'ipdb'
CREATE
GRANT
GRANT

If I try to check the db consistency:
 
tevere# perl ipdb_ck.pl
DBI->connect(dbname=freeipdb;host=127.0.0.1;port=5432) failed: could not
connect to server: Connection refused at ipdb_ck.pl line 17
 /*--------------------- IP Database Consistency Check
---------------------*/
Can't call method "prepare" on an undefined value at ipdb_ck.pl line 32.

Any hint? Really thank you and sorry if these are newbie questions ...
:-) 
 
Bye
 
Gerardo
 
 
 

        -----Messaggio originale----- 
        Da: Hugh Blandford 
        Inviato: sab 18/05/2002 2.09 
        A: Giaretta Gerardo 
        Cc: 
        Oggetto: Re: [freeipdb-users] server error
        
        

        Hi,
        
        you will probably discover that the scripts are looking for perl
in the
        wrong place (been there done that :-))
        
        either put a link in:
        
        ln -s /usr/bin/perl /usr/local/bin/perl
        
        or change the location of perl in all the scripts.
        
        Regards,
        
        Hugh
        
        ----- Original Message -----
        From: "Giaretta Gerardo" <[EMAIL PROTECTED]>
        To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
        Sent: Thursday, April 18, 2002 12:44 AM
        Subject: [freeipdb-users] server error
        
        
        > Hi Ben! Hi lists!
        >
        > I tried to install FreeIPdb on FreeBSD 4.3 and Apache 2.0.35.
        > It seems that everything went ok during installation
procedure, but when
        > I tried to get admin.cgi page this error brings up:
        >
        > Error message:
        >
        > Premature end of script headers:
        > /usr/local/apache2/cgi-bin/freeipdb/admin.cgi
        >
        > Any hint?
        >
        > Thank you in advance,
        >
        > Gerardo
        >
        >
        >