server db drivers not loading

[monte]

I'm trying to work out the issue and I'm not sure if it's just on OS X but the _MAC_SERVER and _SERVER macros aren't defined for the server-revdb project and they seem to be critical for finding the db drivers...

[sturgis]

Replacing the driver files with copies from 5.0.2 commercial solves the issue. Don't know if it helps you track down the problem but thought i'd throw it out there.

EDIT: to test I just copied both folders (externals and drivers) to the correct location and LC community started working fine.

[LCMark]

@monte: Looks like a missing Preprocessor define in the server-* targets in revdb/revdb.xcodeproj. Both _MAC_SERVER and _SERVER should be defined on those targets (they probably got accidentally lost when we redid the project files :S).

[monte]

Ok... That's what I thought... I never seem to know when something should be called a macro and when it should be called a preprocessor define...

[fenick]

I may have the same issue.

When I run:
put revOpenDatabase("MySQL", tHostName, tDataBaseName, tUserName, tPassword) into tDataBaseID

in a stack I get an integer for tDataBaseID
on the server I get "revdberr,invalid database type" for tDataBaseID

Or, the problem could be in configuration. I recently just installed the MySQL database locally and am trying to get up to speed on it.

I am running
OSX 10.8.4 with server.app
I just installed serverLiveCodeCommunityServer-6_1_0_rc_1-Mac but that did not help any.

Question: where could I get an older version of the externals and drivers so I can test out that solution.

or is my problem elsewhere?

[monte]

If you replace the older revdb with the new one it will work. I had thought @runrevmark got this before RC1 but perhaps it was after?

[fenick]

OK. I tried that. I replaced drivers and externals within my CGI-Exectuables folder with the one that comes with 6.1 RC1. That did not solve the problem.

To see what is going on, I tried to output revGetDatabaseDriverPath() on the server... but the server times and only returns empty. To retest, when I comment out that line on the server I get the "revdberr,invalid database type" again. so it seems that revGetDatabaseDriverPath() is causing the server to hang.

Next I added:
revSetDatabaseDriverPath "../drivers/"

The server no longer hangs, But I still get "revdberr,invalid database type"

I'm not sure where to look now. Does the livecode-server or its folder need special permissions that I may have wiped out? Any suggestion on where else to look?

[monte]

no, replace them from version 5.whatever...

[fenick]

I'm new to playing with server. I do not have an earlier version.

I'll send a message to support and see if they can help.

Thanks,

[monte]

Ah.. well you will probably either need to wait for the next RC which should be within a few days or compile it yourself now that it's fixed.

[LCMark]

This should be fixed in 6.1.0-rc-2 - server available here: http://downloads.livecode.com/livecode/server/6_1_0.