------------ Begin of odbcinst.ini --------------------- # Example driver definitions # Driver from the postgresql-odbc package # Setup from the unixODBC package [PostgreSQL] Description = ODBC for PostgreSQL Driver = /usr/lib/psqlodbc.so Setup = /usr/lib/libodbcpsqlS.so Driver64 = /usr/lib64/psqlodbc.so Setup64 = /usr/lib64/libodbcpsqlS.so FileUsage = 1 # Driver from the mysql-connector-odbc package # Setup from the unixODBC package [MySQL] Description = ODBC for MySQL Driver = /usr/lib/libmyodbc5.so Setup = /usr/lib/libodbcmyS.so Driver64 = /usr/lib64/libmyodbc5.so Setup64 = /usr/lib64/libodbcmyS.so FileUsage = 1 ------------ End of odbcinst.ini -------------------- ------------ Begin of odbc.ini ----------------------- [MySQL-asteriskcdrdb] Description=MySQL connection to 'asterisk' database driver=MySQL server=localhost database=asteriskcdrdb Port=3306 Socket=/var/lib/mysql/mysql.sock option=3 [asterisk-connector] Description = PostgreSQL connection to 'asterisk' database Driver = PostgreSQL Database = asterisk Servername = X.X.X.X UserName = ******* Password = ******** Port = 5432 Protocol = 9.2 ReadOnly = No RowVersioning = No ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings = --------------- End of odbc.ini ----------------- --------------- Begin of res_odbc.conf ----------------- [asterisk-psql] enabled => yes dsn => asterisk-connector username => ****** password => ****** pre-connect => yes ---------------- End of res_odbc.conf ---------------------- ---------------- Begin of extconfig.conf ------------------ [settings] queue_log => odbc,asterisk-psql ------------------ End of extconfig.conf ------------------- ------------------ Begin of cdr_adaptative_odbc.conf ------------ [asteriskcdrdb] connection=asteriskcdrdb loguniqueid=yes table=cdr alias start => calldate [asterisk-psql] connection=asterisk-psql loguniqueid=yes table=cdr alias start => calldate -------------------- End of cdr_adaptative_odbc.conf ------------------- -------------------- Begin of cel_odbc.conf ---------------------------- [cel1] connection=asteriskcdrdb loguniqueid=yes table=cel [cel] connection=asterisk-psql loguniqueid=yes table=cel -------------------- End of cel_odbc.conf ----------------------------