Highlight a phrase and click this icon to search it on Swyx-Forum    Highlight a phrase and click this icon to search it within the Swyx Knowledgebase    Highlight a phrase and click this icon to search it using Goolge    Highlight a phrase and click this icon to search it using Wikipedia

Highlight a phrase and click this icon to search it on Swyx-Forum    Highlight a phrase and click this icon to search it within the Swyx Knowledgebase    Highlight a phrase and click this icon to search it using Goolge    Highlight a phrase and click this icon to search it using Wikipedia

Forum

Bookmark and Share

Forum

Bookmark and Share

 
  Forums  SwyxWare Server  Setup  Swyx not writing to database
Previous Previous
 
Next Next
New Post 6/23/2009 11:12 AM
Unresolved
User is offline Rob Collier
3 posts
10th Level Poster


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

 
New Post 6/23/2009 11:22 AM
User is offline Tom Wellige
2201 posts
www.swyx.com
1st Level Poster








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)

I learned very early the difference between knowing the name of something and knowing something.
Richard P. Feynman

 
New Post 6/23/2009 11:30 AM
User is offline Rob Collier
3 posts
10th Level Poster


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

 
New Post 6/23/2009 7:26 PM
User is offline nronchetti
99 posts
www.fsys.co.uk
5th Level Poster


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

 
New Post 6/26/2009 6:03 PM
User is offline Rob Collier
3 posts
10th Level Poster


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 :-(

R

 

 
Previous Previous
 
Next Next
  Forums  SwyxWare 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:

  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to SwyxWare, it's OEM versions.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Furthermore, make sure your posts comply to our Terms of Use.
  5. 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.
  6. The German Jugendmedienschutz-Staatsvertrag (JMStV) (Protection of Minors) defines a disclosure of online medias which are not suitable for minors below the age of 18. The Swyx Forum webseite does not provide any such content and underlies therefore not this disclosure. Please see further details including the responsible person for the protection of minors and direct contact data in the Imprint.
  7. 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.
  8. 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.
  9. 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:

  1. No Advertising. This includes promotion of commercial products and non-commercial products which are not directly related to SwyxWare, it's OEM versions.
  2. No Flaming or Trolling.
  3. No Profanity, Racism, or Prejudice.
  4. Furthermore, make sure your posts comply to our Terms of Use.
  5. 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.
  6. The German Jugendmedienschutz-Staatsvertrag (JMStV) (Protection of Minors) defines a disclosure of online medias which are not suitable for minors below the age of 18. The Swyx Forum webseite does not provide any such content and underlies therefore not this disclosure. Please see further details including the responsible person for the protection of minors and direct contact data in the Imprint.
  7. 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.
  8. 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.
  9. Within the project forums english language is mandatory.

 

Forum Help

Stay up-to-date
Forum Icons
Image Usage
Report Abuse

 

The default language in the forums is english, but feel free to use your mother tongue. Just keep in mind that by using english you will reach the largest audience.

Stay up-to-date
Forum Icons
Image Usage
Report Abuse

 

The default language in the forums is english, but feel free to use your mother tongue. Just keep in mind that by using english you will reach the largest audience.

Sponsors
Atia Communications
UCIT cloud communication
Data Way - data your way
bluvo AG