Mysql lastinsertid

List overview All Threads
Download

newer

older

Log-level Kamailio IMS

Best Module for CPS per IP - PIKE...

Kjeld Flarup

12 Aug 2020 12 Aug '20

1:09 a.m.

Show replies by date

Daniel-Constantin Mierla

12 Aug 12 Aug

12:14 p.m.

Hello, do you need it in the configuration file, or inside C code? Cheers, Daniel On 12.08.20 00:09, Kjeld Flarup wrote:

...

Hello I wonder if there is some way to get the lastinsertid from an "INSERT INTO" sql_query -- -------------------- Med Liberalistiske Hilsner ---------------------- Civilingeniør, Kjeld Flarup - Mit sind er mere åbent end min tegnebog Sofienlundvej 6B, 7560 Hjerm, Tlf: 40 29 41 49 Den ikke akademiske hjemmeside for liberalismen - www.liberalismen.dk _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

-- Daniel-Constantin Mierla -- www.asipto.com www.twitter.com/miconda -- www.linkedin.com/in/miconda Funding: https://www.paypal.me/dcmierla

Kjeld Flarup

12:24 p.m.

In the configuration file. Kjeld Den ons. 12. aug. 2020 kl. 11.14 skrev Daniel-Constantin Mierla < miconda(a)gmail.com>gt;:

...

Hello, do you need it in the configuration file, or inside C code? Cheers, Daniel On 12.08.20 00:09, Kjeld Flarup wrote:

-- Daniel-Constantin Mierla -- www.asipto.com www.twitter.com/miconda -- www.linkedin.com/in/miconda Funding: https://www.paypal.me/dcmierla

-- --------------------- Med Liberalistiske Hilsner ---------------------- Civilingeniør, Kjeld Flarup - Mit sind er mere åbent end min tegnebog Sofienlundvej 6B, 7560 Hjerm, Tlf: 40 29 41 49 Den ikke akademiske hjemmeside for liberalismen - www.liberalismen.dk

Daniel-Constantin Mierla

1:25 p.m.

Have you tried to do "SELECT LAST_INSERT_ID()" with sql_query() from sqlops module? Cheers, Daniel On 12.08.20 11:24, Kjeld Flarup wrote:

...

In the configuration file. Kjeld Den ons. 12. aug. 2020 kl. 11.14 skrev Daniel-Constantin Mierla <miconda(a)gmail.com <mailto:miconda@gmail.com>>: Hello, do you need it in the configuration file, or inside C code? Cheers, Daniel On 12.08.20 00:09, Kjeld Flarup wrote:

Hello I wonder if there is some way to get the lastinsertid from an

"INSERT

INTO" sql_query -- -------------------- Med Liberalistiske Hilsner

----------------------

Civilingeniør, Kjeld Flarup - Mit sind er mere åbent end min

tegnebog

Sofienlundvej 6B, 7560 Hjerm, Tlf: 40 29 41 49 Den ikke akademiske hjemmeside for liberalismen -

www.liberalismen.dk <http://www.liberalismen.dk>

_______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org <mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

-- Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda> Funding: https://www.paypal.me/dcmierla -- --------------------- Med Liberalistiske Hilsner ---------------------- Civilingeniør, Kjeld Flarup - Mit sind er mere åbent end min tegnebog Sofienlundvej 6B, 7560 Hjerm, Tlf: 40 29 41 49 Den ikke akademiske hjemmeside for liberalismen - www.liberalismen.dk <http://www.liberalismen.dk> _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

-- Daniel-Constantin Mierla -- www.asipto.com www.twitter.com/miconda -- www.linkedin.com/in/miconda Funding: https://www.paypal.me/dcmierla

Kjeld Flarup

11:55 p.m.

Hi Daniel I can do that, but am I guaranteed, that the right value is returned? Kamailio is multithreaded, and I do now know if the mysql connection is shared across threads. -------------------- Med Liberalistiske Hilsner ---------------------- Civilingeniør, Kjeld Flarup - Mit sind er mere åbent end min tegnebog Sofienlundvej 6B, 7560 Hjerm, Tlf: 40 29 41 49 Den ikke akademiske hjemmeside for liberalismen - www.liberalismen.dk On 8/12/20 12:25 PM, Daniel-Constantin Mierla wrote:

...

Have you tried to do "SELECT LAST_INSERT_ID()" with sql_query() from sqlops module? Cheers, Daniel On 12.08.20 11:24, Kjeld Flarup wrote:

Hello I wonder if there is some way to get the lastinsertid from an

"INSERT

INTO" sql_query -- -------------------- Med Liberalistiske Hilsner

----------------------

Civilingeniør, Kjeld Flarup - Mit sind er mere åbent end min

