magento2 – Connect the database to MSSQL

I want to connect Magento 2.3.5 to MSSQL database to export records about new orders like (product ID – Quantity sold – price – customer information)
So what are my options?

Before I post this question I found many solutions, but I don’t know if it’s will work or no?
Microsoft Flow
Blend.co
PDO connector

2013 – Store and connect to Outlook PST files in SharePoint

I’m in a large organization and the organization is moving away from local shared folders. In the past, users were able to create Outlook PST files and store them on network folders (shared drives). Users would then connect and use their files PST files within Outlook by providing the network path to the file. Since users do no have an incredibly large amount of space on the exchange server they would make use of PST files to store and archive mail. With shared folders (shared drives) becoming a thing of the past we are left to look for other alternative means of storing and archiving mail.

Enter SharePoint.

It has been decided that we will be keeping our on-prem SharePoint 2013 Server. We do have the capability to increase the size of our SQL Server to handle the influx of emails and files that did reside on the shared folders but are now expected to reside within SharePoint. We will obviously need a more specific SharePoint governance plan, but there’s a technical hurdle: Outlook cannot connect to PST files when it believes those files reside on an internet space.

Our on-prem SharePoint server is our intranet. I created a mapped drive to a location on our intranet had been attempting to direct Outlook to connect to the PST file at that location (Explorer view –> Map network drive to the location) but when I attempted to connected to the PST file I received this message: “You cannot use an Internet address here. Enter a path that points to a location on your computer or on the network.” The location is mapped to F: on my local machine.

So I have some questions…

Is it possible (via 3rd party software or administration magic) to place a PST file within a SharePoint document library and to open that PST file within Outlook from that location?

We don’t currently implement MySites, but will likely have to implement them in the future. Would a better solution be for users to store their mail into a document library within their MySites?

Or, is SharePoint just the wrong tool for the job and we should plead to have our network folders returned?

Any input would be helpful. If this is not making sense and if you have any questions, please ask. I’m at the planning stage right now and I’m looking for ideas.

Thanks in advance for your help.

-Matt

networking – Can’t connect to SSH on private IP through VPN gateway

Morning, everyone,

I’ve been having a strange problem for a few hours. I was SSH connected on my Azure virtual machine and my SSH connection suddenly froze (without disconnecting). I closed my shell and restarted my SSH session without success. I checked the NSGs with neighboring machines I connect well to, the NSGs are almost identical. I tried to reboot the machine, redeploy the machine, reset the SSH configuration, reset the user account, without success too. I can easily connect to other machines on the same subnet. I can connect on public IP. I feel like there’s a problem between the VPN gateway and the private IP… Any ideas?

Thank you

Note : I have the following entry in the health status :

Unavailable
At samedi 4 juillet 2020 à 3:15:32 PM UTC+4, the Azure monitoring system received the following information regarding your Virtual machine:
Your virtual machine is unavailable. We’re working to automatically recover your virtual machine and to determine the source of the problem. No additional action is required from you at this time.
Recommended Steps
Check back here for status updates
Redeploy this virtual machine to a different host server

website – I am trying to connect to a phpmyadmin database on mac but I am getting an error message

So, I have the following php script (with the php reference tags which I had to omit as I think this conflicts with the editor on here):

mysqli_connect('localhost', 'login', '(Intentionally omitted the password');

if (mysqli_connect_error()) {
    echo "There was an error connecting to the database";

} else {
    echo "Database connection successful!";

}

And the error I am getting is the following:

Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘login’@’localhost’ (using password: YES) in /Applications/XAMPP/xamppfiles/htdocs/login_and_registration/page1.php on line 2
There was an error connecting to the database

Admittedly, I am not sure whether I am using the details for the database connection.

I have accessed phpmyadmin from xampp and I don’t believe there is a password per se and the connection according to phpymadmin is localhost but, in any case, regardless of what details I put into the php, the connection does not work.

Does anyone know why this might be or what I might need to do to resolve the issue?

Thank you in advance.

yum – Client machine unable to connect to the local ftp repository server. Writes an error: Failed to synchronize cache for repo ‘***’, ignoring this repo

Please help me to understand where I was wrong, because I’ve read a lot of articles also I’ve seen lot’s of Youtube videos, but all the time in the end I’ve got the same error result.

So, on my Server machine (192.168.25.146) I’ve install from the rpms: ftp, vsftpd, createrepo and dnf-utils packages. Then, I’ve moved inside OS iso directory (/run/media/dmitriy/RHEL-8-0-0-BaseOS-x86_64/) and copied all it’s content to the /var/ftp/pub directory.

Next, I’ve moved to the vsftpd config file and changed next:

anonymous_enable=YES

anon_upload_enable=YES

chown_uploads=YES

chown_username=daemon

After that,I’ve addede port 21/tcp and service to the firewalld:

public (active)
target: default
icmp-block-inversion: no
interfaces: ens160
sources: 
services: cockpit dhcpv6-client ftp ssh
ports: 21/tcp 22/tcp
protocols: 
masquerade: no
forward-ports: 
source-ports: 
icmp-blocks: 
rich rules:

Then, I’ve configured my local repo file (/etc/yum.repos.d/server.repo):

(server)
name=server
baseurl=ftp://192.168.25.146/pub
enabled=1
gpgcheck=0

Then, I’ve enabled booleans:

getsebool -a | grep ftp
ftpd_full_access --> on

After that I,ve performed createrepo /var/ftp/pub

Finally, I’ve restarted vsftpd and the command yum repolist displayed me that everything on server machine nice:

