We have custom application that connects to an Oracle database. We need a tool that is capable of running on the client machine (Windows 10/11) and is able to capture all SQL sent to the database, and show how long it takes to get response. In the Windows 7 environment, we were able to use Quest Software SQL Monitor (Freeware). However, this tool does not work on Windows 10/11. Main problem, is there a tool capable of capturing the application side SQL request and show if it is slow to receive a response?

I'm seeing the following errors repeatedly in the error log file for our production MySQL server: > [Warning] Access denied for user 'root'@'remote.appserver.com' (using > password: NO) So, I know where the connection attempt is coming from, but I don't know how to track down the application trying to connect. Is there any way to determine the application, program, client initiating the request?

On Db2 v11.5.7.0 I would like to enable CLI trace and perform some tests. From official IBM documentation, CLI tracing can be done in two ways: a) dynamic b) with db2clini **A. DYNAMIC** 1. According to CLI documentation I did: db2trc on -cli -f dumpFile It returned: "Trace is turned on". I see file "dumpFile" is created with 465456 bytes. 2. Now I am reproducing the problem. But dumpFile does not increases in size at all. It looks like nothing is traced. 3. Turing off trace: db2trc off Output: "Trace is turned off". 4. Format from binary to readable file: db2trc fmt -cli dumpFile clitrcfile.txt and output is: Trace truncated : NO Trace wrapped : NO Total number of trace records : 0 Nothing has been captured. **B: WITH DB2CLI.INI** Now to db2cli.ini documentation: db2 UPDATE CLI CFG FOR SECTION COMMON USING Trace 1 db2 UPDATE CLI CFG FOR SECTION COMMON USING TracePathName C:\trace db2 UPDATE CLI CFG FOR SECTION COMMON USING TraceComm 1 db2 UPDATE CLI CFG FOR SECTION COMMON USING TraceFlush 1 db2 UPDATE CLI CFG FOR SECTION COMMON USING TraceTimeStamp 3 Now reproduce the problem and turn off tracing. db2 UPDATE CLI CFG FOR SECTION COMMON USING Trace 0 Nothing has been captured. **UPDATE:** What is my problem? I have establish SSL between Db2 client and Db2 server using CLI. I can confirm with Wireshark network sniffing tool that SSL is really working. Now I would like to add hostname validation for CLI applications. From my database alias test1 I have added hostname validation: db2 "UPDATE CLI CONFIGURATION FOR SECTION test1 USING SSLClientHostnameValidation Basic" Now when I test the connection: db2 connect to test1 user using connection works true, but it shouldn't, because at Db2 client I have cataloged "localhost" to point to my virtual machine Db2 server, but in SSL certificate's Subject Alternative Name is my FQDM. If host validation if performed then connection should fail. Now to the part of "reproducing problem". In the same window that "db2trc" or "db2 update cli" commands are executed I have executed "db2 connect to test1 user myuser using pass" and no CLI traces were produced.

I'm searching for a way how to instruct mysql client to reconnect in case of ERROR 2013. I'm testing PXC with ProxySQL and want to keep sql statements flowing from the client in case when the writer node get killed and new one is promoted. Is it possible for mysql client to reconnect when server goes down during the query? Can mysql client rerun the sql query (insert, update, ...)? With Sysbench it is possible if setting the --mysql-ignore-errors=all parameter. (from Comment) I'll be calling that SP from a custom lua script, where I'll test the 'error 2013' condition and in that case I'll rerun that query. Does this make sense, or the value of @err set by the error handler can't be passed to the script, because the session will just die, when the mysqld will get killed? DELIMITER // CREATE PROCEDURE sbtest.InsertIntoTable ( IN trnid INT, IN unixtime INT, OUT err INT) BEGIN DECLARE CONTINUE HANDLER FOR 2013 SET @err = 1; INSERT INTO sbtest.failover_test ( node, trn_id, unix_time ) VALUES (@@hostname, trnid, unixtime); END// my table: failover_test | CREATE TABLE failover_test ( id int NOT NULL AUTO_INCREMENT, node varchar(255) DEFAULT NULL, trn_id int DEFAULT NULL, unix_time int DEFAULT NULL, created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=116837 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci | -- CALL sbtest.InsertIntoTable(1, 1599207191, @err);SELECT @err

