Search found 92 matches

by paullanders
Thu May 21, 2009 5:32 pm
Forum: FreeNATS Support
Topic: smtp auth
Replies: 19
Views: 14671

Re: smtp auth

11:24:01 21/05/2009 2 DB:Query Query Failed: SELECT nodeid FROM fnnode WHERE nodeenabled>0 AND masterid="" ORDER BY weight ASC 11:24:01 21/05/2009 2 DB:Query Query Error: Unknown column 'masterid' in 'where clause' (1054) 11:25:01 21/05/2009 2 DB:Query Query Failed: SELECT nodeid FROM fnnode WHERE ...
by paullanders
Thu May 21, 2009 5:20 pm
Forum: FreeNATS Support
Topic: fntestrun.MYD
Replies: 7
Views: 6833

Re: fntestrun.MYD

OK, wow, I guess I just have that much data! I set retention to 5 and ran cleanup.php: Deleted 0 Alerts Deleted 0 Alert Log Entries Deleted 145913 Test Runs Deleted 165 Result Records Deleted 404 System Log Entries Deleted 0 Stale Sessions The row count is shrinking rapidly, but the mysql data size ...
by paullanders
Thu May 21, 2009 5:02 pm
Forum: FreeNATS Support
Topic: smtp auth
Replies: 19
Views: 14671

Re: smtp auth

Ah, sorry about that. OK, here is the result now: paullanders@koha:/opt/freenats/server/bin$ sudo php ./test-threaded.php test-threaded.sh: spawning node tester processes Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /opt/freenats/server/base/nats.db.inc.php...
by paullanders
Thu May 21, 2009 4:58 pm
Forum: FreeNATS Support
Topic: fntestrun.MYD
Replies: 7
Views: 6833

Re: fntestrun.MYD

OK, retain.testrun was set to 0. I changed it to 30 and and ran cleanup.php: Deleted 0 Alerts Deleted 0 Alert Log Entries Deleted 1773 Test Runs Deleted 3458 Result Records Deleted 7963 System Log Entries Deleted 0 Stale Sessions It shrunk only slightly: "421445 Rows, 1123883.64 Mb Historic Test Run...
by paullanders
Thu May 21, 2009 4:46 pm
Forum: FreeNATS Support
Topic: smtp auth
Replies: 19
Views: 14671

Re: smtp auth

Hi Dave. I updated FreeNATS (only a filesystem update; should I update schema too?) I stopped receiving any alerts so I manually tested: sudo php /opt/freenats/server/bin/test-threaded.php Warning: require(../base/nats.php): failed to open stream: No such file or directory in /opt/freenats/server/bi...
by paullanders
Thu May 21, 2009 3:58 pm
Forum: FreeNATS Support
Topic: fntestrun.MYD
Replies: 7
Views: 6833

fntestrun.MYD

Hi Dave.

I noted that my fntestrun.MYD is massive (>1GB), and on the FreeNATS backup page: "fntestrun 422885 Rows, 1123883.64 Mb Historic Test Runs"

Is this normal and how can this be managed/reduced/cleared?

Thank you!

Paul
by paullanders
Wed May 20, 2009 10:34 pm
Forum: FreeNATS Support
Topic: smtp auth
Replies: 19
Views: 14671

smtp auth

Hi Dave. When I stopped receiving email alerts for a few days I discovered that my employer now enforces smtp auth for all outbound mail. :o Although I've now set all 4 smtp variables in System Configuration the alerts are still not being delivered. As an unrelated test I installed and configured sa...
by paullanders
Thu Mar 19, 2009 7:16 pm
Forum: FreeNATS Support
Topic: UDP test
Replies: 1
Views: 2978

UDP test

Dave, exactly does the UDP test work since UDP is really connectionless? I have an app that communicates only UDP. FreeNATS reports a successful UDP test even if I shut the app down.

Thanks!
by paullanders
Tue Feb 03, 2009 10:42 pm
Forum: FreeNATS Support
Topic: Unusual event
Replies: 4
Views: 4746

Re: Unusual event

Dave, I've increased my max_globalconnections from the default of 100 to 150. Any advice?

Thanks!

Paul
by paullanders
Tue Feb 03, 2009 8:51 pm
Forum: FreeNATS Support
Topic: Unusual event
Replies: 4
Views: 4746

Re: Unusual event

Hi Dave. my script reports this: Too many connections in /opt/freenats/server/base/nats.db.inc.php on line 39 Cannot connect to MySQL server I have emailed you a copy of "show processlist;" from mysql, but I do not know how to troubleshoot a 'too many connections' error. Could you assist me? Thank y...