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.