I have rounded up many tools like vFront, and they all state to do the same, but was unable to find anything with its simplicity and accuracy, and actually works.
I dont know why there is not a big opensource app like this that is better funded as such as PhpMyAdmin, I like phpmyadmin, and the amount of development put into it, but why not create something simple for end users as a target, and it seems vFront is the only thing like this.
@black3dynamite said in vFront (User front-end for MySQL and PostgreSQL databases):
@scottalanmiller said in vFront (User front-end for MySQL and PostgreSQL databases):
@black3dynamite said in vFront (User front-end for MySQL and PostgreSQL databases):
That's awesome. I've always been using Adminer (https://www.adminer.org/) when I need to manage databases.
This isn't for managing them, this is for creating simple front ends, like Access used to do.
Ok, that makes more sense now.
The VFront Administration for DB Administration uses Adminer. Just have to enable the plugin.
Correct, this is there for quick edits, but why use those when there are enterprise solutions like MySQL Workbench.
@dbeato said in Outlook Cannot Open Because of Set of Folders:
Is this Office 2013 or 2016? If so it should not be creating PSTs unless it is a POP account. It has been now OST only.
I always prefer PST for average user, it is very easy to handle and restore.
OST needs exporting to PST as backup and that is not very straight forward.
I know you lose online features with PST, but for those you can use the web client.
@scottalanmiller said in Alternatives to MS SQL Server:
Another good one. MySQL and MariaDB lack ACID compliance, which is huge. PostgreSQL is fully ACID and more SQL complete.
Also some performance numbers and notes. They reiterate, MySQL is good for web workloads where relational data isn't needed.
http://www.cloudhack.in/2017/03/12/mysql-vs-postgresql-relational-database-comparison/
You know what I am benching them right now, hold on with me...
ARM is the future.
Now that we have this settled, if your looking to purchase a single board computer, hold on and wait for boards with = RK3399 from Rockchip like
The Next ODROID!
https://forum.odroid.com/viewtopic.php?f=29&t=29932
which is expected to arrive for nearly 100$
Perfect for RAID 1 on the cheap, or anything really.
performance, my old AMD ATHLON x750K scores= Octane Score: ~13,000
RK3399 chip scores =~ 10,000
in octane 2 google benchamrk
ODROID-N1 key features:
Can i trouble you for to do this, and paste the contents:
virsh dumpxml GuestID > guest.xml
and provide us the xml ? Since it seem you have this installed.
They make pretty decent NAS systems targeted for SOHOs.
https://www.amazon.com/ASUSTOR-AS1002T-2-Bay-Personal-Cloud/dp/B014YN6IK4
and yh there are ASUS
Seems resolved now, I went to the site to see why the NAS cant update an addon
I love COCKS
I mean cockpit-storage
I removed 1 HDD from my test environment and it was very easy to detect and handle.
cockpit is shaping to become the defacto standard in managing linux boxes, I hope they dont stop or sell out
Regarding RAID 1 on boot, I did this one test enviroment and removed RAID 1 disk and now the system on emergency mode, so not sure if I will add complexity and do this, especially since the chance of that partition corrupting is low, cause it is used on startups mostly and reboots.
@scottalanmiller said in NAS alternative on the cheap:
@emad-r said in NAS alternative on the cheap:
@emad-r said in NAS alternative on the cheap:
Should I worry about the fact that the boot partition is not included in the RAID array ? what can you advise to fix or increase the durability of this, without dedicated RAID card
Also the setup is very nice especially with cockpit.
It can't be, you have to manually copy the /boot to each partition.
try it out, have fedora system install, and copy the boot paritions to another disk, then delete the original boot partition and reboot the system, the system will auto detect and boot from the duplicated in another disk boot parition, on centos this does not happen. I tested with in EFI
@emad-r said in NAS alternative on the cheap:
@scottalanmiller said in NAS alternative on the cheap:
@emad-r said in NAS alternative on the cheap:
@emad-r said in NAS alternative on the cheap:
Should I worry about the fact that the boot partition is not included in the RAID array ? what can you advise to fix or increase the durability of this, without dedicated RAID card
Also the setup is very nice especially with cockpit.
It can't be, you have to manually copy the /boot to each partition.
try it out, have fedora system install, and copy the boot paritions to another disk, then delete the original boot partition and reboot the system, the system will auto detect and boot from the duplicated in another disk boot parition, on centos this does not happen. I tested with in EFI
I suspect this behavior is related to that centos uses XFS for boot partition and Fedora uses EXT4 so doing more tests, and perhaps UUID is another possible reason.
@emad-r said in NAS alternative on the cheap:
@emad-r said in NAS alternative on the cheap:
@scottalanmiller said in NAS alternative on the cheap:
@emad-r said in NAS alternative on the cheap:
@emad-r said in NAS alternative on the cheap:
Should I worry about the fact that the boot partition is not included in the RAID array ? what can you advise to fix or increase the durability of this, without dedicated RAID card
Also the setup is very nice especially with cockpit.
It can't be, you have to manually copy the /boot to each partition.
try it out, have fedora system install, and copy the boot paritions to another disk, then delete the original boot partition and reboot the system, the system will auto detect and boot from the duplicated in another disk boot parition, on centos this does not happen. I tested with in EFI
I suspect this behavior is related to that centos uses XFS for boot partition and Fedora uses EXT4 so doing more tests, and perhaps UUID is another possible reason.
I am dropping this, I matched UUID and flags and everything, if you delete boot + boot/efi on Centos no matter what it does not get restored, even if you cloned the parition back and restored same UUID + flags.
EXT4 seems better for boot cause it retains the UUID while copying while XFS changes it.
I will take the floor and rant:
Well Ubuntu, actually Canonical are acting alot like MS with recent innovation, I dont like the way they are heading and taking the community.
For example snap packages, what stupid concept and abit shady, it creates abstraction layer that should not be there in the first place, and it is tied to their OS and only recently it got open to other distros, but it open grounds for newer way of apps that are paid, I dont mind paid apps and supporting the devs, but not knowing what is inside , why they want to push the user more and more away from manually installing packages and be in charge, instead with snaps this allows others in charge which is usually a bad thing + snap apps are not like "real" apps they have poor performance, try running rocketchat in a snap, sure it takes 1 min to setup but its very slow and laggy, which gives the wrong impression on linux, and what more that I can say when skype gets released as snap package in quick manner.
Secondly why reinvent the wheel with docker and create lxd, really who would use number 2 ? when they can use number 1, i feel canonical stopped innovating since 8.04 and 8.10, and with that big fiasco of UNity UI and forcing on users same way Win10 does. The problem is not with Ubuntu desktop or server, Its with the management that have to fork everything and make it canonical, I think the crisis started when Ubuntu stopped down-streaming on Debian unstable, and created their own stuff that does not benefit the community, and I dont see any scenario to use ubuntu server or desktop, when there are other OS actually by just using them you benefit the community in the upsteam/downstream cycle, when ubuntu was based on debian unstable, using ubuntu helped debian and visa versa.
Now with Fedora workstation, no real need for Ubuntu desktop, same goes for the server, the only reason to use ubuntu server is cause there is software that is tied to ubuntu server like openstack or MAAS, not from innovations but from money that made those software closer to ubuntu.
VMware ESXi cause It was the first to put web UI i reckon for management of the hyper-visor, and alot of people hated this and there was backlash, but they continued with the flash then HTML5 FLEX UI, and after while it was the sensible thing to do, it was not full featured nor fast like C# windows client but eventually they will reach it.
Vmware being popular makes it easy to export/import VMs as well, if it was fully unlocked with backup API, once you have web management port that means you can reach it from anywhere using anything device with chrome browser on it.
KVM, not cause of KVM cause it runs and actively supported and updated on Linux OSes, so eventually we will get all the features if not more, and benefits and more of ESXi via external packages like mdraid + cockpit, so you can build pretty strong system but the learning curve can scare people away.
Windows supported too, will check this out and see if I can ditch outlook gradually.
my thoughts for this is I have researched alot but I never really worked on enterprise big enough to justify this.
Especially in this day age Windows installer can be created to USB drives, and if you select fast USB drive the installer will take 10 mins + you can do this on 10 laptops easily , and cost of 8GB USB drive is peanuts.
that said partedmagic
https://partedmagic.com/
is awesome project, and it does support PXE booting, my advice is to play with that and get used to the tools there.
DO note MBR + EFI will be pain if you have not set standard for your existing machines. also different hardware drivers (but to an extend, it is okay and realistic if you have different models)
What you can do is install windows OS preferably in machine model that resembles others, theoretically in VM also. then install everything you want, but keep is light, like Pidgin + MS office 2013 + VLC + SumatraPDF whatever you want. you really want to make the C system drive as light as possible and preferably less than 20-25 GB. Then you will run sysprep with generalize option with shutdown option.
The machine will shutdown, boot partedmagic on that machine, if you failed and entered the generalized environment you will need to run sysprep again. once you see parted magic you can run clonezilla in terminal and run options like disk to image then disk_local 2 disk_local then specify the source which is the windows C 25 GB with all your apps, and create image of that machine to target, and I advise dont use any compression, in the target which can be external drive or network share or whatever, it will have folder with many files worth of 10 GB.
Theortically you can enter any other machine, load up partedmagic and delete the system partition or all paritions then restore using clone zilla then resize the parition from 25 GB to take the more space like 200 GB, then create flag to that partition that it is bootable, then if the machine was set to MBR boot mode it will boot up, and you will see the windows wizard and user creation and time selection + all of your apps.
Extra points if you made the C partition without 100 MB boot partition and integrated them into one during the installer. + check option in clonezilla to remove pagefile sys and hibernate.sys
That said I dont use this, I can create Windows USB installations with runnable scripts or you can make it more simple think how CM like salt does it, if you have NAS your all done, just create folder in the NAS and make it public accessible and create folder called after windows install and have aload of scripts and silent installers, and mainting this is much easier, you will just have to update the installer files without changing their names.
partedmagic is not free but worth at, it is the best person to combine all those FOSS tools and make it work in easy way, for example gparted live standalone OS does not allow you to mount drives, clonzilla standalone OS will run in terminal mode and you wont be able to do any other tasks other than clonezilla, while partedmagic gives you a full experience and very mature.
Currently I do files, even though there are good recommendations and comments regarding the VM level.
The reason I do files cause I can easily create it and know all the aspects about it and easily test the integrity of the backup via applications like p7zip and calculate things and track it, and things are easier to understand like it is expected for the files to either grow or stagnate.
On VM level unless you have approach to test the backups like systematic way of getting that VM export and testing it, who knows then if you will restore from it properly when Disaster arrives and if all your VM backups are un restorable then you dont really have a backup. Do note i am not saying Veeam is bad product or not trustworthy, actually I heard the opposite all the time.
I dont have an automated system for testing exported VM, but this thread got me thinking of virtual-box headless that can be useful for this.
Trying it and installing, but what of those are optional, I want only the core email functionality on single server/VM
Found zimbra-core (local)
Found zimbra-ldap (local)
Found zimbra-logger (local)
Found zimbra-mta (local)
Found zimbra-dnscache (local)
Found zimbra-snmp (local)
Found zimbra-store (local)
Found zimbra-apache (local)
Found zimbra-spell (local)
Found zimbra-memcached (repo)
Found zimbra-proxy (local)
Found zimbra-chat (repo)
Found zimbra-drive (repo)
Found zimbra-imapd (local)
Zimbra core gets installed by defualt, but what else I need for minimum setup, what do you recommend or is there any gotchas if I installed those addons like I need license.
If i get any other thing and it is respectable soon I will for sure. this kind of shit start to affect you and you start being bad worker, cause its all bad from top
hopefully soon I will report back with better status, sadly I cant afford to quit.
If you want to continue down this path of PSEXEC, how about having an python agent that tracks your changes, check SaltStack, and salt minion, it will make your life alot easier, and it is much modern and supported than PSEXEC
