#65 Problem on create new profile

[seamanlo]

Just downloaded v0.9.9 and trying to create new profile, encountered DB write error.

Database error
Error Message: DB Error: syntax error
Debug info: INSERT INTO (id,GroupName,Attribute,op,Value) VALUES (0, 'test', 'Cisco-AVPair','', 'abc') [nativecode=1064 ** 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 '(id,GroupName,Attribute,op,Value) VALUES (0, 'test', 'Cisco-AVPair','', 'abc')' at line 1]

seems the variable $table got an empty string on submit.

[Liran Tal]

Hi Seaman,

Can you please elaborate which version of daloRADIUS are you using?
I am assuming it's the downloaded package and you didn't clone the SVN repository from Sourceforge, right?

[seamanlo]

Hi, Liran,
Thank you for the quick reply. It is downloaded package 0.9.9.

Regards,
seaman.
2015/3/9 下午3:55 於 "Liran Tal" lirantal@users.sf.net 寫道：

Hi Seaman,

Can you please elaborate which version of daloRADIUS are you using?
I am assuming it's the downloaded package and you didn't clone the SVN
repository from Sourceforge, right?

---

• [bugs:#65] http://sourceforge.net/p/daloradius/bugs/65 Problem on
  create new profile*

Status: open
Group: v0.9
Created: Mon Mar 09, 2015 05:07 AM UTC by seamanlo
Last Updated: Mon Mar 09, 2015 05:07 AM UTC
Owner: nobody

Just downloaded v0.9.9 and trying to create new profile, encountered DB
write error.

Database error
Error Message: DB Error: syntax error
Debug info: INSERT INTO (id,GroupName,Attribute,op,Value) VALUES (0,
'test', 'Cisco-AVPair','', 'abc') [nativecode=1064 ** 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 '(id,GroupName,Attribute,op,Value)
VALUES (0, 'test', 'Cisco-AVPair','', 'abc')' at line 1]

seems the variable $table got an empty string on submit.

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/daloradius/bugs/65/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

[Liran Tal]

Can you please check the configuration file in library/daloradius.conf.php and make sure that all database table names are set?

If that doesn't work I'd like to ask you to clone the SVN repository and try again.

[seamanlo]

I have check that all the table names are set in daloradius.conf.php.

I have also put the 0.9.9 from the SVN repository and the situation are the same.

does the new profile need to decide which table need to write? either radcheck or radreply table.

There is no tab in the page that user can select which profile type to be created.

[Liran Tal]

which page are you on specifically? and are you updating an existing profile or creating a new one?

[seamanlo]

i am having the problem when creating new profile and also adding new
attribute to existing profile. After review some code, it seems that when
adding new attribute, it does not pass along table name to the server.

regards,

Wilson

[Anonymous]

Liran, do you have any idea how this might be fixed?
I was looking at mng-rad-profiles-edit.php, I am just wondering where is field[3] was set when the form is submitted.

[Anonymous]

While creating Fortinet-Group-Name in Profile ?. I'm getting database error.

Error Message: DB Error: syntax error
Debug info: INSERT INTO (id,GroupName,Attribute,op,Value) VALUES (0, 'lowaccess', 'Fortinet-Group-Name','', 'firewall-lowaccess') [nativecode=1064 ** 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 '(id,GroupName,Attribute,op,Value) VALUES (0, 'lowaccess', 'Fortinet-Group-Name'' at line 1]

How do i fix this ?.

i'm on Ubuntu 14.04.4 LTS, daloRadius 0.9-9.

[Anonymous]

Is it possible you didn't select a value from the Target dropdown? This selector determines the table to use.

[Anonymous]

Can you post your daloradius.conf.php file?