Skype for Business, Asterisk, CentOS… | ITGala.xyz

Feb 08 2024

MariaDB fails to start: Aria engine is not enabled or did not start

Filed under Fixes, Simple about IT

After low space condition once happened on a server MariaDB failed to start with :

[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
[ERROR] Aborting
...
mariadb.service: main process exited, code=exited, status=1/FAILURE
Failed to start MariaDB 10.3.32 database server.

[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables

[ERROR] Aborting

...

mariadb.service: main process exited, code=exited, status=1/FAILURE

Failed to start MariaDB 10.3.32 database server.

In /var/log/messages:

[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables

[Note] mysqld: Aria engine: starting recovery
recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80%201210 16:07:56 [ERROR] mysqld got signal 11 ;

[ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'"

[ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables

[Note] mysqld: Aria engine: starting recovery

recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80%201210 16:07:56 [ERROR] mysqld got signal 11 ;

[ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'"

error, MariaDB, mysql
Leave comment

Feb 02 2024

Clean and reduce size of Zabbix database

Filed under Fixes, Simple about IT

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

MariaDB, mysql, Zabbix
Leave comment

Jan 30 2024

Vicidial access forbidden to the recordings folder

Filed under Fixes, Linux, Simple about IT, VoIP

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

access, error, Vicidial
Leave comment

Jan 17 2024

Asterisk vicidial WebRTC phone cannot connect

Filed under Asterisk, Fixes, Linux, VoIP

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

Asterisk, error, TLS, Vicidial
Leave comment

Jan 02 2024

MS SQL security audit: list all users and their permissions

Filed under Microsoft

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

Filed under Asterisk, Fixes, VoIP

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

Filed under Linux, VoIP

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

Cloudmin, Hyper-V, Vicibox, Vicidial, Webmin
Leave comment

Nov 22 2023

Difference between BACPAC and DACPAC

Filed under Microsoft, Simple about IT

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

BACPAC, DACPAC, MS SQL
Leave comment

Aug 19 2023

Vicidial: How to update phones Server IP in bulk

Filed under Linux, Simple about IT, VoIP

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:

update phones set server_ip ='1.1.1.1';

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

Filed under Fixes, Simple about IT

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

Dovecot, Laravel, letsencrypt, postfix, SSL
Leave comment