Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-users digest..."
Today's Topics:
1. Problems running 1.0.5 RC1 with apache server 2.4 (Arnaud Lauriou)
2. Updating Device Names (Chip Pleasants)
3. Re: Updating Device Names (Carlos Vicente)
4. Re: Updating Device Names (Chip Pleasants)
5. Re: Updating Device Names (Chip Pleasants)
----------------------------------------------------------------------
Message: 1
Date: Mon, 03 Mar 2014 11:07:18 +0100
From: Arnaud Lauriou <[email protected]>
Subject: [Netdot-users] Problems running 1.0.5 RC1 with apache server
2.4
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hello,
I've got the same troubles that this post :
http://osl.uoregon.edu/pipermail/netdot-users/2013-November/001679.html
Not able to run netdot 1.0.5 RC1 with apache 2.4.
Here is the error log when I try to access netdot home page:
Mon Mar 03 10:22:06.764744 2014] [authz_core:debug] [pid 21295]
mod_authz_core.c(802): [client] AH01626: authorization result of Require
valid-user : denied (no authenticated user yet)
[Mon Mar 03 10:22:06.764777 2014] [authz_core:debug] [pid 21295]
mod_authz_core.c(802): [client] AH01626: authorization result of
<RequireAny>: denied (no authenticated user yet)
[Mon Mar 03 10:22:06.765673 2014] [:error] [pid 21295] ses_key_cookie
[Mon Mar 03 10:22:06.766081 2014] [authz_core:debug] [pid 21295]
mod_authz_core.c(802): [client] AH01626: authorization result of Require
valid-user : denied (no authenticated user yet)
[Mon Mar 03 10:22:06.766096 2014] [authz_core:debug] [pid 21295]
mod_authz_core.c(802): [client] AH01626: authorization result of
<RequireAny>: denied (no authenticated user yet)
[Mon Mar 03 10:22:06.766158 2014] [core:error] [pid 21295] [client]
AH00027: No authentication done but request not allowed without
authentication for /netdot/login.html. Authentication not configured?
The host running netdot is a fresh install of fedora 20, all perl
dependencies are ok and apache version is : Apache/2.4.6 (Fedora)
mod_wsgi/3.4 Python/2.7.5 mod_apreq2-20090110/2.8.0 mod_perl/2.0.9-dev
Perl/v5.18.2
It seems that accessing login page (/netdot/login.html) needs
authentication ... anyone have a solution ?
Regards,
Arnaud Lauriou
------------------------------
Message: 2
Date: Mon, 3 Mar 2014 09:31:32 -0500
From: Chip Pleasants <[email protected]>
Subject: [Netdot-users] Updating Device Names
To: [email protected]
Message-ID:
<CAJq5ATrEA1PzZNLmwPS=1gzsswfjuvxdwsokfscrqz-oscn...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
What's the best way to update the devices names in NetDot? I'm changing
the dns suffixes for my devices and would like to reflect the new suffix
and delete the only one in Netdot. Should I delete the devices and rescan
or is there a faster safer way? I don't want to blow away any Static or
Reserved addresses. I have about 1000 devices so manually would take far
too long. The System Names should be the new name today, so if there is
some way to use the System Name that would be great. Thanks in advance for
any assistance.
Thanks,
Chip
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140303/1a83123d/attachment-0001.html
------------------------------
Message: 3
Date: Mon, 3 Mar 2014 09:43:01 -0500
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Updating Device Names
To: Chip Pleasants <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252
Chip,
There is no need to delete all devices.
You can probably accomplish this with a simple SQL query. Something like:
UPDATE device, rr SET rr.name=device.sysname
WHERE device.name = rr.id
AND device.sysname is not NULL
AND device.sysname != ??;
cv
On Mar 3, 2014, at 9:31 AM, Chip Pleasants <[email protected]> wrote:
> What's the best way to update the devices names in NetDot? I'm changing the
> dns suffixes for my devices and would like to reflect the new suffix and
> delete the only one in Netdot. Should I delete the devices and rescan or is
> there a faster safer way? I don't want to blow away any Static or Reserved
> addresses. I have about 1000 devices so manually would take far too long.
> The System Names should be the new name today, so if there is some way to use
> the System Name that would be great. Thanks in advance for any assistance.
>
> Thanks,
> Chip
>
>
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
Message: 4
Date: Mon, 3 Mar 2014 11:14:25 -0500
From: Chip Pleasants <[email protected]>
Subject: Re: [Netdot-users] Updating Device Names
To: Carlos Vicente <[email protected]>
Cc: [email protected]
Message-ID:
<CAJq5ATrTK+RfEwxRpRhvnbY4=+8s_edk5dnggdvbqn40py2...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Hi Carlos,
Thanks for responding and sorry for these beginner SQL questions. Do I use
Netdot's web interface or is more of a command line or SQL script. I adding
your sql commands to a script and tried to add it to the netdot db but it
didn't look like it did anything. When I added it to the text file for a
command it didn't like the '' characters. I used single quotes in replace
' ' .
-Chip
mysql -u root -p
mysql netdot < change-device-name.sql
change-device-name.sql
UPDATE device, rr SET rr.name=device.sysname
WHERE device.name = rr.id
AND device.sysname is not NULL
AND device.sysname != '';
On Mon, Mar 3, 2014 at 9:43 AM, Carlos Vicente <[email protected]>wrote:
> Chip,
>
> There is no need to delete all devices.
>
> You can probably accomplish this with a simple SQL query. Something like:
>
> UPDATE device, rr SET rr.name=device.sysname
> WHERE device.name = rr.id
> AND device.sysname is not NULL
> AND device.sysname != '';
>
> cv
>
> On Mar 3, 2014, at 9:31 AM, Chip Pleasants <[email protected]> wrote:
>
> > What's the best way to update the devices names in NetDot? I'm changing
> the dns suffixes for my devices and would like to reflect the new suffix
> and delete the only one in Netdot. Should I delete the devices and rescan
> or is there a faster safer way? I don't want to blow away any Static or
> Reserved addresses. I have about 1000 devices so manually would take far
> too long. The System Names should be the new name today, so if there is
> some way to use the System Name that would be great. Thanks in advance for
> any assistance.
> >
> > Thanks,
> > Chip
> >
> >
> >
> > _______________________________________________
> > Netdot-users mailing list
> > [email protected]
> > https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140303/e7e6079b/attachment-0001.html
------------------------------
Message: 5
Date: Mon, 3 Mar 2014 11:44:31 -0500
From: Chip Pleasants <[email protected]>
Subject: Re: [Netdot-users] Updating Device Names
To: Carlos Vicente <[email protected]>
Cc: [email protected]
Message-ID:
<cajq5atr7qsta+wgnazs1zpcy1a1qfdy43u7uthc-5qszqf_...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
I think I made some progress. I came up with this error when running it in
a script.
ERROR 1062 (23000) at line 1: Duplicate entry '4-CMH1-EXT-F01' for key 'rr1'
This is one of our firewalls that does not have a dns suffix. Apparently I
was incorrect when reporting all of my SysNames are accurate. Anyway to
account for SysNames not having a suffix?
-Chip
On Mon, Mar 3, 2014 at 11:14 AM, Chip Pleasants <[email protected]>wrote:
> Hi Carlos,
>
> Thanks for responding and sorry for these beginner SQL questions. Do I
> use Netdot's web interface or is more of a command line or SQL script. I
> adding your sql commands to a script and tried to add it to the netdot db
> but it didn't look like it did anything. When I added it to the text file
> for a command it didn't like the '' characters. I used single quotes in
> replace ' ' .
>
> -Chip
>
>
> mysql -u root -p
> mysql netdot < change-device-name.sql
>
> change-device-name.sql
>
> UPDATE device, rr SET rr.name=device.sysname
> WHERE device.name = rr.id
> AND device.sysname is not NULL
> AND device.sysname != '';
>
>
>
>
>
>
> On Mon, Mar 3, 2014 at 9:43 AM, Carlos Vicente <[email protected]>wrote:
>
>> Chip,
>>
>> There is no need to delete all devices.
>>
>> You can probably accomplish this with a simple SQL query. Something like:
>>
>> UPDATE device, rr SET rr.name=device.sysname
>> WHERE device.name = rr.id
>> AND device.sysname is not NULL
>> AND device.sysname != '';
>>
>> cv
>>
>> On Mar 3, 2014, at 9:31 AM, Chip Pleasants <[email protected]> wrote:
>>
>> > What's the best way to update the devices names in NetDot? I'm
>> changing the dns suffixes for my devices and would like to reflect the new
>> suffix and delete the only one in Netdot. Should I delete the devices and
>> rescan or is there a faster safer way? I don't want to blow away any Static
>> or Reserved addresses. I have about 1000 devices so manually would take
>> far too long. The System Names should be the new name today, so if there is
>> some way to use the System Name that would be great. Thanks in advance for
>> any assistance.
>> >
>> > Thanks,
>> > Chip
>> >
>> >
>> >
>> > _______________________________________________
>> > Netdot-users mailing list
>> > [email protected]
>> > https://osl.uoregon.edu/mailman/listinfo/netdot-users
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140303/223d284c/attachment-0001.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 64, Issue 2
*******************************************
