After some time you may find that you Zabbix database become enormously big and consumes significant amount of disk space. Among really usefull data there is data that may be cleaned up and optimized in Zabbix database in order to reduce size of Zabbix database. Continue reading
Jan 30 2024
Vicidial access forbidden to the recordings folder
I got this upon trying to download call recording in Vicidial on the lead’s page. I have Vicibox 11 installed in virtual machine on Cloudmin with Vicidial VERSION: 2.14-899a BUILD: 231109-2027 Continue reading
Jan 17 2024
Asterisk vicidial WebRTC phone cannot connect
On the newly installed Vicidial box I got problem connecting WebRTC phone to Asterisk.
I followed the setup guide here
In the Asterisk console I saw:
Problem setting up ssl connection: error:00000001:lib(0):func(0):reason(1), Internal SSL error
ERROR[2203]: tcptls.c:179 handle_tcptls_connection: Unable to set up ssl connection with peer ‘22.22.48.22:48756’
[Jan 17 11:46:42] ERROR[2203]: iostream.c:552 ast_iostream_close: SSL_shutdown() failed: error:00000001:lib(0):func(0):reason(1), Internal SSL error
Jan 02 2024
MS SQL security audit: list all users and their permissions
When you need to find out your DB users and their permissions on DB objects use the following query to list all MS SQL users and their permissions on databases and views and get a report: Continue reading
Dec 15 2023
Flash Operator Panel 2 Connecting to server error
The case when FOP2 with HTTPS does not work and you can see “Connecting to server, attempt number ” message was described here
Another case when this error can happen is when you try to log in as an operator and access /fop2
path
Nov 24 2023
ViciBox 11 installation in Cloudmin
ViciBox is worldwide popular callcenter solution. If you want to run ViciBox in virtual machine under Cloudmin you will need to perform a few additional steps to make running because there is no ready-to-go ViciBox image for Cloudmin available. Continue reading
Nov 22 2023
Difference between BACPAC and DACPAC
A data-tier application (DAC) is a self-contained unit of MS SQL Server database deployment that allows packing SQL Server objects into a portable artifact called a DAC package. It is also known as a DACPAC.
BACPAC is simple to export a SQL Server database which will eventually require import to another server or even for longer-term retention.
IN SHORT:
A BACPAC includes the schema and data from the database.
DACPAC has only the schema and not the data.
Now we will see the difference between BACPAC and DACPAC Continue reading
Aug 19 2023
Vicidial: How to update phones Server IP in bulk
To simultaneously update Server IP for all phones in ViCiDial, please log in to your MySQL (or PhpMyAdmin, if available) and run the following SQL statements:
1 |
update phones set server_ip ='1.1.1.1'; |
where instead of “1.1.1.1” specify your Vicidial Server IP.
Check also How to update passwords in bulk in ViciDial
Aug 09 2023
postfix/submission/smtpd certificate expired alert number 45
I tried to configure Laravel mail client with secure connection via TLS to my email server but in email client I got:
Unable to connect with STARTTLS: stream_socket_enable_crypto(): SSL operation failed with code 1. OpenSSL Error messages: error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed.
At the same time on my email server in /var/log/maillog
I observed the following:
Aug 8 10:05:46 mail postfix/submission/smtpd[30830]: connect from unknown[111.211.48.11]
Aug 8 10:05:46 mail postfix/submission/smtpd[30830]: SSL_accept error from unknown[111.211.48.11]: 0
Aug 8 10:05:46 mail postfix/submission/smtpd[30830]: warning: TLS library problem: 30830:error:14094415:SSL routines:ssl3_read_bytes:sslv3 alert certificate expired:s3_pkt.c:1493:SSL alert number 45:
Aug 8 10:05:46 mail postfix/submission/smtpd[30830]: lost connection after STARTTLS from unknown[111.211.48.11]
Aug 8 10:05:46 mail postfix/submission/smtpd[30830]: disconnect from unknown[111.211.48.11]
But Letsencrypt certificate was up to date. Continue reading
Jun 16 2023
How to create full-chain pem certificate
You can use your favourite text editor to create a combined full-chain pem certificate. The most important here is the order.
The correct order in a .crt file will be the following: Continue reading