Questions tagged [mariadb-connector-c]

34 questions
3
votes
0 answers

How to install Python mariadb module in an Amazon Linux environment

My goal is to build an AWS Lambda Layer to supply the mariadb module for AWS Lambdas running python 3.8. Following these instructions to do so, I need to install the mariadb module on an instance compatible with the AWS Lambda platform. Installing…
3
votes
3 answers

MariaDB C connector without mysql_config

I am moving from mysql to MariaDB. With mysql I was linking the C connector to my application with mysql_config --libs, and according to what I can read on internet it should still be possible with MariaDB, but on my system mysql_config does not…
beddu
  • 71
  • 9
2
votes
2 answers

Error trying to install mariadb package using pip3

I am trying to install mariadb usin pip3 on a python 3.8 environment on a Ubuntu 2004 server. I did download the mariadb-connector-c (version 3.31) and copied the files to their destinations. I also installed python2-dev and its dependencies on the…
apnow
  • 33
  • 3
2
votes
1 answer

C program cannot get result value from MySQL procedure

I am practicing with getting a value back from a MySQL stored procedure So I first created the following procedure USE testdb; DROP PROCEDURE IF EXISTS `testdb`.`get_return_value_test`; DELIMITER $$ CREATE PROCEDURE IF NOT EXISTS…
2
votes
1 answer

How to properly install MariaDB Connector/C and mariadb python package on NVIDIA Jetson?

I'm failing to get MariaDB Connecter/C and the mariadb python package properly installed and cooperating on an NVIDIA Jetson AGX Xavier. Apparently the .so files ends up in a location where the python package cannot find it. How can I correct this?…
mattroos
  • 125
  • 1
  • 11
2
votes
1 answer

SELECT prepared statement fails with error 1295 in MariaDB

I'm trying to run the following query via MariaDB Connector/C using a prepared statement: SELECT * FROM customers WHERE ApiKey=? However, mysql_stmt_execute() returns error code 1295: This command is not supported in the prepared statement…
Serge Rogatch
  • 13,865
  • 7
  • 86
  • 158
2
votes
1 answer

error trying to build mariadb connector-c on linux mint. How to fix?

I am trying to build mariadb++ (mariadb connector/c) on a new installation of linux mint. My process looks like this: $ git clone https://github.com/MariaDB/mariadb-connector-c.git $ mkdir build && cd build $ cmake ../mariadb-connector-c/…
Riley Hughes
  • 1,344
  • 2
  • 12
  • 22
1
vote
1 answer

MariaDB connector for NodeJs | How to insert value if not exists

I'm trying to run a batch query from a pool. the query itself is simple but I'm having trouble with the NodeJS Connector the query with the '?' placeholders is INSERT INTO region (region_code, country_code, continent_code) SELECT * FROM (SELECT ?,…
ALGDB
  • 650
  • 1
  • 6
  • 22
1
vote
1 answer

How to use mariadb python connector in Docker?

I want to use the Python mariadb connector in a python container. Yet, until now, I've met only troubles and now I segfault when trying to pass arguments to my SQL queries. here are my dockerfile and a script that highlight the problem. FROM…
IMAGE-ET
  • 13
  • 3
1
vote
0 answers

Why java's mariadb connector connects to mariadb faster than connectors in other languages?

I'm learning rust, and recently I'm trying to use the Sqlx library to connect to the database. Whether I use a pool or not, the connection speed is always at least 2s; however, when I use the Java Connector (mariadb-java-client package provided by…
1
vote
1 answer

RMariaDB on Databricks

I'm trying to get R (either via a notebook or RStudio) to connect to MariaDB on Databricks Azure 10.1. However, whether I add RMariaDB in the Libraries tab of the cluster or via install.packages("RMariaDB") in RStudio I get a failure…
1
vote
1 answer

MariaDb-failover is running high on CPU and chatty even when there is no traffic

We have an API written in scala 2.12.x and Play framework 2.5.x. The API connects to AWS aurora cluster using MariaDb connector/J 2.5.4 as such jdbc:mysql:aurora://some-aurora-cluster Functionally everything works fine except we've noticed high CPU…
1
vote
0 answers

Mariadb nodejs connecor placeholder for table name

I have tables 'ranking' and 'rankingprev' and I would like to show them on same webpage. (a) code without placeholder working pool.query("select ROW_NUMBER() OVER (order by MName) as Rownum, MName, Tbp,Tgp,Tpp from members inner join ranking on…
Andy Chung
  • 21
  • 1
1
vote
0 answers

'mysql_warning_count' incorrectly returns 0 warnings after upgrade from MySQL 5.6 to MariaDB 10.3

I am using "MySQL Connector for C v6.1.11" to connect to a MySQL 5.6.35 server. When I use mysql_real_query() to run a query like SELECT MAKETIME(-1000,57,33), mysql_warning_count() correctly returns 1 warning (SHOW WARNINGS will say "Truncated…
Xaxx
  • 127
  • 11
1
vote
0 answers

Why 'Lost connection to MySQL server during query' errors occur time-to-time (timeouts raised, pinging before query)

I'm creating an experiment, in which the server side is a libuv based C/C++ application that runs queries on a mysql server (it's on localhost). In most cases it just works, but sometimes I get 'Lost connection to MySQL server during query' in…
1
2 3