[isf-wifidog] Error: couldn't find the requested token

[scott simecek]

wifidog=# SELECT * FROM tokens LEFT JOIN connections USING (token_id) WHERE token_id='0fb256df24fe39edb660474b9233c376';
             token_id             | token_template_id | token_status | token_lot_id |    token_creation_date     |           token_issuer           |           token_owner            | conn_id | timestamp_in | node_id | node_ip | timestamp_out | user_id | user_mac | user_ip | last_updated | incoming | outgoing | max_total_bytes | max_incoming_bytes | max_outgoing_bytes | expiration_date | logout_reason
----------------------------------+-------------------+--------------+--------------+----------------------------+----------------------------------+----------------------------------+---------+--------------+---------+---------+---------------+---------+----------+---------+--------------+----------+----------+-----------------+--------------------+--------------------+-----------------+---------------
 0fb256df24fe39edb660474b9233c376 |                   | UNUSED       |              | 2009-07-30 14:27:31.523969 | 1eaa8d96f9ff02ec0d836adc919f8ec4 | 1eaa8d96f9ff02ec0d836adc919f8ec4 |         |              |         |         |               |         |          |         |              |          |          |                 |                    |                    |                 |
(1 row)


-----Original Message-----
From: Benoit Grégoire [mailto:benoitg at coeus.ca]
Sent: Friday, July 31, 2009 12:13 PM
To: wifidog at listes.ilesansfil.org
Cc: scott simecek
Subject: Re: [isf-wifidog] Error: couldn't find the requested token

On July 31, 2009, scott simecek wrote:
> Sorry, I am not very good at postgres.  Do I need any other commands?
>
> #psql
> postgres=# SELECT * FROM tokens LEFT JOIN connections USING (token_id)
> WHERE token_id='0fb256df24fe39edb660474b9233c376'; ERROR:  relation
> "tokens" does not exist
> postgres=#

try:

psql wifidog

--
Benoit Grégoire