sql server – Migrate MySQL to MSSQL with views

I have a MySQL database and I want to migrate it with data to MSSQL. I have tried a few tools, including the import and export wizard of MS SQL server, DataLoader, the ESF database migration toolbox, mysqldump with – compatible = mssql.

All of these tools work, but it migrates views in tabular form.

Do you have experience with the tool which can also migrate views?

linux – Rust Nickel Server does not work during deployment

I created a simple backend server using the Rust "Nickel" framework by following the guide here: https://nickel-org.github.io/getting-started.html

i can run cargo run locally and has reached the local endpoint http://127.0.0.1:6767 via factor to get this answer:

{
    message: "Hello! Sincerely, Jimbob's Rusty Nickel"
}

It’s great, and I’d like to deploy it live. I am using a micro aws ec2 instance with ubuntu 18.04 LTS. After installing the load and running the application with cargo run I get the usual successful start-up output "waiting for requests":

Listening on http://127.0.0.1:6767
Ctrl-C to shutdown server

I have my server ports open with these settings:

incoming:

80  tcp 0.0.0.0/0, ::/0      
22  tcp 0.0.0.0/0        
3000    tcp 0.0.0.0/0    
443 tcp 0.0.0.0/0, ::/0      
0-65535 tcp 0.0.0.0/0       
6767    tcp 0.0.0.0/0       

outbound:

All All  0.0.0.0/0       
6767    tcp 0.0.0.0/0   

When I try to call the live endpoint using ec2 public DNS (IPv4) with port 6767 or public IPv4 with port 6767, i get this error response:

Could not get any response
There was an error connecting to http://3.83.65.51:6767.
Why this might have happened:
The server couldn't send a response:
Ensure that the backend is working properly
Self-signed SSL certificates are being blocked:
Fix this by turning off 'SSL certificate verification' in Settings > General
Proxy configured incorrectly
Ensure that proxy is configured correctly in Settings > Proxy
Request timeout:
Change request timeout in Settings > General

networking – How do I connect my home network to my OpenVPN server? (No port forwarding)

Let me precede this by saying that my knowledge of networking is bare to say the minimum, but I have successfully set up routing tables and troubleshoot OpenVPN servers before, so I believe that what I want to achieve is not far from my capabilities.

Here is my scenario:

I have a gigabit connection at home, which is fantastic, and I want to use it to host stuff. However, my provider (Vodafone Kabel) gave me a cable modem which does not support port forwarding. It allows me to see local IPv6 addresses from the Internet if the firewall is disabled, but it reactivates the firewall automatically after 24h (meh). I don't know if my IP is static, but I don't think so. I can work around this with a dynamic DNS configuration.

I also have a dedicated VPS with an OpenVPN server and a static IP. I currently use it mainly when I need to connect to untrusted networks. It is currently just a tun server that I use to tunnel all client traffic to its own local network and then access the internet from there.

My current layout:

                 Home                  +          Cloud Provider
                                       |
        +--------------------+         |      +---------------------+
        |                    |         |      |                     |
        |    Cable Modem     |         |      |    VPS - OpenVPN    |
        | (home.example.com) |         |      | (cloud.example.com) |
        |                    |         |      |                     |
        +--+-------------+---+         |      +---+-------------+---+
           ^             ^             |          ^             ^
           |             |             |          |             |
           v             v             |          v             v
+----------+-----+    +--+--------+    |     +----+---+    +----+----+
|                |    |           |    |     |        |    |         |
|  Raspberry Pi  |    |    NAS    |    |     | iPhone |    | MacBook |
| OpenVPN Server |    | NextCloud |    |     |        |    |         |
|                |    |           |    |     +--------+    +---------+
+----------------+    +-----------+    |
                                       |
                                       +

Here is what I want to achieve:

My cable modem is the least configurable of the devices on this list. So I would like to use it as a DHCP server for the whole network. Since the RaspberryPi on my home network is not accessible from the Internet, I want it to connect to my VPS and expose the home network to the VPS. That way, when devices like my iPhone connect to the VPS, they talk directly to my home modem to get an IP address.

If I do the right configuration, the OpenVPN VPS server (cloud.example.com) will simply forward all traffic to the RaspberryPi OpenVPN server and relay the traffic. So should I use a dev tap configuration for this? But on which server, the VPS? Or the RaspberryPi? Which OpenVPN servers get which client / server configuration files?

In other words, is this a "standard" model that I could look for somewhere? I don't think this is an unorthodox configuration, but I don't know what to look for to find a better explanation on how to configure it.

Thank you for your help!

SQL server – separate string or table

