Search found 92 matches
- Thu May 21, 2009 5:32 pm
- Forum: FreeNATS Support
- Topic: smtp auth
- Replies: 19
- Views: 27276
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 ...
- Thu May 21, 2009 5:20 pm
- Forum: FreeNATS Support
- Topic: fntestrun.MYD
- Replies: 7
- Views: 13262
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 ...
- Thu May 21, 2009 5:02 pm
- Forum: FreeNATS Support
- Topic: smtp auth
- Replies: 19
- Views: 27276
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...
- Thu May 21, 2009 4:58 pm
- Forum: FreeNATS Support
- Topic: fntestrun.MYD
- Replies: 7
- Views: 13262
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...
- Thu May 21, 2009 4:46 pm
- Forum: FreeNATS Support
- Topic: smtp auth
- Replies: 19
- Views: 27276
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...
- Thu May 21, 2009 3:58 pm
- Forum: FreeNATS Support
- Topic: fntestrun.MYD
- Replies: 7
- Views: 13262
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
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
- Wed May 20, 2009 10:34 pm
- Forum: FreeNATS Support
- Topic: smtp auth
- Replies: 19
- Views: 27276
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...
- Thu Mar 19, 2009 7:16 pm
- Forum: FreeNATS Support
- Topic: UDP test
- Replies: 1
- Views: 7333
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!
Thanks!
- Tue Feb 03, 2009 10:42 pm
- Forum: FreeNATS Support
- Topic: Unusual event
- Replies: 4
- Views: 10231
Re: Unusual event
Dave, I've increased my max_globalconnections from the default of 100 to 150. Any advice?
Thanks!
Paul
Thanks!
Paul
- Tue Feb 03, 2009 8:51 pm
- Forum: FreeNATS Support
- Topic: Unusual event
- Replies: 4
- Views: 10231
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...