MySQL数据库配置成功，脚本加载不了是什么原因？ - 主题

description

如图，配置好数据库成功后，在jupyter Lab运行这个脚本加载所需的包和数据结构，出现下面的提示，有知道是什么原因的吗？
OperationalError Traceback (most recent call last)
File C:\veighna_studio\Lib\site-packages\peewee.py:3192, in Database.connect(self, reuse_if_open)
3191 with exception_wrapper:
-> 3192 self._state.set_connection(self._connect())
3193 if self.server_version is None:

File C:\veighna_studio\Lib\site-packages\peewee.py:4149, in MySQLDatabase._connect(self)
4148 raise ImproperlyConfigured('MySQL driver not installed!')
-> 4149 conn = mysql.connect(db=self.database, autocommit=True,
4150 **self.connect_params)
4151 return conn

File C:\veighna_studio\Lib\site-packages\pymysql\connections.py:365, in Connection.init(self, user, password, host, database, unix_socket, port, charset, collation, sql_mode, read_default_file, conv, use_unicode, client_flag, cursorclass, init_command, connect_timeout, read_default_group, autocommit, local_infile, max_allowed_packet, defer_connect, auth_plugin_map, read_timeout, write_timeout, bind_address, binary_prefix, program_name, server_public_key, ssl, ssl_ca, ssl_cert, ssl_disabled, ssl_key, ssl_key_password, ssl_verify_cert, ssl_verify_identity, compress, named_pipe, passwd, db)
364 else:
--> 365 self.connect()

File C:\veighna_studio\Lib\site-packages\pymysql\connections.py:681, in Connection.connect(self, sock)
680 self._get_server_information()
--> 681 self._request_authentication()
683 # Send "SET NAMES" query on init for:
684 # - Ensure charaset (and collation) is set to the server.
685 # - collation_id in handshake packet may be ignored.
(...) 694 # - https://github.com/wagtail/wagtail/issues/9477
695 # - https://zenn.dev/methane/articles/2023-mysql-collation (Japanese)

File C:\veighna_studio\Lib\site-packages\pymysql\connections.py:980, in Connection._request_authentication(self)
979 if self._auth_plugin_name == "caching_sha2_password":
--> 980 auth_packet = _auth.caching_sha2_password_auth(self, auth_packet)
981 elif self._auth_plugin_name == "sha256_password":

File C:\veighna_studio\Lib\site-packages\pymysql_auth.py:245, in caching_sha2_password_auth(conn, pkt)
244 print("caching sha2: succeeded by fast path.")
--> 245 pkt = conn._read_packet()
246 pkt.check_error() # pkt must be OK packet

File C:\veighna_studio\Lib\site-packages\pymysql\connections.py:782, in Connection._read_packet(self, packet_type)
781 self._result.unbuffered_active = False
--> 782 packet.raise_for_error()
783 return packet

File C:\veighna_studio\Lib\site-packages\pymysql\protocol.py:219, in MysqlPacket.raise_for_error(self)
218 print("errno =", errno)
--> 219 err.raise_mysql_exception(self._data)

File C:\veighna_studio\Lib\site-packages\pymysql\err.py:150, in raise_mysql_exception(data)
149 errorclass = InternalError if errno < 1000 else OperationalError
--> 150 raise errorclass(errno, errval)

OperationalError: (1049, "Unknown database 'sqlite'")

During handling of the above exception, another exception occurred:

OperationalError Traceback (most recent call last)
Cell In[52], line 8
5 from vnpy.trader.object import BarData, TickData
7 # 获取数据库实例
----> 8 database = get_database()

File C:\veighna_studio\Lib\site-packages\vnpy\trader\database.py:158, in get_database()
155 module = import_module("vnpy_sqlite")
157 # Create database object from module
--> 158 database = module.Database()
159 return database

File C:\veighna_studio\Lib\site-packages\vnpy_mysql\mysql_database.py:168, in MysqlDatabase.init(self)
166 """"""
167 self.db: PeeweeMySQLDatabase = db
--> 168 self.db.connect()
170 # 如果数据表不存在，则执行创建初始化
171 if not DbBarData.table_exists():

