Send Netdot-devel mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
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-devel digest..."
Today's Topics:
1. [Netdot - Bug #1735] Table rrloc not Created
([email protected])
----------------------------------------------------------------------
Message: 1
Date: Wed, 6 Mar 2013 01:26:20 -0800
From: [email protected]
Subject: [Netdot-devel] [Netdot - Bug #1735] Table rrloc not Created
To: [email protected], [email protected],
[email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Issue #1735 has been updated by Adli Reza.
I faced this issue with netdot-1.0.4. Ran _$make installdb_, found out that
table 'rrloc' wasn't created.
I solved it by editing netdot.meta.
<pre>
6439 description => 'Location Information. See RFC1876',
6440 has_history => 0,
6441 index => [[]],
6442 isjoin => '0',
6443 label => [
</pre>
Change line 6441 to
*index => [],*
and run _$make installdb_ again, it should work.
----------------------------------------
Bug #1735: Table rrloc not Created
https://osl.uoregon.edu/redmine/issues/1735#change-3045
Author: Michael Lambert
Status: New
Priority: Normal
Assignee: Carlos Vicente
Category:
Target version:
Resolution:
Queries were complaining about not being able to find entries in the rrloc
table. I checked and it doesn't exist in the netdot database. I tried
creating it by hand with the output below. The platform is FreeBSD 9.1 on
amd64.
Michael
<pre>
% mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1048
Server version: 5.5.30-log Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> \u netdot
Database changed
mysql> describe rrloc;
ERROR 1146 (42S02): Table 'netdot.rrloc' doesn't exist
mysql> CREATE TABLE `rrloc` (
-> `altitude` bigint NOT NULL,
-> `horiz_pre` varchar(32) NULL,
-> `id` bigint NOT NULL auto_increment,
-> `latitude` bigint NOT NULL,
-> `longitude` bigint NOT NULL,
-> `rr` bigint NOT NULL,
-> `size` varchar(32) NULL,
-> `ttl` varchar(32) NULL,
-> `vert_pre` varchar(32) NULL,
-> UNIQUE INDEX `rrloc1` (`rr`),
-> INDEX `RRLOC2` (``),
-> PRIMARY KEY (`id`),
-> CONSTRAINT `fk_rr_4` FOREIGN KEY (`rr`) REFERENCES `rr` (`id`)
-> ) ENGINE=InnoDB;
ERROR 1072 (42000): Key column '' doesn't exist in table
mysql>
</pre>
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
_______________________________________________
Netdot-devel mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
End of Netdot-devel Digest, Vol 72, Issue 2
*******************************************
