mysqldump directly to another server, mysqldump redirect to scp

mysql-logo-imageIt’s not a big deal to perform mysqldump command, get your database as a file and transfer MySQL database to another server by moving the file to another server and import it,

But what if there is no enough space on a disk to store the dump file? In this case it would be great to create MySQL dump file directly on the remote server. And not only you can create dump file directly but even clone a database to remote MySQL! Here I show how to do this.

Continue reading

key type ssh-rsa not in pubkey accepted algorithms

I was running Ubuntu 20.04 happily, and then over the weekend decided to back everything up and install 22.04. I installed my previous keys but I couldn’t login via MobaXTerm remotely as I usually did with 20.04.

I logged in with a console and checked /var/log/auth.log . Here are the messages generated upon my tries to log in:

Continue reading

Jenkins: The remote end hung up unexpectedly fatal: early EOF fatal: index-pack failed

Again the same git error: The remote end hung up unexpectedly fatal: early EOF fatal: index-pack failed.

This time – during the execution of Jenkins pipeline:

Continue reading

Using GotoIfTime with Timezones in Asterisk

Asterisk PBXStarting from Asterisk 1.6 GotoIfTime application supports Timezone parameter:

[Syntax]
GotoIfTime(times,weekdays,mdays,months[,timezone]?[labeliftrue][:labeliffalse])

I setup a system that receives calls from people in different timezones so I need to use Timezone parameter in GotoIfTime Asterisk application. Surprisingly I could not find examples on Asterisk’s website so I had to search for some.

There can be two possible formats: you can specify timezone as a shift relative to the time the Asterisk operates in, or you can specify as a path to respective timezone file. Here are the examples: Continue reading

Auto-renew Letsencrypt certificates in Azure Automation Account with managed identity

Recently my Job for renewing Letsencrypt certificates in KeyVault has stopped working. Upon closer look I found that my Run As account certificate expired:

Run-as-account-certificate-is-expired

I navigated to certificate’s properties to renew it as described in Microsoft documentation and thouhgt I have 1 minute work to fix that but no! There is no option to renew it anymore!

Renew-Run-as-certificate-no-option Continue reading

CentOS7 dockerError while creating filesystem xfs on device docker exit status 1

When you try to start docker it exits with exit status 1.

In /var/log/messages you can find the following: Continue reading

OnlyOffice Docker pull argument exception: repository=onlyoffice/documentserver, tag=

Upon installing OnlyOffice with Docker by the provided script it ends up with the following error:

Docker pull argument exception: repository=onlyoffice/documentserver, tag=

It’s not clear what causes this error but the reason is obvious: Continue reading

Virtualmin: cannot verify software.virtualmin.com’s certificate

webmin-logoOn a number of installations after the let’s Encrypt update in September 2021 you won’t be able to continue. Your may get this error.

ERROR: cannot verify software.virtualmin.com‘s certificate, issued by ‘/C=US/O=Let\’s Encrypt/CN=R3’: Issued certificate has expiredTo connect to software.virtualmin.com insecurely, use `–no-check-certificate‘. chmod: cannot access ‘slib.sh’: No such file or directory ./install.sh: line 297: ./slib.sh: No such file or directory Continue reading

Couldn’t add sdp streams for stream

Asterisk PBXYou try to establsish a call but it got disconnected and there is following message in Asterisk console from PJSIP Couldn’t add sdp streams for stream:

Two most common cases can cause this: Continue reading

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database

SQLRS-error-occured-within-the-report-server-database
I had this issue due to having the Reporting Services databases in an Availability Group. When we failed over (for the first time) there were a bunch of permissions not correctly set, specifically the RSExecRole was not there. The reports worked, but not the subscriptions and we couldn’t edit any of the report settings. Upon saving the subscription you see the error on the screenshot above.
Continue reading

Load more