[ refdb-Bugs-1545233 ] 0.9.7 refdba command "listuser" doesn't work

Bugs item #1545233, was opened at 2006-08-23 13:53
Message generated for change (Comment added) made by mhoenicka
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1545233&group_id=26091

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: refdbd
Group: None
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: akusmin (akusmin)
Assigned to: Markus Hoenicka (mhoenicka)
Summary: 0.9.7 refdba command "listuser" doesn't work

Initial Comment:
after starting  refdbd as root with the command:
refdbd -s -e 0 -l 7  

I start refdba:
 refdba -u root

And I give password.

Command listdb lists databases.

Command "listuser" returns:

select failed

Slackware 10.2, database engine mysql 4.1.14

----------------------------------------------------------------------

>Comment By: Markus Hoenicka (mhoenicka)
Date: 2006-08-24 21:50

Message:
Logged In: YES 
user_id=85809

I've added a check for the database option in the listuser
command.

----------------------------------------------------------------------

Comment By: Markus Hoenicka (mhoenicka)
Date: 2006-08-23 14:37

Message:
Logged In: YES 
user_id=85809

The listuser command requires the -d option to specify a
database, otherwise RefDB does not know where to look for users.

refdba: listuser -d mydb .*

should work ok. Therefore, the bug is that refdba does not
check for the missing database and thus causes a less than
helpful error message.

If you want to know the users of all available reference
databases, you're currently out of luck. If you need this
functionality, please feel free to submit a feature request.


----------------------------------------------------------------------

Comment By: akusmin (akusmin)
Date: 2006-08-23 13:58

Message:
Logged In: YES 
user_id=1462269

This is output in the xterm where refdbd was launched:

listuser  -u root -w 052060047061121037092101123
dbi is up
localhost
root
---mypassword--
3306
mysql
/usr/local/var/lib/refdb/db

refdb
connected to database server using database:
refdb
Main database looks ok:
refdb
localhost
root
---mypassword---



3306
mysql
/usr/local/var/lib/refdb/db

refdb
connected to database server using database:
refdb
SELECT VERSION()
1146: Table 'refdb.t_user' doesn't exist
SELECT DISTINCT user_name FROM t_user WHERE user_name RLIKE '.*'
select failed
child finished client on fd 5
child exited with code 1


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1545233&group_id=26091

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642