libdb (SQLite / MySQL / MariaDB / PostgreSQL / ODBC library)

[Mighty]

Sadly, empty string

[SyavX]

Now I'm out of ideas too...

[ExHunter]

Hey,

We also encountered some problems with the ODBC drivers/connectors... We are able to run the server with the library, but we do not get any drivers installed..

System info and what we tried to do to get it work:

CentOS 5.8
libiodbc completely installed (also re-installed)
$LD_LIBRARY_PATH correct
mysql-connector-odbc installed 3.51 64b
tested with
mysql-connector-odbc 5.2 64b
3.51 32b and 5.2 32b

looking for drivers:

(20:12:17) /drivers (*.*.*.*)
(20:12:17) No ODBC drivers installed!

trying to connect to a db DB_error() shows:

(20:12:22) Data source name not found and no default driver specified. Driver could not be loaded

What possibilities do we have to get the driver loaded? I would appreciate any help, since we cannot think of anything more than that now. Thanks

[SyavX]

I've updated the libdb (check attachments in the 1st post), so it's Linux version requires unixODBC instead of iODBC now. Maybe it would help to solve the problems mentioned above.

ExHunter, unfortunately I'm not experienced with Linux enough, but I could suggest you to read this first: Configuring MySQL Connector/ODBC
and, since libdb was updated, this: Guide to getting unixODBC and MySQL/MyODBC working.

Also, you could try Mr's SoldatSOCI.

[Szaman]

Hi,

I have some problems with compiling libdb on server (1.6.5 version, Debian hosted)

When I try to compile it there is an error:
►   00:13:31 

• Compiling libdb-0.2 -> libdb_linux.pas...

►   00:13:31 

• libdb-0.2 -> [Error] (23:1): Semicolon (';') expected

►   00:13:31 

• Disabling libdb-0.2

Line 23 is:
Function DB_ColumnName(DatabaseID, Column: Integer): PChar;

Does anybody had the same problem and solved it ?

Thanks in advace for the response.

Best regards,
Peter.

[Falcon`]

you have safemode off. Launch soldatserver with -safe 0 switch.

[Szaman]

Oh... such a stupid bug  Sorry for wasting your time 

And thank you very much for explaining that error Now everything works

[Leader]

Hello there! Ive got a problem! I try to learn database scripting. I started it connecting databasing with script core2 and it works with safe 0. But Id like to move to script core 3 and I cannot. When I recompile trial script I get an error like when it would be sc2 with safe on "Semicolon expected". Could someone tell me what should I install/change/remove or anything?

[SyavX]

Try to enable external DLLs in ScriptCore3 config file: AllowDlls=1

[Nedi]

Hello,
I have some problems with running soldatserver with this lib:

Code: [Select]

             -= Soldat Dedicated Server 1.6.8 - 2.7.8 =-

----------------------------------------------------------------
         Soldat Dedicated Server initializing...
----------------------------------------------------------------

   Need help running your server?
   IRC: #soldat.devs @ irc.quakenet.org

   ---> http://forums.soldat.pl/

   Additional parameters:
   ./soldatserver -p PORT -l MAXPLAYERS -k PASSWORD
   Example: ./soldatserver -p 23073 -l 16 -k "my pass"


 Compiled with FreePascal (Indy 10)

 Hit CTRL+C to Exit
 Please command the server using the Soldat Admin program
Welcome to Soldat 1.6.8
 Server name: Soldat Server
 Server PID: 6217
 [*] Compiling stats -> libdb_linux.pas...
 [*] Compiling stats -> stats.pas...
 [*] stats -> Cannot Import dll:libdb-0.2.so
 [*] Disabling stats
----------------------------------------------------------------
Mapslist loaded mapslist
ctf_nothard
 Server IP: 0.0.0.0 Port: 23073
 Connection for file server started. Port: 23083
Registering server @ 67.23.118.179


I have debian 7 64bit
libdb-0.2.so is placed in soldatserver root folder
also in:
/var/lib/libdb-0.2.so
/etc/lib/libdb-0.2.so
/lib64/libdb-0.2.so
/lib/libdb-0.2.so
/usr/local/lib/libdb-0.2.so
/usr/lib/libdb-0.2.so

Do you have any ideas why it doesn't work?

[jrgp]

Hello,
I have some problems with running soldatserver with this lib:

Code: [Select]

             -= Soldat Dedicated Server 1.6.8 - 2.7.8 =-

----------------------------------------------------------------
         Soldat Dedicated Server initializing...
----------------------------------------------------------------

   Need help running your server?
   IRC: #soldat.devs @ irc.quakenet.org

   ---> http://forums.soldat.pl/

   Additional parameters:
   ./soldatserver -p PORT -l MAXPLAYERS -k PASSWORD
   Example: ./soldatserver -p 23073 -l 16 -k "my pass"


 Compiled with FreePascal (Indy 10)

 Hit CTRL+C to Exit
 Please command the server using the Soldat Admin program
Welcome to Soldat 1.6.8
 Server name: Soldat Server
 Server PID: 6217
 [*] Compiling stats -> libdb_linux.pas...
 [*] Compiling stats -> stats.pas...
 [*] stats -> Cannot Import dll:libdb-0.2.so
 [*] Disabling stats
----------------------------------------------------------------
Mapslist loaded mapslist
ctf_nothard
 Server IP: 0.0.0.0 Port: 23073
 Connection for file server started. Port: 23083
Registering server @ 67.23.118.179


I have debian 7 64bit
libdb-0.2.so is placed in soldatserver root folder
also in:
/var/lib/libdb-0.2.so
/etc/lib/libdb-0.2.so
/lib64/libdb-0.2.so
/lib/libdb-0.2.so
/usr/local/lib/libdb-0.2.so
/usr/lib/libdb-0.2.so

Do you have any ideas why it doesn't work?

Can you paste the output of "ldd libdb-0.2.so" in your soldat's root folder?

[SyavX]

Hello,
I have some problems with running soldatserver with this lib:

Seems like there is something wrong with server compiled with Indy 10, try to run soldatserver_legacy

Btw, I've updated notes section to make it more specific about dependencies.

[Nedi]

Can you paste the output of "ldd libdb-0.2.so" in your soldat's root folder?

There was:

Code: [Select]

libodbc.so.1 => not found

Btw, I've updated notes section to make it more specific about dependencies.

It works now

Thanks

[Walls]

Yeah, I was going to make a note on that all deps must be 32bits, took quite a while for exhunter and me to get it working on our servers.
So it shall work on other distros as long as you get all odbc and deps on 32b.

[SyavX]

Version 0.3 (27 Jan 2019):
+ Added MySQL support (see DB_Plugin_MySQL)
+ Added SQL bind variables (see DB_SetString(), DB_SetLong() etc.)
+ Added things which I can't recall...
% Modified library bindings and example code (rewritten with ScriptCore3 syntax)
% Modified some bindings and internal code which broke backward compatibility, see description below for more info

1. Most functions that were returning non zero on success and 0 otherwise are returning Boolean now (e.g. DB_NextRow(), DB_Query() etc.)
For example:

Code: (Pascal) [Select]

if DB_NextRow(0) <> 0 then
// and
if DB_NextRow(0) = 0 then

should be replaced with

Code: (Pascal) [Select]

if DB_NextRow(0) then
// and
if not DB_NextRow(0) then

2. You should now call one of DB_UseMySQL(), DB_UseODBC(), DB_UsePostgreSQL(), DB_UseSQLite() procedures before using any functions related to the corresponding database plugins.

3. Database plugins and column type constants are declared as enumerations now:

Code: (Pascal) [Select]

{ Database plugins enumeration for the DB_Open() function }
type TDatabasePluginType = (DB_Plugin_Undefined, DB_Plugin_ODBC, DB_Plugin_SQLite, DB_Plugin_PostgreSQL, DB_Plugin_MySQL);

{ Database column types enumeration for the DB_ColumnType() function }
type TDatabaseColumnType = (DB_Type_Undefined, DB_Type_Long, DB_Type_String, DB_Type_Float, DB_Type_Double, DB_Type_Quad);

See first post for the download link...

[jrgp]

Nice addition of the bind variables! Great to finally have prepared statements.

[Savage]

Amazing work