I decided to do a new install. Because it's fun! My version was old anyway.
On install, I get this:
mysql> source /opt/netdb/createnetdb.sql
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
Query OK, 0 rows affected (0.05 sec)
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's_speed` varchar(30),
`minutes` INT,
`uptime` varchar(55),
`firstseen` dat' at line 8
mysql>
[root@networker5 netdb]# mysql -V
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
What's my problem? (I'm network engineer, damnit! Not a linux admin!)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
OOPS, I meant to test that script. For now, add in the missing backtick on s_name. I’ll package up an update to resolve this. Thanks again for being an early tester:
-- mac table data from switches
CREATE TABLE switchports ( switch varchar(100) NOT NULL, port varchar(30) NOT NULL, mac varchar(20) NOT NULL, type varchar(30), s_vlan varchar(20), s_ip varchar(32), s_name varchar(100),
^
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's_speedvarchar(30),minutesINT,uptimevarchar(55),firstseen` dat' at line 8
mysql> [root@networker5 netdb]# mysql -V
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
What's my problem? (I'm network engineer, damnit! Not a linux admin!)
Great, the short-lived 1.13.0 has been updated to 1.13.1. Hopefully everything else should be smooth. You should be able to import your old database using the backup and restore netdbctl functions, but you’ll have to run the SQL update scripts from the version you were on to get it up to v1.13. They’re in the /opt/netdb/sql/ directory.
Hiya -
I decided to do a new install. Because it's fun! My version was old anyway.
On install, I get this:
[root@networker5 netdb]# mysql -V
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
What's my problem? (I'm network engineer, damnit! Not a linux admin!)
OOPS, I meant to test that script. For now, add in the missing backtick on s_name. I’ll package up an update to resolve this. Thanks again for being an early tester:
-- mac table data from switches
CREATE TABLE
switchports
(switch
varchar(100) NOT NULL,port
varchar(30) NOT NULL,mac
varchar(20) NOT NULL,type
varchar(30),s_vlan
varchar(20),s_ip
varchar(32),s_name
varchar(100),^
Jonathan
On Oct 22, 2014, at 2:00 PM, Pete hoffswell hoffswell@users.sf.net wrote:
Fixed! Thanks!
Great, the short-lived 1.13.0 has been updated to 1.13.1. Hopefully everything else should be smooth. You should be able to import your old database using the backup and restore netdbctl functions, but you’ll have to run the SQL update scripts from the version you were on to get it up to v1.13. They’re in the /opt/netdb/sql/ directory.
Jonathan
On Oct 22, 2014, at 2:08 PM, Pete hoffswell hoffswell@users.sf.net wrote: