Re: smsd deletes inbound SMS messages when database connection down

[Alastair Watts]

On Thu, 2008-07-31 at 11:56 +0200, Jan Derfinak wrote:

> The problem is that MySQL changed its dafault behaviour (once again).
> The fix was implemented:
> 
> * Mon Jul 16 2007 Jan Derfinak
> - Switch reconnect flag (part of the MYSQL structure) to on for MySQL 5.0.13
>   and newer. It was by default on in versions of the API older than 5.0.3.
> 
> I cannot find which gnokii version this is because I don't see dates in
> gnokii Changelog.

MySQL server is 5.0.51, and client is 5.0.41, both of which are newer
than 5.0.13.

> This is not strange. This is expected! :)
> 
> For outbox and inbox I have separate connections to database.
> MySQL will shutdown connection for connections without reconnect flag if
> there is inactivity for some time period.
> Activity on inbox connection is driven by phone. SMSD only update inbox if
> there is new sms in phone.
> Activity on outbox is driven by SMSD. And SMSD checks outbox periodically in
> short interval.

At least there sounds like an explanation! :)

What about the versions being newer than 5.0.13 though?