First issue in this chunk:

@@ -122,8 +123,9 @@
 #!ifdef WITH_MYSQL
 # - database URL - used to connect to database server by modules such
 #       as: auth_db, acc, usrloc, a.s.o.
-#!ifndef DBURL
-#!define DBURL "mysql://kamailio:kamailiorw@localhost/kamailio"
+#!define DBURL "mysql://openser:openserrw@localhost/openser"
+#!ifdef WITH_ASTERISK
+#!define DBASTURL "mysql://asterisk:asterisk_password@localhost/asterisk"

You remove the line "#!ifndef DBURL" but not the corresponding #!endif, just readd the line there to fix it.

The you should leave the DBURL as it was, with kamailio instead of openser, respectively:

#!define DBURL "mysql://kamailio:kamailiorw@localhost/kamailio"
Likely, you use an old tutorial, from an older kamailio version when we still used openser name. But today, if you do kamdbctl create, the database name and user use kamailio.

The I do not see where you loaded the uac module. Add:

loadmodule "uac.so"

after the last line in kamailio.cfg which starts with:

loadmodule ...

Try with these changes and let's see if it moves forward. If not, paste here the new error messages that you get.

Cheers,
Daniel

On 13.12.18 19:54, John Tuxies wrote:
here is the output of diff


On Thu, Dec 13, 2018 at 10:54 AM Daniel-Constantin Mierla <miconda@gmail.com> wrote:

Probably the best is to send here the diff from your current kamailio.cfg and the default one from kamailio v5.2.0.

The default one can be downloaded from github with:

cd /tmp

wget https://raw.githubusercontent.com/kamailio/kamailio/5.2/etc/kamailio.cfg

Then do:

diff -u /tmp/kamailio.cfg /etc/kamailio/kamailio.cfg

And send the output here. If you set a different mysql password, then edit the output of the diff to change it to a random value before sending it.

Cheers,
Daniel

On 12.12.18 20:09, John Tuxies wrote:
Could u tell me which ones please? All i did was to install kamailio 5.2 from kamailio's repo for debian. Kamailio worked fine. Then i started the installation of Asterisk and starting to edit the cong file of kamailio kai boom it failed. I have no idea how to fix it.

On Wednesday, December 12, 2018, Serge S. Yuriev <me@nevian.org> wrote:
Hi

And you had failed with IF defines - perhaps deleted some of them by mistake or added and not closed properly

--
Wbr, Serge via mobile

11.12.2018, 16:09, "John Tuxies" <atuxnull@gmail.com>:
I have gone a bit further and installed Asterisk 13 LTS from source in Debian 9 64 bit. It works fine with ODBC and asterisk listens on port 5080. I have installed Kamailio 5.2 from repository (deb.kamailio) and it started OK for the default config.
When i try to insert in the Kamailio config, the Asterisk handle, it fails to start. Could someone give me a hand over here to see the code attached please(my kamailio.cfg)?

