10 Čen
2009
10 Čen
'09
7:32
when browsing november 2008 mail archive, i found that my problem might be
related to postgresql like Julian had but the error message
function create_tmp_table(unknown) does not exist at character 8
aside from that it only happens only 5 times around 11 AM
when i try again at 12 PM
REG-UMAR(a)192.168.56.6> create_contact CID:CA000001 'Umarzuki'
umarzuki@gmail123 Beranang 43700 MY
Do you really want to send this command to the server? (y/N): y
Return code: 2400
Reason: Command failed
Still same messages
grep exist /var/log/postgresql/postgresql-8.3-main.log
2009-06-09 11:40:28 MYT ERROR: function create_tmp_table(unknown) does not
exist at character 8
2009-06-09 11:40:36 MYT ERROR: function create_tmp_table(unknown) does not
exist at character 8
2009-06-09 11:40:40 MYT ERROR: function create_tmp_table(unknown) does not
exist at character 8
2009-06-09 11:40:43 MYT ERROR: function create_tmp_table(unknown) does not
exist at character 8
2009-06-09 11:40:49 MYT ERROR: function create_tmp_table(unknown) does not
exist at character 8
but that was yesterday
even the few log messages
tail -25 /var/log/postgresql/postgresql-8.3-main.log
2009-06-10 11:02:25 MYT FATAL: terminating connection due to administrator
command
2009-06-10 11:02:25 MYT LOG: autovacuum launcher shutting down
2009-06-10 11:02:25 MYT LOG: shutting down
2009-06-10 11:02:25 MYT LOG: database system is shut down
2009-06-10 11:02:35 MYT LOG: could not load root certificate file
"root.crt": no SSL error reported
2009-06-10 11:02:35 MYT DETAIL: Will not verify client certificates.
2009-06-10 11:02:35 MYT LOG: database system was shut down at 2009-06-10
11:02:25 MYT
2009-06-10 11:02:35 MYT LOG: autovacuum launcher started
2009-06-10 11:02:35 MYT LOG: database system is ready to accept connections
2009-06-10 11:02:35 MYT LOG: incomplete startup packet
2009-06-10 11:09:25 MYT LOG: incomplete startup packet
2009-06-10 11:09:25 MYT LOG: received fast shutdown request
2009-06-10 11:09:25 MYT LOG: aborting any active transactions
2009-06-10 11:09:25 MYT FATAL: terminating connection due to administrator
command
2009-06-10 11:09:25 MYT FATAL: terminating connection due to administrator
command
2009-06-10 11:09:25 MYT LOG: autovacuum launcher shutting down
2009-06-10 11:09:25 MYT FATAL: terminating connection due to administrator
command
2009-06-10 11:09:25 MYT LOG: shutting down
2009-06-10 11:09:25 MYT LOG: database system is shut down
2009-06-10 11:10:06 MYT LOG: could not load root certificate file
"root.crt": no SSL error reported
2009-06-10 11:10:06 MYT DETAIL: Will not verify client certificates.
2009-06-10 11:10:06 MYT LOG: database system was shut down at 2009-06-10
11:09:25 MYT
2009-06-10 11:10:06 MYT LOG: autovacuum launcher started
2009-06-10 11:10:06 MYT LOG: database system is ready to accept connections
2009-06-10 11:10:06 MYT LOG: incomplete startup packet
--
Regards,
Umarzuki Mochlis
http://gameornot.net
10 Čen
10 Čen
17:05
Umarzuki Mochlis escribió:
when browsing november 2008 mail archive, i found that
my problem
might be related to postgresql like Julian had but the error message
function create_tmp_table(unknown) does not exist at character 8
aside from that it only happens only 5 times around 11 AM
when i try again at 12 PM
REG-UMAR(a)192.168.56.6 <mailto:REG-UMAR@192.168.56.6>> create_contact
CID:CA000001 'Umarzuki' umarzuki@gmail 123 Beranang 43700 MY
Do you really want to send this command to the server? (y/N): y
Return code: 2400
Reason: Command failed
Seems like you don't have the PostgreSQL Perl language package
installed. In my case (Ubuntu 8.04):
/root@mguerra:~# dpkg -l | grep postgresql-plperl
ii postgresql-plperl-8.3 8.3.7-0ubuntu8.04.1
PL/Perl procedural language for PostgreSQL 8/
if you have it installed, create the language using the PostgreSQL
command line.
Best regards.
Mario
18:40
2009/6/10 Mario Guerra <mguerra(a)nic.cr>
Umarzuki Mochlis escribió:
Did you mean like in http://www.lghost.ru/docs/postgres/postgres/plperl.html
# createlang plperl fred
when browsing november 2008 mail archive, i found
that my problem
might be related to postgresql like Julian had but the error message
function create_tmp_table(unknown) does not exist at character 8
aside from that it only happens only 5 times around 11 AM
when i try again at 12 PM
REG-UMAR(a)192.168.56.6 <mailto:REG-UMAR@192.168.56.6>> create_contact
CID:CA000001 'Umarzuki' umarzuki@gmail 123 Beranang 43700 MY
Do you really want to send this command to the server? (y/N): y
Return code: 2400
Reason: Command failed
Seems like you don't have the PostgreSQL Perl language package
installed. In my case (Ubuntu 8.04):
/root@mguerra:~# dpkg -l | grep postgresql-plperl
ii postgresql-plperl-8.3 8.3.7-0ubuntu8.04.1
PL/Perl procedural language for PostgreSQL 8/
if you have it installed, create the language using the PostgreSQL
command line.
Best regards.
Mario
_______________________________________________
fred-users mailing list
fred-users(a)lists.nic.cz
https://lists.nic.cz/mailman/listinfo/fred-users
--
Regards,
Umarzuki Mochlis
http://gameornot.net
18:51
Umarzuki Mochlis escribió:
Did you mean like in
http://www.lghost.ru/docs/postgres/postgres/plperl.html
# createlang plperl fred
Exactly. At least that happened to me and that fixed the problem.
Regards.
Mario
19:16
2009/6/11 Mario Guerra <mguerra(a)nic.cr>
Umarzuki Mochlis escribió:
Maybe my situation is a bit different but thanks anyway
server:~# su - postgres -c "createlang plperl fred"
createlang: language "plperl" is already installed in database "fred"
on client
-------------
REG-UMAR(a)192.168.56.6> create_contact CID:ID0001 umar a(a)b.com 123 KL 55100
MY
Client-side validation command:
xmllint --noout --schema "/usr/local/share/fred-client/schemas/all.xsd" -
Do you really want to send this command to the server? (y/N): y
Client-side validation command:
xmllint --noout --schema "/usr/local/share/fred-client/schemas/all.xsd" -
Return code: 2400
Reason: Command failed
any more ideas?
Did you mean like in
http://www.lghost.ru/docs/postgres/postgres/plperl.html
# createlang plperl fred
Exactly. At least that happened to me and that fixed the problem.
Regards.
Mario
_______________________________________________
fred-users mailing list
fred-users(a)lists.nic.cz
https://lists.nic.cz/mailman/listinfo/fred-users
--
Regards,
Umarzuki Mochlis
http://gameornot.net
11 Čen
11 Čen
1:17
2009/6/11 Mario Guerra <mguerra(a)nic.cr>
Umarzuki Mochlis escribió:
-------------
REG-UMAR(a)192.168.56.6> create_contact CID:ID0001 umar a(a)b.com 123 KL 55100
MY
Client-side validation command:
xmllint --noout --schema "/usr/local/share/fred-client/schemas/all.xsd" -
Do you really want to send this command to the server? (y/N): y
Client-side validation command:
xmllint --noout --schema "/usr/local/share/fred-client/schemas/all.xsd" -
Return code: 2400
Reason: Command failed
any more ideas?
Ummm.....do you have all of your fred-server services up?. Here is how I
check that:
root@mguerra:~# ps ax
.
.
.
14258 ? Ss 0:00 /usr/sbin/cron
17548 ? Sl 25:39 */usr/bin/python /usr/local/bin/fred-pyfred*
17555 ? Ssl 0:02 */usr/sbin/fred-rifd -ORBnativeCharCodeSet
UTF-8 -ORBe*
17560 ? Ssl 0:00 /*usr/sbin/fred-pifd -ORBnativeCharCodeSet
UTF-8 -ORBe*
17567 ? Ss 0:00 postgres: fred fred 127.0.0.1(60013)
idle
17568 ? Ssl 0:00 */usr/sbin/fred-adifd -ORBnativeCharCodeSet
UTF-8 -ORB*
17574 ? Ss 0:00 postgres: fred fred 127.0.0.1(60015)
idle
17578 ? Ss 0:00 postgres: fred fred 127.0.0.1(60017)
idle
17608 ? Ss 0:07 /usr/sbin/apache2 -k start
.
.
idn:~# ps ax | grep pyfred
2221 ? Sl 0:23 /usr/bin/python /usr/local/bin/fred-pyfred
8676 pts/0 S+ 0:00 grep pyfred
idn:~# ps ax | grep rifd
2223 ? Ssl 0:00 /usr/sbin/fred-rifd -ORBnativeCharCodeSet UTF-8
-ORBendPoint giop:tcp::2222
8703 pts/0 S+ 0:00 grep rifd
idn:~# ps ax | grep pifd
2240 ? Ssl 0:00 /usr/sbin/fred-pifd -ORBnativeCharCodeSet UTF-8
-ORBendPoint giop:tcp::2223
8713 pts/0 S+ 0:00 grep pifd
idn:~# ps ax | grep adifd
2255 ? Ssl 0:00 /usr/sbin/fred-adifd -ORBnativeCharCodeSet UTF-8
-ORBendPoint giop:tcp::2224
8719 pts/0 S+ 0:00 grep adifd
.
Also, check pyfred.conf:
[General]
modules=genzone mailer filemanager techcheck
*dbuser=fred*
*dbname=fred
dbhost=localhost
dbport=5432
dbpassword=fred
.*
.
same
.
and server.conf:
##
# DATABASE
##
*[database]
host = localhost
port = 5432
name = fred
user = fred
password = fred
timeout = 2*
.
same also
.
weirdly with the same configuration on client, i can log on to the demo
server.
.
Best regards.
_______________________________________________
fred-users mailing list
fred-users(a)lists.nic.cz
https://lists.nic.cz/mailman/listinfo/fred-users
--
Regards,
Umarzuki Mochlis
http://gameornot.net
5440
days inactive
5440
days old
6 comments
2 participants
participants (2)
-
Mario Guerra -
Umarzuki Mochlis