<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:΢ÈíÑźÚ
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
HI All,<BR> <BR>my Lua script using the freeswitch.dbh (ODBC) to connect to the postgresql and it works, however I find that freeswitch creates odbc connecting logs in different folders, I find two logs in the conf/autoload_configs/ 16600.log, 16603.log, and one log in the freeswitch base folder /opt/freeswitch/ 12324.log. It's really strang.<BR> <BR>How can I configure the system to put these logs in one place? <BR>and how to turn off these logs?<BR> <BR>=============snip =========================<BR>[3061185392]calling getDSNdefaults<br>conn = 0xb713ade8, PGAPI_Connect(DSN='cb', UID='conf', PWD='xxxxx')<br>[3061185392]CC_connect: entering...<br>[3061185392]sslmode=disable<br>[3061185392]original_CC_connect: entering...<br>Driver Version='08.04.0200,200912260001'<br>[3061185392]Driver Version='08.04.0200,200912260001'<br>Global Options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=65536<br> disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=0<br> text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64<br> extra_systable_prefixes='dd_;', conn_settings='' conn_encoding=''<br>[3061185392]original_CC_connect: DSN = 'cb', server = 'localhost', port = '5432', database = 'cb', username = 'conf', password='xxxxx'<br>[3061185392]connecting to the server socket...<br>[3061185392](0)(null) ERRNO=115<br>[3061185392]connection to the server socket succeeded.<br>[3061185392]sizeof startup packet = 292<br>[3061185392]sent the authentication block successfully.<br>[3061185392]gonna do authentication<br>[3061185392]read -1, global_socket_buffersize=4096<br>[3061185392]Lasterror=11<br>[3061185392]read 15, global_socket_buffersize=4096<br>[3061185392]auth got 'R'<br><BR>----snip ------<BR>[3060202352][SQLGetData][3060202352]PGAPI_GetData: enter, stmt=0xb7145ad0 icol=1<br>[3060202352] num_rows = 1<br>[3060202352] value = '1000'<br>[3060202352]**** PGAPI_GetData: icol = 0, target_type = 1, field_type = 23, value = '1000'<br>[3060202352]copy_and_convert: field_type = 23, fctype = 1, value = '1000', cbValueMax=11<br>[3060202352]DEFAULT: len = 4, ptr = '1000'<br>[3060202352] SQL_C_CHAR, default: len = 4, cbValueMax = 11, rgbValueBindRow = '1000'<br>[3060202352][SQLDescribeCol][3060202352]PGAPI_DescribeCol: entering.2..<br>[3060202352]SC_pre_execute: status = 3<br>[3060202352]PGAPI_DescribeCol: result = 0xb7140688, status = 3, numcols = 3<br>[3060202352]describeCol: col 1 fieldname = 'conf_pin'<br>[3060202352]describeCol: col 1 fieldtype = 23<br>[3060202352]describeCol: col 1 column_size = 10<br>[3060202352]describeCol: col 1 *pfSqlType = 4<br>[3060202352]describeCol: col 1 *pcbColDef = 10<br>[3060202352]describeCol: col 1 *pibScale = 0<br>[3060202352]describeCol: col 1 *pfNullable = 1<br>[3060202352][SQLGetData][3060202352]PGAPI_GetData: enter, stmt=0xb7145ad0 icol=2<br>[3060202352] num_rows = 1<br>[3060202352] value = '1234'<BR>----snip -------<BR> <BR>Thanks,<BR>Kevin<BR> </div></body>
</html>