forum.purplepixie.org

Hi Paul,

Excellent - glad to hear it.

Actually getting useful information from the system event log as well... Wonders will never cease.

Regards,

Dave.

Hi Paul, Looks like an SQL schema problem to me - specifically with the changes that were released in 1.08.0a and beyond (utility links). Did you do a schema import/upgrade when you installed the most recent version? If not you need to run: * server/base/sql/schema.sql * server/base/sql/schema.upgra...

Hi Paul,

Hmm... weird.

Do you see any errors in the log (Configuration -> System Settings -> System Event Log) which would indicate a query failing?

In the meantime let me have a poke around and see if I think I can find anything that may cause your problem.

Cheers,

Dave.

Hi, The msql error just refers to a shared object that can't be loaded - will just mean msql functions don't work. Shouldn't affect anything. As for it firing every second - hmm... not sure. Could you try the following: cd into the server/bin directory php logwatch.php -c 100 You can either cut+past...

Hi, Well re-looking at your logs this was mysql reporting (and fixing) the crashed errors on startup but it's always worth checking again. Hmm... Obviously I know the timing supports freenats being somehow behind your system hanging but, especially if it was firing every hour then it seems unlikely ...

Hi there,

Ok that would be great. I'll need to have a play and localise the code so you can easily plug in other languages.

This may take a while as I'm a bit hectic at the moment but as soon as it's done I will let you know.

Regards,

Dave.

Hi Gary, Glad you're finding the system useful but sorry for the hanging. The error messages obviously imply that there is a problem or corruption with the MySQL tables. Sadly what I can't tell you is if this is a cause of a problem or a symptom! What I would certainly suggest is repairing the table...

hi there, have you got the tester script running from your cron? It needs root priv to ping. Sorry for format but from my phone. Cheers, Dave.

Hi Paul, Good to hear from you. There are two ways to accomplish what you're after. The easiest way is to use views but you can also use the Data API . A view is configured within FreeNATS itself and then just a single line of code is added to your web page. The advantage of this method is that you ...

Ok good stuff - glad it's working.

Cheers,

Dave.