Problem connecting to mySQL

rahulmes · Post by **rahulmes** » Fri Apr 08, 2011 2:24 am

I am evaluating your product for use in my projects. I am very impressed with the features and functionality and am considering a purchase soon. However, while testing the demo, I am unable to create a data source with my mySQL local DB.

I have watched the video and connected to the DB successfully. During the connection process, the DB connects only if I tick 'Prompt User Name and Password'.

This is my conn string: Server=localhost;Port=33307;Database=intranet;User=gallery; Password=gall;Option=3;

After entering this, if I press Test Connection, I get a message saying 'Connection was successfull'

But, once I try to create the data source, it is not creating correctly. I enter the query but when I say retrieve columns, no columns are retrieved. I thought it was a problem with mySQL permissions and so granted all priveliges to the 'gallery' user. Still, I have the same problem.

I tested the software with the XML demo data, it is working fine. I have put the Quick Start folder in my Apache htdocs and I am running the software from there.

I am using Version 2011.1.1000 from 2011.04.06.

Please help. Thanks in advance.

chopper64 · Post by **chopper64** » Fri Apr 08, 2011 2:51 am

I think the more of a problem is the sql query ...
Ahead, have some of the query in another query tool (phpmyadmin). when she goes there, then they should also work in the report.

Also, remember that you have the schema name angibst ....

Code: Select all

select * from tablename

TableName expected in the current schema (in such intranet)

Code: Select all

select * from table localnet.tablename

expects table in the schema localnet.

If you are so working, remember that the user also needs the rights to the other database schema!

rahulmes · Post by **rahulmes** » Fri Apr 08, 2011 4:43 am

Thanks for the response. The query seems to be ok. The table being queried is from the default schema.

It is a simple query - Select * from products

I also tried 'Select * from intranet.products', but even that does not work.

Also, when I click Retrieve Columns, the software asks me for a user name and password. Once I enter this, the dialog box disappears and then nothing happens, no data is retrieved. The query is working fine from phpMyAdmin.

Any other thoughts? Thanks.

chopper64 · Post by **chopper64** » Fri Apr 08, 2011 4:51 am

1. Try it without the query log. maybe they will fail ...
2. Use Firebug to find out which communication between the designer / viewer (client side) and the Web server (PHPScript index.php) expires. There must be the fault
3. Check the php script which is responsible for communication with mysql (php database_mysql. ... or so) is included in the index.php ... Do I believe

rahulmes · Post by **rahulmes** » Fri Apr 08, 2011 8:10 am

Thanks for the response.

There is definitely some problem with the mySQL 'Test Connection' button on the New connection dialog. I have realised that even if we do not include the database parameter or mispell the DB name, the connection is successful. I also tried bypassing this dialog by changing the connection parameters in the database_mysql.php file. The problem still continues.

chopper64 · Post by **chopper64** » Sat Apr 09, 2011 3:16 am

Default Port of MySQL is: 3306
Why do you use 33307 ????

Check the Port in Startoption of the mysql server or Settings in mysql.ini.

Try Port = 3306

What is "Option=3" ????? I dont know this parameter.

For the correct Connectionstring syntax See also: http://www.connectionstrings.com/mysql

rahulmes · Post by **rahulmes** » Sun Apr 10, 2011 7:06 pm

The connection string is correct. The option parameter is usually specified during connections using an mySQL 3.51/5.1 ODBC connector connection. It is not strictly necessary here.

Also, 33307 is the port that I am running mySQL on. I have tried with default 3306 port too. Why do you think the connection is successful even if no DB is specified?

Thanks.

Post by **Vladimir** » Mon Apr 11, 2011 1:56 am

Hello,

Please tell us which version do you use? In the first version of release 2011.1 there was an error in the retrieve columns function. If you are using version 2011.1, please download it from our website again. In the current version the error with retrieving columns is fixed.

Thank you.

rahulmes · Post by **rahulmes** » Mon Apr 11, 2011 7:29 am

Thanks for the response.

I have downloaded the latest version today and tried again. No luck, same problem. The 'Retreiving columns' progress bar appears after clicking 'Retreive Columns', but nothing happens after that.

The information from the About screen is:

Version: 2011.1.1000 from 2011.04.07.
Flash Player: 10.1.85 for Windows

I have also tried with port 3306, same problem. I have given the user all mySQL priviliges.

Regards.

tony.tomov · Post by **tony.tomov** » Tue Apr 12, 2011 6:04 am

Hello,

Maybe you will need to check your SQL query.
The easiest way is to open phpMyAdmin and copy/paste the query in PhPAdmin.
Run it - maybe there is the error.
I use the latest version and everything seems to be fine.

Cheers

Tony