How to Install TS & MySQL 4 Properly

**fv1689** · 17-10-2006, 20:35

Still get the same error log.

---------------------------------------------------------------
-------------- log started at 17-10-06 15:30 -------------
---------------------------------------------------------------
17-10-06 15:30:47,ALL,Info,server, Server init initialized
17-10-06 15:30:47,ALL,Info,server, Server version: 2.0.20.1 Win32
17-10-06 15:30:47,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load libmySQL.dll
17-10-06 15:30:47,ERROR,All,SERVER, Start_Server: unable to open database
17-10-06 15:30:47,ERROR,All,GENERAL, critical error, shutdown initiated

I started with a clean install of the ts server and sql.

**Reedy Boy** · 17-10-2006, 21:33

It may not like the case sensitivity

In your server.ini change it to VendorLib=libmysql.dll

ie so it is all in lowercase

**ANR Daemon** · 31-10-2006, 04:38

MySQL 4.1.13
DBexpress library from http://codecentral.borland.com/Item.aspx?id=17739
libmySQL-4.1.dll from MySQL installation

[DBEXPRESS]
sqldir=mysql_sql\
Drivername=mysql
User_name=ts
Password=tsserver
Database=ts
Hostname=mysql.darkdragon
GetDriverFunc=getSQLDriverMYSQL
VendorLib=libmySQL-4.1.dll
;VendorLib=libmysql-5.dll
;LibraryName=dbexpmysql.dll
;LibraryName=dbexpmda.dll
LibraryName=dbexpmy4.dll
Active=1

Code:

---------------------------------------------------------------
-------------- log started at 31-10-06 07:22 -------------
---------------------------------------------------------------
31-10-06 07:22:03,ALL,Info,server,	Server init initialized
31-10-06 07:22:03,ALL,Info,server,	Server version: 2.0.20.1 Win32
31-10-06 07:22:04,ERROR,All,SQL,	Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
31-10-06 07:22:04,ERROR,All,SERVER,	Start_Server: unable to open database
31-10-06 07:22:04,ERROR,All,GENERAL,	critical error, shutdown initiated
---------------------------------------------------------------
-------------- log started at 31-10-06 07:22 -------------
---------------------------------------------------------------
31-10-06 07:22:35,ALL,Info,server,	Server init initialized
31-10-06 07:22:35,ALL,Info,server,	Server version: 2.0.23.6 Win32
31-10-06 07:22:36,ERROR,All,SQL,	Database initialization error: EDatabaseError.dbExpress Error: dbExpress Error [0x000B]: Parameter Not Set
SQL Server Error: Can't connect to MySQL server on 'localhost' (10061)
31-10-06 07:22:36,ERROR,All,SERVER,	Start_Server: unable to open database
31-10-06 07:22:36,ERROR,All,GENERAL,	critical error, shutdown initiated

Any ideas, suggestions? Why 2.0.23.6 trying to connect to localhost instead of host specified in INI file?

*Idea with passwords - now I trying to convert `mysql` database to new passwords (I detected that it still using old (16-chars) hash).

**ANR Daemon** · 31-10-2006, 07:07

MySQL 4.1.21
Updated libmySQL.dll
Recreated password (or no password at all) - same problem.

While trying to map local 3306 port to remote system, got followed errors:

Code:

---------------------------------------------------------------
-------------- log started at 31-10-06 10:04 -------------
---------------------------------------------------------------
31-10-06 10:04:23,ALL,Info,server,	Server init initialized
31-10-06 10:04:23,ALL,Info,server,	Server version: 2.0.20.1 Win32
31-10-06 10:04:24,ERROR,All,SQL,	TableExists Error: EDatabaseError.dbExpress Error: Invalid Data Translation in query: 
31-10-06 10:04:24,ERROR,All,SERVER,	Start_Server: unable to open database
31-10-06 10:04:24,ERROR,All,GENERAL,	critical error, shutdown initiated
---------------------------------------------------------------
-------------- log started at 31-10-06 10:04 -------------
---------------------------------------------------------------
31-10-06 10:04:43,ALL,Info,server,	Server init initialized
31-10-06 10:04:43,ALL,Info,server,	Server version: 2.0.23.6 Win32
31-10-06 10:04:44,ERROR,All,SQL,	TableExists Error: EDatabaseError.dbExpress Error: [0x0006]: Invalid Time in query: 
31-10-06 10:04:44,ERROR,All,SERVER,	Start_Server: unable to open database
31-10-06 10:04:44,ERROR,All,GENERAL,	critical error, shutdown initiated

