Re: ODBC driver compile error

2018-03-01 Thread bagsiur
Thanks Igor, I will be grateful. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: ODBC driver compile error

2018-03-01 Thread bagsiur
So, cammand line: "apt-cache policy openssl" show: openssl: Installed: 1.0.1t-1+deb8u7 Candidate: 1.0.1t-1+deb8u7 Version table: *** 1.0.1t-1+deb8u7 0 500 http://http.us.debian.org/debian/ jessie/main amd64 Packages 500 http://security.debian.org/ jessie/updates/main amd64 P

Re: ODBC driver compile error

2018-03-01 Thread bagsiur
ok, here are whole console logs: make[3]: Entering directory '/root/ignite/modules/platforms/cpp/odbc' [0/1251] CXX src/ssl/secure_socket_client.lo In file included from ./include/ignite/odbc/ssl/ssl_

Re: ODBC driver compile error

2018-03-01 Thread bagsiur
I have libssl-dev in newest version. Before compile I install gcc g++ make automake libtool m4 libssl-dev unixodbc unixodbc-dev So I have all dependencies from DEVNOTES.txt : * GCC, g++, autotools, automake, and libtool must be installed * Java Development Kit (JDK) must be installed: https://j

ODBC driver compile error

2018-03-01 Thread bagsiur
Hello, I try to compile odbc but I have fallowing errors: So I make fallowing commands: 1. cd ./modules/platforms/cpp 2. libtoolize && aclocal && autoheader && automake --add-missing && autoreconf 3. ./configure 4. make Errors are: error: 'ignite::odbc::ssl::OPENSSL_init_ssl' declared as an '

Re: Apache Ignite & unixODBC and truncating text

2018-02-28 Thread bagsiur
Yes, Here is my libignite-odvc.so. Command "ldd /usr/local/lib/libignite-odbc.so" show: linux-vdso.so.1 (0x7fff18aad000) libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x7f96a60f7000) libignite-binary-2.5.0.26265.so.0 => not found libodbcinst.so.2 => /usr/

Re: Apache Ignite & unixODBC and truncating text

2018-02-28 Thread bagsiur
I'm try to execute fallowing code: setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = 'CREATE TABLE IF NOT EXISTS test_md5 (id int PRIMARY KEY, userkey LONGVARCHAR, server LONGVARCHAR, tsession LONGVARCHAR, tpost LONGVARCHAR, tget LONGVARCHAR, adddate i

Re: Apache Ignite & unixODBC and truncating text

2018-02-28 Thread bagsiur
Hello, So, I was testing today fix of this bug and well... I have similar error. Different is that before I had truncated string and now I have NULL when I try to add more longer string. My Ignite version is: Ignite ver. 2.5.0-SNAPSHOT#20180228-sha1:6641267df826e74213c9921e1d0c3490f09aae45 When

Re: Apache Ignite & unixODBC and truncating text

2018-01-15 Thread bagsiur
ok, I ask becouse I wont to be sure. Fix will be included in Ignite 2.4 or 2.5? On the ticket: https://issues.apache.org/jira/browse/IGNITE-7362 in details is write that fix this bug is planning for 2.5 version... -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Apache Ignite & unixODBC and truncating text

2018-01-10 Thread bagsiur
Ok, thank you very much for your time nad reply. So, if I understend corectly, this is bug of Apache Ignite. How much time will take to resolve and fix this problem? I will track progress :) -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

RE: Apache Ignite & unixODBC and truncating text

2018-01-09 Thread bagsiur
Yes, and maybe will difficult to find solution on this error: https://bugzilla.xamarin.com/show_bug.cgi?id=37368 If will be nessesery I can try to prepare VS 2017 and compile it one more time... So, here is my simple script: setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

Re: Apache Ignite & unixODBC and truncating text

2018-01-08 Thread bagsiur
So, I use Apache Ignite in 2.3.0 version. Im not C# programmer but I compile attached C# example by mono: mcs -out:odbcvarchar.exe -r:System.dll -r:System.Data.dll odbcvarchar.cs And after when I run it I have fallowing errors: [ERROR] FATAL UNHANDLED EXCEPTION: System.EntryPointNotFoundExcepti

Re: Apache Ignite & unixODBC and truncating text

2018-01-07 Thread bagsiur
Hello, I refresh this post -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Apache Ignite & unixODBC and truncating text

2018-01-05 Thread bagsiur
Hello I try to create table with TEXT type. TEXT data type is not supported by ODBC driver but I can use types like: VARCHAR or LONGVARCHAR. Problem is that every time my text is truncating to 64 characters. Why? Haw Can I configure Apache Ignite / unixODBC to work with normal TEXT type? I tested

Re: Problem with creating table and insert data

2017-12-27 Thread bagsiur
Thank you very much. This is the answer. So, I understend that in ODBC best equivalent of TEXT type is LONGVARCHAR? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Problem with creating table and insert data

2017-12-27 Thread bagsiur
Hi, I have problem with creating table and insert example data. I use PHP, ODBC and Apache Ignite. I create simple script to do it: // create table: $sql = 'CREATE TABLE test_md5 (id int PRIMARY KEY, userkey varchar(255), server text, tsession text, tpost text, tget text, adddate int)'; $ignite-

Re: Is it possible to import existing mysql database from file in console?

2017-12-21 Thread bagsiur
Ok, thanks for reply. It's helpful. I have another question: What about backup? I storage my database in memory, what happened if Apache Ignite is stopping? Do I lose my data? Haw Can I do backup and if is nessesery load it to the cluster? Does apache ignite provide tools for do this, or I must wr

Is it possible to import existing mysql database from file in console?

2017-12-19 Thread bagsiur
Hi, My question is: Is it possible to import existing mysql database from file in console? In mysql I do: mysql -u myuser -p mydatabase < verybigdatabase.sql Is it posible to do something similar in apache ignite? How Can I import existind database to Ignite? -- Sent from: http://apache-ignit

Re: PHP and Apache Ignite - very slow query

2017-12-13 Thread bagsiur
Ok, thank you for reply. Now I understand where is mistake. See you soon :) -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: PHP and Apache Ignite - very slow query

2017-12-12 Thread bagsiur
ok, I will try to build cluster on 3 machines and I will prepare tests one more time. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: PHP and Apache Ignite - very slow query

2017-12-12 Thread bagsiur
Thanks for reply. What do you mean with "warmed up" the JVM prior testing? How can I do this? Do you mean to prepare JAVA application with some SQL queries like my PHP scripts from first post, and run it in JVM to check query time? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: PHP and Apache Ignite - very slow query

2017-12-12 Thread bagsiur
Maybe Im not explain everythinnk correctly. I run mysql queries by PHP of course So, one more time: I prepare the same database, first db in MySQL and second in Apache Ignite. Database have the same size and number of rows (~6 milion rows). I prepare the same PHP script (as in my first post) use

Re: PHP and Apache Ignite - very slow query

2017-12-12 Thread bagsiur
Hi and thank you for your answer. Im not test mysql with odbc driver and at this moment my goal is to find more faster solution like mysql. I know that mysql is working on native mysql driver and ODBC is a third-party driver but this is recommended solution in official Apache Ignite documentation:

PHP and Apache Ignite - very slow query

2017-12-12 Thread bagsiur
Firstly, sorry for my English. I start to use Apache Ignite with PHP (PDO, UnixODBC, Ignite ODBC driver). I successfully installed it and configured Ignite, DSN and ODBC on my linux server (Debian). I installed php-odbc extension and everything looks well. I start Apache Ignite by: ./bin/ignite.s