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

[SourceForge.net]

Bugs item #1545233, was opened at 2006-08-23 11:53
Message generated for change (Tracker Item Submitted) made by Item Submitter
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: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: akusmin (akusmin)
Assigned to: Nobody/Anonymous (nobody)
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

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

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

[SourceForge.net]

Bugs item #1545233, was opened at 2006-08-23 11:53
Message generated for change (Comment added) made by akusmin
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: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: akusmin (akusmin)
Assigned to: Nobody/Anonymous (nobody)
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: akusmin (akusmin)

Date: 2006-08-23 11: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

[SourceForge.net]

Bugs item #1545233, was opened at 2006-08-23 13:53
Message generated for change (Settings changed) 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: Open
Resolution: None
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: 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

[SourceForge.net]

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: Open
Resolution: None
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-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

[SourceForge.net]

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