(RADIATOR) AddQuery in Session Databse SQL

[Hugh Irvine]

Hello Julio -

If you check in the SessSQL.pm module, you will see that the manual is 
incorrect (and I have just copied you on a note from another user telling us 
about this). You can also check the MySQL creation script 
("goodies/mysqlCreate.sql") to verify the columns that are created in the 
RADONLINE table (or use the mysqlshow command).

BTW - you do not have to specify the default queries, they are defined in the 
source code already.

Our apologies for the inaccuracy in the manual.

regards

Hugh

On Tuesday 29 May 2001 21:19, julio.prada at bt.es wrote:
> Hello,
>
> as the manual documentation says I put default addQuery:
>
>
> insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, \
> ACCTSESSIONID, TIME_STAMP, FRAMEDADDRESS, PORTTYPE, \
> SERVICETYPE) values ('%n', '%N', %{NAS-Port}, '%{Acct-Session-Id}', \
> %{Timestamp}, '%{Framed-IP-Address}', '%{Port-Type}', '%{Service-Type}')
>
> A mySQl database is used, and it returns the error in the statement.
>
> Is this sentence correct?
>
> regards,
> jules
>
> **********************************************
> Noticia legal
> Este mensaje electrónico contiene información de BT Telecomunicaciones S.A.
> que es privada y confidencial, siendo para el uso exclusivo de la
> persona(s) o entidades arriba mencionadas. Si usted no es el destinatario
> señalado, le informamos que cualquier divulgación, copia, distribución o
> uso de los contenidos está prohibida. Si usted ha recibido este mensaje por
> error, por favor borre su contenido y comuníquenoslo en la dirección
> postmaster at bt.es. Gracias
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.