Menu

#64 create new user attribute fails

v0.9
open
nobody
None
1
2014-10-17
2014-10-17
Anonymous
No

if i try to add a 2nd attribute to a user i get following error:

Database error
Error Message: DB Error: syntax error
Debug info: SELECT Attribute FROM WHERE UserName='xxxxx' AND Attribute='MS-CHAP-Use-NTLM-Auth' AND id=0 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE UserName='xxxxx' AND Attribute='MS-CHAP-Use-NTLM-Auth' AND id=0' at line 1]

SELECT Attribute FROM WHERE

there is a missing 'radcheck' between FROM and WHERE.

thanks

Discussion

  • Liran Tal

    Liran Tal - 2014-10-17

    Indeed looks like it's missing.

    1. Which daloRADIUS verion is it? and can you test working with the SVN code?
    2. Please take a look in your library/daloradius.conf.php that there's a table specified for radcheck, and that it exists in your database too.
     
    • Anonymous

      Anonymous - 2014-10-20

      Hi, i work already on svn.
      ['CONFIG_DB_TBL_RADCHECK'] = 'radcheck'; is set

      if i add on line 499 in mng-edit.php: $table="radcheck";
      it works too.

       

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB