this is an old post, but still i will comment. I ran into this myself and a 
quick answer would have been nice.

mysql sees the field named key as a reserved word. At the mysql commandline 
i enclosed the field name key with backticks `key`.
I was then able to add my users via the command line.

On Monday, February 4, 2013 at 12:30:23 AM UTC-6, hzzg6y wrote:
>
> Additionally mysql Insert command at mysql prompt is not updating the 
> records...  Our expectation is that we should able to add the users on this 
> prosoxy xmpp
> server via PHP script.
>
> mysql> insert into prosody (host,user,store,key,type,value) value ("
> example.com","john","accounts","key","type" "password");
>
> Any pointers will help.
>
> Rgds,
>
>
> On Sunday, February 3, 2013 11:08:34 PM UTC+5:30, hzzg6y wrote:
>>
>> Please review the below table created by prosody... Please let me know 
>> how should we manage the groups in such cases...  Objective is to group 
>> uses in particular group of users & they should be authenticated via mysql. 
>> Please advice.
>>
>>
>> mysql> select * from prosody;
>> +---------------+------------+----------+----------+--------+----------+
>> | host          | user       | store    | key      | type   | value    |
>> +---------------+------------+----------+----------+--------+----------+
>> | example.com | johny        | accounts | password | string | password |
>> | example.com | ramram       | accounts | password | string | password |
>> +---------------+------------+----------+----------+--------+----------+
>> 2 rows in set (0.00 sec)
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"prosody-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to prosody-dev+unsubscr...@googlegroups.com.
To post to this group, send email to prosody-dev@googlegroups.com.
Visit this group at http://groups.google.com/group/prosody-dev.
For more options, visit https://groups.google.com/d/optout.

Reply via email to