smtp auth
Re: smtp auth
Hi Paul,
Nodes not testing:
Wondering if this might be an issue with the nextrunx being set oddly owing to the schema problems though I don't see why it should be.
Can you do a SELECT * FROM fnnode WHERE nodeid="NOT_WORKING_NODE";
and also a SELECT * FROM fnnode WHERE nodeid="WORKING_NODE";
And let's see what the differences are.
SMTP:
Hmm... Certainly sounds like SMTP AUTH is failing.
Multiple addressses should go one-per-line rather than comma-seperated but still the single address failing is not so good. I'll try and have a play today and see what I can find from this end.
Regards,
Dave.
Nodes not testing:
Wondering if this might be an issue with the nextrunx being set oddly owing to the schema problems though I don't see why it should be.
Can you do a SELECT * FROM fnnode WHERE nodeid="NOT_WORKING_NODE";
and also a SELECT * FROM fnnode WHERE nodeid="WORKING_NODE";
And let's see what the differences are.
SMTP:
Hmm... Certainly sounds like SMTP AUTH is failing.
Multiple addressses should go one-per-line rather than comma-seperated but still the single address failing is not so good. I'll try and have a play today and see what I can find from this end.
Regards,
Dave.
Re: smtp auth
Paul,
I was just in the middle of hacking a snippet of FreeNATS code to run on it's own and made the stunning realisation there was an error in the code regarding AUTH (use of phpmailer to specific hosts would have been fine).
Turns out I was referencing the wrong variable names for the auth settings but not for the host.
Because there had been a bug with phpmailer as well I'd never really managed to spot it.
Try 1.04.4a which is now available at http://www.purplepixie.org/freenats/rel ... on=1.04.4a (or direct from http://www.purplepixie.org/freenats/dow ... .4a.tar.gz ).
This should work (famous last words) but if not at least give a different error.
Still none the wiser on the nodes not being tested though.
Regards,
Dave.
I was just in the middle of hacking a snippet of FreeNATS code to run on it's own and made the stunning realisation there was an error in the code regarding AUTH (use of phpmailer to specific hosts would have been fine).
Turns out I was referencing the wrong variable names for the auth settings but not for the host.
Because there had been a bug with phpmailer as well I'd never really managed to spot it.
Try 1.04.4a which is now available at http://www.purplepixie.org/freenats/rel ... on=1.04.4a (or direct from http://www.purplepixie.org/freenats/dow ... .4a.tar.gz ).
This should work (famous last words) but if not at least give a different error.
Still none the wiser on the nodes not being tested though.
Regards,
Dave.
-
- Posts: 92
- Joined: Thu Sep 04, 2008 9:48 pm
Re: smtp auth
Ugh, sorry I should have created 2 threads originally
On the "node not testing" problem:
Working node:
Non-working node:
On the "node not testing" problem:
Working node:
Code: Select all
| nodeid | nodename | nodedesc | hostname | nodeenabled | pingtest | pingfatal | alertlevel | nodeicon | weight | nodealert | scheduleid | lastrunx | testinterval | nextrunx | nsenabled | nsurl | nskey | nspullenabled | nspushenabled | nspuship | nsinterval | nslastx | nsnextx | nspullalert | nsfreshpush | masterid | masterjustping |
+-----------+----------+----------+--------------+-------------+----------+-----------+------------+-----------+--------+-----------+------------+------------+--------------+------------+-----------+-------+-------+---------------+---------------+----------+------------+---------+---------+-------------+-------------+----------+----------------+
| test_node | iMac | iMac | 66.230.4.134 | 1 | 1 | 0 | 0 | mac32.png | 230 | 1 | 0 | 1243003875 | 0 | 1243003875 | 0 | | | 0 | 0 | | 15 | 0 | 0 | 0 | 0 | | 1 |
Non-working node:
Code: Select all
| nodeid | nodename | nodedesc | hostname | nodeenabled | pingtest | pingfatal | alertlevel | nodeicon | weight | nodealert | scheduleid | lastrunx | testinterval | nextrunx | nsenabled | nsurl | nskey | nspullenabled | nspushenabled | nspuship | nsinterval | nslastx | nsnextx | nspullalert | nsfreshpush | masterid | masterjustping |
+----------+----------+----------+-------------------------+-------------+----------+-----------+------------+-----------+--------+-----------+------------+------------+--------------+------------+-----------+-------+-------+---------------+---------------+----------+------------+---------+---------+-------------+-------------+----------+----------------+
| goldrush | GoldRush | GoldRush | goldrush.coalliance.org | 1 | 0 | 0 | 0 | globe.gif | 90 | 1 | 0 | 1242919269 | 5 | 1242919539 | 0 | | | 0 | 0 | | 15 | 0 | 0 | 0 | 0 | NULL | 1 |
-
- Posts: 92
- Joined: Thu Sep 04, 2008 9:48 pm
Re: smtp auth
Woo who! SMTP auth works great now! Thank you so much!!! Now I can stop enjoying the 4 days of my cell phone not going off.
Thanks for all your work, Dave!
Paul
Thanks for all your work, Dave!
Paul
Re: smtp auth
Hi,
Glad SMTP AUTH is now working.
I think the problem is the master node not being updated. Hmm... I'm using a new version of MySQL etc and I did notice some default stuff didn't go across.
To test it can you try (BTW I'm assuming you're not using master nodes anywhere):
UPDATE fnnode SET masterid=0;
Which should update all the nodes to have a masterid of 0 rather than null. If this works I'll look into why defaults aren't working properly this weekend.
Cheers,
Dave.
Glad SMTP AUTH is now working.
I think the problem is the master node not being updated. Hmm... I'm using a new version of MySQL etc and I did notice some default stuff didn't go across.
To test it can you try (BTW I'm assuming you're not using master nodes anywhere):
UPDATE fnnode SET masterid=0;
Which should update all the nodes to have a masterid of 0 rather than null. If this works I'll look into why defaults aren't working properly this weekend.
Cheers,
Dave.
-
- Posts: 92
- Joined: Thu Sep 04, 2008 9:48 pm
Re: smtp auth
Hi Dave.
LOL, running UPDATE fnnode SET masterid=0; caused all nodes to stop testing
I then selected a broken node and ran SELECT * FROM fnnode WHERE nodeid="NOT_WORKING_NODE"; both before and after "fixing" it (by clicking Save Node Settings). Here are the results:
Before fixing:
After fixing:
After fixing and after next node test:
Hope this helps with troubleshooting.
Have a great weekend, Dave!
Paul
LOL, running UPDATE fnnode SET masterid=0; caused all nodes to stop testing
I then selected a broken node and ran SELECT * FROM fnnode WHERE nodeid="NOT_WORKING_NODE"; both before and after "fixing" it (by clicking Save Node Settings). Here are the results:
Before fixing:
Code: Select all
| nodeid | nodename | nodedesc | hostname | nodeenabled | pingtest | pingfatal | alertlevel | nodeicon | weight | nodealert | scheduleid | lastrunx | testinterval | nextrunx | nsenabled | nsurl | nskey | nspullenabled | nspushenabled | nspuship | nsinterval | nslastx | nsnextx | nspullalert | nsfreshpush | masterid | masterjustping |
+----------+----------+----------+-------------------------+-------------+----------+-----------+------------+-----------+--------+-----------+------------+------------+--------------+------------+-----------+-------+-------+---------------+---------------+----------+------------+---------+---------+-------------+-------------+----------+----------------+
| goldrush | GoldRush | GoldRush | goldrush.coalliance.org | 1 | 0 | 0 | 0 | globe.gif | 90 | 1 | 0 | 1242919269 | 5 | 1242919539 | 0 | | | 0 | 0 | | 15 | 0 | 0 | 0 | 0 | 0 | 1 |
After fixing:
Code: Select all
| nodeid | nodename | nodedesc | hostname | nodeenabled | pingtest | pingfatal | alertlevel | nodeicon | weight | nodealert | scheduleid | lastrunx | testinterval | nextrunx | nsenabled | nsurl | nskey | nspullenabled | nspushenabled | nspuship | nsinterval | nslastx | nsnextx | nspullalert | nsfreshpush | masterid | masterjustping |
+----------+----------+----------+-------------------------+-------------+----------+-----------+------------+-----------+--------+-----------+------------+------------+--------------+------------+-----------+-------+-------+---------------+---------------+----------+------------+---------+---------+-------------+-------------+----------+----------------+
| goldrush | GoldRush | GoldRush | goldrush.coalliance.org | 1 | 0 | 0 | 0 | globe.gif | 90 | 1 | 0 | 1242919269 | 5 | 1242919539 | 0 | | | 0 | 0 | | 15 | 0 | 0 | 0 | 0 | | 1 |
After fixing and after next node test:
Code: Select all
| nodeid | nodename | nodedesc | hostname | nodeenabled | pingtest | pingfatal | alertlevel | nodeicon | weight | nodealert | scheduleid | lastrunx | testinterval | nextrunx | nsenabled | nsurl | nskey | nspullenabled | nspushenabled | nspuship | nsinterval | nslastx | nsnextx | nspullalert | nsfreshpush | masterid | masterjustping |
+----------+----------+----------+-------------------------+-------------+----------+-----------+------------+-----------+--------+-----------+------------+------------+--------------+------------+-----------+-------+-------+---------------+---------------+----------+------------+---------+---------+-------------+-------------+----------+----------------+
| goldrush | GoldRush | GoldRush | goldrush.coalliance.org | 1 | 0 | 0 | 0 | globe.gif | 90 | 1 | 0 | 1243022701 | 5 | 1243022971 | 0 | | | 0 | 0 | | 15 | 0 | 0 | 0 | 0 | | 1 |
Hope this helps with troubleshooting.
Have a great weekend, Dave!
Paul
Re: smtp auth
Hi Paul,
I really am a spanner - they should take me outside and shoot me.
UPDATE fnnode SET masterid="";
It's alphanumeric as it's a flipping nodeid. Argh. I blame the fact that I have to debug away from an actual internet connection so try and remember what it is I did.
Anyway - that is definately the problem. I'll figure out over the weekend why it broke for you and get that sorted (I hope!).
Cheers,
Dave.
I really am a spanner - they should take me outside and shoot me.
UPDATE fnnode SET masterid="";
It's alphanumeric as it's a flipping nodeid. Argh. I blame the fact that I have to debug away from an actual internet connection so try and remember what it is I did.
Anyway - that is definately the problem. I'll figure out over the weekend why it broke for you and get that sorted (I hope!).
Cheers,
Dave.
Re: smtp auth
Hi Paul,
Ok the stopping of testing was definately the masterid field being added. It seems on the new version of MySQL I'm using different answers get given for a DESCRIBE TABLE call so whereas previously the Null column being empty meant NOT NULL now it has a NO contained!
So the field was being created but without NOT NULL and consequently was in fact null. The query for "unmastered" nodes is WHERE masterid="" which doesn't return nulls. Oh well.
The upgrade script is now resolved and I have tested it and seems to work fine for new fields.
http://www.purplepixie.org/freenats/rel ... on=1.04.5a or http://www.purplepixie.org/freenats/dow ... .5a.tar.gz for direct download.
Once you've done this update including schema (or in fact just the schema) all should be well again.
Regards,
Dave.
Ok the stopping of testing was definately the masterid field being added. It seems on the new version of MySQL I'm using different answers get given for a DESCRIBE TABLE call so whereas previously the Null column being empty meant NOT NULL now it has a NO contained!
So the field was being created but without NOT NULL and consequently was in fact null. The query for "unmastered" nodes is WHERE masterid="" which doesn't return nulls. Oh well.
The upgrade script is now resolved and I have tested it and seems to work fine for new fields.
http://www.purplepixie.org/freenats/rel ... on=1.04.5a or http://www.purplepixie.org/freenats/dow ... .5a.tar.gz for direct download.
Once you've done this update including schema (or in fact just the schema) all should be well again.
Regards,
Dave.
-
- Posts: 92
- Joined: Thu Sep 04, 2008 9:48 pm
Re: smtp auth
Hi Dave.
So far, so good!
Thanks!
Paul
So far, so good!
Thanks!
Paul
Re: smtp auth
Glad to hear it.
Hopefully that will be the last of my "change environment and think it'll just be ok" packaging bugs.
Regards,
Dave.
Hopefully that will be the last of my "change environment and think it'll just be ok" packaging bugs.
Regards,
Dave.