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…

Sean B. Durkin
- 12,659
- 1
- 36
- 65
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…

Ctrl_halt
- 43
- 4
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…

flicker0ne
- 19
- 1
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…

Alun ap Rhisiart
- 21
- 2
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…

Eric K Yung
- 1,754
- 11
- 10
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…

user3853774
- 11
- 4