[Netdisco] alias hack

[Nenad T. <Nen...@bn...>]

Hi,

As I have already mentioned in my earlier messages, the only problematic thing with Netdisco for me is aliasing which doesnt discover neighbours if they have same IP address and I have several devices in different routing domains which have same private address on them.

So I have decided to make some dirty postgres hacking;

#!/bin/bash
for i in `cat /home/netdisco/alias_ip.txt`
do
/usr/bin/psql -q -U netdisco -d netdisco -c "delete FROM device_ip WHERE alias  = inet '$i';"
done

Alias_ip.txt is a list of duplicate aliases.

Well, I'm not expirienced database admin, so question is; is it possible to break database if I put that script in crontab?
It must be executed every few minutes, especially during rediscovering hole network so can I expect any problems?

Or maybe someone has better idea?



Nenad