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. Re: System error looking for a mac address (Michael T. Voity)
----------------------------------------------------------------------
Message: 1
Date: Mon, 27 Jan 2014 10:45:41 -0500
From: "Michael T. Voity" <[email protected]>
Subject: Re: [Netdot-users] System error looking for a mac address
To: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset="iso-8859-1"
Hello Again,
So I think I found my problem. The table 'fwtableentry' is missing.
What is the easiest way to get this table back? Is there a script I
can run? Can I manually add the table and fields?
Thanks,
-Mike
Michael T. Voity
Network Engineer
University of Vermont
On 1/15/2014 12:47 PM, Michael T. Voity wrote:
> Hello list,
>
> I think I have seen this error before and might have seen a solution
> before, but I cant seem to find the solution in the archives.
>
> I think I have to delete a table or dump a table in the MySQL DB?
>
> Here is the error:
>
> *error:* DBD::mysql::db selectall_arrayref failed: Table
> 'netdot.fwtableentry' doesn't exist [for Statement "SELECT ft.tstamp
> FROM physaddr p, interface i, fwtableentry fte, fwtable ft
> WHERE p.id=213716
> AND fte.physaddr=p.id
> AND fte.interface=i.id
> AND fte.fwtable=ft.id
> GROUP BY ft.tstamp
> ORDER BY ft.tstamp DESC
> LIMIT 10"] at /usr/local/netdot/lib/Netdot/Model/PhysAddr.pm line 687.
> *context:*
> *...*
> *683:* GROUP BY ft.tstamp
> *684:* ORDER BY ft.tstamp DESC
> *685:* LIMIT $limit";
> *686:*
> *687:* my @tstamps = @{ $dbh->selectall_arrayref($q1) };
> *688:* return unless @tstamps;
> *689:* my $tstamps = join ',', map { "'$_'" } map { $_->[0] } @tstamps;
> *690:*
> *691:* my $q2 = "SELECT ft.tstamp, i.id
> *...*
>
> *code stack:* /usr/local/netdot/lib/Netdot/Model/PhysAddr.pm:687
> /usr/local/netdot/htdocs/management/mac.html:108
> /usr/local/netdot/htdocs/management/device_tasks.html:60
> /usr/local/netdot/htdocs/management/autohandler:81
> /usr/local/share/perl5/HTML/Mason/Request.pm:951
> /usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21
> /usr/local/netdot/htdocs/autohandler:76
>
>
> -Mike
> --
> Michael T. Voity
> Network Engineer
> University of Vermont
>
>
> _______________________________________________
> 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/20140127/cb3766e3/attachment-0001.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 62, Issue 9
*******************************************
