From e6b64ec454869c5df26145271feead9a62b581cb Mon Sep 17 00:00:00 2001 From: Xanthem <2vendor@hisfootsteps.net> Date: Tue, 17 Aug 2021 07:15:53 -0700 Subject: Set up Localhost --- main.sql | 1 - server.py | 2 +- sql.py | 3 ++- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/main.sql b/main.sql index 828a856..e19e271 100644 --- a/main.sql +++ b/main.sql @@ -22,7 +22,6 @@ CREATE TABLE IF NOT EXISTS `login` ( `userid` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `userpw` VARCHAR(32) NOT NULL DEFAULT '', `email` VARCHAR(255) NOT NULL DEFAULT '', - --`guild_id` INT(11) UNSIGNED NOT NULL DEFAULT 0, `lastlogin` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`userid`), KEY `name` (`userid`) diff --git a/server.py b/server.py index 84ab8b1..e465ba8 100755 --- a/server.py +++ b/server.py @@ -36,7 +36,7 @@ p=json.load(f) f.close() PORT=p["PORT"] -SECURE=p["SSL"] +SECURE=False#p["SSL"] ############################################################### # Main Class diff --git a/sql.py b/sql.py index 21aa065..372c539 100644 --- a/sql.py +++ b/sql.py @@ -40,7 +40,8 @@ db = mysql.connector.connect( host=SQLHOST, user=SQLUSER, passwd=SQLPASS, - database=SQLDBID + database=SQLDBID, + auth_plugin='mysql_native_password' ) ####################################### Private methods -- cgit v1.2.3-60-g2f50 From 58aaeecc4baf56014494c7b7267e2fec858148fe Mon Sep 17 00:00:00 2001 From: Xanthem <2vendor@hisfootsteps.net> Date: Tue, 17 Aug 2021 07:15:53 -0700 Subject: Set up Localhost --- main.sql | 1 - server.py | 2 +- sql.py | 3 ++- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/main.sql b/main.sql index 828a856..e19e271 100644 --- a/main.sql +++ b/main.sql @@ -22,7 +22,6 @@ CREATE TABLE IF NOT EXISTS `login` ( `userid` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `userpw` VARCHAR(32) NOT NULL DEFAULT '', `email` VARCHAR(255) NOT NULL DEFAULT '', - --`guild_id` INT(11) UNSIGNED NOT NULL DEFAULT 0, `lastlogin` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`userid`), KEY `name` (`userid`) diff --git a/server.py b/server.py index e66b63a..1a3a7cd 100755 --- a/server.py +++ b/server.py @@ -36,7 +36,7 @@ p=json.load(f) f.close() PORT=p["PORT"] -SECURE=p["SSL"] +SECURE=False#p["SSL"] ############################################################### # Main Class diff --git a/sql.py b/sql.py index 21aa065..372c539 100644 --- a/sql.py +++ b/sql.py @@ -40,7 +40,8 @@ db = mysql.connector.connect( host=SQLHOST, user=SQLUSER, passwd=SQLPASS, - database=SQLDBID + database=SQLDBID, + auth_plugin='mysql_native_password' ) ####################################### Private methods -- cgit v1.2.3-60-g2f50