Install SQL Procedures to your radius database (Syntax error when trying to load the procedure to MariaDB )

[kraman2681]

Hi Joze,

thanks very much for your API documentation, was trying to test this, on steps-3 when trying to install this procedure on MYSQL which is Maria-DB, I see there is syntax error, I am not a DB expert, hence struggling on how to find and fix the syntax, is this something you can help

I tried to load your NAS procedure-nasAdd.sql which is below,

USE radius;

DELIMITER $$
USE radius$$

CREATE PROCEDURE nasAdd (
IN _nasname VARCHAR(128),
IN _shortname VARCHAR(32),
IN _type VARCHAR(30),
IN _secret VARCHAR(60),
IN _description VARCHAR(200)
)
BEGIN
INSERT INTO nas (nasname, shortname, type, secret, description)
VALUES (_nasname, _shortname, _type, _secret, _description);

when I try to create a a stored procedure using mySql work bench and try to just paste your details, I get syntax error as shown below or attached

please can you help,
I have same issue even when I load the user add or edit SQL as well

Thanks
Kiran

[kraman2681]

The error is specifically for NAS
at line number 10

root@admin:/opt/radius-api/extra/database# cat -n procedure-nasAdd.sql
1 USE radius;
2
3 DELIMITER $$
4 USE radius$$
5
6 CREATE PROCEDURE nasAdd (
7 IN _nasname VARCHAR(128),
8 IN _shortname VARCHAR(32),
9 IN _type VARCHAR(30),
10 IN _secret VARCHAR(60), <<<<<<<
11 IN _description VARCHAR(200)
12 )
13 BEGIN
14 INSERT INTO nas (nasname, shortname, type, secret, description)
15 VALUES (_nasname, _shortname, _type, _secret, _description);
16 ENDroot@admin:/opt/radius-api/extra/database#

attached is error seen when I execute that SQL procedure.

Thanks
Kiran