here is the error:
root@deb9:~# -- Unit kamailio.service has begun starting up.
Dec 11 15:07:32 deb9 kamailio[696]: ERROR: <core> [core/pvapi.c:903]: pv_parse_spec2(): error searching pvar "uac_req"
Dec 11 15:07:32 deb9 kamailio[696]: ERROR: <core> [core/pvapi.c:1106]: pv_parse_spec2(): wrong char [m/109] in [$uac_req(method)] at [9 (5)]
Dec 11 15:07:32 deb9 kamailio[696]: CRITICAL: <core> [core/cfg.y:3507]: yyerror_at(): parse error in config file /etc/kamailio/kamailio.cfg, line 1058, column 2-17: Ca
n't get from cache: $uac_req(method)
Dec 11 15:07:32 deb9 kamailio[696]: ERROR: bad config file (1 errors)
Dec 11 15:07:32 deb9 kamailio[696]: WARNING: <core> [core/ppcfg.c:220]: pp_ifdef_level_check(): different number of preprocessor directives: N(#!IF[N]DEF) - N(#!ENDIF)
 = 1
Dec 11 15:07:32 deb9 kamailio[696]: INFO: <core> [core/sctp_core.c:53]: sctp_core_destroy(): SCTP API not initialized
Dec 11 15:07:32 deb9 systemd[1]: kamailio.service: Control process exited, code=exited status=255
Dec 11 15:07:32 deb9 systemd[1]: Failed to start Kamailio (OpenSER) - the Open Source SIP Server.
-- Subject: Unit kamailio.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit kamailio.service has failed.
--
-- The result is failed.
Dec 11 15:07:32 deb9 systemd[1]: kamailio.service: Unit entered failed state.
Dec 11 15:07:32 deb9 systemd[1]: kamailio.service: Failed with result 'exit-code'.
Dec 11 15:07:32 deb9 systemd[1]: kamailio.service: Service hold-off time over, scheduling restart.
Dec 11 15:07:32 deb9 systemd[1]: Stopped Kamailio (OpenSER) - the Open Source SIP Server.
-- Subject: Unit kamailio.service has finished shutting down
-- Defined-By: systemd

root@deb9:~#



On Fri, Nov 30, 2018 at 2:45 PM John Tuxies <atuxnull@gmail.com> wrote:
Dear all,


First of all i would like to thank you for your interest in this topic.
I did scratch a little bit further and corrected the script. Currently i stick to bash and once finished with that i will invest in different techniques.
I came to a state where the script finishes succesfully. Asterisk installed and runs OK, but i got an issue with Kamailio's service.
i have attached the scripts and logs, so if someone could have a look and see if i am missing something. I do not expect someone to install it for me, but have a look on the code and logs.
-File named asteriskkamailio0.sh.txt needs the .txt extension removed in order to be executed
-File named asterisk.sql.txt needs the .txt extension removed in order to be able to imported to mysql.
-File Installation.txt is the SSH log file of the installation part.
-File Debug.txt is the SSH log file for the debug after executing systemctl status kamailio.service and journalctl -xe


Thanks in advance for your help.

Friendly,
John

On Fri, Nov 30, 2018 at 10:16 AM Samuel F. <samuel_is_kewl@hotmail.com> wrote:
We run Ansible with great success. We use Ansible to provision the server and keep all Kamailio related code in a git-repo. Ansible has two tasks, (1) to provision the server according to business security standards and all sub-deps, and (2) to update the server when new code is commited to the repo.

On new code, it would then setup all dirs, restart Kamailio etc as needed.

We use the same logic and setup for Asterisk and have been doing that in production for a few years without any issues whatsoever.

Cheers,
Samuel

From: sr-users <sr-users-bounces@lists.kamailio.org> on behalf of Daniel-Constantin Mierla <miconda@gmail.com>
Sent: Friday, November 30, 2018 08:26
To: Kamailio (SER) - Users Mailing List; Alex Balashov
Subject: Re: [SR-Users] Automating installation
 

On 29.11.18 22:53, Alex Balashov wrote:
> On Thu, Nov 29, 2018 at 01:50:55PM -0800, Joel Serrano wrote:
>
>> If it was me, I would handle everything with ansible, but that is just
>> my tool of preference.
> I'll add a vote for SaltStack, my preferred tool of choice.

Did you start with it and stayed with, or you compared and found some
benefits vs. others like ansible, puppet, ...?

I started with ansible and happy with it, when I looked around the
reasons were that python was installed anyhow by default in debian, then
the target system didn't need to have any server/agent app deployed before.

Cheers,
Daniel

--
Daniel-Constantin Mierla -- https://nam03.safelinks.protection.outlook.com/?url=www.asipto.com&amp;data=02%7C01%7C%7Cbddcc5fbd0df470749ef08d656954101%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636791596364449003&amp;sdata=i%2BrWG9MKhzZ1FQgaVaj7dbyEdTeGd3xWy3Lkb2%2FcYzE%3D&amp;reserved=0
https://nam03.safelinks.protection.outlook.com/?url=www.twitter.com%2Fmiconda&amp;data=02%7C01%7C%7Cbddcc5fbd0df470749ef08d656954101%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636791596364449003&amp;sdata=fODOG0JM6gwXIneoxel2QVy5PGAmbTYFgGk68ctOPdU%3D&amp;reserved=0 -- https://nam03.safelinks.protection.outlook.com/?url=www.linkedin.com%2Fin%2Fmiconda&amp;data=02%7C01%7C%7Cbddcc5fbd0df470749ef08d656954101%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636791596364449003&amp;sdata=CHA9TnvLV5CKkWJNDwntmo7w6bn%2BsB%2F6RbjpxT1%2BN4w%3D&amp;reserved=0
Kamailio World Conference -- https://nam03.safelinks.protection.outlook.com/?url=www.kamailioworld.com&amp;data=02%7C01%7C%7Cbddcc5fbd0df470749ef08d656954101%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636791596364449003&amp;sdata=ac0qNl3hlv2MMSMd7t82UCLLDpPzvRD2iFmxMoxdC5M%3D&amp;reserved=0
Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- https://nam03.safelinks.protection.outlook.com/?url=www.asipto.com&amp;data=02%7C01%7C%7Cbddcc5fbd0df470749ef08d656954101%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636791596364449003&amp;sdata=i%2BrWG9MKhzZ1FQgaVaj7dbyEdTeGd3xWy3Lkb2%2FcYzE%3D&amp;reserved=0


_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.kamailio.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fsr-users&amp;data=02%7C01%7C%7Cbddcc5fbd0df470749ef08d656954101%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636791596364449003&amp;sdata=hcYbPWDj2JTtRPI6pBXUQkdlOBgDGadM1sUVkErqLds%3D&amp;reserved=0
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

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


_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@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
Kamailio World Conference - May 6-8, 2019 -- www.kamailioworld.com
Kamailio Advanced Training -- www.asipto.com
-- 
Daniel-Constantin Mierla -- www.asipto.com
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio World Conference - May 6-8, 2019 -- www.kamailioworld.com
Kamailio Advanced Training -- www.asipto.com