7 posts were split to a new topic: Roaming profiles in AD
So a little update what happend.
I created the shares on the new NS7rc3 which is not a DC at the moment and copied the shares thru a Ubuntu 16.04 from one to the other Server. Unfortunately there have been some trouble with some of the files so I´ve to figure out how to get them from one to the other share.
Now I´m planning to move the mySQL Database of our EMR- therefore I need phpmyadmin on the NS7 which worked like that:
http://wiki.nethserver.org/doku.php?id=stephdl_repository and
http://wiki.nethserver.org/doku.php?id=phpmyadmin
To be continued…
By the way- does somebody knows, if NS7 backup includes those mySQL files?
2 Likes
Great project you have there …and a lot of work 
For the files you may use rsync.
IIRC mysql backups are stored in /var/lib/nethserver/backup/mysql/
Out of curiosity do you run any Free Software/OpenSource Hospital management software, like GNU Health, OpenHospital or HospitalRun?
1 Like
Thank´s for tip. So I´ve to think about, automatized backup for mySQL datas.
And no, we´re using some Java App named Aceto working on Windows, Apple and Linux ( https://www.aceto-online.at/ ) but experiencing with openEMR ( http://www.open-emr.org/ ) which is web based and really fascinating and we already used it in documenting during the refugee crisis last summer. I´d prefer a web based app, because nothing else then a browser with net access is needed on the client side, but at this stage it does not fulfill our needs.
1 Like
So that’s what I am going to try.
http://mirror.de-labrusse.fr/doku.php?id=nethserver-automysqlbackup
For the mysql backup. It is really fascinating, at last there are so many solutions already here. Thank you all for your work.
That also worked perfectly. No failures until now, but still copying.
Mysql are backuped by the nethserver backup module and restored with the restore module.
With my module automysql backup only the backup is automatic (once a day), restoration is manual.
I needed it because when a mysql db is corrupted I prefer to restore the db backup rather to restore the whole server
2 Likes
Good to know. So I won’t need another backup.
Belt and suspenders 
2 Likes
So- we´ve done the transfer of the shares via rsync.
Next step is generating a copy of the mySQL DB: export with standard settings from mySQL 5.5- transfering to new server and importing MariaDB- is making trouble. More tomorrow.
Next is a snapshot (VM Ware) of both servers.
We also now plan to draw outlook pst dumps of the mail accounts for each user, which we will reimport at the new mail server tomorrow.Therefore we have to reset all user passwords.
In the meantime we´re closing the smtp connection at the router, so no mails can come in and get out during movement of the mailserver.
Then we can shut down the old DC (Zentyal) and activate the NS7 after changing the IP and making it a DC (AD)- creating the users, mails, activating the mailserver. Incorperating the windows clients (which should be easy. clearing the old useracounts on them and playing back the userbackup. Then we´ll set up the Ubuntu GNome Clients put them in the domain, als playing back the user profiles. Doing the roaming function for windows and Linux Clients.
Testing the whole stuff.
Will be a very long day tomorrow…wish us luck please.
1 Like
As part of our new clients will be dual boot machines (Linux for “normal” clients and WIndows for those using medical software, which unfortunately exists mainly and only on Windows 32bit sicc! platforms) this guide to regulate the booting https://wiki.ubuntuusers.de/GRUB_2/Konfiguration/
1 Like
Integration of Ubuntu Gnome 16.04 Clients is another Topic- a lot of tipping on each of the clients- so probably we’re going to do that https://www.centrify.com/express/server-suite-form/ (only working on Windows clients, but why not, we do have them.
1 Like
So everything different- tough we are working tomorrow, we only upgrade the VM-ware today to 6.5 so that we can see our RAID controller working and get rid of some nasty HALT action of one of our servers due to driver incompatibilities.
Then we’ll have time until new years eve for the big stuff.
But we will keep you informed! 
1 Like
What are your needs? Can you be more specific? We have some experts on Ubuntu Clients around
1 Like
I do have some experiences with Ubuntu 14.04. It really depends on how you want to integrate the access (only shares/login accounts/SSO with Kerberos, etc.). If you need a second thought raise an hand 
, I may not have all the answers but I will work with you if possible.
3 Likes
Thank you so much- I’ll be raising my 
probably soon 
Another question- has somebody experience with integrating Nethserver mysql into mysql workbench- because It was no problem with the old Zentyal server, but I get a failure with nethserver (I’m using a tunnel with different IP ranch, but the network is trusted in Nethserver and network service is set to green/red). The root/ password combination is working in phpmyadmin!
Just solved- wrong privileges with user root at mysql!
2 Likes
And that’s a great tool for migrating mySQL DB’s from one to the next server- much easier then via myphpadmin!
http://www.mysql.com/products/workbench/dev/
1 Like