forum.purplepixie.org

Posted: **Fri May 22, 2009 7:47 am**

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.

Posted: **Fri May 22, 2009 3:02 pm**

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.

Posted: **Fri May 22, 2009 4:00 pm**

Ugh, sorry I should have created 2 threads originally

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 |

Posted: **Fri May 22, 2009 4:11 pm**

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

Posted: **Fri May 22, 2009 4:46 pm**

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.

Posted: **Fri May 22, 2009 9:08 pm**

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:

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

Posted: **Fri May 22, 2009 10:08 pm**

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.

Posted: **Sun May 24, 2009 12:20 pm**

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.

Posted: **Tue May 26, 2009 8:30 pm**

Hi Dave.

So far, so good!

Thanks!

Paul

Posted: **Wed May 27, 2009 12:07 pm**

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.

forum.purplepixie.org

smtp auth

Re: smtp auth

Re: smtp auth

Re: smtp auth

Re: smtp auth

Re: smtp auth

Re: smtp auth

Re: smtp auth

Re: smtp auth

Re: smtp auth

Re: smtp auth