Re: Era in MYSQL RealTime
On Sat, 14 Aug 2021 at 01:30, Yah's Global Kingdom wrote: > I am using version 16.13.0. I don't know what would be making the query, > or if there are other fields that it requires. The documentation > say's field order is important. > I would recommend to follow this https://openmeetings.apache.org/AsteriskIntegration.html guide step-by-step I had no issues with the `sipuser` table :( > On Thu, Aug 12, 2021 at 7:22 PM Maxim Solodovnik > wrote: > >> OM creates "sipusers" DB table >> but column "insecure" is NOT created >> >> I saw no issues with this >> >> what version of Asterisk are you using? >> >> I guess you can manually add the desired column to this DB table :) >> >> On Thu, 12 Aug 2021 at 09:29, Yah's Global Kingdom >> wrote: >> >>> I am getting the following era in Asterisk trying to implement VOIP SIP >>> integration >>> resconfig_mysq.c: 513 realtime_multi_mysql: MySQL RealTime: Failed to >>> query database: unknown column 'insecure' in 'where clause' >>> >>> I "assume" this is coming from sipusers table. However I know what the >>> order of the fields are and were this field should be added. >>> >>> Miles >>> >> >> >> -- >> Best regards, >> Maxim >> > -- Best regards, Maxim
Re: Era in MYSQL RealTime
I am using version 16.13.0. I don't know what would be making the query, or if there are other fields that it requires. The documentation say's field order is important. On Thu, Aug 12, 2021 at 7:22 PM Maxim Solodovnik wrote: > OM creates "sipusers" DB table > but column "insecure" is NOT created > > I saw no issues with this > > what version of Asterisk are you using? > > I guess you can manually add the desired column to this DB table :) > > On Thu, 12 Aug 2021 at 09:29, Yah's Global Kingdom > wrote: > >> I am getting the following era in Asterisk trying to implement VOIP SIP >> integration >> resconfig_mysq.c: 513 realtime_multi_mysql: MySQL RealTime: Failed to >> query database: unknown column 'insecure' in 'where clause' >> >> I "assume" this is coming from sipusers table. However I know what the >> order of the fields are and were this field should be added. >> >> Miles >> > > > -- > Best regards, > Maxim >
Re: Era in MYSQL RealTime
OM creates "sipusers" DB table but column "insecure" is NOT created I saw no issues with this what version of Asterisk are you using? I guess you can manually add the desired column to this DB table :) On Thu, 12 Aug 2021 at 09:29, Yah's Global Kingdom wrote: > I am getting the following era in Asterisk trying to implement VOIP SIP > integration > resconfig_mysq.c: 513 realtime_multi_mysql: MySQL RealTime: Failed to > query database: unknown column 'insecure' in 'where clause' > > I "assume" this is coming from sipusers table. However I know what the > order of the fields are and were this field should be added. > > Miles > -- Best regards, Maxim
Era in MYSQL RealTime
I am getting the following era in Asterisk trying to implement VOIP SIP integration resconfig_mysq.c: 513 realtime_multi_mysql: MySQL RealTime: Failed to query database: unknown column 'insecure' in 'where clause' I "assume" this is coming from sipusers table. However I know what the order of the fields are and were this field should be added. Miles