in this case for zabbix database:
Convert tables from latin1 to utf-8 :
mysql zabbix -B -N -e 'show tables' | xargs -L 1 | awk '{print "ALTER TABLE "$1" CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin"}' | xargs -L 1 -I {} echo mysql zabbix -e \' {} \' | sh -x
convert database charset :
mysql -e 'ALTER DATABASE zabbix DEFAULT CHARACTER SET utf8 COLLATE utf8_bin'
After connecting pptp vpn dns servers recieved from vpn server are listed at the bottom of the list in /etc/resolv.conf and have lowest priority.
To make them have higher priority:
nmcli -p connection modify MY_VPN_CONNECTION ipv4.dns-priority -42
found this on:
based on https://wiki.mikrotik.com/wiki/Dynamic_DNS_Update_Script_for_No-IP_DNS
:local ddnsuser "<no-ip_username>"
:local ddnspass "<no-ip_pass>"
:local ddnshostname "<no-ip_host.ddns.net>"
:local ddnsinterface "<ddns_iface_name>"
# global variables definition
:global ddnslastip
#local vars definitions
:local ddnsip
#:local ddnsURL "http://dynupdate.no-ip.com/nic/update?hostname=$ddnshostname&myip=$ddnsip"
# base64 encoded string of username:password used
# https://www.noip.com/integrate/request
:local auth "Authorization:<base64 encoded string>"
:local useragent "User-Agent:Mikrotik-script <maintainer email>"
:local headers
:set $headers "$auth , $useragent"
:if ([ :typeof $ddnslastip ] = nil ) do={ :global ddnslastip "0" }
:local ddnsip [ /ip address get [/ip address find interface=$ddnsinterface ] address ]
:if ([ :typeof $ddnsip ] = nil ) do={
:log info ("ServiceDNS: No ip address on $ddnsinterface .")
} else={
:for i from=( [:len $ddnsip] - 1) to=0 do={
:if ( [:pick $ddnsip $i] = "/") do={
:set ddnsip [:pick $ddnsip 0 $i];
}
}
}
:if ($ddnsip != $ddnslastip) do={
:log info ("ServiceDNS: $ddnshostname -> $ddnsip")
:local ddnsURL "http://dynupdate.no-ip.com/nic/update?hostname=$ddnshostname&myip=$ddnsip"
:local response [ /tool fetch url=$ddnsURL http-header-field=$headers as-value output=user ]
if ($response->"status" = "finished") do={
:local data ($response->"data");
:set $ddnslastip $ddnsip
:log info ("$ddnslastip")
:log info "DDNS: Update succeeded."
} else={
:log error "DDNS: Update failed.";
}
} else {
# :log info "DDNS: No IP change.";
}
}
error:
checking for DocBook XSL Stylesheets in XML catalog... not found
checking for DocBook XSL Stylesheets in XML catalog... not found
configure: error: DocBook XSL Stylesheets are required for --enable-man
===> Script "configure" failed unexpectedly.
In the config.log file :
configure:28806: checking for DocBook XSL Stylesheets in XML catalog
configure:28809: $XMLCATALOG --noout "$XML_CATALOG_FILE" "http://docbook.sourcef
No entry for SYSTEM http://docbook.sourceforge.net/release/xsl/current/manpages/
No entry for URI http://docbook.sourceforge.net/release/xsl/current/manpages/doc
configure:28812: $? = 4
configure:28818: result: not found
configure:28827: error: DocBook XSL Stylesheets are required for --enable-man
Same thing for
configure: error: docbook dtd is required for --enable-man
Root of the problem in xml catalog file. Because XML/XSL entry is missing
My solution was to add manually XSL entry in /usr/local/share/xml/catalog.ports:
# cat /usr/local/share/xml/catalog.ports
<?xml version="1.0"?>
<!DOCTYPE catalog PUBLIC "-//OASIS//DTD Entity Resolution XML Catalog V1.0//EN"
"http://www.oasis-open.org/committees/entity/release/1.0/catalog.dtd">
<!-- Created by XML Catalog Manager 2.2 -->
<catalog xmlns="urn:oasis:names:tc:entity:xmlns:xml:catalog">
<nextCatalog catalog="/usr/local/share/xml/docbook/catalog.xml" />
<nextCatalog catalog="/usr/local/share/xsl/docbook/catalog.xml" /><nextCatalog catalog="/usr/local/share/xml/sdocbook/1.1/dtd/catalog.xml" />
</catalog>