On Db2 v11.5.7 on Linux/x86_64 I have a UTF-8 database. Executing db2 get db cfg for test1 returns: Database code page = 1208 Database code set = UTF-8 On my Windows 10 computer in Putty I have set: *Window | Translation | Remote character set* to UTF-8. I can properly see non-English characters in Putty. I have also installed DBeaver tool and I can also properly see non-English characters. The problem I have is "db2cmd" tool. In Putty remote connection I created tables and inserted one character: db2 "connect to test1 user db2inst1 using db2inst1" db2 "create table admin.test8 (id int not null generated always as identity, a varchar(20))" db2 "insert into admin.test8 (a) values ('č')" db2 "select id, a, hex(a) as hex_a from admin.test8 order by id" Output of select statement is (which is correct): If I do the same in DBeaver: insert into admin.test8 (a) values ('č'); select id, a, hex(a) as hex_a from admin.test8 order by id; I get: Both Putty and DBeaver correctly inserts character in database. Now saving the commands into UTF-8 encoding: From db2cmd I check for the code page: chcp and output is: Active code page: 1252 Execute commands: db2 -tf a.sql Output in column A is completely wrong. In ID=3 also HEX_A is completely wrong. I tried several things like: 1. Changing: chcp 65001 2. db2set DB2CODEPAGE=1208 But in both cases I see the same result as last command. If I try to connect with "-a" switch I get Db2 server code page is 1208 (utf-8) and Db2 client code page is 1252. Now to configure db2cmd to properly handle the UTF-8 code-page?

I have pgserver running postgres 17, OS untuntu 24. The collation version is 2.40. My client side is Rocky linux 8: hlsb_release -a LSB Version: :core-4.1-amd64:core-4.1-noarch Distributor ID: Rocky Description: Rocky Linux release 8.10 (Green Obsidian) Release: 8.10 Codename: GreenObsidian hepsql --version psql (PostgreSQL) 17.0 After I login to the server from my client machine (pgclient) I got warning. WARNING: database "aurum" has a collation version mismatch DETAIL: The database was created using collation version 2.40, but the operating system provides version 2.39. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE aurum REFRESH COLLATION VERSION, or build PostgreSQL with the right library version. psql (17.0) I don't want to rebuild my server to 2.39. To upgrade my collation to 2.40, should I recompile a new client program using the latest GCC library?

I have a script that creates a new dbeaver connection using the dbeaver command line utility (on osx), and I'm having a hard time creating it with a custom connection.type. I've tried a few different things: 1. Defining it in the connection string using multiple different keys/names: - ...|type=prod|... - ...|connectionType=prod|... - ...|connection.type=prod|... - ...|prop.type=prod|... - ...|prop.connectionType=prod|... - ...|prop.connectiontype=prod|... 2. Tried using a params.properties file: /Applications/DBeaver.app/Contents/MacOS/dbeaver -vars params.properties -connect "driver=mysql|..." with the contents:

connection.type=prod
connectionType=prod
type=prod
connectionType=prod
connection.type=prod

I also deleted the existing connection just to make sure this gets created (instead of modifying an existing connection). None of the above seemed to work. Does anyone know how to set the connection.type from the _dbeaver_ command?

I am using Sequel Ace (version 4.0.13 on Mac) to access a database. There used to be a list of all the tabels in the database in a component on the left side that is now missing. I cannot figure out how to make that list of tables appear. I've looked through the menu items but I can't find a way to bring this section back to the UI. Any ideas?

For many years I have used to use the environment variable $PGUSER when I work with client tools such as psql/pg_dump/pg_restore. Recently I build up a new PG13 server, the env var $PGUSER does **NOT** take effect, when I try to use the client tools on a terminal of the server. I get message like this: > leon@mamba:~$ echo $PGUSER > > postgres > > leon@mamba:~$ psql > > psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: > > FATAL: role "leon" does not exist If I use the tools on a terminal of another physical computer, the env var takes effect normally. Of course, the var has been set on both machines. My pg_hba.conf: > \# TYPE DATABASE USER ADDRESS METHOD > > host all all 127.0.0.1/32 trust > > host all all 192.168.x.x/16 md5 > > \# IPv6 local connections: > > host all all ::1/128 trust

