Site transfer from local server to remote hosting – e-mail, OS and CPanel

Regarding an e-mail… It’s set in BIND9 zone file residing on my local computer. I want to use exactly the same address, but from a remote server. Right now I use Postfix-Dovecot on my local Ubuntu machine. Maybe it’s just easier to rename a zone file or something… And them to set up same e-mail account on hosting? As per SSL, I use Truecrypt locally… I think it also works on hosting. Though it’s something I’ll have to look into, ‘cos I have no clue. Hosting support probably will tell. With db it’s an easy part. They have Hepsie CP on VPS coming pre-installed. Though, of course I would prefer CPanel, but they charge extra for it. The weird part though… I requested Ubuntu OS on VPS hosting, and it says that it’s Ubuntu in hosting info page. BUT… When I open SSH terminal from within my hosting account page… And check this:

cat /etc/os-release 

I see this:

NAME="CentOS Linux" 

VERSION="7 (Core)" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="7" PRETTY_NAME="CentOS Linux 7 (Core)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:7" HOME_URL="https://www.centos.org/" BUG_REPORT_URL="https://bugs.centos.org/"

Does it mean, it’s actually CentOS and NOT Ubuntu? And if so… may I and can I install Cpanel myself on hosting then?

Which Remote Desktop Technology Should I Use if I want to have a website :)

What Is RDP?

Distant Desktop Protocol (RDP) is a convention created by Microsoft which allows clients distantly to assume realistic responsibility for another PC.

What Is VNC?

Virtual Network Computing (VNC) is a work area sharing framework that uses a convention named RFB. It allows individuals distantly to control a PC while the fundamental client can watch and connect too.

1-The Way They Work(How is VNC Different from RDP)

As we referenced, VNC is a…

Which Remote Desktop Technology Should I Use if I want to have a website :)

Connect two remote oracle databases as a schemas on each other

This Question is about Oracle Database.

I have two remote databases DB_1 and DB_2, and I have two schemas on each database: Schema DB_1 and Schema DB_2 on database DB_1, and Schema DB_1 and Schema DB_2 on database DB_2. I want to reach database DB_2 Schema DB_2 from database DB_1 Schema DB_1. For example: when I try this query in DB_1 from schema DB_1:

SELECT * FROM DB_2.example_table

I got an error because there is not table "example_table" in DB_2 Schema on the DB_1 database. But, when I try the same query on DB_2 Schema DB_2, I got the correct result (some data).

So, I need to tune my databases in some way so I can SELECT * FROM DB_2.example_TABLE from DB_1 Database.

But, there is another problem, I don’t have permission to CREATE LINK. However, when I query SELECT * FROM ALL_LINKS; on my production database DB_1 schema DB_1 – there are no links at all. So, I need to figure out which way my production Databases was linked (unfortunately my colleagues don’t know either). On my production database DB_1 schema DB_1 I can fetch data with the query:

SELECT * FROM DB_2.example_table

And the data I got is the same if I try to query the same on DB_2 production database DB_2 schema.

But there are no public\private Links on DB1/DB2 production databases at all. Is there another way to create a "connect" between my databases? (I queried SELECT * FROM ALL_LINKS from DB_1 schema DB_1, is this possible so I can fetch some other data if I try the query on DB_1 schema DB_2?)

Thanks in anticipation!

Timeout connecting to PostgreSQL from remote address

I’m going nuts here.

We had a production server running PostgreSQL 9.6; it took a dump on Thursday, we thought we had it up and running, but discovered an issue this morning with a materialized view. Any attempt to drop, alter, index or analyze the view locked up without throwing an error.

First step was to reinstall 9.6. On doing so, we were able to restore the data with no errors, and everything looked fine from the local machine.

However, we were not able to connect to the database from any remote IP address on the server’s network.

The system sits on a private network, and I connect to it through VPN. Two production web servers connect to it via the private network.

We’re running Windows Server 2016, and have tried the following to absolutely no effect:

  • Edited postgresql.conf ‘listen_addresses’ to ‘*’, ‘0.0.0.0’, ”, and a comma deliminted list of these.

  • Changed the port in postgresql.conf

  • Edited pg_hba.conf file to: ‘0.0.0.0/0’, ‘X.Y.Z.0/24’, ‘samenet’

  • Deleted and recreated the Windows firewall policy

  • Loosened up the incoming IP address restrictions in Windows firewall until there were no IP restrictions.

  • Turned off Windows firewall.

  • Deleted PostgreSQL 9.6, scrubbed every reference to it from the registry, except for benign entries like ‘recent items’, deleted every file from the HD.

  • Installed PGSQL 13

Same issue.

Tried these additional steps in 13, again, with no effect.

  • Changed the port in postgresql.conf

  • Changed the ‘listen_addresses’ in posgresql.conf to variations used above.

  • Used ‘all’ in ADDRESS field of the PGSQL 13 pg_hba.conf file as well as the other options (0.0.0.0/0, X.Y.0.0/16)

As far as I know, I’ve tried all the obvious fixes: pg_hba.conf, postgresql.conf, Windows firewall, with absolutely no change.

Short of torching the whole d*mn thing and starting over, I don’t know what else to try.

Problem with connect mysql databases of remote

I’m getting error with connect remote mysql database. Firstly;

1-) I use windows 10 machine and my remote server also windows 10 machine.

2-) My database at locale at remote windows machine with root.

I tried so many things but enter image description here and

ı took error picture enter image description here

Also I CREATE USER user but again ı have a problem. How can ı fixed and connect remote database

Please help me?

Changes to server configuration option remote access are not supported in SQL Database Managed Instances

Having just set up our new SQL Server Managed Instance, restored a sample database for testing, and run Azure’s vulnerability assessment, it produces this high risk finding:

VA2120 – Features that may affect security should be disabled

The more SQL Server features and services you enable, the larger its surface attack area becomes, making your system more vulnerable to potential attacks. These fetures should be disabled unless it is absolutely needed in this environment.

Remediation Script:

EXECUTE sp_configure 'show advanced options', 1; RECONFIGURE WITH OVERRIDE; EXECUTE sp_configure 'remote access', 0; RECONFIGURE; EXECUTE sp_configure 'show advanced options', 0; RECONFIGURE; 

Turning to Google before doing anything, I found this Microsoft Docs article stating that (emphasis mine):

This topic is about the "Remote Access" feature. This configuration option is an obscure SQL Server to SQL Server communication feature that is deprecated, and you probably shouldn’t be using it.

Can anyone therefore please provide some clarity on the following?

  1. Why is it enabled given Microsoft’s description?
  2. Does it need to be enabled in Azure SQLMI? Because…
  3. When I run the remediation script I get this error:

Changes to server configuration option remote access are not supported in SQL Database Managed Instances.

PayDo: Remote European IBAN opening for high-risk business

Hi guys!

We all know that forex trading has a reputation for being a high-risk business. Since many forex business owners provide their services without a license it casts a shadow over the entire industry.

It is difficult for this type of business to obtain a license due to the constantly tightening regulation by supervisory authorities.

But we at PayDo have a solution.

What do we offer?

  • PayDo offers opening a merchant account for forex and crypto…

PayDo: Remote European IBAN opening for high-risk business

How do I accommodate a blind player at my remote table?

For remote play at our table, we use a camera stuck on a microphone-boom-arm that we can rotate by 360°. We found out that we prefer it to have our rest position at about 45°, instead of top-down because the top-down angle creates nausea for some of our players, and it simulates sitting at a table. We use a 19 by 19 go-board with numbered and lettered tiles to make calls based on a grid for combat encounters and other visualisation when appropriate. For indicating features, we use a mix of miniatures that were part of the 2002 D&D boardgame by Hasbro and cardboard printouts that create terrain objects by sliding them together at a 90° angle with little plastic sockets, so they don’t topple over.

I designed our base set-up for remote play to feign an in-person feeling by visualisation.

I will have a remote guest player for three sessions who is blind, and I’m looking for preparations and ways to accommodate them and make our set-up as accessible as reasonable. What can I do to optimise the experience for them in particular, and so in turn for all of us?

How to make a remote server be invisible to a user

I have a webserver www.example.com that takes user input and calculates results on a remote server: <form action="www2.example.com/action.cgi">

Now the user is on the second server. How do I keep the user on the main server (or make www2 invisible to the user)?

One possibility is to do an Ajax query in the background, but that would mean results are transferred from www2 to www and then to the user, which adds delay and bandwidth costs.

What are some possibilities to accomplish this?

Also, if, in future, we have multiple remote servers www2, www3, etc. what would be the best way to accomplish this?

Query to polybase external table giving error “Access to the remote server is denied because no login-mapping exists.”

we have successfully created all pre-requisite of creating external tables using SQL Server 2017 Standard Edition CU22 Polybase.

The issue we have is the non-sysadmin login can’t query those external tables .It shows below error.

Msg 7416, Level 16, State 2, Line 29 Access to the remote server is denied because no login-mapping exists.

The sysadmin login can query external tables without any issue. Is there anybody saw this issue and can help to resolve it.