Hello, Thanks! I am total noob in this. I tried :

kamctl db show ERROR: missing table parameter

And then:

root# kamctl db show subsciber ERROR 1146 (42S02) at line 1: Table 'openser.subsciber' doesn't exist

root# kamctl db show mysql ERROR 1146 (42S02) at line 1: Table 'openser.mysql' doesn't exist

which parameter should I pass ?

Regards, Rafi

On Mon, Dec 21, 2009 at 4:25 PM, Daniel-Constantin Mierla miconda@gmail.com wrote:

Hello,

On 12/21/09 3:02 PM, Rafi Gordon wrote:

...

Hello, I had added successfully several users by : kamctl add xxx yyy

How can I list all users that exist in the DB?

you can use the 'db show' command, which works with any table in db as parameter:

kamctl db show subsctiber

Cheers, Daniel

-- Daniel-Constantin Mierla

• http://www.asipto.com/

Hello,

On 12/21/09 9:53 PM, Henning Westerholt wrote:

On Mon, December 21, 2009 9:19 pm, Rafi Gordon wrote:

...

root# kamctl db show subsciber ERROR 1146 (42S02) at line 1: Table 'openser.subsciber' doesn't exist

Hey Rafi,

there is a spelling error in the statement above, the correct name for the table is "subscriber".

good eye, thanks!

...

root# kamctl db show mysql ERROR 1146 (42S02) at line 1: Table 'openser.mysql' doesn't exist

This will not work, as there is no table with this name in the openser database scheme.

just to mention that one can execute via kamctl any SQL query over openser database, see:

kamctl db roquery kamctl db query

For example:

kamctl db roquery "describe subscriber"

Cheers, Daniel