Database client-server connectivity can sometimes happen. I mean: there is client side dll that sits on the client computer (device, it can be mobile phone as well). For the Windows OS based clients: - fbclient.dll, gds32.dll - Firebird - libpq.dll - Postgresql - oci.dll - Oracle (of course, these dll can have dependencies). And the usual scenarios are: the application (it may be fat client of the client-server application) loads DB client library (fbclient.dll, oci.dll, etc.) in its process space and calls dll commands. dll - in turn - establishes connection with the server process (e.g. Firebird server process that runs on 3050 port on the server machine, Postgresql server process that runs no 5432 port on the server machine, Oracle TNS Listener on 1521 port) and keeps this connection open for the duration of the db client-server session. E.g. user can authenticat and start connection and issue multiple SQL commands over this connection. I understand that today the client-server DB communication usually hapens in the wired environment exclusively. E.g. either DB server and Web/Application server sit on the same machine or either they are in the different machines that are connected by very fast and reliable wired network. It was differently in the early days of IT. That was the time when client-server architecture was quite common - client machines had fat clients of the application and they used database dlls on their machine and these dlls communicated with the DB services on the server machine. Such applications are still in use and maybe there are some other scenarios where client-server DB connectivity can happen even today. So - all that was background. **My question is - can database client-server connectivity be deployed over WiFi networks** *(or over networks which has WiFi link, e.g. employee laptop can connect to the WiFi Access Point then then this access point has wired connection the database server - this can be pretty common setting both in the work office and home office situations)* **or is it common DBA understanding that no client-server connectivity can involve WiFi link.** My collegues adheres to the quite strict rules that there can be no deployment of our solutions which involve client-server DB connectivity over WiFi. I have seen, that such deploymen is possible though. I can not believe that such constraint can really be in force? Are WiFi networs really so unreliable although they are quite popular?

I would like to find a MYSQL Client program which can be config as FULLY DARK THEME. Many of them can not be dark theme in displaying result in grid.

I use AWS RDS, and there is top application tab in perfomance insight like below sceenshot TablePlus is a SQL client that I used. If I run query using that app, it shows TablePlus in that tab. But if I run with my application that use golang or PHP programming language, it shows unknown. How does it works? Can I change that programmatically or using SQL query? I want to change it because I want to know if there is unknown application connect to my database server. But currently my own application detected as unknown.

A server I manage has Oracle Client 19.16 with Java JRE 1.8_331 installed. Can I just copy a newer version of the Java JRE, like 1.8_351 over the old one without having any negative effect on Oracle Client? I'm limited to only using the 19.16 patch, but an older version of Java is being flagged when the workstation is scanned.

I have a Postgresql sever which happens to be running on a NAS, on a Docker instance. It has worked flawlessly for years, but all of the sudden one of my client machines is having all sorts of strange errors when I query it. I know that: - The errors occur with multiple databases on the host, so not db specific. - The errors *don't* occur with other client machines, just my main workstation - A brand new Docker Postgres instance on the NAS continues to have problems, so it's not something with that docker instance - This one client gets errors when accessing the server from multiple applications (PGAdmin4, QGIS, etc.) I get different errors including: - Database error: insufficient data in "D" message - lost synchronization with server - ERROR: SSL error: decryption failed or bad record mac The only thing I've found talks about network issues, packet sniffing, etc., and it seems like it must be something else.. Is there a way to flush/reset/destroy the cache(?) of postgresql info on the client machine? Is there such a thing?

I want to configure SSL so that clients can only require certificate signed by root CA

.crt

, then every client must use their issued e.g. cert **postgresql.crt**, key **postgresql.key** and **password** to connect to database server. Hereby allowing the database server to verify each client certificate on authentication. Postgres v14 server configs: **postgresql.conf**

...
ssl = on
ssl_ca_file = ca.crt   # root CA or (root+intermediate CA bundle) that signed client cert.
#ssl_cert_file =
#ssl_key_file =
...

**pg_hba.conf**

...
hostssl  all  all  all  md5  clientcert=verify-ca
...

Starting database server failed with this error.

...
FATAL: could not load server certificate file "server.crt": No such file or directory
...

Why does it fail, I've no need for **server.crt** and **server.key** because server should be doing the client verification using

.crt

not the client? Reading postgres document doesn't help me. Thanks in advance.

I have an application to debug which performs a few dozen operations against a MySQL database. These operations are performed in a single transaction. I need to know the state of the database while debugging at a specific breakpoint. I can log into the MySQL service using the common mysql CLI tool. I see that a transaction in progress:

