Asterisk setup + Kyivstar SIP + n8n + Telegram bot + binding to the OpenCart/ocStore website database
Task description:
A specialist is needed to fully install and configure the working connection on our server.
We have:
- Hetzner Ubuntu server with a public IP;
- website on OpenCart/ocStore;
- aaPanel on the server;
- SIP number Kyivstar with IP authorization;
- Telegram bot @msm_order_bot;
- the task is to create a custom system without KeyCRM, Bitrix24, SendPulse, and other CRMs.
Install and configure Asterisk
Requirements:
- install or restore Asterisk on Ubuntu;
- connect the Kyivstar SIP trunk via IP authorization;
- use PJSIP;
- configure incoming calls;
- and outgoing calls
- configure Asterisk to start automatically after server reboot.
3. Configure IVR
4. Link Asterisk with n8n via webhook
5. Install and configure n8n
6. Configure the Telegram bot
The Telegram bot should continue the script after the call.
7. Bind the Telegram bot to the OpenCart/ocStore website database
8. Save applications
9. SMS if the client does not have Telegram
Asterisk Security
It is essential to set up protection so that no one can call through our SIP trunk.
Requirements:
- allow SIP/PJSIP port only from Kyivstar IP and trusted IPs;
- close SIP to the entire internet;
- configure RTP only in the required range;
- disable anonymous / guest SIP calls;
- prohibit outgoing calls without authorization;
- prohibit international, premium, and unknown destinations;
- configure Fail2Ban;
- use complex passwords for internal subscribers;
- close AMI/ARI from external access;
- do not leave FreePBX/control panel open to the outside if it will be used;
- enable CDR and call logs.
The work is considered completed if:
1. Incoming (outgoing) call from Kyivstar reaches Asterisk.
2. A greeting is played.
3. Pressing 1 sends a webhook doors to n8n.
4. Pressing 2 sends a webhook loft to n8n.
5. Pressing 3 sends a webhook complaint to n8n.
6. A missed call sends a webhook missed_call.
7. n8n creates an application ID.
8. The Telegram link opens the correct script.
9. Before the script, the client confirms consent.
10. The fact of consent is saved.
11. The bot reads products and prices from the OpenCart/ocStore website database.
12. The bot shows the product, price, photo, and link to the website.
13. After the client's responses, the application is saved.
14. The administrator receives the application in Telegram.
15. SIP is protected from external access.
16. International and unknown outgoing calls are prohibited.
17. Fail2Ban is configured.
18. After the server reboot, Asterisk and n8n start automatically.
19. The website and aaPanel continue to work.
20. A brief instruction is provided.
-
Good day, I can fully set up the Asterisk + n8n + Telegram + OpenCart connection on your Hetzner server.
1. What version of Ubuntu is currently installed?
2. Is there root access to the server?
3. Is Asterisk, n8n already installed or is everything from scratch?
4. Are there ready-made Telegram bot scripts?
5. What is the deadline?
-
Hello! The task is clear — I will set up the complete connection: Asterisk + Kyivstar SIP, IVR, n8n, Telegram bot for reading products from OpenCart, SMS for those without Telegram. Security, auto-start, instructions — everything is included.
Two clarifications:
Does Kyivstar provide a static IP for the SIP trunk or a dynamic one? This affects the connection scheme.
Which service do you plan to use to send SMS — is there already a gateway or do we need to find one?
-
Hello!
We are dZENcode – a full-cycle digital solutions development company: from design and programming to integrations and post-release support. We take on projects from scratch and also engage in the refinement of existing solutions.
We can create a working solution for this task.
Is there already a current Asterisk installation or do you need setup from scratch? Is data and scenario migration from the existing system required?
You can find detailed information about our services and rates on our website:Freelancehunt
… Take a look – after that we can discuss the details and agree on the next step.
⚠️ After clarifying all the details, we will determine the scope, the suitable format of cooperation: by task, outsourcing, or outstaffing, and the final cost.
Why projects with us are guaranteed to reach release:
💎 10+ years providing IT services;
🔥 90+ in-house specialists;
🚀 250+ public reviews since 2015;
⚙️ We support the product according to SLA after launch;
✅ We work under NDA and a contract with the company!
-
I will install Asterisk with PJSIP on Ubuntu Hetzner and connect the Kyivstar trunk via IP authorization. IVR, through extensions.conf with separate contexts for doors/loft/complaint/missed_call, each sends a POST to the n8n webhook; n8n generates a request ID and sends a deeplink to the Telegram bot, which reads products directly from the MySQL database ocStore. Fail2Ban + iptables whitelist only for Kyivstar IPs, AMI is closed on localhost. Question: is there a ready list of Kyivstar IP ranges for the whitelist, or should I clarify with the provider during the setup process?
-
1729 9 0 Good day, I have experience working with Python as well as Telegram bots, I can complete everything quickly and efficiently, write to discuss the details.
-
3418 11 1 Hello! I am ready to implement your custom ecosystem without third-party CRMs. I have extensive experience with Hetzner architecture (Ubuntu + aaPanel), VoIP telephony, and automation systems.
How I will solve your task:
Asterisk (PJSIP) + Kyivstar: I will configure the SIP trunk with IP authorization, routing, and IVR. Each key press will generate the corresponding Webhook in n8n.
Maximum security (Priority): I will set up a strict firewall (allowing only Kyivstar IPs), Fail2Ban, close AMI/SIP from scanners, and completely block guest, international, and unauthorized calls.
n8n + Telegram: I will deploy a local n8n, build scenario branches, generate request IDs, verify client consent, and send SMS fallback.
…
Integration with OpenCart: I will configure secure requests from the Telegram bot directly to the ocStore database for dynamic product card output (price, photo, link).
I guarantee the completion of all 20 points on your checklist, uninterrupted operation of the site on aaPanel, correct auto-start of daemons (Asterisk/n8n) after reboot, and I will provide clear documentation/instructions.
I am ready to discuss the details and start configuring the server!
-
573 9 0 Write in private messages, I will set up the task you need, I have set up Asterisk for different tasks before.
-
265 We are Devoxen, an IT outsourcing company specializing in backend solutions, automation, and integrations. We have practical experience in setting up IP telephony based on Asterisk, including working with SIP providers.
Connecting Kyivstar via SIP is well known to us - we understand the typical nuances (registration, NAT, codecs, call routing) and immediately incorporate this into a stable configuration.
What we will do:
- set up a SIP trunk with Kyivstar
- check registration and connection stability
- configure inbound/outbound routes
- implement IVR, queues, and call forwarding if needed
… - test and bring the system to stable operation
We work in stages: first, we ensure stable connectivity, then the logic and optimization for your tasks. After launch, we remain in touch for support and adjustments.
We are ready to start soon.
-
9927 117 0 Hello.
I am a NodeJS developer. I have experience with Telegram. I am ready to take on the task. Write to me, we will discuss.
-
2930 8 0 1 For sending to the client:
Hello! My name is Matviy. I have extensive experience in setting up complex automation systems that combine telephony, bots, and databases. The project is clear to me — it involves creating a fully autonomous CRM based on Asterisk and n8n without third-party services.
I have experience integrating complex solutions: linking Python/n8n with website databases, working with Webhooks and Telegram bots of any complexity. I clearly understand the security requirements (PJSIP, Fail2Ban, ACL for Kyivstar IPs, and closing AMI/ARI), as I often work with financial bots where server protection is priority number one.
How I will implement your task:
Asterisk: I will install and configure a PJSIP trunk from Kyivstar with strict IP filtering. I will set up a dial plan with IVR and sending Webhook to n8n.
…
n8n + Telegram: I will deploy n8n on your server, create scenarios for processing incoming/missed calls. The bot will be directly connected to the OpenCart database via SQL queries to retrieve current products and prices.
Security: In addition to Fail2Ban, I will configure the closure of all unnecessary ports through UFW and disable anonymous calls.
Please let me know if you already have access to the OpenCart database (host/user), and if SMS configuration is needed through a specific gateway (for example, TurboSMS or AlphaSMS)?
Current freelance projects in the category Bot Development
Creation of a TikTok farm with income generation
602 USD
Looking for a person who can write software for a TikTok farm, so we can generate traffic and earn income. We are seeking a ready-made solution with a full cycle. Python, Bot Development ∙ 7 hours 14 minutes back ∙ 4 proposals |
Pocket Option trading bot
71 USD
I need a bot and your expertise who has already been able to create a similar bot when the bets are correct, they are read from Pocket Option I am interested in Brent Oil I do not need a beginner or someone who will just write code for the sake of it I need someone who knows… AI & Machine Learning, Bot Development ∙ 1 day 7 hours back ∙ 17 proposals |
TG BOT for Auto Ria
156 USD
We are interested in creating a bot that can send 1000+ exchange offers per day from one account. Authorization through Ria login and password, with characteristics exclusively those listed on the portal. The ability to limit the number of exchange requests. Also, monitoring… Bot Development ∙ 1 day 9 hours back ∙ 40 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 1 day 10 hours back ∙ 13 proposals |
Development of a Telegram store for a clothing brand. Product catalog, sizes, cart, order processing.
178 USD
A Telegram channel is needed with a warehouse from the KCRM system, showing stock balances, and full payment to the IBAN account. Bot Development ∙ 2 days 20 hours back ∙ 70 proposals |