File C:\veighna_studio\Lib\site-packages\peewee.py:3191, in Database.connect(self, reuse_if_open)
3188 raise OperationalError('Connection already opened.')
3190 self._state.reset()
-> 3191 with exception_wrapper:
3192 self._state.set_connection(self._connect())
3193 if self.server_version is None:

File C:\veighna_studio\Lib\site-packages\peewee.py:3019, in ExceptionWrapper.exit(self, exc_type, exc_value, traceback)
3017 new_type = self.exceptions[exc_type.name]
3018 exc_args = exc_value.args
-> 3019 reraise(new_type, new_type(exc_value, *exc_args), traceback)

File C:\veighna_studio\Lib\site-packages\peewee.py:192, in reraise(tp, value, tb)
190 def reraise(tp, value, tb=None):
191 if value.traceback is not tb:
--> 192 raise value.with_traceback(tb)
193 raise value

File C:\veighna_studio\Lib\site-packages\peewee.py:3192, in Database.connect(self, reuse_if_open)
3190 self._state.reset()
3191 with exception_wrapper:
-> 3192 self._state.set_connection(self._connect())
3193 if self.server_version is None:
3194 self._set_server_version(self._state.conn)

File C:\veighna_studio\Lib\site-packages\peewee.py:4149, in MySQLDatabase._connect(self)
4147 if mysql is None:
4148 raise ImproperlyConfigured('MySQL driver not installed!')
-> 4149 conn = mysql.connect(db=self.database, autocommit=True,
4150 **self.connect_params)
4151 return conn

File C:\veighna_studio\Lib\site-packages\pymysql\connections.py:681, in Connection.connect(self, sock)
678 self._next_seq_id = 0
680 self._get_server_information()
--> 681 self._request_authentication()
683 # Send "SET NAMES" query on init for:
684 # - Ensure charaset (and collation) is set to the server.
685 # - collation_id in handshake packet may be ignored.
(...) 694 # - https://github.com/wagtail/wagtail/issues/9477
695 # - https://zenn.dev/methane/articles/2023-mysql-collation (Japanese)
696 self.set_character_set(self.charset, self.collation)

File C:\veighna_studio\Lib\site-packages\pymysql\connections.py:980, in Connection._request_authentication(self)
978 # https://dev.mysql.com/doc/internals/en/successful-authentication.html
979 if self._auth_plugin_name == "caching_sha2_password":
--> 980 auth_packet = _auth.caching_sha2_password_auth(self, auth_packet)
981 elif self._auth_plugin_name == "sha256_password":
982 auth_packet = _auth.sha256_password_auth(self, auth_packet)

File C:\veighna_studio\Lib\site-packages\pymysql_auth.py:245, in caching_sha2_password_auth(conn, pkt)
243 if DEBUG:
244 print("caching sha2: succeeded by fast path.")
--> 245 pkt = conn._read_packet()
246 pkt.check_error() # pkt must be OK packet
247 return pkt

File C:\veighna_studio\Lib\site-packages\pymysql\connections.py:782, in Connection._read_packet(self, packet_type)
780 if self._result is not None and self._result.unbuffered_active is True:
781 self._result.unbuffered_active = False
--> 782 packet.raise_for_error()
783 return packet

File C:\veighna_studio\Lib\site-packages\pymysql\protocol.py:219, in MysqlPacket.raise_for_error(self)
217 if DEBUG:
218 print("errno =", errno)
--> 219 err.raise_mysql_exception(self._data)

File C:\veighna_studio\Lib\site-packages\pymysql\err.py:150, in raise_mysql_exception(data)
148 if errorclass is None:
149 errorclass = InternalError if errno < 1000 else OperationalError
--> 150 raise errorclass(errno, errval)

OperationalError: (1049, "Unknown database 'sqlite'")

wjinshui

Member

wjinshui

Member

您确定?