mysql> SELECT * FROM information_schema.innodb_trx\G
*************************** 1. row ***************************
                    trx_id: 325090
                 trx_state: RUNNING
               trx_started: 2022-09-14 12:10:32
     trx_requested_lock_id: NULL
          trx_wait_started: NULL
                trx_weight: 30
       trx_mysql_thread_id: 26
                 trx_query: NULL
       trx_operation_state: NULL
         trx_tables_in_use: 0
         trx_tables_locked: 10
          trx_lock_structs: 26
     trx_lock_memory_bytes: 1128
           trx_rows_locked: 43
         trx_rows_modified: 4
   trx_concurrency_tickets: 0
       trx_isolation_level: REPEATABLE READ
         trx_unique_checks: 1
    trx_foreign_key_checks: 1
trx_last_foreign_key_error: NULL
 trx_adaptive_hash_latched: 0
 trx_adaptive_hash_timeout: 0
          trx_is_read_only: 0
trx_autocommit_non_locking: 0
       trx_schedule_weight: NULL
1 row in set (0.01 sec)

## Now, how can I join that transaction to query the state of the database during the transaction? As a workaround, I could add a query to the application code. However that requires me to know which query I want to run before running the application, and then to recompile the app for each query I want to run. Having an open CLI to debug would be very helpful. The database is MySQL 8.0 running on Debian.

When working with pgAdmin 4 (and actually, several other programs that act as clients to the database), the connection to the server disconnects after some 10 or 15 minutes of inactivity. One coffee and one phone call, and you get a message similar to "Sorry, connection to database is lost. Do you want me to try to reconnect?" And pgAdmin reconnects always need more than one trial, and the object-tree that was already expanded gets collapsed... So, it's a little bit annoying. pgAdmin doesn't seem to have any parameter related to that behaviour. (There seems to be ways to change some connection timeouts , but they're related to how pgAdmin behaves with regard to the server taking too long to connect). What can be done it to avoid pgAdmin from disconnecting from the database? --- Disclosure: This is actually a "pseudo-question". It is *spin-off* of another one , that ended up not being related to loss of connectivity... Given the fact I already had one answer in place, I (not very humbly) think it is worth "asking", in case the answer is helpful to someone.

My Mac runs Mac OS X, version 10.7.5., so it's a 64 bit system. First, I downloaded mysql-5.5.28-osx10.6-x86_64.dmg. Then I double clicked mysql-5.5.28-osx10.6-x86_64.dmg, it's mounted, and shows 1. mysql-5.5.28-osx10.6-x86_64.pkg -> I double-clicked it to run, after clicked buttons a few times it's said to be successfully installed. However, I could not see anything in Applications. 2. MySqlStartupItem.pkg -> I double-clicked to run, also successfully done. However, I still could not see anything in Applications. 3. MySQL.prefPane -> I double-clicked it to run. Now I see a window jumped out, with a button Start/Stop MySQL Server, I clicked it, now it says "The MySQL Server Instance is *running*". I'm a bit lost here: Q1. Why until now there's nothing in the Applications? I can't see any item or folder like mysql there. Is it that every time I want to run mysql, I have to mount the installation package? Q2. What did MySQLStartupItem.pkg install? Q3. Are there any client side tools inside the installation package? I mean, for example, Microsoft SQL Server for Windows, there are Microsoft SQL Server; and there are Microsoft SQL Server Management Studio, which serves as a client tool to browse databases and doing queries; also, if I download "Microsoft SQL Server Express with Tools" package, it will install both. Does mysql-5.5.28-osx10.6-x86_64.dmg contain only the server, or also a client tool inside?

I'm trying to use letsencrypt to generate certs in order to encrypt communication between a remote client and my postgresql database server. I'm not sure how to get started on setting this up. What kind of certs do I need for the client? What cert files should I store on the server? I've gone through this documentation as reference but it's still unclear as to which certificates go where? Thanks in advance! Edit: Some clarification since this question was put on hold: I was unsure of what to expect when trying to use letsencrypt. I understand the basics of ssl/tls. But I needed some clarification about whether the certs generated on the server need corresponding certs on the client. The accepted answer has since pointed me in the right direction and the linked postgresql documentation has helped as well.

I used this command to backup my "supplies" table: COPY supplies (id, price, ...) FROM 'C:\Users\MyCompany\Desktop\database03-01-2022.sql'; But now, I would like to write three more tables' data into that file, and call the same COPY FROM command. 1. Is that possible? 2. How should the file be formatted? 3. Will the COPY FROM command need to change? Thank you for your time.