Comments (5)
these are defined in the networkinfo
table. At the moment there is no GUI interface to modify this so it's necessary to modify the sql directly. See the "Network Info" section of https://github.com/inex/IXP-Manager/wiki/Installation-08-Setting-Up-Your-IXP
from ixp-manager.
Hi,
as I'm not an sql expert, can give me little help with the mysql sql syntax to
populate this table? Should be added to the wiki, as well.
I tried:
mysql> use ixp
mysql>INSERT INTO networkinfo (protocol, network, masklen, rs1address, rs2address, dnsfile) VALUES (4,"193.178.185.0",25,"193.178.185.5","193.178.185.6","/etc/bind/zones/185.178.193.in-addr.arpa.include") WHERE vlanid = 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 'WHERE vlanid=100' at line 1
mysql>
Thanks, Thorleif
from ixp-manager.
INSERT INTO networkinfo (vlanid, protocol, network, masklen, rs1address, rs2address, dnsfile) VALUES (100, 4,"193.178.185.0",25,"193.178.185.5","193.178.185.6","/etc/bind/zones/185.178.193.in-addr.arpa.include");
Make sure that you use vlanid
here. I.e. if you issue select id, name, number from vlan
, you need to use the value in the id
column.
from ixp-manager.
Ah, ok.
mysql> select id, name, number from vlan;
+----+--------------------------------+--------+
| id | name | number |
+----+--------------------------------+--------+
| 1 | BCIX Peering LAN | 100 |
gives me the id "1" for the insert:
INSERT INTO networkinfo (vlanid, protocol, network, masklen, rs1address, rs2address, dnsfile) VALUES (1, 4,"193.178.185.0",25,"193.178.185.5","193.178.185.6","/etc/bind/zones/185.178.193.in-addr.arpa.include");
and this looks fine:
mysql> select * from networkinfo;
+----+--------+----------+---------------+---------+---------------+---------------+--------------------------------------------------+
| id | vlanid | protocol | network | masklen | rs1address | rs2address | dnsfile |
+----+--------+----------+---------------+---------+---------------+---------------+--------------------------------------------------+
| 2 | 1 | 4 | 193.178.185.0 | 25 | 193.178.185.5 | 193.178.185.6 | /etc/bind/zones/185.178.193.in-addr.arpa.include |
+----+--------+----------+---------------+---------+---------------+---------------+--------------------------------------------------+
So the "vlanid" is not the Q-TAG number, but the Database-ID
from ixp-manager.
So the "vlanid" is not the Q-TAG number, but the Database-ID
yep, correct.
from ixp-manager.
Related Issues (20)
- Master branch docker-compose setup broken; web interface error HOT 1
- Allow 2fa to be enabled on a per customer basis
- exception handler for Irrdb\\UpdateAsnDb, Irrdb\\UpdatePrefixDb HOT 2
- Whois PeeringDB closed Jan 2024
- IX-F export: allow excluding VLANs HOT 2
- Use MANRS API HOT 4
- Missing required parameter for [Route: customer@overview] [URI: customer/overview/{cust}/{tab?}] HOT 4
- Setup wizard for the initial database objects
- Looking Glass Page Syntax Error ! HOT 2
- MySQL issues with Install Script HOT 2
- Collector Startup Failure After Upgrade to Version 6.4.0 HOT 8
- Core bundle statistic page missing selection fields in mobile view
- IX-F Member Export Cannot Exlcude ASN/Tag HOT 1
- Misspelling "Port Utilisation" HOT 2
- ISSUE WITH MRTG HOT 1
- The masklen must not be greater than 64. HOT 2
- logger: "Driver [null] is not supported." HOT 3
- VLAN into IXPmanager is informational? HOT 1
- `/switch/store-by-snmp` fails with error 405 HOT 2
- The layer2 provisioner API reports the wrong port name for interfaces on different switches HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ixp-manager.