データベースでエラーが起きるが原因がわからない

Question

次のエラーでシステムが動きません
何か原因がわかる方がいましたら教えてください

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace KawanoCrawler.Database.MySQL
{
    public class Table_Signatures : DBUtility
    {
        public static readonly string TableName = "signatures";

        public static readonly string ColumnId = "id";
        public static readonly string ColumnContent = "content";

        public string ID
        {
            get; set;
        }

        public string Content
        {
            get; set;
        }

        public Table_Signatures(string id, string content)
        {
            this.ID = id;
            this.Content = content;
        }

        /// <summary>
        /// 既存のシグニチャをセットする
        /// </summary>
        public static void Initialize()
        {
            var signatureList = new List<string>();
            signatureList.Add(@"<iframe src=\""[A-Za-z0-9 \t \t\n\r\f\v]{1,}?\"" width=0 height=0>[A-Za-z0-9 \t \t\n\r\f\v]*</iframe>");
            signatureList.Add(@"[a-f0-9]{16}/[a-z]{1,2}\.php");
            signatureList.Add(@"forcing_shown_truth-increased\.php");
            signatureList.Add(@"http://[a-f0-9]{24}\..+?:8000/");
            signatureList.Add(@"meta *http-equiv=\""refresh\"" *content\""0;url=http:// {3,}?");
            signatureList.Add(@"jar *href=\""[A-Za-z0-9 \t \t\n\r\f\v]{1,}?.jar\"" *main=\""true");
            signatureList.Add(@"<param *name=\""__applet_ssv_validated\"" *value\""true\"" */>");
            signatureList.Add(@"hxxp://[A-Za-z0-9 ]{1,}?/[A-Za-z0-9 ]{1,}?/[A-Za-z0-9 ]*.html");
            signatureList.Add(@"http://[A-Za-z0-9 ]{1,}?/[A-Za-z0-9 ]{1,}?/[A-Za-z0-9 ]*.html");
            signatureList.Add(@"eval");
            signatureList.Add(@"document.write");
            signatureList.Add(@"escape");
            signatureList.Add(@"unescape");
            signatureList.Add(@"/check.php?uid=[0-9a-f]{16}");
            signatureList.Add(@".in/t/[0-9a-z]{32}");
            signatureList.Add(@".ftp1.biz/t/[0-9a-z]{32}");
            signatureList.Add(@".ddns.info/t/[0-9a-z]{32}");
            signatureList.Add(@"/ap1.php?f=[0-9a-z]{1-5}");
            signatureList.Add(@"/ap2.php?f=[0-9a-z]{1-5}");
            signatureList.Add(@"/[a-z].php?f=[0-9a-z]{1-5}&e=[0-9]");
            signatureList.Add(@"/[a-z0-9]{16}/ff.php");
            signatureList.Add(@"/[a-z0-9]{16}/q.php");
            signatureList.Add(@"/[a-z0-9]{32}/q.php");
            signatureList.Add(@"/pdf.php");
            signatureList.Add(@"/pdf2.php");
            signatureList.Add(@"/javaobe.jar");
            signatureList.Add(@"/CP-ENC-[0-9]{4}.php");
            signatureList.Add(@"/5734.jar");
            signatureList.Add(@"/432.jar");
            signatureList.Add(@"/load.php?sql=");
            signatureList.Add(@"/dududu.js");
            signatureList.Add(@"/jueoaritjuir.php");
            signatureList.Add(@"/in.php?a=[0-9a-zA-Z]{36}==");

            using (var trans = sql.BeginTransaction())
            using (var cmd = sql.CreateCommand())
            {
                foreach (var signature in signatureList)
                {
                    cmd.CommandText = string.Format("insert into {0}({1}) values ({2})", TableName, ColumnContent, "'"+signature+"'");
                    cmd.ExecuteNonQuery();
                }

                trans.Commit();
            }
        }

        /// <summary>
        /// シグニチャの一覧を取得する
        /// </summary>
        /// <returns></returns>
        public static List<Table_Signatures> GetSignatureList()
        {
            var result = new List<Table_Signatures>();

            using (var dbResult = DBUtility.SQL_SelectAll(TableName))
            {
                while(dbResult.Read())
                {
                    // @がついてるのは逐語的文字列リテラルにするため
                    result.Add(new Table_Signatures(dbResult[ColumnId].ToString(), @dbResult[ColumnContent].ToString()));
                }
            }

            return result;
        }
    }
}

エラー内容
Unhandled Exception:
System.TypeInitializationException: The type initializer for 'KawanoCrawler.Database.MySQL.DBUtility' threw an exception. ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at MySql.Data.Common.StreamCreator.GetTcpStream (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00036] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.Common.StreamCreator.GetStream (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00021] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.NativeDriver.Open () [0x00007] in <20067061e6b6431192625305716b2d50>:0
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.NativeDriver.Open () [0x00041] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.Driver.Open () [0x0000e] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x0004e] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection () [0x00006] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x0008a] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x0003f] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.MySqlPool.GetConnection () [0x0001c] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.MySqlConnection.Open () [0x0016d] in <20067061e6b6431192625305716b2d50>:0
at KawanoCrawler.Database.MySQL.DBUtility..cctor () [0x0012b] in /Users/idaryuunosuke/Desktop/??????????????????/Crawler-master/Crawler2/Database/MySQL/DBUtility.cs:63
--- End of inner exception stack trace ---
at KawanoCrawler.Database.MySQL.Table_Signatures.GetSignatureList () [0x00007] in /Users/idaryuunosuke/Desktop/??????????????????/Crawler-master/Crawler2/Database/MySQL/Table_Signatures.cs:93
at KawanoCrawler.Program.Main (System.String[] args) [0x0036e] in /Users/idaryuunosuke/Desktop/??????????????????/Crawler-master/Crawler2/Program.cs:204
[ERROR] FATAL UNHANDLED EXCEPTION: System.TypeInitializationException: The type initializer for 'KawanoCrawler.Database.MySQL.DBUtility' threw an exception. ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at MySql.Data.Common.StreamCreator.GetTcpStream (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00036] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.Common.StreamCreator.GetStream (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00021] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.NativeDriver.Open () [0x00007] in <20067061e6b6431192625305716b2d50>:0
--- End of inner exception stack trace ---
at MySql.Data.MySqlClient.NativeDriver.Open () [0x00041] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.Driver.Open () [0x0000e] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x0004e] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection () [0x00006] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x0008a] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x0003f] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.MySqlPool.GetConnection () [0x0001c] in <20067061e6b6431192625305716b2d50>:0
at MySql.Data.MySqlClient.MySqlConnection.Open () [0x0016d] in <20067061e6b6431192625305716b2d50>:0
at KawanoCrawler.Database.MySQL.DBUtility..cctor () [0x0012b] in /Users/idaryuunosuke/Desktop/??????????????????/Crawler-master/Crawler2/Database/MySQL/DBUtility.cs:63
--- End of inner exception stack trace ---
at KawanoCrawler.Database.MySQL.Table_Signatures.GetSignatureList () [0x00007] in /Users/idaryuunosuke/Desktop/??????????????????/Crawler-master/Crawler2/Database/MySQL/Table_Signatures.cs:93
at KawanoCrawler.Program.Main (System.String[] args) [0x0036e] in /Users/idaryuunosuke/Desktop/??????????????????/Crawler-master/Crawler2/Program.cs:204

Comments

[m.ts10806]

原因だけならエラーで出してくれてますけど・・・
https://qiita.com/cannorin/items/eb062aae88bfe2ad6fe5

[mmaeda]

詳細の表示は、どう表示されますか？

[Rondon7251]

詳細追加しました

[mmaeda]

DBUtility の中身が分かりませんが、その条件を満たしていますか？

[Q71]

MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.
と、エラーの理由は書かれていますが？
「指定されたMySQL hostsのいずれにも接続できない」

Answer 1

サーバ内のWi-Fiから接続したところデータベースにアクセスできました。