I am creating the database for a system and it is an alert system, where, when a certain action occurs or when certain information is present, an alert (via email) is triggered. I allow users to customize their own alerts so that they can receive alerts when they want, not when, as a product engineer, I think they should receive them. I also allow account administrators to create alerts on behalf of other users, that is, the boss can create alerts to send to employees who are responsible for managing the # 39; alert.

So there are three different ways for a user to sign up for an alert: 1) all employees 2) all administrators 3) manually decide which users get it.

I decided that having an is_all_users and is_admin column as booleans is the right approach to handle these scenarios, but the question is, when it comes to "manually deciding users", is it okay to be a string of user IDs that are then scanned (I don't expect there to be more than 5 recipients in this scenario), or should I make it a separate table ?

The two diagrams are:

alerts

  • client_id (int)
  • alert_id (int)
  • etc.
  • recipients (channel)
  • addressees_is_admin (boolean)
  • recipients_is_all (boolean)

OR

alerts

  • client_id (int)
  • alert_id (int)
  • etc.

alerts_recipients

  • alert_id (int)
  • user_id (int)
  • addressees_is_admin (boolean)
  • recipients_is_all (boolean)

In Scenario 1, there could be a speed and / or analysis problem, but Scenario 2 simply seems cumbersome and unnecessary. Of course, in the second scenario, I could also put recipients_is_admin and recipients_is_all in the first table, but I would then treat two different tables for one purpose, which just seems wrong.

SFS partition on Linux – Server error

When I clone some Windows hard drives with Linux, I get strange messages.
Cloning in itself is correct.

The drives involved are Microsoft Dynamic disks.
Normal disk partitions do not cause this problem.

On the console, I repeated errors:

(  208.816951)  sda: (LDM) sda1 sda2
(  349.478387) ldm_parse_tocblock(): Cannot find TOCBLOCK, database may be corrupt.
(  349.478472) ldm_parse_tocblock(): Cannot find TOCBLOCK, database may be corrupt.

These errors only appear when accessing partition information (fdisk, partprobe, etc.).

In the example below, it is a 1 TB drive with a 120 GB partition and a 350 GB partition.

With fdisk I get this:

Disk /dev/sda: 931.5 GiB, 1000204886016 bytes, 1953525168 sectors
Disk model: ST1000LM035-1RK1
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 4096 bytes
I/O size (minimum/optimal): 4096 bytes / 4096 bytes
Disklabel type: dos
Disk identifier: 0x44df379a

Device     Boot     Start        End    Sectors   Size Id Type
/dev/sda1              63       2047       1985 992.5K 42 SFS
/dev/sda2  *         2048  251674289  251672242   120G 42 SFS
/dev/sda3       251674290 1953523119 1701848830 811.5G 42 SFS

Partition 1 does not start on physical sector boundary.
Partition 3 does not start on physical sector boundary.

When I display partitions with fdisk or cfdisk, I always get a small SFS partition before the others.
When i use cat /proc/partitions I randomly receive one of these:

# cat /proc/partitions 
major minor  #blocks  name

   8        0  976762584 sda
   8        1  125836121 sda1
   8        2  359474336 sda2

# cat /proc/partitions 
major minor  #blocks  name
   8        0  976762584 sda
   8        1        992 sda1
   8        2  125836121 sda2
   8        3  850924415 sda3

The first output reflects the 2 real partitions.
The second output shows that the last partition is far too large.

Can anyone explain with I get the errors on the console and why the displayed partition structure is not stable when the disks are not written?

Need a Dedi server in Miami 3Gbps without measurement

Hello,

We have servers at OVH and we need servers in Miami that will connect to our CA OVH servers.

Search for a Dedi server in Miami with a 3Gbps network without measurement.
Hardware: 1 CPU, 32 GB, 2×1 TB SSD.
No management needed, using Debian 10.x

Budget ~ 800 USD

Starting with 1 server and if it works well, we will have more.

Thank you.

python 3.x – Trying to connect to the server with the client

I am creating a chat client with a graphical interface. I have a working server and I now want to connect to this server but failing that. Here is the function that tries to connect when you press the connection button:

def tryToConnect():
# we need to modify the following global variables
global g_bConnected
global g_sock

g_sock = socket.socket(family=socket.AF_INET, type=socket.SOCK_STREAM)


if g_sock != None:
    g_sock.settimeout(0.1)
    print("inside g_sock if")

    try:
        print("inside try block")
        ipPort = g_app.ipPort.get()
        print(ipPort)
        g_sock.connect(ipPort)
        g_bConnected = True
        printToMessages("Successfully connected!")
        g_app.connectButton('text') = 'disconnect'

    except:
        printToMessages("Unable to connect!")

By default, g_sock is set to None and g_bConnected to False. At the moment, I cannot connect?

{Global HostITSmart} Fast and reliable dedicated server at low cost | Support 24 * 7 – Advertising, offers

Global HostITSmart is the best dedicated low cost hosting that provides you with all types of web hosting solutions. We assure you that your website is fast, secure and always up and running so you can focus on your work. We offer everything you need to build, host and manage your website with 24 * 7 technical support. There are no hidden fees. Select the best web hosting service in the world for your website.

Dedicated server locations:

India

WE

Here is the list of quality hosting plans-

Start-up plan: @ only $ 46 / month (Dual Processor 8 Core)

Intel Xeon L5420 (2.50 GHz)

8 GB RAM

500 GB SATA hard drive

33 TB bandwidth on the 1 Gbit / s port

2.50 GHz Quad-Core

12 MB L2 cache

1 IP address IPV4 addresses

Support for the latest Linux and Windows versions

Performance plan: @ only $ 66 / month (dual 12 (24) core processor)

Intel Xeon X5650 (2.66 GHz)

8 GB RAM

1 TB SATA hard drive

33 TB bandwidth on the 1 Gbit / s port

Quad-Core @ 2.66 GHz

12 MB smart cache

1 IP address IPV4 addresses

Support for the latest Linux and Windows versions

Business plan: @ only $ 86 / month (Dual Processor 8 (16) core)

Intel Xeon L5630 (2.13 GHz)

24 GB RAM

500 GB SATA hard drive

33 TB bandwidth on the 1 Gbit / s port

Quad-Core @ 2.13 GHz

12 MB of smart cache

IPV4 1IP addresses

Support for the latest Linux and Windows versions

For more details on dedicated server plans, visit our website:

Our support team is always ready to support you in any situation and at any time, which helps you to solve any problem as quickly as possible. We also provide instant chat service to easily connect you at any time.

For immediate assistance or for more information, contact us: info@hostitsmart.com or visit our website for live chat.

. (tagsToTranslate) dedicated offer (t) cheap dedicated host (t)

Windows Server 2012 R2 – PowerShell exception – PS: unable to find a process with the name "C: UserPath". Check the process name and call the cmdlet again

Please note that I have omitted the actual user path, indicated by *

What am I trying to achieve?

My desired result is a PowerShell script which allows me to generate a WSUS report of the necessary Windows updates containing my selected variables:

PS C: UserPath * ### Provide configuration data ###

$ TargetGroup = "Computers not assigned"

$ WSUSServer = "name of my WSUS server" *

$ Severity = "Critical", "Security"

$ Product = Office 2003, Office 2007, Office 2010, Office 2013, Office 2016, Office 2019, Office 365 Client, Windows 7, Windows Internet Explorer 7 Dynamic Installer, Windows Internet Explorer 8 Dynamic Installer, Windows Server 2003, Datacenter Edition, Windows Server 2003, Windows Server 2008 R2, Windows Installer 2008 Server Manager Dynamic Installer, Windows Server 2008, Windows Server 2012 R2 and later, Windows Server 2012 R2, Windows Server 2012 R2, Windows Server 2012, Windows Server 2016 and later, Windows Server 2016, Windows Server Drivers, Windows Server Manager – Windows Server Update Services (WSUS) Dynamic Installer

Error 1

Currently, this shows me this as an error:

PS: unable to find a process with the name "C: UserPath *>". Check the
name of the process and call the cmdlet again.
In C: WSUSReport_Critical_Security_Defined_Products.ps1: 1 char: 1
+ PS C: UserPath *> ### Provide configuration data ###
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~

  • CategoryInfo: ObjectNotFound: (C: UserPath *: String)
    (Get-Process), ProcessCommandException
    • FullyQualifiedErrorId: NoProcessFoundForGivenName, Microsoft.PowerShell.
      Commands.GetProcessCommand

NGINX real_ip_header ignore IPv6 – Server error

We have Nginx behind AWS cloudfront.
To use the real Ip user via the $ remote_addr parameter, we implemented the suggestion in this article:
https://blog.jayway.com/2014/03/28/how-to-get-the-client-ip-when-using-cloudfront-and-nginx/

This works well, but we have found that when the request comes from IPv6, the $ remote_addr parameter uses cloudfront IP instead of the client's IP address.

For example,
request with this header:
X-Forwarded-For: 1.1.1.1, 64.252.171.151 (random cloudfront IP)
Define $ remote_addr with 1.1.1.
But even request with this header
X-Forwarded-For: 1111: 2222: 3333: aaaa: bbb: ccc: eeee: 6666, 64.252.171.151 (random cloudfront IP)
Will set $ remote_addr to 64.252.171.151.

Did I miss something?