virsh domifaddr shows nothing. Trying to setup IP address on guest similar to host

I am trying to get my guest machine to have an IP similar to its host machine. The address on the host is 10.75.1.239, the address on the guest I want to be: 10.75.1.187.

I can set up the guest to have the ip I want by editing the

/etc/sysconfig/network-scripts/ifcfg-eth0   BOOTPRO=none NAME=eth0 DEVICE=eth0 ONBOOT=yes IPADDR=10.75.1.187 GATEWAY=10.75.0.1 

The host machine’s /etc/sysconfig/network setup is as such:

NETWORKING=yes HOSTNAME=test-vm-server1 NTPSERVERARGS=iburst GATEWAY=10.75.0.1 

If i use virt-manager to pop onto the guest machine and do an ip a it shows the ip ass being what I set it to.

But if I am on the host machine of that guest, then doing an `ssh root@10.75.1.187′ comes back with:

ssh: connect to host 10.75.1.187 port 22: No route to host

I double checked that ssh is indeed running. Not sure what other configs for this cent OS guest on KVM (virt-manager) to test/check?

(Before I mucked with the file it had a 192.168.122.67 IP address I could ssh to.) What I didn’t test and wish I had was if it could see the outside network, I am guessing it could since I could ssh into it. This new box whose IP address is set to 10.75.1.187 I cannot ping out to anything really, so guessing something else I am missing in configuring the network. Not a lot of experience here so knowing what files to open and what edits to make is difficult.

server host key usage problem

I have my server host key(private key) in Openssl format that i want to use for server authentication. I prefer to use the trust model that client local database should associates each host name with the corresponding public host key. Since openssl format key is not supported in openssh architecture, i am looking a solution that should convert my openssl format private key to openssh format private key. Appreciate any help to resolve this problem

Chef, dynamic value for one host

I am configuring a proftpd server running on port 2222. I would like disable sftp on 22 which I can do by commenting the sftp line in sshd.config.

There is a ssh recipe part of another cookbook which drops sshd.config, but I am using different cookbook for proftp. How can we get sshd_config updated without 2 recipe runs?

How do I import database data to a new host that runs a newer version of MySQL without ssh access?

My current host for an old website has only MySQL 5.0 (serverVersion=10.2.12-MariaDB-log).

I want to move this website to a host that has either 5.5 or 5.6 or 5.7 MySQL (depending which server I move to).

But the only instructions I can find for updating database data from 5.0 to 5.6/5.7 are run from the command line, requiring ssh access that I do not have.
For example these are the best, clearest instructions I have found, but I cannot use them because, as AFAIK, I do not have ssh, nor do no fully understand the references ([he?] makes. (e.g. he says --no faults “for simplicity” but even if I had ssh, I don’t know if I should also use that flag or others.)

  • http://mysqlserverteam.com/upgrading-directly-from-mysql-5-0-to-5-7-using-an-in-place-upgrade/
  • https://mysqlserverteam.com/upgrading-directly-from-mysql-5-0-to-5-6-with-mysqldump/

I usually use MySQL Workbench to connect to remote databases, but when I connect to that old host via MySQL Workbench, a message pops up saying [Workbench] is not compatible with 5.0.
So for that host, I have either used MySQL Workbench anyway to make a backup (which probably probably means the backup is no good), or I use the host’s web-based tool (not my preference, but obviously better). I have also recently installed HeidiSQL because it seems to be compatible with 5.0 (I does not give a warning/error message anyway). So I have started making backups and minor data changes on that host using HeidiSQL.

The only reason I have continued to use the host running MySQL 5.0 is because I haven’t yet found instructions on how to migrate data for websites on that server, whether it’s via a hosting provider’s online database tool, MySQL Workbench, or HeidiSQL !
Everything I see is for for doing step-wise data upgrades using the command line, and/or for upgrading the database server itself.

I need a way to upgrade the data from 5.0 to 5.6 or 5.0 to 5.7, probably in 1 step, using a gui database connection tool, or some other independent method. I will not have access to any mySQL servers other than the server I’m migrating away from (5.0), and the server I am migrating to (5.5 or 5.6 or 5.7).

Does anyone know how to do this?

EDIT:

  • I usually choose “Export” from the gui to export and choose all tables, when I do a database backup. I assume this is the same as a “database dump” that I see referenced everywhere.
    Is this correct? If not, how do I generate a proper dump file?
  • What export “settings” should I use when the goal is to upgrade and migrate?
  • I also see some references to users table. Do I need to perform any other exports in order to fully transfer and upgrade my database to a new server with a more recent version?

How do I import database data to a new host that runs a newer version of MySQL without ssh access?

My current host for an old website has only MySQL 5.0 (serverVersion=10.2.12-MariaDB-log).

I want to move this website to a host that has either 5.5 or 5.6 or 5.7 MySQL (depending which server I move to).

But the only instructions I can find for updating database data from 5.0 to 5.6/5.7 are run from the command line, requiring ssh access that I do not have.
For example these are the best, clearest instructions I have found, but I cannot use them because, as AFAIK, I do not have ssh, nor do no fully understand the references ([he?] makes. (e.g. he says --no faults “for simplicity” but even if I had ssh, I don’t know if I should also use that flag or others.)

  • http://mysqlserverteam.com/upgrading-directly-from-mysql-5-0-to-5-7-using-an-in-place-upgrade/
  • https://mysqlserverteam.com/upgrading-directly-from-mysql-5-0-to-5-6-with-mysqldump/

I usually use MySQL Workbench to connect to remote databases, but when I connect to that old host via MySQL Workbench, a message pops up saying [Workbench] is not compatible with 5.0.
So for that host, I have either used MySQL Workbench anyway to make a backup (which probably probably means the backup is no good), or I use the host’s web-based tool (not my preference, but obviously better). I have also recently installed HeidiSQL because it seems to be compatible with 5.0 (I does not give a warning/error message anyway). So I have started making backups and minor data changes on that host using HeidiSQL.

The only reason I have continued to use the host running MySQL 5.0 is because I haven’t yet found instructions on how to migrate data for websites on that server, whether it’s via a hosting provider’s online database tool, MySQL Workbench, or HeidiSQL !
Everything I see is for for doing step-wise data upgrades using the command line, and/or for upgrading the database server itself.

I need a way to upgrade the data from 5.0 to 5.6 or 5.0 to 5.7, probably in 1 step, using a gui database connection tool, or some other independent method. I will not have access to any mySQL servers other than the server I’m migrating away from (5.0), and the server I am migrating to (5.5 or 5.6 or 5.7).

Does anyone know how to do this?

EDIT:

  • I usually choose “Export” from the gui to export and choose all tables, when I do a database backup. I assume this is the same as a “database dump” that I see referenced everywhere.
    Is this correct? If not, how do I generate a proper dump file?
  • What export “settings” should I use when the goal is to upgrade and migrate?
  • I also see some references to users table. Do I need to perform any other exports in order to fully transfer and upgrade my database to a new server with a more recent version?

Is it safe to save virtual machine state between host reboots if VM uses external drive?

I now use the following setup:

SATA hard drive -> SATA-USB Bridge -> laptop running Ubuntu Host and VirtualBox -> Debian-based network share server (OMV) Guest

External USB drive is passed through to the guest OS automatically. So, when the VM powers on, the USB drive connects to it. When it is powered down, it connects to the host and Ubuntu tries to mount it.

I have set VirtualBox to automatically save state before shutdown of the host and after power up of the host. Is it safe to save state of the guest OS when the host laptop is being rebooted? If not, how can it be improved?

After installing vsftpd, sshd uses the wrong host key

Running Ubuntu 16.04 LTS, I have had an ssh server with a specified key running for a couple years. Recently, I set up vsftpd for a couple users and generated a key for it. After doing so, trying to connect to ssh now serves the key I generated for vsftpd.

The sshd_config and vsftpd.conf files both point to completely different keys so I do not understand why this is happening or how to fix it.

ProxMox w’ PFSense, No Route To Host

I have ProxMox and I use PFSense as DHCP for VMs

I follow tutorial but I get no route to host when ping from pfsense to 8.8.8.8

Funny thing, I see incoming connection to PFSense WAN IP(10.0.1.1), but Blocked…

10.0.1.1 is PFSense WAN IP

192.168.1.1 is PFSense LAN IP

Here is ProxMox /etc/network/interfaces

auto lo iface lo inet loopback  iface eno1 inet manual  iface eno2 inet manual  auto vmbr0 iface vmbr0 inet static     address  <censored> # WAN Public IP     netmask  255.255.255.0     gateway  <censored> # WAN Public IP Gateway     bridge-ports eno1     bridge-stp off     bridge-fd 0  auto vmbr1 iface vmbr1 inet static     address  10.0.1.254     netmask  255.255.255.0     bridge-ports none     bridge-stp off     bridge-fd 0     post-up echo 1 > /proc/sys/net/ipv4/ip_forward     post-up iptables -t nat -A POSTROUTING -s '10.0.1.0/24' -o vmbr0 -j MASQUERADE     post-down iptables -t nat -D POSTROUTING -s '10.0.1.0/24' -o vmbr0 -j MASQUERADE     post-up iptables -t nat -A PREROUTING -i vmbr0 -p tcp --dport 443 -j DNAT --to 10.0.1.1:443     post-down iptables -t nat -D PREROUTING -i vmbr0 -p tcp --dport 443 -j DNAT --to 10.0.1.1:443  auto vmbr4 iface vmbr4 inet static     address  192.168.1.254     netmask  255.255.255.0     bridge-ports none     bridge-stp off     bridge-fd 0 

My question be if I do routing correct

Mouse and keyboard not working in Hyper-V connection after mirgating VM on other host

I’ve create an 1st generation VM with Ubuntu 18.04.2 on Hyper-V Windows 10, it work properly. Then, i clone VM by the export/import VM in Hyper-V menus. When i start VM on other host – it started and work, even I can connect to it over XRDP session, but if i try to connect it with usual connect from Hyper-V dispatcher I’ve see full process of loading console session, same on original host, but mouse and keyboard no work in it. If i clone so way Windows 10, for example, all clone connect using usual connect to VM from Hyper-V dispatcher without so problem. I suspect it happens because the Ubuntu can’t detect that HAL was changed and not expecting the mouse and keyboard on other places. I’ve tryed to reset VM but in vain. How to force Ubuntu rebuild HAL?

Mouse and keyboard not working in Hyper-V connection after mirgating VM on other host

I’ve create an 1st generation VM with Ubuntu 18.04.2 on Hyper-V Windows 10, it work properly. Then, i clone VM by the export/import VM in Hyper-V menus. When i start VM on other host – it started and work, even I can connect to it over XRDP session, but if i try to connect it with usual connect from Hyper-V dispatcher I’ve see full process of loading console session, same on original host, but mouse and keyboard no work in it. If i clone so way Windows 10, for example, all clone connect using usual connect to VM from Hyper-V dispatcher without so problem. I suspect it happens because the Ubuntu can’t detect that HAL was changed and not expecting the mouse and keyboard on other places. I’ve tryed to reset VM but in vain. How to force Ubuntu rebuild HAL?