Is there a way to check connection properties of an active SQL Server connection?

The context:

I have a Java application that’s using HikariCP for its connection pooling solution. While lightning-fast, HikariCP doesn’t have a lot of configuration options, by design, and that’s all fine and dandy except I need to set a connection property, and while a DataSource like Tomcat’s gives me the ability to do something like:

tomcatDataSource.setConnectionProperties("someProperty=true"); 

Hikari’s DataSource object doesn’t have such a method.

My options, as far as I’ve been able to tell are to either create a DataSource object manually and pass it to Hikari to wrap it in it’s own class, or to include the connection property as part of the connection URL.

(Just to make sure we’re on the same page, I’m talking about the “sendStringParametersAsUnicode” flag as described in this document: Setting the connection properties – SQL Server)

The question (also known as “so far this question seems to belong in StackOverflow but hopefully you kept reading”):

Is there a way, on the database side, to see the connection properties of an active connection? In SSMS or some other tool? I tried SSMS’s activity monitor on the target database, and right clicking on anything that seemed right-clickable, but nothing mentioned the properties of the open connections. Is this even possible?

I’d like to see the properties so I can double-check if my two options described above for setting this flag actually work.

Install Realtek RTL8111/RTl8168 driver without internet connection

So I’ve been following this guide: https://unixblogger.com/how-to-get-your-realtek-rtl8111rtl8168-working-updated-guide/ and a couple of others (this one has helped the most). I just can’t get the driver installed. When I try to run the autorun.sh file from I first got an error saying that make wasn’t a command. I fixed this by following this right here: How do I install build-essential without an Internet connection? This helped, but then when I went to run the install file again, I got an error saying gcc wasn’t a command. So then I used that same tutorial but replaced the build-essential linux-headers-$ (uname -r) with gcc. When I try to install that I get this an error because I’m pretty sure it’s trying to download more things within the install of gcc. So I went and downloaded and installed everything on the list The following additional packages will be installed: but it still didn’t work. I’m lost, if anyone could offer help please do so. Thanks! I’ll be answering any questions as soon as I can to try and get this resolved.

FATAL: pg_hba.conf rejects connection for host … SSL OFF

Before this issue happen, it work perfectly fine for months.

I am had try the configuration below at DO droplet:

1) Change pg_hba.conf

host all all 0.0.0.0/0 trust 

2) I issue the restart commond

service postgresql restart 

3) I still receive the error in

tail -f /var/log/postgresql/postgresql-10-main.log 

Spec:

  • PG: Postgresql 10
  • OS: Ubuntu 18.04.1 LTS
  • My postgresql.conf configuration file as follow:

    listen_addresses = ‘*’

How to deliberately slow internet connection to better understand UX on slower connections?

I would like to better understand UX on slower connections.

Is there a set of tools or instructions on how to achieve this on mac/windows?

FYI my software isn’t a website or app, it’s desktop software that runs on mac and windows.

Perhaps there are tools available to help? (I don’t mind a DIY solution though)

Wired connection keeps on dropping

I know there are some similar questions over here but none of them actually works. I am experiencing a lot of problems in connecting to the internet through a wired connection on Ubuntu. The connection gets lost in middle of work and does not work thereafter. earlier restarting the network service worked for a bit but now nothing of it works. Please need help badly. If you need some more info please let me know in comments section I will update the question. Right now I am not sure what all info to include.

No internet connection after configuring ad-hoc interface

Using Ubuntu 19.04 I am trying to connect to an ad-hoc network with my Wi-Fi card (wlo1) and use ethernet (eno2) for access to the internet. The ethernet internet connection works fine on it’s own. In order to connect to the Ad-Hoc network my /etc/network/interfaces file is as follows:

# interfaces(5) file used by ifup(8) and ifdown(8) auto lo iface lo inet loopback  auto wlo1 iface wlo1 inet static     wireless-mode ad-hoc     wireless-channel 1     wireless-essid AdhocSSID     address 192.168.1.2     netmask 255.255.255.0 

Now with the interfaces file like this I can access the Ad-Hoc network correctly, but I can no longer access the internet with ethernet. This is the output of ifconfig for the interfaces file above, which suggests to me that the ethernet connection still works somewhat:

eno2: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500         inet 192.168.1.129  netmask 255.255.255.0  broadcast 192.168.1.255         inet6 fe80::9035:712a:baa8:687f  prefixlen 64  scopeid 0x20<link>         ether b4:2e:99:39:dc:57  txqueuelen 1000  (Ethernet)         RX packets 30  bytes 7760 (7.7 KB)         RX errors 0  dropped 0  overruns 0  frame 0         TX packets 51  bytes 6147 (6.1 KB)         TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0         device interrupt 16  memory 0x55300000-55320000  lo: flags=73<UP,LOOPBACK,RUNNING>  mtu 65536         inet 127.0.0.1  netmask 255.0.0.0         inet6 ::1  prefixlen 128  scopeid 0x10<host>         loop  txqueuelen 1000  (Local Loopback)         RX packets 174  bytes 14210 (14.2 KB)         RX errors 0  dropped 0  overruns 0  frame 0         TX packets 174  bytes 14210 (14.2 KB)         TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0  wlo1: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500         inet 192.168.1.2  netmask 255.255.255.0  broadcast 192.168.1.255         inet6 fe80::aa6d:aaff:fefd:661e  prefixlen 64  scopeid 0x20<link>         ether a8:6d:aa:fd:66:1e  txqueuelen 1000  (Ethernet)         RX packets 8  bytes 336 (336.0 B)         RX errors 0  dropped 0  overruns 0  frame 0         TX packets 53  bytes 6469 (6.4 KB)         TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0 

Any suggestions?

Trigger to insert new row into second table causes “Connection is busy with results for another command”

I have created this trigger to insert new row into table @AL_ORDR_TRACKER after new row is inserted in table ORDR.

CREATE TRIGGER dbo.trgAfterInsertORDR ON dbo.ORDR AFTER INSERT AS BEGIN INSERT INTO dbo."@AL_ORDR_TRACKER"         (U_DocEntry, U_Updated)     SELECT         DocEntry as U_DocEntry, GETDATE() U_Updated         FROM inserted END 

The trigger gets registered but when inserting new rows into ORDR I get the error message:

Connection is busy with results fro another commands

What might be going wrong here?

Slow Samba connection

I’ve installed Ubuntu 19.04 on my laptop alongside Windows 10.

I’m happy using Ubuntu and would like to leave Windows behind, but the only thing that is keeping it on my system is that I can transfer files about 5x quicker using Windows!?

I upload video files from my phone to my laptop and then transfer them via Samba (on Wi-Fi) to a Raspberry Pi3B running Libreelec.

When I use Windows my upload speed is around 10Mb/sec Using Ubuntu it’s only around 2Mb/sec

What am I doing wrong? I’m assuming it’s a setting somewhere.

Any help would be really appreciated. Many thanks in advance.

Disk less ubuntu client not getting internet connection

I followed the ubuntu diskless boot as per documentation and I am able to boot the client with nfs.But it is not connected to internet.getting ip using ifconfig,but no network connection shows.I searched google but all documentation refered upto disk less booting ,no information about the problems faced by the client afterwards