New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

function 'manuf' does not exist in mac #132

jean1 opened this Issue Sep 10, 2014 · 0 comments


None yet
2 participants

jean1 commented Sep 10, 2014

Date: Thu, 22 May 2014 15:30:38 +0200
From: Emmanuel Dollé
Subject: [netmagis] Problems with MAC module.

I want to use the MAC module but I have some difficulties with
it. I configure the Metro module first and I see data from my Procurve
switches into "/data/metro/report" directory ant into the "portmac"
table. Also, when I consult the "MAC stats" page, I see 3700 MAC
addresses into "Number of unique MAC addresses". But when I try to
search a existing MAC address into the "MAC search", I have this
message (debug mode) :

ERROR: the function manuf(unknown) does not exist
LINE 1: SELECT manuf('f0:4d:a2:24:22:89') AS m
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
while executing
"pg_select $mdbfd "SELECT manuf('$mac') AS m" tab {
set manuf $tab(m)
(procedure "display-mac" line 9)
invoked from within
"display-mac $mdbfd $tab(mac)"
("pg_select" body line 4)
invoked from within
"pg_select $mdbfd $sql tab {
incr n
set portmac_assoc_link [gen-link [mc "Details"]
(procedure "gen-choice-portmac" line 16)
invoked from within
"gen-choice-portmac $mdbfd $ndbfd "(data).mac='$mac'""

@pdav pdav added the bug label Sep 10, 2014

@pdav pdav added this to the v2.2.3 milestone Sep 10, 2014

pdav added a commit that referenced this issue Sep 10, 2014

Fill OUI information from IEEE into MAC database
Close #132

Welcome the new netmagis-getoui program which fetches the
OUI database from IEEE web site, and updates the mac.oui
table in MAC database.

This program is meant to be used:
- once in database creation (see netmagis-dbcreate)
- periodically (see example crontab)

@pdav pdav closed this Sep 10, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment