[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Re: rlm_sql_getvpdata: database query error
From:       phil lemelin <phil.lemelin () gmail ! com>
Date:       2009-03-26 19:34:45
Message-ID: efe037fe0903261234r68674914u2118cc32208769de () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


On Thu, Mar 26, 2009 at 3:30 PM, <tnt@kalik.net> wrote:

> > radius_xlat:  'SELECT \
> > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheckAttribute,radgroupcheck.Value,radgroupcheck.op
> > 
> FROM radgroupcheck,usergroup WHERE usergroup.Username = '0021709d3d47' AND
> usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
> > rlm_sql_mysql: MYSQL check_error: 1146 received
> > rlm_sql_getvpdata: database query error
> > radius_xlat:  'SELECT id, UserName, Attribute, Value, op           FROM
> radreply           WHERE Username = '0021709d3d47'           ORDER BY id'
> > radius_xlat:  'SELECT \
> > radgroupreply.id,radgroupreply.GroupName,radgroupreplyAttribute,radgroupreply.Value,radgroupreply.op
> > 
> FROM radgroupreply,usergroup WHERE usergroup.Username = '0021709d3d47' AND
> usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
> > rlm_sql_mysql: MYSQL check_error: 1146 received
> > rlm_sql_getvpdata: database query error
> 
> Hm, mysql error 1146 is - table does not exist. Do you have
> radgroupcheck, radgroupreply and usergroup tables in your radius
> database? Are the names correct? If you made them using script provided
> with the server this shouldn't happen.
> 
> Ivan Kalik
> Kalik Informatika ISP
> 

I had table does not exist error.

At first, I installed the freeradius server using the yum repository and ran
the script to fill mysql with that.
Then, following the suggestions here, I upgraded the server but forgot to
re-run the scripts and ended up with missing tables. Maybe that's what
happened here following the suggestion to upgrade.


-- 
Philippe-Alexandre Lemelin


[Attachment #5 (text/html)]

<br><br><div class="gmail_quote">On Thu, Mar 26, 2009 at 3:30 PM,  <span \
dir="ltr">&lt;<a href="mailto:tnt@kalik.net">tnt@kalik.net</a>&gt;</span> \
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, \
204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> &gt;radius_xlat:  &#39;SELECT \
<a href="http://radgroupcheck.id" \
target="_blank">radgroupcheck.id</a>,radgroupcheck.GroupName,radgroupcheckAttribute,radgroupcheck.Value,radgroupcheck.op \
FROM radgroupcheck,usergroup WHERE usergroup.Username = &#39;0021709d3d47&#39; AND \
usergroup.GroupName = radgroupcheck.GroupName ORDER BY <a \
href="http://radgroupcheck.id" target="_blank">radgroupcheck.id</a>&#39;<br>

<div class="im">&gt;rlm_sql_mysql: MYSQL check_error: 1146 received<br>
&gt;rlm_sql_getvpdata: database query error<br>
&gt;radius_xlat:  &#39;SELECT id, UserName, Attribute, Value, op           FROM \
radreply           WHERE Username = &#39;0021709d3d47&#39;           ORDER BY \
id&#39;<br> </div>&gt;radius_xlat:  &#39;SELECT <a href="http://radgroupreply.id" \
target="_blank">radgroupreply.id</a>,radgroupreply.GroupName,radgroupreplyAttribute,radgroupreply.Value,radgroupreply.op \
FROM radgroupreply,usergroup WHERE usergroup.Username = &#39;0021709d3d47&#39; AND \
usergroup.GroupName = radgroupreply.GroupName ORDER BY <a \
href="http://radgroupreply.id" target="_blank">radgroupreply.id</a>&#39;<br>

<div class="im">&gt;rlm_sql_mysql: MYSQL check_error: 1146 received<br>
&gt;rlm_sql_getvpdata: database query error<br>
<br>
</div>Hm, mysql error 1146 is - table does not exist. Do you have<br>
radgroupcheck, radgroupreply and usergroup tables in your radius<br>
database? Are the names correct? If you made them using script provided<br>
with the server this shouldn&#39;t happen.<br>
<div class="im"><br>
Ivan Kalik<br>
Kalik Informatika ISP<br>
</div></blockquote><div><br>I had table does not exist error.<br><br>At first, I \
installed the freeradius server using the yum repository and ran the script to fill \
mysql with that. <br>Then, following the suggestions here, I upgraded the server but \
forgot to re-run the scripts and ended up with missing tables. Maybe that&#39;s what \
happened here following the suggestion to upgrade.<br> <br></div></div><br>-- \
<br>Philippe-Alexandre Lemelin<br>



-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

[prev in list] [next in list] [prev in thread] [next in thread]