Database

[ghost]

How to disable database :/? I am not using it but if I try to load plugin without database it shows this error:

[Server thread/CRITICAL]: Exception: "Unable to open database: unable to open database file" (EXCEPTION) in "/PiggyAuth-master/src/PiggyAuth/Databases/SQLite3" at line 15

Please, I want to use this auth. It looks really great!

[Thunder33345]

but it needs a database to store player data?

[ghost]

Cannot be it stored in config?

[ghost]

So, how can I setup SQLite3 database?

[Thunder33345]

not a maintainer, but nope not for this plugin, i think it just creates it itself maybe the plugin dont have permission to create the players.sql not very sure tho

[DaPigGuy]

Do you have sqlite3 files in your bin folder?

[Aericio]

if you are in windows, download this and drop it in bin/php

[ghost]

Okay, I will test. Thank you!

[DaPigGuy]

Is it working?

[ghost]

No :/. I will create MySQL database and host it on. I will never more change Auth plugin. I think this is perfect.

[DaPigGuy]

You getting any new errors with SQLite3?

[ghost]

Yes. this. [Server thread/CRITICAL]: Exception: "Unable to open database: unable to open database file" (EXCEPTION) in "/PiggyAuth-master/src/PiggyAuth/Databases/SQLite3" at line 15

[DaPigGuy]

Can you show me your php.ini file & php_sqlite3.dll in your bin folder?

[ghost]

Yes. php_sqlite3.dll - https://www.opendll.com/index.php?file-download=php_sqlite3.dll&arch=32bit&version=5.4.3.0&dsc=SQLite3 php.ini - wait, I must upload it on cloud.

[ghost]

; Compiled by SalmonDE zend.enable_gc = On max_execution_time = 0 memory_limit = 256M error_reporting = -1 display_errors = stderr display_startup_errors = On register_argc_argv = On default_charset = "UTF-8" include_path = ".;.\ext" extension_dir = "./" enable_dl = On allow_url_fopen = On extension=php_weakref.dll extension=php_curl.dll extension=php_mysqli.dll extension=php_sqlite3.dll extension=php_sockets.dll extension=php_mbstring.dll extension=php_yaml.dll extension=php_pthreads.dll extension=php_openssl.dll extension=php_com_dotnet.dll extension=php_gd2.dll zend_extension=php_opcache.dll cli_server.color = On phar.readonly = Off phar.require_hash = On zend.assertions=-1 opcache.enable=1 opcache.enable_cli=1 opcache.memory_consumption=128 opcache.interned_strings_buffer=8 opcache.max_accelerated_files=4000 opcache.save_comments=1 opcache.load_comments=1 opcache.fast_shutdown=0 opcache.optimization_level=0xffffffff date.timezone=UTC

[DaPigGuy]

It should work fine. Does your server have permission to edit files?

[ghost]

I think yes. If I execute any command and it edits config (for example)?

[ghost]

I download latest update and try it.

[ghost]

I have this error with latest update. [17:20:34] [Server thread/INFO]: Enabling PiggyAuth v2.0.1 [17:20:34] [Server thread/CRITICAL]: ClassNotFoundException: "Class SQLite3 not found" (EXCEPTION) in "/src/spl/BaseClassLoader" at line 144

[DaPigGuy]

... What did you do?

[ghost]

Nothing. I only deleted old version. downloaded version from GitHub (the newest) and pasted.

[DaPigGuy]

I think you did something wrong. Try again, I'm on the latest version and no problems.

[ghost]

I have SQLite3 class in src/PiggyAuth/Databases.

[DaPigGuy]

Try again...

[ghost]

I think the plugin did not create SQLite3 file with players data.

[DaPigGuy]

It should, check PiggyAuth folder for players.db

[ghost]

Okay.

[ghost]

I have in PiggyAuth folder only config.yml.

[ghost]

I try it again.

[ghost]

[Server thread/CRITICAL]: Exception: "Unable to open database: unable to open database file" (EXCEPTION) in "/PiggyAuth-master/src/PiggyAuth/Databases/SQLite3" at line 15

What can I do with it? I am running my test server on Windows 32-bit. I have the latest version of binaries and Genisys server sofware.

[DaPigGuy]

Try out FactionsPro & see if it creates the database. It uses SQLite3 too. https://github.com/Awzaw/FactionsPro/blob/master/src/FactionsPro/FactionMain.php

[ghost]

Yes.

[DaPigGuy]

It creates a database?

[ghost]

No. I have the same error.

[DaPigGuy]

It's your problem not the plugins.

[ghost]

I will test it on hosting. Wait please.

[ghost]

It is working on hosting server.

[DaPigGuy]

It is your problem them.

[ghost]

Yes. Thank you for everything!