[rsyslog-notify] Forum Thread: port number on remote DB - (Mode 'post')

[noreply at adiscon.com]

User: astaran 
Forumlink: http://kb.monitorware.com/viewtopic.php?p=24139#p24139

Message: 
----------
I'm working with a remote postgres DB and cannot write to it with a port
number.  I've tested the insert statement in the config below and it works
fine and I need to specify port 54000 with our local setup.

If I include the port, I get "no connection to server" (see below) and
absolutely nothing in a tcpdump.  Remove the port and still get no
connection to server, which is expected since no port is given and I get
some data showing in the tcpdump.  It appears that it's choking on a port
specification on the remote db.  

How does one specify a port in rsyslog?


[b:2rr13rg7]Relevant portions of the config:[/b:2rr13rg7]
------------------------------------------------------------
#rsyslog v3 config file

$ModLoad imuxsock.so    # provides support for local system logging (e.g.
via logger command)
$ModLoad imklog.so      # provides kernel logging support (previously done
by rklogd)
#$ModLoad immark.so     # provides --MARK-- message capability

# Provides UDP syslog reception
$ModLoad imudp.so
$UDPServerRun 514

$ModLoad ompgsql

$ActionFileDefaultTemplate RSYSLOG_TraditionalFileFormat

$template pgmsg,"insert into systemevents (message) values('msg')",SQL

cron.* :ompgsql:web-wxlogdb-pre01:54000,systemlog,postgres,pgpwd;pgmsg
------------------------------------------------------------

[b:2rr13rg7]When I get a cron msg as config'd above, rsyslog returns this
in a log message file yet absolutely nothing is in a tcp dump: 
[/b:2rr13rg7]
       Jan 28 00:03:02 web-wxrsyslog-pre01 rsyslogd: db error (1): no
connection to the server

[b:2rr13rg7]If I remove the ":54000" I get this in tcp dump while still
getting while still getting the error shown above (expected)[/b:2rr13rg7]
    00:05:02.333828 IP web-wxrsyslog-pre01.32782 >
web-wxlogdb-pre01.postgres: Flags [S], seq 1572670207, win 14600, options
[mss 1460,sackOK,TS val 622793476 ecr 0,nop,wscale 7], length 0
    00:05:02.334124 IP web-wxlogdb-pre01.postgres >
web-wxrsyslog-pre01.32782: Flags [R.], seq 0, ack 1572670208, win 0, length
0
    00:05:07.333866 ARP, Request who-has web-wxrsyslog-pre01 tell
web-wxlogdb-pre01, length 46
    00:05:07.333884 ARP, Reply web-wxrsyslog-pre01 is-at 00:50:56:9b:45:8e
(oui Unknown), length 28