<?xml version="1.0" encoding="UTF-8"?>
<!-- generator="FeedCreator 1.8" -->
<?xml-stylesheet href="https://wiki.netyce.com/lib/exe/css.php?s=feed" type="text/css"?>
<rdf:RDF
    xmlns="http://purl.org/rss/1.0/"
    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
    xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
    xmlns:dc="http://purl.org/dc/elements/1.1/">
    <channel rdf:about="https://wiki.netyce.com/feed.php">
        <title>Technical documentation - maintenance:general:tools</title>
        <description></description>
        <link>https://wiki.netyce.com/</link>
        <image rdf:resource="https://wiki.netyce.com/lib/exe/fetch.php?media=wiki:logo.png" />
       <dc:date>2026-05-01T07:55:38+00:00</dc:date>
        <items>
            <rdf:Seq>
                <rdf:li rdf:resource="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:go_utility&amp;rev=1720009873&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:mk_debug_set.pl&amp;rev=1720009873&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:mk_ssl_cert.pl&amp;rev=1720009873&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:mysql_repair.sh&amp;rev=1720009873&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:net_setup.pl&amp;rev=1720009873&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:net_update.pl&amp;rev=1720009873&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:table_renew.pl&amp;rev=1720009873&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:tools&amp;rev=1720009873&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:yce_setup.pl&amp;rev=1720009873&amp;do=diff"/>
            </rdf:Seq>
        </items>
    </channel>
    <image rdf:about="https://wiki.netyce.com/lib/exe/fetch.php?media=wiki:logo.png">
        <title>Technical documentation</title>
        <link>https://wiki.netyce.com/</link>
        <url>https://wiki.netyce.com/lib/exe/fetch.php?media=wiki:logo.png</url>
    </image>
    <item rdf:about="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:go_utility&amp;rev=1720009873&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2024-07-03T12:31:13+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>go_utility</title>
        <link>https://wiki.netyce.com/doku.php?id=maintenance:general:tools:go_utility&amp;rev=1720009873&amp;do=diff</link>
        <description>Go utility

Originally created to assist the NetYCE developers to jump between the various directories of the application when using the bash CLI, the go utility offers sufficient benefits for the application manager to warrant some explanation.

The</description>
    </item>
    <item rdf:about="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:mk_debug_set.pl&amp;rev=1720009873&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2024-07-03T12:31:13+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>mk_debug_set.pl</title>
        <link>https://wiki.netyce.com/doku.php?id=maintenance:general:tools:mk_debug_set.pl&amp;rev=1720009873&amp;do=diff</link>
        <description>mk_debug_set.pl

A NetYCE support debug data file can be created using the 'Admin -&gt; System -&gt; Debug logs' tool. The resulting file can be downloaded and sent to a NetYCE engineer for support purposes. 

The file it creates (named “&lt;customer&gt;_support_&lt;server&gt;_&lt;date&gt;_&lt;time&gt;.bin</description>
    </item>
    <item rdf:about="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:mk_ssl_cert.pl&amp;rev=1720009873&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2024-07-03T12:31:13+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>mk_ssl_cert.pl</title>
        <link>https://wiki.netyce.com/doku.php?id=maintenance:general:tools:mk_ssl_cert.pl&amp;rev=1720009873&amp;do=diff</link>
        <description>mk_ssl_cert.pl

The mk_ssl_cert.pl script, stored in /opt/yce/system/, is used for creating certificate (and related) files.

This script needs to be run before enabling SSL using yce_setup.pl, if files are missing yce_setup will give feedback on it.

The script can be used to create certificate signing request (CSR) that must be submitted to a certificate authority for signing. The returned certificate must then be installed.</description>
    </item>
    <item rdf:about="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:mysql_repair.sh&amp;rev=1720009873&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2024-07-03T12:31:13+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>mysql_repair.sh</title>
        <link>https://wiki.netyce.com/doku.php?id=maintenance:general:tools:mysql_repair.sh&amp;rev=1720009873&amp;do=diff</link>
        <description>mysql_repair.sh

If you ever run into a situation that MariaDB (mysql) isn't running and doesn't want to start anymore, the script mysql_repair.sh can save your day. 

First of all, verify that mysqld is indeed not working by using go ps, which will show the following if the process is offline.</description>
    </item>
    <item rdf:about="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:net_setup.pl&amp;rev=1720009873&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2024-07-03T12:31:13+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>net_setup.pl</title>
        <link>https://wiki.netyce.com/doku.php?id=maintenance:general:tools:net_setup.pl&amp;rev=1720009873&amp;do=diff</link>
        <description>net_setup.pl

The net_setup.pl script, located in /opt/yce/system/, is used for setting up the networking environment of the CentOS/Redhat Linux system for NetYCE. It is used at the initial setup of the system or anytime a change to the networking environment is needed.</description>
    </item>
    <item rdf:about="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:net_update.pl&amp;rev=1720009873&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2024-07-03T12:31:13+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>net_update.pl</title>
        <link>https://wiki.netyce.com/doku.php?id=maintenance:general:tools:net_update.pl&amp;rev=1720009873&amp;do=diff</link>
        <description>net_update.pl

The net_update.pl script is used to detect IP changes. If the instance is rebooted and the IP address has changed, the change is detected automatically and modified in the YCE configuration files. Afterwards the yce_setup -r is ran to regenerate the configurations and restarts the application.</description>
    </item>
    <item rdf:about="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:table_renew.pl&amp;rev=1720009873&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2024-07-03T12:31:13+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>table_renew.pl</title>
        <link>https://wiki.netyce.com/doku.php?id=maintenance:general:tools:table_renew.pl&amp;rev=1720009873&amp;do=diff</link>
        <description>Error 1168 SQL MERGE non-MyISAM type

When importing a database from another server with a different MariaDB version, it could happen the MERGE engine fails and therefore the task_log, action_log, node_log and job_log aren't shown from the GUI. 

Looking at the different tables manually, (ending in 'quarter' or 'all') the following error is shown:</description>
    </item>
    <item rdf:about="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:tools&amp;rev=1720009873&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2024-07-03T12:31:13+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>tools</title>
        <link>https://wiki.netyce.com/doku.php?id=maintenance:general:tools:tools&amp;rev=1720009873&amp;do=diff</link>
        <description>Tools and Scripts

In the menu on the left you'll find links to detailed explanations on the several command line tools that are used. These includes the most common:

	*  Go utility
	*  mk_debug_set.pl
	*  net_setup.pl
	*  yce_setup.pl
	*  net_update.pl
	*  mysql_repair.sh
	*  mk_ssl_cert
	*  table_renew.pl - error 1168, non-MyISAM</description>
    </item>
    <item rdf:about="https://wiki.netyce.com/doku.php?id=maintenance:general:tools:yce_setup.pl&amp;rev=1720009873&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2024-07-03T12:31:13+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>yce_setup.pl</title>
        <link>https://wiki.netyce.com/doku.php?id=maintenance:general:tools:yce_setup.pl&amp;rev=1720009873&amp;do=diff</link>
        <description>yce_setup.pl

The yce_setup.pl script, located in /opt/yce/system/, is used for setting up the YCE application. The script is used at initial system setup, when changes to the system setup must be made, when the networking environment has changed, and when a software update is completed.</description>
    </item>
</rdf:RDF>
