Questions tagged [plugins]
The plugins tag has no usage guidance.
22 questions
1
vote
0
answers
142
views
Does MariaDB support server-side query rewriting?
MySQL has something called "The Rewriter Query Rewrite Plugin". I've tried to find info about anything similar in MariaDB but so far found nothing. Is there any way in MariaDB to examine and ...
1
vote
1
answer
864
views
MySQL Plugin "mysql_old_password" not loaded
In an attempt to fix another issue I had, I ran the commands below (as per https://dev.mysql.com/doc/refman/5.6/en/old-client.html)
mysql> UPDATE mysql.user SET plugin = 'mysql_old_password'
mysql&...
0
votes
1
answer
43
views
Passively load a monitoring shared object into an Oracle process
I'm trying to load my own code, which should add some security features to my environment, into each oracle BEQ dedicated process.
The reason I'm posting this on this platform, is that I hope there is ...
- 118
1
vote
1
answer
93
views
Is there some plugin that would reconnect query tabs to original DB's in SSMS?
It's a minor thing, but annoying one.
I'm currently working on about 5 different databases, and every time I restore db's from snapshots or run my restore from backup scripts, all of the queries get ...
- 195
0
votes
1
answer
81
views
With Postgresql v10 and WAL2JSON... Is it possible to include the database name / datname in the json?
We have a set of databases that were not set up in a multi-tenant fashion. Looking to build a hub that will hold the data in a multi-tenant fashion using wal2json to pipe data from source to the hub. ...
- 15
1
vote
1
answer
4k
views
Unable to change root user unix_socket to mysql_native_password
Server version: 10.1.41-MariaDB-0+deb9u1 Debian 9.9
I have installed a LAMP stack on my Debian 9 machine and can not log in with the root user. From my searching, it seems that it's because the ...
- 25
1
vote
1
answer
169
views
How to use mysql_plugin utility?
I tried to follow this official documentation to install unix_socket plugin using mysql_plugin utility but getting an error that
Cannot read plugin config file unix_socket. Bad format in plugin
...
- 125
1
vote
2
answers
5k
views
Ubuntu cannot open shared library mysqlx.so
MySQL Server version:
Ubuntu: 5.7.23-0ubuntu0.18.04.1-log (Ubuntu)
MySQL installed using apt-get.
When installing a plugin with the following command:
mysql> INSTALL PLUGIN mysqlx SONAME '...
- 41
34
votes
1
answer
209k
views
What is mysql_native_password?
I was trying to set password for root. When I run:
mysql> SELECT * from mysql.user where User="root";
It shows:
+-----------+------+-------------+-------------+-------------+-------------+-------...
- 443
2
votes
1
answer
278
views
SQL Management Studio - Add-on / Extension to view Column Data Type
Is there any way (built in) or free/paid add-on/Extension for SQL Management Studio that allows us to know exactly a data type of a column when we are writing a query?
In this specific project I have ...
- 211
1
vote
1
answer
722
views
MySQL - Duplicate Entry when trying to install a Plugin
I'm trying to install a Plugin on my MySQL database, but each time I try I get a Duplicate Entry error:
INSTALL PLUGIN audit_log SONAME 'audit_log.so';
Error Code: 1062. Duplicate entry 'audit_log' ...
- 2,166
3
votes
1
answer
19k
views
MariaDB: Disable the GSSAPI plugin
How can i disable the GSSAPI plugin? I do not need authentication via Kerberos on my server.
This is my environment:
Centos 7.3 with SELinux mode enforcing
MariaDB Server: 10.1.19
In my log file /...
- 133
3
votes
1
answer
2k
views
MySQL can't import a custom library for udf
I am working on Linux Mint 17 Qiana with MySQL Ver 14.14 Distrib 5.5.53, for debian-linux-gnu (x86_64).
Following the instructions found here:
http://dev.mysql.com/doc/refman/5.7/en/adding-udf.html
...
- 71
2
votes
1
answer
27k
views
MySQL reads Date columns in Excel as DateTime?
I'm trying to export Excel sheets to MySQL as new table using the plugin.
The export fails on "MySQL error 1064" when I tried to change the data type to Date.
I have a few columns in Excel that are ...
- 141
1
vote
0
answers
219
views
Add Shapefile loader plugin to PgAdminPortable
I'm using PgAdminPortable and I'd like to enable « PostGIS Shapefile and DBF loader » plugin. The issue is that the files are not structured as in a PostgreSQL complete install (see below).
I have ...
- 317
1
vote
1
answer
2k
views
SQL Server 2016 Plugin's not working [closed]
Recently I installed SQL Server 2016 on my PC.
Here is the detailed information of my server :
Microsoft SQL Server 2016 (RC1) - 13.0.1200.242 (X64)
Mar 10 2016 16:49:45
Copyright (c) ...
- 1,399
1
vote
1
answer
1k
views
Cannot connect to local db
I am in a Supply Chain Masters program and need to install the Excel Data Mining add-in for Excel. I downloaded and installed Microsoft® SQL Server® 2012 SP1 Data Mining Add-ins for Microsoft® Office®....
- 11
1
vote
1
answer
2k
views
Question on Oracle OEM version and plugin version upgrade
I have a OEM 12c (12.1.0.4) running in my setup in which I have registered over 70-80 databases. I see the plugin updates with versions of each target (Oracle database, MS-SQL, MySQL) and I have the ...
- 1,926
1
vote
1
answer
1k
views
MySQL 5.1: Upgrade innodb plugin
My application is running on MySQL 5.1.58 community edition. As I studied on SO websites that After acquisition by Oracle, new InnoDB plugin has been released and MySQL 5.1 with InnoDB plugin is the ...
- 2,061
1
vote
1
answer
1k
views
mariadb 5.5.36 with innodb plugin
I installed mariadb 5.5.36 on a win32 system. Everything runs fine except innodb requests are 2 x slower than an identical MySQL installation. So I want to switch back to original innodb plugin to ...
- 11
3
votes
2
answers
3k
views
PostgreSQL How do I convert struct text to plain *char in C functions?
I'm using my internal C function which doesn't know about postgresql's text struct, how do I pass text argument when char * expected?
#include <stdio.h>
#include <string.h>
#include "...
- 41
3
votes
1
answer
1k
views
Can underscore be forced as a word splitter without a full-text parser plugin?
Is there any way in MySQL to force underscore to become a word splitter character (like space or dash) without having to use a fulltext parser plugin?
If not, does such a plugin already exist or do I ...
- 271