Hi!
I am installing FRED for the first time here. Got so far as to install the latest database fred-db-2.3.2 into pgsql 8.4. Here's the errors I get. Anybody who has seen this before?
...
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "request_property_value_pkey" for table "request_property_value"
setval
--------
1406
(1 row)
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: function tr_request(integer, timestamp without time zone, timestamp without time zone, inet, integer, integer, integer, character varying, boolean) does not exist
LINE 1: ...unction AS ON INSERT TO request DO INSTEAD SELECT tr_request...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
ERROR: function tr_request_data(timestamp without time zone, integer, boolean, integer, text, boolean) does not exist
LINE 1: ...on AS ON INSERT TO request_data DO INSTEAD SELECT tr_request...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
ERROR: function tr_request_property_value(timestamp without time zone, integer, boolean, integer, integer, integer, text, boolean, integer) does not exist
LINE 1: ...NSERT TO request_property_value DO INSTEAD SELECT tr_request...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
ERROR: function tr_session(integer, character varying, timestamp without time zone, timestamp without time zone, character varying) does not exist
LINE 2: DO INSTEAD SELECT tr_session ( NEW.id, NEW.name, NEW.login_d...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
ERROR: language "plpgsql" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
Hello,
I was wondering when domain expires, and leaves behind contact and
nssets, are they deleted after some time?
Is there any messages email/epp generated to registrar on these events ?
--
Georg Kahest
Süsteemiadministraator
Eesti Interneti SA • Silikaltsiidi 3a, 11216 Tallinn
Tel 727 1016 • Faks 727 1010 • Mobiil 58 50 35 64
www.eestiinternet.ee
Hello,
We have a problem with domain deletion and I will try to describe our
problem.
Domain expired at 2010-10-08 and an expiration registration protection
came to an end (in our system it is set to 90 days). After this period
FRED for an epp query:
<?xml version="1.0" encoding="UTF-8"?>
<epp xmlns="urn:ietf:params:xml:ns:epp-1.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="urn:ietf:params:xml:ns:epp-1.0 epp-1.0.xsd">
<command>
<poll op="req"/>
<clTRID>1293530719893#17</clTRID>
</command>
</epp>
should generate an epp response similar to the one below:
<?xml version="1.0" encoding="UTF-8"?>
<epp xmlns="urn:ietf:params:xml:ns:epp-1.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="urn:ietf:params:xml:ns:epp-1.0 epp-1.0.xsd"><response>
<result code="1301">
<msg>Command completed successfully; ack to dequeue</msg>
</result>
<msgQ count="40" id="3296">
<qDate>2010-12-23T02:30:01+01:00</qDate>
<msg>
<domain:delData
xmlns:domain="http://www.nic.cz/xml/epp/domain-1.3"
xsi:schemaLocation="http://www.nic.cz/xml/epp/domain-1.3 domain-1.3.xsd">
<domain:name>mytestdomain.xy.zv</domain:name> <<<< this is the
most important part of the message for me
<domain:exDate>2010-09-23</domain:exDate>
</domain:delData>
</msg>
</msgQ>
<trID><clTRID>1293530719893#17</clTRID><svTRID>ccReg-0000485086</svTRID></trID>
</response>
</epp>
In most cases it worked fine and there were no problems with this, but
sometimes it looks like that the response containing information about
domain deletion had not been generated and it is a big problem for us.
I had looked at the FRED database and I found an action_xml table which
contains all conversations between FRED and a software which
communicates with it by epp protocol. Searching performed on this table
gave no satisfied results.
Is it possible that in case of:
* hardware problems
* system restart
* unexpected service stopped
or any other unpredictable reason, a queue which contains information
about event such as domain deletion is being cleaned and there is no way
to restore these information?
Does the queue is stored only in memory or it is persisted on filesystem
or in db?
Does an epp request with command op='req' is the only way to get an
information about domain deletion or there are some other ways to obtain
this kind of information?
Thanks and best regards.
Michal Pochwala
