[ERROR] ManiaLive1 r267 and SQlite

Discuss the Dedicated Server Tools developed by Nadeo Live such as ManiaLive, Trust Circles, Dedicated Manager, Competition Manager and Lobbies

Moderator: NADEO

Post Reply
Cayseth
Posts: 5
Joined: 22 Jul 2012, 19:14

[ERROR] ManiaLive1 r267 and SQlite

Post by Cayseth »

Hi,

im getting the following error with ManiaLive1 r267:

Code: Select all

ManiaLive
PHP Environment Compatibility Test
-----------------------------------------------------
PHP 5.3.1 or newer    -> required  -> [ Yes ] 5.3.10-1ubuntu3.2
Standard PHP Library  -> required  -> [ Yes ]
JSON                  -> required  -> [ Yes ]
OpenSSL               -> required  -> [ Yes ]
cURL with SSL         -> required  -> [ Yes ] 7.22.0 (OpenSSL/1.0.1) (with OpenSSL/1.0.1)
SQLite                -> optional  -> [ Yes ]
-----------------------------------------------------
[01:24:23] XML-RPC connection established
[01:24:23] Successfully authentified with XML-RPC server
PHP Fatal error:  Call to undefined function ManiaLive\Database\SQLite\sqlite_open() in /home/tmf/ManiaLive/libraries/ManiaLive/Database/SQLite/Connection.php on line 41

Fatal error: Call to undefined function ManiaLive\Database\SQLite\sqlite_open() in /home/tmf/ManiaLive/libraries/ManiaLive/Database/SQLite/Connection.php on line 41
Everything is running fine on my old server with the same ManiaLive settings.

I have pdo_sqlite (SQLite Library 3.7.9) and sqlite3 (module version 0.7-dev) installed.
I'm using CGI/FastCGI as server API.

The funny thing is, even when I manually set $sqlite_ok = false in bootstrapper.php, I get the same error again (?).

Would be grateful if someone could help me, it's the one thing keeping me away from changing the server machines.

Greetings,
Cay
Server & Site Administrator of FreeZone superLoL.
Visit us at http://superlol-tm.net!
farfa
Nadeo
Nadeo
Posts: 585
Joined: 14 Jun 2010, 16:15
Location: In front of your hood with one lap late

Re: [ERROR] ManiaLive1 r267 and SQlite

Post by farfa »

You have to setup sqlite, it's not sqlite3 neither pdo_sqlite.
Also known as: satanasdiabolo
Cayseth
Posts: 5
Joined: 22 Jul 2012, 19:14

Re: [ERROR] ManiaLive1 r267 and SQlite

Post by Cayseth »

How can I get the old sqlite installed?

apt-get/yum install sqlite doesn't work, it says sqlite is already the latest version.

When I install the 2.8.17 (http://sqlite.org/sqlite-2.8.17.tar.gz) version from source, I only get the libsqlite.so?
And with the pecl version (1.0.3) there is an error with byref_none undeclared (seems like it was a bug back then in 2004).

I also wonder why it says SQLite is enabled in the ManiaLive log.
And it seems to check for either sqlite2 or sqlite3, but sqlite3 doesn't work with sqlite_open()?
Server & Site Administrator of FreeZone superLoL.
Visit us at http://superlol-tm.net!
Cayseth
Posts: 5
Joined: 22 Jul 2012, 19:14

Re: [ERROR] ManiaLive1 r267 and SQlite

Post by Cayseth »

Okay, I worked around it.
I copied a working sqlite.so into the lib and loaded that. Im not getting any php error now, ManiaLive is starting perfectly with FreeZone and MLIntegration plugins.

But I don't see the server in the public lists (like via choosing Country->State) on a TMN account (I do see it with TMF account).
Joining via tmtp://#join=superloltm doesn't work on a TMN account as well (it does on TMF account).

I know that ManiaLive sometimes needs a few hours to start up? Hopefully that will fix it, otherwise I'll be coming back :D

Greetings
Server & Site Administrator of FreeZone superLoL.
Visit us at http://superlol-tm.net!
Cayseth
Posts: 5
Joined: 22 Jul 2012, 19:14

Re: [ERROR] ManiaLive1 r267 and SQlite

Post by Cayseth »

Well, it still doesn't work.

As there is not a single error, this is very hard for me to judge.
Everything seems to be running perfect, everything in the logs is ok.
The settings are the same as on the old working machine.

But it just doesn't show up in the server lists on a TMN account, even not in favorites??
Joining via tmtp://# link just returns "Server connection failed".

For TMF accounts nothing has changed. Seeing it in the public server lists works, favorite works, tmtp-join works.
Restarting the server doesn't help either.

Someone got an idea?
Server & Site Administrator of FreeZone superLoL.
Visit us at http://superlol-tm.net!
Cayseth
Posts: 5
Joined: 22 Jul 2012, 19:14

Re: [ERROR] ManiaLive1 r267 and SQlite

Post by Cayseth »

Anyone? I'm happy about every input.

EDIT: It's working now with an old version of ManiaLive.
Server & Site Administrator of FreeZone superLoL.
Visit us at http://superlol-tm.net!
TheBigG.
Posts: 401
Joined: 11 Jun 2011, 16:11

Re: [ERROR] ManiaLive1 r267 and SQlite

Post by TheBigG. »

i have the same problem which version did you choose?
Client:
OS: Win10/Debian CPU: Intel 9900k GPU: NVIDIA 1080TI Display: 3x Acer Predator XB271HUbmiprz 1440p@165 Hz

Server:
OS: Debian Stable @ Backports Kernel CPU: Intel 6700k RAM: 32 GB Storage: 2x 256 GB NVMe SSD@Raid 1
TheBigG.
Posts: 401
Joined: 11 Jun 2011, 16:11

Re: [ERROR] ManiaLive1 r267 and SQlite

Post by TheBigG. »

ok so i have to remove manialive from every server
Client:
OS: Win10/Debian CPU: Intel 9900k GPU: NVIDIA 1080TI Display: 3x Acer Predator XB271HUbmiprz 1440p@165 Hz

Server:
OS: Debian Stable @ Backports Kernel CPU: Intel 6700k RAM: 32 GB Storage: 2x 256 GB NVMe SSD@Raid 1
Post Reply

Return to “Dedicated Server Tools”

Who is online

Users browsing this forum: No registered users and 1 guest