Query error in Acct table for Tenant_ID

[Emrah Yıldırım]

 >Apparently you are.  Because you didn't create a syntactically correct
MySQL query.

You may be right about what you say, but I disagree. I researched it, and I
did my best. There's a syntax in the middle, and I've asked for help to
rectify my mistake here.

I don't have a lot of information about this. I managed to investigate a
number of queries. as follows

authorize_check_query = "\
SELECT ${authcheck_table}.id, ${authcheck_table}.username,
${authcheck_table}.attribu, ${authcheck_table}.value,
${authcheck_table}.op, ${authcheck_table}.tenant_id,
${client_table}.realipaddr \
FROM ${authcheck_table} INNER JOIN ${client_table} \
ON username = '%{SQL-User-Name}' \
AND ${client_table}.realipaddr = '%{NAS-IP-Address}' \
ORDER BY id"

>I've been doing this for twenty years.  The only people who complain about
not being helped are the people who ignore the help that they're given.

If you've been doing this for 20 years, it's weird that you said I'd stop
the slightest complaint. I didn't disrespect anyone.

I won't extend the polemic anymore. Excuse me, I'm sorry.

2018-03-21 10:42 GMT+03:00 Alan DeKok <aland at deployingradius.com>:

> On Mar 20, 2018, at 6:13 PM, Emrah Yıldırım <emrah.yldrm81 at gmail.com>
> wrote:
> >
> > You misunderstand me... I'm not the kind of guy who tries to get ready
> > information without doing research.
>
>   Apparently you are.  Because you didn't create a syntactically correct
> MySQL query.
>
> > You do the same thing to me every time, I have a grudge... Tell me my
> > brother if I write...
>
>   You shouldn't have a grudge.  You should *clue in*.  And learn how to
> ask good questions.
>
> > I don't know what happened to the bandwagon as we share information.
> >
> > What if you could help us in this life for two minutes?
>
>   I've been doing this for twenty years.  The only people who complain
> about not being helped are the people who ignore the help that they're
> given.
>
>   Stop complaining and start following instructions.  This is your only
> warning.  If you keep complaining about how mean we are for helping you,
> you will be unsubscribed from the list and permanently banned.
>
>   Alan DeKok.
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/
> list/users.html
>