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 (Carlos Vicente)
----------------------------------------------------------------------
Message: 1
Date: Mon, 27 Jan 2014 21:52:24 -0500
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] System error looking for a mac address
To: "Michael T. Voity" <[email protected]>,
"[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hello Michael,
That's odd.
The easiest way would be to copy the table definition from the
etc/schema.mysql file. You should have a copy from when you installed.
But here it is for your convenience:
CREATE TABLE `fwtableentry` (
`fwtable` bigint NOT NULL,
`id` bigint NOT NULL auto_increment,
`interface` bigint NOT NULL,
`physaddr` bigint NOT NULL,
INDEX `FWTableEntry1` (`fwtable`),
INDEX `FWTableEntry2` (`interface`),
INDEX `FWTableEntry3` (`physaddr`),
PRIMARY KEY (`id`),
CONSTRAINT `fk_fwtable` FOREIGN KEY (`fwtable`) REFERENCES `fwtable`
(`id`),
CONSTRAINT `fk_interface_1` FOREIGN KEY (`interface`) REFERENCES
`interface` (`id`),
CONSTRAINT `fk_physaddr_3` FOREIGN KEY (`physaddr`) REFERENCES
`physaddr` (`id`)
) ENGINE=InnoDB;
Then you need to paste it into your mysql client, like:
# mysql -u netdot_user -p <netdot_password> netdot
> [paste here]
>quit;
Best,
cv
On 1/27/14, 10:45 AM, Michael T. Voity wrote:
> 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
>
>
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 62, Issue 10
********************************************
