Otdfbt

Do wooden building fires get hotter than 600°C?

How could we fake a moon landing now?

What is the appropriate index architecture when forced to implement IsDeleted (soft deletes)?

Is there hard evidence that the grant peer review system performs significantly better than random?

How would a mousetrap for use in space work?

How were pictures turned from film to a big picture in a picture frame before digital scanning?

Is there any word for a place full of confusion?

How fail-safe is nr as stop bytes?

ArcGIS Pro Python arcpy.CreatePersonalGDB_management

Putting class ranking in CV, but against dept guidelines

Why do we bend a book to keep it straight?

An adverb for when you're not exaggerating

Selecting user stories during sprint planning

Effects on objects due to a brief relocation of massive amounts of mass

Why do we need to use the builder design pattern when we can do the same thing with setters?

Most bit efficient text communication method?

How does light 'choose' between wave and particle behaviour?

Taylor expansion of ln(1-x)

Time to Settle Down!

How come Sam didn't become Lord of Horn Hill?

Question about debouncing - delay of state change

What do you call the main part of a joke?

How to compare two different files line by line in unix?

Chinese Seal on silk painting - what does it mean?

Automatically reconnect to ODBC sources?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

I am using Asterisk 1.8.10.1 and a MySQL database connected via ODBC to store CDRs. When my MySQL database isn't available when Asterisk starts or has an outage while Asterisk is running, I would expect Asterisk to retry to connect to the database, but this doesn't happen! Anyone knows where I can enable some kidn of automatic reconnect to databases in Asterisk?

My res_odbc.conf looks like this:

[asterisk]
enabled => yes
dsn => asterisk-connector
username => user
password => pass
pre-connect => yes
pooling => no
limit => 1
idlecheck => 1
negative_connection_cache => 1

mysql asterisk odbc unixodbc

share|improve this question

edited Aug 31 '12 at 22:08

stefan.at.wpf

asked Aug 31 '12 at 22:01

stefan.at.wpfstefan.at.wpf

4801918

add a comment | 

1

I am using Asterisk 1.8.10.1 and a MySQL database connected via ODBC to store CDRs. When my MySQL database isn't available when Asterisk starts or has an outage while Asterisk is running, I would expect Asterisk to retry to connect to the database, but this doesn't happen! Anyone knows where I can enable some kidn of automatic reconnect to databases in Asterisk?

My res_odbc.conf looks like this:

[asterisk]
enabled => yes
dsn => asterisk-connector
username => user
password => pass
pre-connect => yes
pooling => no
limit => 1
idlecheck => 1
negative_connection_cache => 1

mysql asterisk odbc unixodbc

share|improve this question

edited Aug 31 '12 at 22:08

stefan.at.wpf

asked Aug 31 '12 at 22:01

stefan.at.wpfstefan.at.wpf

4801918

add a comment | 

I am using Asterisk 1.8.10.1 and a MySQL database connected via ODBC to store CDRs. When my MySQL database isn't available when Asterisk starts or has an outage while Asterisk is running, I would expect Asterisk to retry to connect to the database, but this doesn't happen! Anyone knows where I can enable some kidn of automatic reconnect to databases in Asterisk?

My res_odbc.conf looks like this:

[asterisk]
enabled => yes
dsn => asterisk-connector
username => user
password => pass
pre-connect => yes
pooling => no
limit => 1
idlecheck => 1
negative_connection_cache => 1

mysql asterisk odbc unixodbc

share|improve this question

edited Aug 31 '12 at 22:08

stefan.at.wpf

asked Aug 31 '12 at 22:01

stefan.at.wpfstefan.at.wpf

4801918

[asterisk]
enabled => yes
dsn => asterisk-connector
username => user
password => pass
pre-connect => yes
pooling => no
limit => 1
idlecheck => 1
negative_connection_cache => 1

share|improve this question

edited Aug 31 '12 at 22:08

stefan.at.wpf

asked Aug 31 '12 at 22:01

stefan.at.wpfstefan.at.wpf

4801918

share|improve this question

edited Aug 31 '12 at 22:08

stefan.at.wpf

asked Aug 31 '12 at 22:01

stefan.at.wpfstefan.at.wpf

4801918

asked Aug 31 '12 at 22:01

stefan.at.wpfstefan.at.wpf

4801918

asked Aug 31 '12 at 22:01

stefan.at.wpfstefan.at.wpf

4801918

1 Answer
1

active

oldest

votes

0

Usualy it do reconnect on next realtime request.

Try this set

idlecheck => 300; ( will check connection in pool every 5 minutes)
connect_timeout => 5; ( how long to wait on reconnect)
negative_connection_cache=>10 ;( how long wait before reconnect)
pre-connect = yes; will allow you check if connection ok by issue "realtime show odbc status"

Also i recomend set limit to more then 1.

share|improve this answer

edited Sep 8 '12 at 20:52

answered Sep 8 '12 at 20:45

arheopsarheops

6531513

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f423428%2fautomatically-reconnect-to-odbc-sources%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Usualy it do reconnect on next realtime request.

Try this set

idlecheck => 300; ( will check connection in pool every 5 minutes)
connect_timeout => 5; ( how long to wait on reconnect)
negative_connection_cache=>10 ;( how long wait before reconnect)
pre-connect = yes; will allow you check if connection ok by issue "realtime show odbc status"

Also i recomend set limit to more then 1.

share|improve this answer

edited Sep 8 '12 at 20:52

answered Sep 8 '12 at 20:45

arheopsarheops

6531513

add a comment | 

0

Usualy it do reconnect on next realtime request.

Try this set

idlecheck => 300; ( will check connection in pool every 5 minutes)
connect_timeout => 5; ( how long to wait on reconnect)
negative_connection_cache=>10 ;( how long wait before reconnect)
pre-connect = yes; will allow you check if connection ok by issue "realtime show odbc status"

Also i recomend set limit to more then 1.

share|improve this answer

edited Sep 8 '12 at 20:52

answered Sep 8 '12 at 20:45

arheopsarheops

6531513

add a comment | 

Usualy it do reconnect on next realtime request.

Try this set

idlecheck => 300; ( will check connection in pool every 5 minutes)
connect_timeout => 5; ( how long to wait on reconnect)
negative_connection_cache=>10 ;( how long wait before reconnect)
pre-connect = yes; will allow you check if connection ok by issue "realtime show odbc status"

Also i recomend set limit to more then 1.

share|improve this answer

edited Sep 8 '12 at 20:52

answered Sep 8 '12 at 20:45

arheopsarheops

6531513

idlecheck => 300; ( will check connection in pool every 5 minutes)
connect_timeout => 5; ( how long to wait on reconnect)
negative_connection_cache=>10 ;( how long wait before reconnect)
pre-connect = yes; will allow you check if connection ok by issue "realtime show odbc status"

share|improve this answer

edited Sep 8 '12 at 20:52

answered Sep 8 '12 at 20:45

arheopsarheops

6531513

answered Sep 8 '12 at 20:45

arheopsarheops

6531513

answered Sep 8 '12 at 20:45

arheopsarheops

6531513