U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » Developing U++ » Releasing U++ » Not compile example reference/SQL_MySql in ROSA Linux R6

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Not compile example reference/SQL_MySql in ROSA Linux R6 [message #45936]

Thu, 28 January 2016 15:35

Navadvipa Chandra das is currently offline

Navadvipa Chandra das
Messages: 34
Registered: January 2016
Location: DPR, Donetsk region, Chay...

Member

Hello, All!

I needed access to the database MySql. But even the standard example (reference/SQL_MySql) of the box of Ultimate++ is not working.

/home/navadvipa/upp/uppsrc/MySql/MySql.h:16:25: fatal error: mysql/mysql.h: No such file or directory
#include <mysql/mysql.h>
compilation terminated.

In the file MySql/MySql.h has the following lines

#ifdef PLATFORM_POSIX
#include <mysql/mysql.h>
#endif

But even if you correct the file name to the correct case-sensitive

#ifdef PLATFORM_POSIX
#include <MySql/MySql.h>
#endif

it is still not working. It gives other errors. Can somebody help to rectify the situation?

The version of Ultimate++ 9435 (64 bit) (Gtk)

The other examples work well. But all examples I is not checked.

Thank you!

With best regards Navadvipa Chandra das.

Report message to a moderator

Re: Not compile example reference/SQL_MySql in ROSA Linux R6 [message #45939 is a reply to message #45936]

Thu, 28 January 2016 20:14

dolik.rce
Messages: 1791
Registered: August 2008
Location: Czech Republic

Ultimate Contributor

Hello Navadvipa Chandra das,

Welcome to the forum Cool

The code was actually correct when it was lowercase. It does not refer to the header in MySql U++ package, but to the header for libmysql, usually located in /usr/include/mysql/mysql.h. To get this to your system, you'll need to install libmysqlclient-devel via your distributions package manager.

Let us know if that doesn't solve the problem.

Best regards,
Honza

Report message to a moderator

Re: Not compile example reference/SQL_MySql in ROSA Linux R6 [message #45943 is a reply to message #45939]

Fri, 29 January 2016 22:06

Navadvipa Chandra das
Messages: 34
Registered: January 2016
Location: DPR, Donetsk region, Chay...

Member

Hello Jan and all also!

Thank you very much! After installing the package lib64mysqlclient-devel example (reference/SQL_MySql) works well. Here is an example (reference/SQL_PostgreSql) doesn't compile for similar reasons.

In file included from /home/navadvipa/upp/uppsrc/PostgreSQL/PostgreSQL.cpp:1:0:
/home/navadvipa/upp/uppsrc/PostgreSQL/PostgreSQL.h:10:33: fatal error: postgresql/libpq-fe.h: No such file or directory
#include <postgresql/libpq-fe.h>

I installed the packages:
$ sudo urpmi postgresql postgresql-plpgsql postgresql-server postgresql-contrib postgresql-devel postgresql-docs

Please help with PostgreSQL database.

With best regards Navadvipa Chandra das.

Report message to a moderator

Re: Not compile example reference/SQL_MySql in ROSA Linux R6 [message #45945 is a reply to message #45943]

Sat, 30 January 2016 08:33

dolik.rce
Messages: 1791
Registered: August 2008
Location: Czech Republic

Ultimate Contributor

Hello,

Navadvipa Chandra das wrote on Fri, 29 January 2016 22:06

In file included from /home/navadvipa/upp/uppsrc/PostgreSQL/PostgreSQL.cpp:1:0:
/home/navadvipa/upp/uppsrc/PostgreSQL/PostgreSQL.h:10:33: fatal error: postgresql/libpq-fe.h: No such file or directory
#include <postgresql/libpq-fe.h>

I installed the packages:
$ sudo urpmi postgresql postgresql-plpgsql postgresql-server postgresql-contrib postgresql-devel postgresql-docs

This looks like a bug. The file is actually located in /usr/include/libpq-fe.h. Quick file search would tell you that Wink

So the postgresql/ shouldn't be there, the only systems where this works are those based on Debian, where the path is for some reason different. For a quick fix, just remove the "postgresql/" from the include.

Best regards,
Honza

Report message to a moderator

Re: Not compile example reference/SQL_MySql in ROSA Linux R6 [message #45948 is a reply to message #45945]

Sat, 30 January 2016 13:03

Navadvipa Chandra das
Messages: 34
Registered: January 2016
Location: DPR, Donetsk region, Chay...

Member

Hello, Jan and all!

Indeed the file was already in my system and in my fright I began to panic and thought I need one more set. The path like this - /usr/include/libpq-fe.h .

Per Your suggestion, removed the "postgresql/" from the include and example work!
Now I need to configure the Postgresql server itself Razz

, but that's another story.

Another question.

ArrayCtrl - table not for SQL
SqlArray - table for SQL
GridCtrl - tables and for SQL and for not SQL data

ArrayCtrl and SqlArray suitable to display external data ( AddRowNumColumn ). But GridCtrl, I understand, to display the external data is not suitable. Right? Why are there so many tables? GridCtrl just looks prettier than ArrayCtrl and SqlArray? Or there is some covert reason?

With best reason Navadvipa Chandra das.

Report message to a moderator

Previous Topic:	U++ Package availability for LinuxMint
Next Topic:	Theide problem on lubuntu 16.04 dolik ppa

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 26 18:13:00 CEST 2025

Total time taken to generate the page: 0.03267 seconds