[root@EDOMIC7 /]# mysql --user=root -D LBS_19000304_Telegram_Edomibot < /usr/local/edomi/main/include/php/php-telegram-bot/structure.sql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [root@EDOMIC7 /]# cd /var/lib/mysql [root@EDOMIC7 mysql]# ls aria_log.00000001 aria_log_control edomiAdmin edomiLive edomiProject ibdata1 ib_logfile0 ib_logfile1 LBS_19000304_Telegram_Edomibot mysql performance_schema [root@EDOMIC7 mysql]#
I once had this problem and solved it by installing mysql-server, so make sure that you have installed the mysql-server, not the mysql-client or something else. That error means the file /var/run/mysqld/mysqld.sock doesn't exists, if you didn't install mysql-server, then the file would not exist. So in that case, install it with sudo apt-get install mysql-server But if the mysql-server is already installed and is running, then you need to check the config files. The config files are: /etc/my.cnf /etc/mysql/my.cnf /var/lib/mysql/my.cnf In /etc/my.cnf, the socket file config may be /tmp/mysql.sock and in /etc/mysql/my.cnf the socket file config may be /var/run/mysqld/mysqld.sock. So, remove or rename /etc/mysql/my.cnf, let mysql use /etc/my.cnf, then the problem may solved.
[root@EDOMIC7 /]# yum list installed mysql-server Loaded plugins: fastestmirror, ovl Loading mirror speeds from cached hostfile * base: linux.darkpenguin.net * epel: mirror.de.leaseweb.net * extras: centos.intergenia.de * remi-php72: remi.mirror.karneval.cz * remi-safe: remi.mirror.karneval.cz * updates: centos.mirror.iphh.net Error: No matching Packages to list [root@EDOMIC7 /]#
[TABLE="class: log, border: 0, cellpadding: 0, cellspacing: 0, width: 0, height: 12"] [TR="class: sErr"] [TD]2021-02-22 20:06:08[/TD] [TD]929917[/TD] [TD]?[/TD] [TD]8813[/TD] [TD]Datei: /usr/local/edomi/main/include/php/php-telegram-bot/src/DB.php | Fehlercode: 2 | Zeile: 224 | PDOStatement::execute(): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'LBS_19000304_Telegram_Edomibot.telegram_update' doesn't exist[/TD] [TD]ERROR[/TD] [/TR] [/TABLE]
[TABLE="class: log, border: 0, cellpadding: 0, cellspacing: 0, width: 0, height: 12"] [TR] [TD]2021-02-22 20:04:27[/TD] [TD]182846[/TD] [TD]536[/TD] [TD]debug[/TD] [TD]LBS19000304 [v0.8]: Telegram Receiver LBS started[/TD] [/TR] [TR] [TD]2021-02-22 20:04:27[/TD] [TD]241992[/TD] [TD]536[/TD] [TD]debug[/TD] [TD]LBS19000304 [v0.8]: Daemon is running with PID: 8524[/TD] [/TR] [TR] [TD]2021-02-22 20:04:27[/TD] [TD]244448[/TD] [TD]536[/TD] [TD]debug[/TD] [TD]LBS19000304 [v0.8]: Restarting daemon ...[/TD] [/TR] [TR] [TD]2021-02-22 20:04:27[/TD] [TD]334170[/TD] [TD]536[/TD] [TD]debug[/TD] [TD]LBS19000304 [v0.8]: Telegram Receiver LBS ended[/TD] [/TR] [TR] [TD]2021-02-22 20:04:27[/TD] [TD]732868[/TD] [TD]8813[/TD] [TD]debug[/TD] [TD]EXE19000304 [v0.8]: MYSQL DATABASE CREATION:[/TD] [/TR] [TR] [TD]2021-02-22 20:04:27[/TD] [TD]738270[/TD] [TD]8813[/TD] [TD]debug[/TD] [TD]EXE19000304 [v0.8]: Telegram receiver daemon started[/TD] [/TR] [/TABLE]
Datei: /usr/local/edomi/www/data/liveproject/lbs/EXE19000303.php | Fehlercode: 8192 | Zeile: 132 | Invalid characters passed for attempted conversion, these have been ignored
$text = str_replace('\n', "\n", $content);
// replace UTF8 emoji codes with emojis
// $text = preg_replace("#(\\\x[0-9A-Fa-f]{2})#e", "chr(hexdec('\\1'))", $text);
$text = preg_replace_callback("/(\\\x[0-9A-Fa-f]{2})/", function ($matches) {
return chr(hexdec($matches[1]));
}, $text);
// replace unicode emoji codes with emojis
$text = preg_replace_callback('/\\\\u([0-9a-fA-F]{4})/', function ($match) {
return mb_convert_encoding(pack('H*', $match[1]), 'UTF-8', 'UCS-2BE');
}, $text);
Kommentar