**ANR Daemon** · 31-10-2006, 23:16

Any one can share worked pair of dbexmysql.dll & libmysql.dll ?

**ANR Daemon** · 01-11-2006, 04:05

Some additional experiments...
dbexpmysql.dll shipped with D7 (dbexpmysql-3.dll) told me about "Operation not supported".
Updated DLL from http://cc.borland.com/Item.aspx?id=20483 produce other very strange error:

Code:

01-11-06 06:58:03,ERROR,All,SQL,	OpenSQL Error: EDatabaseError.dbExpress Error: [0x0002]: Insufficient Memory for Operation in query: select * from ts2_servers;

All logs and files attached here.

**Reedy Boy** · 01-11-2006, 16:47

I've just had the problem of the dbexpmysql.dll only allowing 30 days

Attached my versions that were working, till it through the time problem

**ANR Daemon** · 01-11-2006, 21:24

Unable to load libmysql.dll :-\

**Reedy Boy** · 02-11-2006, 11:25

That is from MySQL 5...

So i dont know if that would cause a problem

**ANR Daemon** · 03-11-2006, 02:00

I was trying with more than 5 different libmySQL.dll and 5 dbex libraryes.
Only commercial libs work, but I can't pay for it. I dont have Visa, PayPal or other applicable systems.

**Reedy Boy** · 03-11-2006, 23:39

$70 is a hell of a lot!!

http://crlab.com/dbx/ordering.html

There must be an alternative

**fv1689** · 03-11-2006, 23:51

ok, I feel like an Idiot becouse I cant seem to get it to work.

anyhow ive changed the name, put the file in every location I can think of and it hasent worked. I have reinstalled the server, but I have no clue how to uninstall the mysql as a service to start fresh.

anyhow, any help would be great and to those who already tried to help me, thanks anyhow

**ANR Daemon** · 04-11-2006, 04:22

Originally Posted by Reedy Boy

$70 is a hell of a lot!!

http://crlab.com/dbx/ordering.html

There must be an alternative

I don't have Visa or bank account, I don't have access to wire transfer, I can't send check...
No options for me.

And at last, I don't have courage to pay for use of free software.
I don't make any money from it, so, I hate to spend any money for it.

2 moderators: Sorry for tis off-topic.

**Reedy Boy** · 04-11-2006, 11:15

Originally Posted by fv1689

ok, I feel like an Idiot becouse I cant seem to get it to work.

anyhow ive changed the name, put the file in every location I can think of and it hasent worked. I have reinstalled the server, but I have no clue how to uninstall the mysql as a service to start fresh.

anyhow, any help would be great and to those who already tried to help me, thanks anyhow

You know you dont need to use MySQL

**Reedy Boy** · 04-11-2006, 11:16

Originally Posted by ANR Daemon

I don't have Visa or bank account, I don't have access to wire transfer, I can't send check...
No options for me.

And at last, I don't have courage to pay for use of free software.
I don't make any money from it, so, I hate to spend any money for it.

2 moderators: Sorry for tis off-topic.

I've got a copy of Delphii 7.2 SE, and pulling the module from the bin folder, it gives the same errors, aswell as being the same size....

Will look into it....

Thread: How to Install TS & MySQL 4 Properly

Thread Tools

Rate This Thread

Display

didnt work

ugh, still aint working

Thread Information

Users Browsing this Thread

Similar Threads

Install: MYSQL: Invalid Username/Password

Another option for MySQL 4.1

Windows TS2 Server to Remote MySQL Server?

Found some problems (and fixed) with a TS2 and MySQL installation

browser install Im only getting 3 out of the 5 tables in mysql

Tags for this Thread

Posting Permissions