Forums :: Swyx Forum

Forums Server Setup Swyx not writing to database

6/23/2009 11:12 AM

	Rob Collier
3 posts

Swyx not writing to database (United Kingdom)

Good Morning all,

We are running Swyx Server 6.02.0120 (en-GB) and for all purposes has been working well for years ever since we installed it. We developed a php frontend to the Call Detail Records database, which simply pulls data from the mysql database that is fed through ODBC as per the server config. The problem we have discovered is that the call records will stop writing into the database randomly, and the only way to kick start it into action again is to restart the server. The process will repeat itself at another random interval, sometimes even days apart. I have searched the forums a few times and looked at the Swyx knowledge base and cant find any mention of this happening to anyone else (just to note we have several clients with different minor versions of v6 and they all have the same problem). I also took a look at the Release Notes for all minor (free) updates but couldnt find mention of the problem or a fix for it.

Does this issue ring a bell to anyone?

Best Regards,

Rob Collier

6/23/2009 11:22 AM

	Tom Wellige
1238 posts
www.swyx.com

Re: Swyx not writing to database (Germany)

Are there any error messages in the Windows Event Log at that time ?

Tom Wellige
(Lead Solution Consultant, Swyx)

"It is a capital mistake to theorize before you have all the evidence. It biases the judgment."
(Sir Arthur Conan Doyle - Sherlock Holmes - A Study in Scarlet)

6/23/2009 11:30 AM

	Rob Collier
3 posts

Re: Swyx not writing to database (United Kingdom)

No, I'm afraid not.

It would be a case of checking the webpage (front end to the call log database) and noticing that it would have missed half a day of calls, for example. After rebooting the server, it would run normally again when checked ... from one day to the next the same thing would occur again.

Rob

6/23/2009 7:26 PM

	nronchetti
94 posts
www.fsys.co.uk

Re: Swyx not writing to database (United Kingdom)

I have found if network connection is broken it will stop logging the calls. You can restart the logging without restarting the server by running the database connection test under the CDR tab in server properties.

For this reason i always try to log the CDR's locally if possible.

Nathan

6/26/2009 6:03 PM

	Rob Collier
3 posts

Re: Swyx not writing to database (United Kingdom)

I was hoping this was going to be the answer :)

But (unfortunatly) the mysql database specified in the odbc connector IS on localhost :-(

Page 1 of 1

Forums

Server

Setup

Swyx not writing to database

Forum Policy

The discussion forums at Swyx Forum are dedicated to the discussion of Swyx, SwyxWare and related topics.

For the benefit of the community and to protect the integrity of swyx-form, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to SwyxWare, it's OEM versions or a forum topic.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Furthermore, make sure your posts comply to our Terms of Use.
Newest development in German law defines online forums as journalistic content, making the forum owner and all posters to journalists. With this statement the forum owner declares that neither he nor his users are journalists with all legal consequences.
The forums are currently unmoderated, meaning all postings will appear immediately after submission. If this turns out not working due to massive abuse all forums will switch to moderated mode, meaning a posting must be approved after submission my a moderator before appearing.
You can use any language you like (except for the project forums) but keep in mind that by using english you will reach the largest audience.
Within the project forums english language is mandatory.

Forum Policy

The discussion forums at Swyx Forum are dedicated to the discussion of Swyx, SwyxWare and related topics.

For the benefit of the community and to protect the integrity of swyx-form, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to SwyxWare, it's OEM versions or a forum topic.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Furthermore, make sure your posts comply to our Terms of Use.
Newest development in German law defines online forums as journalistic content, making the forum owner and all posters to journalists. With this statement the forum owner declares that neither he nor his users are journalists with all legal consequences.
The forums are currently unmoderated, meaning all postings will appear immediately after submission. If this turns out not working due to massive abuse all forums will switch to moderated mode, meaning a posting must be approved after submission my a moderator before appearing.
You can use any language you like (except for the project forums) but keep in mind that by using english you will reach the largest audience.
Within the project forums english language is mandatory.