(root@control ~)# yum repolist 
Updating Subscription Management repositories.
Last metadata expiration check: 0:27:12 ago on Sat 04 Jul 2020 12:15:21 AM EEST.
repo id                                             repo name                                                                 status
server                                              server                                                                 6,328
ansible-2.8-for-rhel-8-x86_64-rpms                  Red Hat Ansible Engine 2.8 for RHEL 8 x86_64 (RPMs)                           13
rhel-8-for-x86_64-appstream-rpms                    Red Hat Enterprise Linux 8 for x86_64 - AppStream (RPMs)                  10,766
rhel-8-for-x86_64-baseos-rpms                       Red Hat Enterprise Linux 8 for x86_64 - BaseOS ( RPMs)                      4,834

Also, see the ftp connection to the localhost:

(root@control ~)# ftp localhost
Trying ::1...
Connected to localhost (::1).
220 (vsFTPd 3.0.3)
Name (localhost:root): anonymous
331 Please specify the password.
Password:
230 Login successful.
Remote system type is UNIX.
Using binary mode to transfer files.
ftp> ls
229 Entering Extended Passive Mode (|||17555|)
150 Here comes the directory listing.
drwxr-xr-x    3 0        0          380928 Jul 03 19:33 pub
226 Directory send OK.
ftp> 

Now, I went to my Client machine
I configured my repo file in ** /etc/yum.repos.d/client.repo

(root@ansible1 ~)# cat /etc/yum.repos.d/client.repo 
(client)
name = client
baseurl = ftp://192.168.24.146/pub
gpgcheck = 0
enabled = 1

I’ve enabled booleans, made the same changes in /etc/vsftpd/vsftpd.conf, installed ftp, vsftpd, but when I logged to the ftp I do not see my packages.

I also don’t do all these things on client machine, but just configured repo file, but result the same, when I perform yum repolist I’ve got:

(root@ansible1 ansible)# yum repolist
Updating Subscription Management repositories.
Unable to read consumer identity
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
client                                   0.0  B/s |   0  B     00:21    
Failed to synchronize cache for repo 'client', ignoring this repo.

Please help me to understand where I was wrong!!!

untagged – Germany: Is it legal to connect a gas oven to a gas tank manually?

I have arrived recently in Germany and I want to get a gas oven.

I was wondering if it’s possible to buy the oven, the gas tank, and manually connect them on my own, is this possible legally? Or should I use a professional service?

networking – Windows 10 won’t connect to WiFi after changing subnet

After changing a Ubiquiti Aircube router’s subnet, (router IP, DHCP range etc), windows 10 simply refuses to connect to the WiFi. Phones and tablets are just fine.

I’ve tried ipconfig /renew, restarted everything, and no joy. Surely something to do with routing tables but I’m a bit out of my depth here so would appreciate any help.

When trying to connect, after entering the password, windows 10 says “checking network requirements” then “unable to connect to this network”.

wi fi – How use certificate to connect to Wi-Fi

Background
I have Samsung Galaxy S20 with Android Version 10 installed. I have company provided Cisco Access Point at home. The access point is connected to my home wi-fi router.
In phone’s wi-fi settings i see two networks:
1>MyHome ( My home router wi-fi network)
2>MyCompany (Access point)

Initially when i setup this phone, i installed microsoft intune app and connected to my company’s portal. After connecting to company’s portal, system automatically downloaded certificates and connected to MyCompany Access Point successfully.

Issue
I accidentally click on Forget Network for MyCompany, and now i don’t know how to connect back to MyCompany network.
Under settings -> Biometrics and security -> Other Security Settings ->User Certificates i see the ceritificate(s) are there, but i don’t know how to use this to connect to MyCompany n/w

Bitcoin c-lightning node on Synology cannot connect to bitcoind

I’m trying to setup a bitcoin lightning node on my NAS (Synology), following this tutorial: https://bitcoindev.network/running-a-lightning-node-on-synology-nas/

Unfortunately I get the following error (log):

lightningd: WARNING: default network changing in 2020: please set network=testnet in config!
bcli: 
Could not connect to bitcoind using bitcoin-cli. Is bitcoind running?
    
Make sure you have bitcoind running and that bitcoin-cli is able to connect to bitcoind.

You can verify that your Bitcoin Core installation is ready for use by running:
    
        $ bitcoin-cli -testnet echo 'hello world'   

2020-06-30T19:45:20.256Z INFO plugin-bcli: Killing plugin: Plugin exited before completing handshake.
The Bitcoin backend died.
lightningd: WARNING: default network changing in 2020: please set network=testnet in config!

My lightning.conf contains the following:

alias=myalias
network=bitcoin
bitcoin-rpcuser=myusername
bitcoin-rpcpassword=mypassword
bitcoin-rpcconnect=127.0.0.1
bitcoin-rpcport=18332
log-level=io

I’ve tried several parameters for bitcoin-rpcconnect (internal ip, external ip of my bitcoin node including the right ports).

Since my bitcoin node is running on mainnet I try to setup the lightning node for mainnet as well.

So does anyone knows what I’m doing wrong?

java – OAuth 2.0/OpenID Connect: Get notification when user deleted from Identity provider

Does OAuth2 and/or OpenID Connect have a feature to notify the client (e.g my app) about user deletions? If so is it part of the standard, or just some providers have it, some don’t?

Let’s have an example:

  1. User registers in my app with his Github account (or any oauth2 id. Provider)
  2. Starts working, do changes and saves stuff
  3. Decides to delete his account from github.

Does oauth2 have a mechanism for this scenario to somehow let my application know that ‘hey, this user deleted himself, clean up after him’?

Another example could be this site. I registered with my Github account. How would StackOverflow know it needs to delete my comments once my github account is long gone?

Thank you in advance!