Struggles are real here, new setup that is 50% working.
Layout first:
I have a urbackup server running or Iubuntu or Ubuntu cant’t remember but I think it’s a true Ubuntu distro.
I have one Windows 10 client that will backup fine to it
I have 2-3 linux VM’s I have been trying with to get backed up , all are headless and urbackup client compiled as such.
They can ping and telnet to the respective ports back and forth and I have added them via both ip and hostname ans put the hostnames in Urbackup server /etc/hosts
The server says “yes” for Online to each but I do not think it really sees them. I have tried with internet mode on and off.
The topology is :
Server is at a colo
One client is on same esx host
One client is at my house via site to site VPN tunnel with cisco routers on each end.
192.168.254.20 for urbackup server
192.168.254.11 for urbackup client
192.168.1.242 for urbackup client
Logs have shown socker error 113 and socket code 11 I think.
Aby help is appreciated!!!
Okay… let me try that again… after reading my post and then re-reading yours I’ve revised my advice. 
Hi Eric, I have a similar setup that I have been testing (at least in terms of local and remote clients). Things you might want to check:
// unhelpful bit removed //
I note that you can ping the server port from the client but can you also ping the client port from the server?
When you created the new client(s) on the server it asked for a “computer name” and should have also given you a “network” password. Those need to be entered in the client config (or can be checked to make sure they are already there).
Sorry if you have already tried that and if they didn’t help. I ran up against that issue getting the start of a test-bed setup.
Thanks ssemone, I did not get prompted with a password after adding the clients via HTTP gui, and for awhile that was the error that I was receiving , related to “Auth Failed” but that has since went away.
Below are some outputs that might help someone at least direct me to the issue.
Test of connection from urbackup server (192.168.254.20) towards the client:
root@archive-nix:/home/eday# telnet 192.168.254.11 35621
Trying 192.168.254.11...
Connected to 192.168.254.11.
Escape character is '^]'.
root@archive-nix:/home/eday# telnet 192.168.254.11 35623
Trying 192.168.254.11...
Connected to 192.168.254.11.
Escape character is '^]'.
SERVER Logs (last 48 hours are pretty quite, I can turn debug on but not certain how)
:
2016-08-09 22:05:45: WARNING: Shutting down (Signal 15)
2016-08-09 22:36:49: ERROR: No permission to access “/media/BACKUP/urbackup/urbackup_tmp_files”
2016-08-10 01:56:15: WARNING: Shutting down (Signal 15)
2016-08-10 11:50:23: WARNING: Shutting down (Signal 15)
2016-08-10 12:54:43: WARNING: Shutting down (Signal 15)
2016-08-10 14:00:45: WARNING: Getting index log data from client failed
2016-08-10 14:00:45: WARNING: Timeout: Getting index log data from client failed
2016-08-11 03:05:43: ERROR: Server admin stopped backup.
2016-08-11 03:05:44: ERROR: Backup failed
2016-08-11 03:05:45: WARNING: Exponential backoff: Waiting at least 40m before next image backup
2016-08-11 03:19:37: WARNING: Shutting down (Signal 15)
2016-08-12 01:59:22: WARNING: Restarting shadow copy of C:\ because it was started by this server
2016-08-12 03:44:30: WARNING: Shutting down (Signal 15)
2016-08-12 04:20:50: WARNING: Shutting down (Signal 15)
2016-08-12 04:30:50: WARNING: Shutting down (Signal 15)
root@archive-nix:/var/log#
CLIENT /etc/rc.local
I have both listed, but I haven’t seen start_urbackup_client listed anywhere to be used:
/usr/local/sbin/start_urbackup_client
/usr/local/sbin/urbackupclientbackend -d
exit 0
/var/log/urbackclient.log
2016-08-12 17:50:04: Looking for old Sessions… 0 sessions
2016-08-12 18:20:05: Looking for old Sessions… 0 sessions
2016-08-12 18:50:06: Looking for old Sessions… 0 sessions
2016-08-12 19:20:07: Looking for old Sessions… 0 sessions
2016-08-12 19:50:08: Looking for old Sessions… 0 sessions
2016-08-12 20:20:10: Looking for old Sessions… 0 sessions
2016-08-12 20:50:10: Looking for old Sessions… 0 sessions
2016-08-12 21:20:11: Looking for old Sessions… 0 sessions
2016-08-12 21:25:00: WARNING: Shutting down (Signal 15)
root@bluegiraffe:/var/log#
urbackup_client.log
2016-08-12 04:19:38: ERROR: Error preparing Query [UPDATE shadowcopies SET refs=? WHERE id=?]: malformed database schema (ha
rdlinks) - near "WITHOUT": syntax error
2016-08-12 04:19:38: ERROR: Error preparing Query [INSERT OR REPLACE INTO mfiles_backup SELECT dir_id,name FROM mfiles]: mal
formed database schema (hardlinks) - near "WITHOUT": syntax error
2016-08-12 04:19:38: ERROR: Error preparing Query [DELETE FROM mfiles]: malformed database schema (hardlinks) - near "WITHOU
T": syntax error
2016-08-12 04:19:38: ERROR: Error preparing Query [DELETE FROM mfiles_backup]: malformed database schema (hardlinks) - near
"WITHOUT": syntax error
2016-08-12 04:19:38: ERROR: Error preparing Query [SELECT dir_id FROM mfiles_backup WHERE dir_id=? AND name=? UNION SELECT d
ir_id FROM mfiles WHERE dir_id=? AND name=?]: malformed database schema (hardlinks) - near "WITHOUT": syntax error
2016-08-12 04:19:38: ERROR: Error preparing Query [SELECT name FROM mfiles_backup WHERE dir_id=? UNION SELECT name FROM mfil
es WHERE dir_id=?]: malformed database schema (hardlinks) - near "WITHOUT": syntax error
2016-08-12 04:19:38: ERROR: Error preparing Query [SELECT tvalue FROM misc WHERE tkey=?]: malformed database schema (hardlin
ks) - near "WITHOUT": syntax error
2016-08-12 04:19:38: ERROR: Error preparing Query [INSERT INTO misc (tkey, tvalue) VALUES (?, ?)]: malformed database schema
(hardlinks) - near "WITHOUT": syntax error
2016-08-12 04:19:38: ERROR: Error preparing Query [UPDATE misc SET tvalue=? WHERE tkey=?]: malformed database schema (hardli
nks) - near "WITHOUT": syntax error
root@bluegiraffe:/var/log#
Hey Eric…
Some googling makes me think this might be a potential issue though I confess to not knowing why the sqlite database would be opened more than one with different names.
2.5 Multiple links to the same file
If a single database file has multiple links (either hard or soft links) then that is just another way of saying that the file has multiple names. If two or more processes open the database using different names, then they will use different rollback journals and WAL files. That means that if one process crashes, the other process will be unable to recover the transaction in progress because it will be looking in the wrong place for the appropriate journal.
In other words, opening and using a database file that has two or more names results in behavior that is undefined and probably undesirable.
Beginning with SQLite version 3.7.17, the unix OS interface will send SQLITE_WARNING messages to the error log if a database file has multiple hard links.
Beginning with SQLite version 3.10.0, the unix OS interface will attempt to resolve symbolic links and open the database file by its canonical name. Prior to version 3.10.0, opening a database file through a symbolic link was similar to opening a database file that had multiple hard links and resulted in undefined behavior.
Thanks again ssemone, I will take that and see where it leads me.
I’d be willling to even completely remove everything off the backup server if I thought it would resolve it.
So far I have only backed up a single windows image, and 3 days of incremental file backups.
I’ll see what I dig up more on the malformed database error that you pointed out.