tegnebog

Sofienlundvej 6B, 7560 Hjerm, Tlf: 40 29 41 49 Den ikke akademiske hjemmeside for liberalismen -

www.liberalismen.dk <http://www.liberalismen.dk>

-- Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com> www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda> Funding: https://www.paypal.me/dcmierla -- --------------------- Med Liberalistiske Hilsner ---------------------- Civilingeniør, Kjeld Flarup - Mit sind er mere åbent end min tegnebog Sofienlundvej 6B, 7560 Hjerm, Tlf: 40 29 41 49 Den ikke akademiske hjemmeside for liberalismen -www.liberalismen.dk <http://www.liberalismen.dk> _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

-- Daniel-Constantin Mierla --www.asipto.com www.twitter.com/miconda --www.linkedin.com/in/miconda Funding:https://www.paypal.me/dcmierla

Fred Posner

13 Aug 13 Aug

12:08 a.m.

On Wed, 2020-08-12 at 22:55 +0200, Kjeld Flarup wrote:

...

Hi Daniel I can do that, but am I guaranteed, that the right value is returned? Kamailio is multithreaded, and I do now know if the mysql connection is shared across threads.

That is a general sql question, not particular to kamailio... To me, personally, this is a good use case of a stored procedure, and then having that stored procedure return to you the information you want as a result of the sql action taken. -- Fred Posner fred(a)palner.com https://www.palner.com Need Fred? Call Fred. 336-HEY-FRED Matrix: @fred:matrix.lod.com

Henning Westerholt

12:14 a.m.

Hello, Kamailio is not multi-threaded, it is multi-process. Each process opens its own connection to the DB. Cheers, Henning -- Henning Westerholt – https://skalatan.de/blog/ Kamailio services – https://gilawa.com<https://gilawa.com/> From: sr-users <sr-users-bounces(a)lists.kamailio.org> On Behalf Of Kjeld Flarup Sent: Wednesday, August 12, 2020 10:55 PM To: miconda(a)gmail.com; Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org> Subject: Re: [SR-Users] Mysql lastinsertid Hi Daniel I can do that, but am I guaranteed, that the right value is returned? Kamailio is multithreaded, and I do now know if the mysql connection is shared across threads. -------------------- Med Liberalistiske Hilsner ---------------------- Civilingeniør, Kjeld Flarup - Mit sind er mere åbent end min tegnebog Sofienlundvej 6B, 7560 Hjerm, Tlf: 40 29 41 49 Den ikke akademiske hjemmeside for liberalismen - www.liberalismen.dk<http://www.liberalismen.dk> On 8/12/20 12:25 PM, Daniel-Constantin Mierla wrote: Have you tried to do "SELECT LAST_INSERT_ID()" with sql_query() from sqlops module? Cheers, Daniel On 12.08.20 11:24, Kjeld Flarup wrote: In the configuration file. Kjeld Den ons. 12. aug. 2020 kl. 11.14 skrev Daniel-Constantin Mierla <miconda@gmail.com<mailto:miconda@gmail.com>>: Hello, do you need it in the configuration file, or inside C code? Cheers, Daniel On 12.08.20 00:09, Kjeld Flarup wrote:

...

Hello I wonder if there is some way to get the lastinsertid from an "INSERT INTO" sql_query -- -------------------- Med Liberalistiske Hilsner ---------------------- Civilingeniør, Kjeld Flarup - Mit sind er mere åbent end min tegnebog Sofienlundvej 6B, 7560 Hjerm, Tlf: 40 29 41 49 Den ikke akademiske hjemmeside for liberalismen - www.liberalismen.dk<http://www.liberalismen.dk> _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org<mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

-- Daniel-Constantin Mierla -- www.asipto.com<http://www.asipto.com> www.twitter.com/miconda<http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda<http://www.linkedin.com/in/miconda> Funding: https://www.paypal.me/dcmierla -- --------------------- Med Liberalistiske Hilsner ---------------------- Civilingeniør, Kjeld Flarup - Mit sind er mere åbent end min tegnebog Sofienlundvej 6B, 7560 Hjerm, Tlf: 40 29 41 49 Den ikke akademiske hjemmeside for liberalismen - www.liberalismen.dk<http://www.liberalismen.dk> _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org<mailto:sr-users@lists.kamailio.org> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla -- www.asipto.com<http://www.asipto.com> www.twitter.com/miconda<http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda<http://www.linkedin.com/in/miconda> Funding: https://www.paypal.me/dcmierla

1566

days inactive

1567

days old

sr-users@lists.kamailio.org

Manage subscription

6 comments

4 participants

tags (0)

participants (4)

Daniel-Constantin Mierla
Fred Posner
Henning Westerholt
Kjeld Flarup