Rev CGI, Linux, MySQL, invalid database type

[chris bohnert]

Hi Dave,

You might try:

chmod 774 dbmysql.so

and failing that

chown apache:apache dbmysql.so (assuming your cgis run as apache)

and then tweak back to the appropriate level of security for your instance.

--
cb

On 11/9/06, Viktoras Didziulis <viktoras at ekoinf.net> wrote:
>
> Hi Dave,
>
> try executing in mySQL admin before connecting to the database:
> SET PASSWORD FOR 'user'@'host'=OLD_PASSWORD('password');
>
> hint source:
> http://www.sonsothunder.com/devres/revolution/tips/data004.htm
>
> Viktoras
>
> -------Original Message-------
>
> From: Dave Cragg
> Date: 11/09/06 18:06:40
> To: How to use Revolution
> Subject: Rev CGI, Linux, MySQL, invalid database type
>
> Hi
>
> I'm getting the often mentioned "invalid database type" when
> connecting to a MySQL server from a Rev CGI on Linux. I've done this
> successfully before, but not on this server. So I'm wondering what
> I've forgotten or overlooked.
>
> The CGI setup is fine. Non-database CGIs work.
>
> The Rev engine I'm using is version 2.6.1 (that's the engine
> version). I'm using revdb_setdriverpath to set the driver path.
>
> The MySQL version is 3.23.58. Is it possible the driver from Rev
> 2.1.2 (equivalent revVersion package) doesn't work with that version?
> (I used it before with MySQL 4.x.
>
> The revdb_connect line is like this:
>
> put revdb_connect("mysql",sDBHost,sDBName,sDBUser,sDBPass) into
> sDBID
>
> I've tried "mysql" in various case combinations, but with no luck.
> (It worked in lower case before.)
>
> Any help appreciated.
>
> Cheers
> Dave
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>