-
Posts
56 -
Joined
-
Last visited
Content Type
Profiles
Downloads
Forums
Store
Support
DOWNLOADS EXTRA
Services
Everything posted by dFxPhoeniX
-
The login plugin is already downloaded both the old one and the new one. you have to make sure you use the old one. add that setting to the mysql configuration. To execute the commands, you must connect to mysql with the command mysql -u user -p in cmd
-
Yeah. You only need to put this in the mysql server config for old auth plugin: default_authentication_plugin=mysql_native_password And update the user auth plugin ALTER USER 'user'@'ip' IDENTIFIED WITH 'mysql_native_password' BY 'pswd'; You can check the user auth plugin by using SELECT user, host, plugin FROM mysql.user;
-
Yeah, you have .ini because you have the server on Windows, not on Linux. is that all you have in this file? what other files do you have? The plugin only uses the mysql oxide library to connect, but does not support ssl, and the authentication plugin is the old one, because of library. Most likely the problem is with the server, as I said. Try to change the authentication plugin and put the ssl code that I gave you in the mysql config, then restart. That version of mariadb that you have should work fine.
-
What you show me there are the settings from the client you use for the certificate, the settings from the server you can find in the server configuration, where I said, in the my.cnf file. I told you, I need more details, the mysql version, as well as what the configuration looks like to be able to figure out what is not working.
-
As I said, the plugin can't connect to the database because of that authentication error, so it's normal that it didn't create your tables. Use another mysql database or give me more details. The plugin is tested on MySql 5.7 and 8.0, as well as on Mariadb 11 and it works. Make sure that the certificate you are using is correct, repair the database, the error states that it could be corrupted. Also make sure you use the old authentification plugin on the server, if you use recent versions. The old auth plugin is mysql_native_password, make sure you don't use caching_sha2_password. Anyway, the problem is related to the ssl certificate, most likely. run in mysql server SHOW VARIABLES LIKE '%ssl%'; to see if you have ssl enabled.
-
To disable ssl you need to edit the mysql config from server (my.ini/my.cng) and set the: ssl=0 skip_ssl
-
You need to use MySQL or MariaDB, HidiSQL is a client? I can not see the version in the photo. Tables will generated automatically, you only need to create a database.
-
Are you using ssl certificate on the Mysql server? If so, disable it. Can you connect to the Mysql server with another client, such as PHPMyAdmin or Navicat? What version of Mysql do you have?
-
Error when empty parameter to.user group or others command
dFxPhoeniX posted A Support Request in Support
As the title says, if I use the o.usergroup command or any other command, such as grant, revoke, etc. without any parameter, I get a null error Failed to call hook 'OnServerCommand' on plugin 'TemporaryPermissions v0.1.0' (NullReferenceException: Object reference not set to an instance of an object) at Oxide.Plugins.TemporaryPermissions.CommandUserGroup (System.String[] args) [0x00014] in <77a7d872b2154971802c677f14aad733>:0 at Oxide.Plugins.TemporaryPermissions.OnServerCommand (ConsoleSystem+Arg arg) [0x00062] in <77a7d872b2154971802c677f14aad733>:0 at Oxide.Plugins.TemporaryPermissions.DirectCallHook (System.String name, System.Object& ret, System.Object[] args) [0x062a0] in <77a7d872b2154971802c677f14aad733>:0 at Oxide.Plugins.CSharpPlugin.InvokeMethod (Oxide.Core.Plugins.HookMethod method, System.Object[] args) [0x00079] in <206a0f2c6ee141f38e2ad549cde44d70>:0 at Oxide.Core.Plugins.CSPlugin.OnCallHook (System.String name, System.Object[] args) [0x000de] in :0 at Oxide.Core.Plugins.Plugin.CallHook (System.String hook, System.Object[] args) [0x00060] in :0 -
My name is dFxPhoeniX, and I’m here to bring your ideas to life with a blend of technology and creativity. I offer professional services in plugin development, web development, graphic design, and programming. Custom Website Development: Whether you need a presentation site, an server website, or a blog, I provide modern and functional solutions tailored to your needs. Logo, Avatar and Banner Design: Want a visual identity that stands out? I create unique designs that represent your brand and capture attention online. Discord Bots: Need automation and special features for your Discord server? I develop custom bots that make your server more interactive and easier to manage. Rust Plugins & Server Setup: If you're passionate about Rust, I create plugins and offer full server setup services to enhance your gaming experience. No matter the project, I’m committed to delivering professional and efficient solutions. Let’s collaborate and create something extraordinary together! Feel free to contact me on Discord at dfxphoenix for inquiries or to discuss your project.
-
- 8 comments
-
Changed Status from Pending to No Response
-
Changed Status from to Pending
-
Changed Status from No Response to
-
Changed Status from No Response to
-
Changed Status from Pending to No Response Changed Fixed In to 1.8.8
-
Starting from MariaDB 10.6.1, the primary name for the previous 3-byte UTF character set has been updated to 'utf8mb3'. Consequently, there may be compatibility issues, such as the error 'Character set 'utf8mb3' is not supported by .Net Framework' when interfacing with MySQL.Data.MySqlClient. Additionally, from MariaDB 10.10.1 onwards, the ID field has been made Nullable, potentially resulting in errors like 'Object cannot be cast from DBNull to other types' So I'm afraid I can not do someting to solve, it is a problem from the mysql library. Downgrade to version 10.4 and will works.
-
The problem is only on version 11+ of MariaDB, I guess, on version 10.4 I tested it and it works, I'm trying to see if I can solve it
-
I'll try tonight if I have some free time to test MariaDB myself and fix the problem. I'll keep you updated on the changes, if it's resolved quickly I'll upload the update tomorrow on CF.
-
If you are using MariaDB then this may be the problem, MariaDB has more changes than MySQL, as it is a fork. If you have the posibility, I would recommend using MySQL. I recommend MySQL version 8, older versions are outdated. I can make the plugin support MariaDB in the next update, but only if the oxide library allows me. Until then, I recommend using MySQL.
-
I can make you a database at my host to see if everything is ok, although it will surely work since I already have a server running, but we can try to check.
-
Try to check if is some null values on db by executing SELECT userid FROM yourtable WHERE userid IS NULL; Can you tell me which version of MySQL you are using? Also, if you move to SQlite does everything works well?
-
This error indicates that the column with key 12548 does not exist in the database. Have you made any changes to the plugin? The way the database looks, I assume that you let the plugin create the table and you didn't create it yourself. All you have to do when you load the plugin is to change the config to MySQL, have a database accessible by the host where the plugin is located and that's it, the tables and the rest are created automatically. And one more thing, what character set are you using for the database? I recommend utf8mb4_unicode_ci
-
Can you give me more details, such as when this error occurs and if you load an object such as a null object in the database?