Database Query Builder problem

benoestrada · Post by **benoestrada** » Thu Jan 31, 2008 5:56 pm

Hi,

I'm new to RR and have this problem:

I'm using RevStudio 2.8.1 in my iMac (registered) and same version in my Windows PC (trial).

If I try to connect to a MySQL database with my iMac using the Database Query Builder everything runs nice, I can connect.

But if I try to do this in the trial version on my PC then a error window pops saying: "There was an error in connecting to the database. Please check that the connection fields are correct Revdb error: revdberr, invalid database type"

In both cases I'm using the same parameters, so it is impossible that the problem may be in it.

Is this a limitation of the trial version?
Ideas?

Thanks for your time and help,

Benito Estrada

Mark · Post by **Mark** » Sun Feb 10, 2008 7:49 pm

Benito,

Post your script.

Mark

benoestrada · Post by **benoestrada** » Sun Feb 10, 2008 8:16 pm

Hi Mark,

There is no script in this problem. I'm using the "Database Query Builder" option from the Tools menu in RR.

Here is a screenshot:

This is the Windows screen displaying the error. As you can see it does not connect to the database.

Using the same parameters for: myhost, mydatabase, myuser and mypassword in my iMac connects with no problem.

Thanks for your time.

Benito Estrada

Mark · Post by **Mark** » Sun Feb 10, 2008 9:19 pm

benoestrada,

Is your host address a local address or remote? If local, are you sure that MySQL has been installed and set up properly?

Does the firewall of your PC allow traffic on port 3306?

Best,

Mark

benoestrada · Post by **benoestrada** » Sun Feb 10, 2008 10:59 pm

Hi Mark,

Is your host address a local address or remote?

Did tests in both cases: remote and local, both fail.

If local, are you sure that MySQL has been installed and set up properly?

Yes, this is running fine. I can connect to this MySQL in my LAN (Macs & PCs) and using other tools.

Does the firewall of your PC allow traffic on port 3306?

My firewall is not blocking that port.

--------------------

More on this subject:

I have tested this connection using another Multimedia Authoring System in this Windows machine and connects Ok to this database (local and remote).

Thanks for your time,

Benito Estrada

Janschenkel · Post by **Janschenkel** » Mon Feb 11, 2008 1:09 pm

To things come to mind,

- Is it possible the database requires SSL connections? Try toggling the 'SSL' checkbox.

- Is the database set to use 'old-style' passwords? (See the MySQL Administrator) The MySQL database driver is built to sue the 'old-style' passwords.
Which means that you should either toggle the checkbox in the MySQL administrator, or convert the passwords yourself, as explained here:
http://www.sonsothunder.com/devres/revo ... ata004.htm

Hope this gets youy closer to a solution,

Jan Schenkel.

benoestrada · Post by **benoestrada** » Tue Feb 12, 2008 5:18 am

Hi Janschenkel,

- Is it possible the database requires SSL connections? Try toggling the 'SSL' checkbox.

Test it and no success. As stated above; the connections parameters are working nice from the iMac and from the WinPC using other tools. But thanks for the idea.

- Is the database set to use 'old-style' passwords? ...

Nope, RunRev 2.8.1 & MySQL 5 in local and remote tests.

Thanks for your time,

Benito Estrada

BvG · Post by **BvG** » Tue Feb 12, 2008 12:44 pm

- Is the database set to use 'old-style' passwords? ...
Nope, RunRev 2.8.1 & MySQL 5 in local and remote tests.

Rev's database external for mySQL can only use the "old-style" password. therefore you have to enable this setting on your mySQL server, otherwise you won't be able to connect.

benoestrada · Post by **benoestrada** » Tue Feb 12, 2008 3:35 pm

Hi BvG,

Rev's database external for mySQL can only use the "old-style" password. therefore you have to enable this setting on your mySQL server, otherwise you won't be able to connect.

I started this thread stating that the DataBase Query Builder option of the Tools menu works perfect in iMac using RR 2.8.1 (registered) and accesing a remote or local database.

Next, using the same parameters on a WinPC with RR 2.8.1 (trial) does not connect and pops: "There was an error in connecting to the database. Please check that the connection fields are correct Revdb error: revdberr, invalid database type" which is different to 'Client does not support authentication protocol requested by server; consider upgrading MySQL client' as documented at: http://www.sonsothunder.com/devres/revo ... ata004.htm (from Janschenkel).

It is supposed that a RR application will run in both platforms transparently , I would expect differences in filenames and paths (OS dependencies).

My fantasy all the time has been that someone will jump and write: the problem is that the trial version does not support database connections... but this is my imagination, and yes; I would have to think in acquiring a Win license if want to develop in Windows too.

Anyway I appreciate your time and ideas on this subject.

Regards,

Benito Estrada