GGSCI (localhost.localdomain) 1> dblogin sourcedb ogg@192.168.176.127:3306,userid ogg,password ogg

Source Context :
SourceModule : [ggdb.mysql.util]
SourceID : [../gglib/ggdbmysql/mysqlutil.c]
SourceMethod : [MYSQLUTIL_check_err]
SourceLine : [560]
ThreadBacktrace : [17] elements
: [/opt/ogg/libgglog.so(CMessageContext::AddThreadContext())]
: [/opt/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...))]
: [/opt/ogg/libgglog.so(_MSG_String_UInt32_String(CSourceContext*, int, char const*, unsigned int, char const*, CMessageFactory::MessageDisposition))]
: [ggsci(MYSQLUTIL_check_err(short, char const*, ...))]
: [ggsci(MYSQLUTIL_get_server_charset())]
: [ggsci(DBUTIL_getDatabaseMetadata(ggs::gglib::ggunicode::UString const*, ggs::gglib::ggapp::CDatabaseMetadata const**, ggs::gglib::ggunicode::UString&))]
: [ggsci(gl_db_login(char const*, char const*, ggs::gglib::ggapp::CDBObjName<(DBObjType)11>&, ggs::gglib::ggapp::CDBObjName<(DBObjType)12>&, short, char (&) [2048]))]
: [ggsci()]
: [ggsci(GGSCIDB_get_command(char const*, char const*, char const*, short, char (&) [2048]))]
: [ggsci(do_cmd(char*, unsigned long, char*, unsigned long))]
: [ggsci()]
: [ggsci(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [ggsci(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
: [ggsci(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [ggsci(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [ggsci()]

2022-10-13 18:08:10 ERROR OGG-00768 Failed to Map server character to ULibCharSet. SQL error (0).

2022-10-13 18:08:10 ERROR OGG-01668 PROCESS ABENDING.

之前的字符集是：

mysql> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'ogg';
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| utf8 | utf8_general_ci |
+----------------------------+------------------------+
1 row in set (0.00 sec)

然后重新指定创建

mysql> CREATE DATABASE ogg CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Query OK, 1 row affected (0.08 sec)

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| ogg |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.00 sec)

mysql> use ogg
Database changed
mysql> create table tableone(id int,name varchar(20),primary key(id));
Query OK, 0 rows affected (0.15 sec)

mysql>
mysql> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8mb4 | utf8mb4_unicode_ci |

在dblogin的时候还是会报OGG-00768 Failed to Map server character to ULibCharSet. SQL error (0).