21 Dec
2009
21 Dec
'09
9:02 a.m.
Hello,
I had added successfully several users by :
kamctl add xxx yyy
How can I list all users that exist in the DB?
Rgs,
Rafi
21 Dec
21 Dec
9:25 a.m.
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/
3:19 p.m.
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(a)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/
3:53 p.m.
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".
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.
Regards,
Henning
4:03 p.m.
Hello,
On 12/21/09 9:53 PM, Henning Westerholt wrote:
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
--
Daniel-Constantin Mierla
* http://www.asipto.com/
On Mon, December 21, 2009 9:19 pm, Rafi Gordon wrote:
good eye, thanks!
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".
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.
22 Dec
22 Dec
2:09 a.m.
Hello,
Thnaks! my badness. Indeed:
"kamctl db show subscriber"
works,
Rafi
On Mon, Dec 21, 2009 at 11:03 PM, Daniel-Constantin Mierla
<miconda(a)gmail.com> wrote:
Hello,
On 12/21/09 9:53 PM, Henning Westerholt wrote:
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
--
Daniel-Constantin Mierla
* http://www.asipto.com/
On Mon, December 21, 2009 9:19 pm, Rafi Gordon wrote:
good eye, thanks!
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".
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.
5503
days inactive
5504
days old
5 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Henning Westerholt -
Rafi Gordon