ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login
    1. Topics
    2. dbeato
    • Profile
    • Following 70
    • Followers 8
    • Topics 74
    • Posts 6,043
    • Best 1,482
    • Controversial 3
    • Groups 0

    dbeato

    @dbeato

    Daniel Beato is an IT Professional that has been working on the industry for more than 10 years, born and raised in Dominican Republic and now resides in United States. He is an avid reader and supporter of the Spiceworks and Mangolassi Community. He loves to contribute and help other IT Pros in any are he can.

    2.1k
    Reputation
    5.1k
    Profile views
    6.0k
    Posts
    8
    Followers
    70
    Following
    Joined Last Online
    Location NJ Age 34

    dbeato Unfollow Follow

    Best posts made by dbeato

    • Setup Z-Push for Zimbra 8

      Install Apache on the server

      sudo apt-get update apt-get install apache2 php-curl
      

      Get the correct repository for your Linux Distribution on the below link:
      http://repo.z-hub.io/z-push:/final/

      In this case I was running it on a Ubuntu 16.04 server, so I used the commands below:

      sudo echo "deb http://repo.z-hub.io/z-push:/final/Ubuntu_16.04/ /" > /etc/apt/sources.list.d/z-push.list
      sudo wget -qO - http://repo.z-hub.io/z-push:/final/Ubuntu_16.04/Release.key | apt-key add -
      

      Then Updated the repos

      sudo apt update
      

      Then installed z-push from the repo

      sudo apt install z-push-common z-push-config-apache z-push-backend-combined z-push-ipc-sharedmemory
      

      Go to the Z-push Backend folder

      cd /usr/share/z-push/backend
      

      Get the latest Z-Push Zimbra Backend file from https://sourceforge.net/projects/zimbrabackend/files in this case it will be Release68 (https://sourceforge.net/projects/zimbrabackend/files/Release68/)

      wget https://sourceforge.net/projects/zimbrabackend/files/Release68/zimbra68.tgz
      wget https://sourceforge.net/projects/zimbrabackend/files/Release68/zpzb-install.sh/
      

      Modify the zpzb-install.sh and run it after it to install the Zimbra backend release files

      sudo chmod +700 zpzb-install.sh
      chmod +x zpzb-install.sh
      sudo ./zpzb-install.sh 68
      

      Modify the default-ssl.conf apache configuration to point to the Z-Push Backend folder

      sudo nano /etc/apache2/sites-available/default-ssl.conf
      

      The configuration will look as below:
      0_1542039010375_ef825305-222c-4cd2-9a8c-d61b830c2cd9-image.png

      Then enable the SSL site and enable SSL for Apache.

      sudo a2ensite default-ssl.conf
      sudo a2enmod ssl 
      sudo systemctl restart apache2
      

      Configure the Z-Push Backend Configuration File as below:

      sudo nano /usr/share/z-push/config.php
      

      Configure the following lines for TimeZone (Use PHP Timezones), BackendProvider (For ZImbra), in my case this is what I needed

       define('TIMEZONE', 'America/New_York');
       define('BACKEND_PROVIDER', 'BackendZimbra');
      

      Modify the Zimbra Backend Configuration

      sudo nano /usr/share/z-push/backend/zimbra/config.php
      

      Correct the Zimbra Configuration on the backend to point to your Zimbra internal or External Server

      define('ZIMBRA_URL', 'https://mail.domain.com');
      define('ZIMBRA_DISABLE_URL_OVERRIDE', true);
      

      If you don't want (Contact, Calendar, Tasks and Notes) to sync you can comment them on the configuration

      define('ZIMBRA_VIRTUAL_CONTACTS',true);
      define('ZIMBRA_VIRTUAL_APPOINTMENTS',true);
      define('ZIMBRA_VIRTUAL_TASKS',true);
      define('ZIMBRA_VIRTUAL_NOTES',true);
      

      Then allow your Z-Push Server to be white-listed on your Zimbra Server (Connect to your Zimbra server and do the following)

      su zimbra
      zmprov  mcf +zimbraHttpThrottleSafeIPs 192.168.xxx.xxx
      zmcontrol restart
      

      In my case I have my Z-Push behind an Nginx and I configured it as needed and it worked properly after this. (For Nginx SSL Proxy you can look at @JaredBusch topic on the following URL: https://mangolassi.it/topic/16651/install-nginx-as-a-reverse-proxy-on-fedora-27. You will also need to create a DNS entry to point to your Z-push server. I chose not to setup Z-push on my Zimbra server as the configurations get removed every-time the server is updated and also I did not want to install Apache over the same server as well.

      posted in IT Discussion zimbra 8.8 zimbra z-push nginx apache 2
      dbeatoD
      dbeato
    • Zabbix Server Setup on Debian 9.0

      Prior to doing anytighing if you are basing this on a Debian 9 NetInstall you need to install the following packages as root

      apt install ufw sudo -y
      

      Then setup the user in the sudo group

      sudo adduser username sudo 
      

      Then you can start the install process as below

      1- Install the Zabbix Repository

      wget wget https://repo.zabbix.com/zabbix/4.0/debian/pool/main/z/zabbix-release/zabbix-release_4.0-2+stretch_all.deb
      sudo dpkg -i zabbix-release_4.0-2+stretch_all.deb
      sudo apt update
      

      2- Install Zabbix Server Package

       sudo apt install zabbix-server-mysql zabbix-frontend-php zabbix-agent
      

      3- Secure MariDB & Create your MariaDB Database

      sudo mysql_secure_installation
      
      mysql -uroot -p
      password
      mysql> create database zabbix character set utf8 collate utf8_bin;
      mysql> grant all privileges on zabbix.* to zabbix@localhost identified by 'password';
      mysql> quit
      

      4- Import the Zabbix Server SQL Database to Mysql

       zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbix
      
      

      5- Edit the Zabbix Server Configuration

      sudo nano /etc/zabbix/zabbix_server.conf
      

      Change the DB password
      DBPassword=password

      6- Edit the Zabbix PHP for the frontend

      sudo nano /etc/zabbix/apache.conf
      

      Uncomment the following line and adjust to your time zone

      php_value date.timezone America/New_York

      7- Start the Zabbix Server

      sudo systemctl restart zabbix-server zabbix-agent apache2
      sudo systemctl enable zabbix-server zabbix-agent apache2
      

      8- Edit the Zabbix Apache Configuration to be the root of the Webserver

      sudo nano /etc/apache2/sites-available/000-default.conf
      

      Change the DocumentRoot from /var/www/html
      to
      DocumentRoot /usr/share/zabbix

      9- Edit the Zabbix Apache Alias Configuration

       sudo nano /etc/apache2/conf-available/zabbix.conf
      

      Comment the following line

      #Alias /zabbix /usr/share/zabbix
      

      10- Restart the Apache2 Service

      sudo systemctl restart apache2
      

      11- Go to your web browser and configure Zabbix
      0_1542820456552_464c1de9-6a8e-424f-8c4e-6a7be313c805-image.png

      12- Press next and make sure your prerequisites are me
      0_1542820519202_62fff5ff-379b-47a3-a3f6-69956d6847d6-image.png
      0_1542820524809_4d60afe4-ec00-4a9f-b802-33e2c9da992e-image.png

      13- Press Next and configure your Database Configuration
      0_1542820583170_ae25d54b-1ec6-4563-8e9e-38f9ad94946b-image.png

      14- Press Next and configure the server name and port
      0_1542820617534_72f060f0-2215-4614-8e47-2bbd84a34e42-image.png

      15- You will get a summary of the install and then press next
      0_1542820644728_2e0aadd6-9e8e-4030-ae4a-9747d6105469-image.png

      16- You will then presented that your installation was successful
      0_1542820682268_08fdcdf6-839f-4677-9c9f-5f970f835797-image.png

      17- Press Finish

      18- You will be presented with the Login Screen
      0_1542820749717_4b544537-6754-4323-8070-7cd710e35310-image.png
      The default username and password is Admin and zabbix respectively.

      19- You will now be on the Zabbix Dashboard
      0_1542820833552_51cf7579-df82-4ba1-b2da-5614da7de8df-image.png

      For your firewall rules open port 80,10050, 10051 and I decided on this post to limit it to my own network for SSH. (I only used port 80 because I plan on placing it behind a SSL proxy server)

      sudo ufw allow 80,10050,10051/tcp
      sudo ufw allow from 192.168.x.0/24  to any port 22
      sudo ufw enable
      
      posted in IT Discussion debian stretch debian 9 zabbix server mariadb monitoring
      dbeatoD
      dbeato
    • Windows 10 1709 and SMBv1 disabled reminder

      Just a reminder that SMBv1 is disabled on Windows 10 1709
      https://support.microsoft.com/en-us/help/4034314/smbv1-is-not-installed-by-default-in-windows-10-rs3-and-windows-server

      posted in IT Discussion windows 10 1709 smb 1 fall creators update 2017
      dbeatoD
      dbeato
    • Install Chocolatey Remotely on Domain Computers

      Enable PS Remoting in your Domain by following the Guide here

      https://devblogs.microsoft.com/scripting/enable-powershell-remoting-to-enable-running-command

      Then run this Powershell Script from a System with the Active Directory Powershell Modules installed: (Example below only installs it on the computers that are less or equal than 2 months old)

      Import-Module ActiveDirectory
      
      # get today's date
      $today = Get-Date
      
      #Get today - 60 days (2 month old)
      $cutoffdate = $today.AddDays(-60)
      
      $computers= Get-ADComputer -Properties * -Filter {LastLogonDate -gt $cutoffdate} | Select-Object -ExpandProperty Name
      
      
      foreach ($comp in $computers)
      {
         Invoke-Command -computername $comp {Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))}
      }
      

      Script is below
      https://github.com/dbeato/scripts/blob/master/Chocolatey/Install-Chocolatey-AD.ps1

      This can be automated and changed as well to fit your needs.

      posted in IT Discussion chocolatey windows domain remote powershell remote management install installation install guide psremoting
      dbeatoD
      dbeato
    • RE: Unifi + RADIUS + AD

      This is a configuration I have for AD with Unifi APs using RADIUS

      SSID
      c8fc6bbc-4100-43a0-b22a-a9ed6602bd50-image.png

      RADIUS Profile in UNifi
      c0cefead-a9e5-43d5-ae0b-7514a24654b1-image.png

      NPS Connection Request Policies
      APs are configured under RADIUS Clients with the Authentication password used on the RADIUS profile in the Unifi Controller.
      b1ae5e7f-9929-4bb0-9201-f611c134f126-image.png
      Policies
      efbc0274-d174-4a78-891d-97d2f0bf3b0c-image.png
      e845192a-8846-4136-b7fc-091d4e294bb7-image.png
      Nothing to change here
      2560bb73-6b15-4872-970c-1f34f105b3d0-image.png

      **NPS Network Policy **
      c5099fb8-2878-4a6d-986a-938dbda77e54-image.png
      e25485fb-3694-4d97-94f9-67a515551531-image.png
      7264e0ad-dfe8-4a35-8f92-36b68db0ac7f-image.png
      Under the Editing of the PEAP settings make sure to select your CA Certificate Authority
      5804bed9-4d88-48cd-a5f4-336a82bb7f88-image.png
      cb1a9740-a219-4a60-8786-2f7cc21b4bb9-image.png

      posted in IT Discussion
      dbeatoD
      dbeato
    • RE: SW Year in review

      @dafyre said in SW Year in review:

      @fuznutz04 said in SW Year in review:

      I just checked mine. 2 spice ups, and 0 in every other category. That shows how much I use Spiceworks anymore.

      Ladies and gentlemen, we have a winner.

      No, @Grey wins
      0_1513371910970_DeepinScreenshot_select-area_20171215160416.png

      posted in Water Closet
      dbeatoD
      dbeato
    • Upgrading Zimbra 8.5 on Ubuntu 12.04 to Zimbra 8.8.11 in Ubuntu 16.04

      1- Do a Full Backup of your Server
      2- Backup your localconfig.xml file located in /opt/zimbra/conf/
      3-Install Zimbra 8.5.1 Upgrade

      wget https://files2.zimbra.com/downloads/8.5.1_GA/zcs-8.5.1_GA_3056.UBUNTU12_64.20141103151510.tgz
      tar -xvf zcs-8.5.1_GA_3056.UBUNTU12_64.20141103151510.tgz
      cd zcs-8.5.1_GA_3056.UBUNTU12_64.20141103151510
      ./install.sh
      

      4-Install the Zimbramemcached and zimbra proxy roles. (Source: https://wiki.zimbra.com/wiki/Enabling_Zimbra_Proxy)

      Do you wish to upgrade? [Y] y
      Install zimbra-memcached [N] y
      Install zimbra-proxy [N] y
      

      5-Then configure Zimbra Proxy After Install

      ./libexec/zmproxyconfig -e -w -o -a 8080:80:8443:443 -x https  -H `zmhostname`
      

      6-Set the mail proxy ports

      ./libexec/zmproxyconfig -e -m -o -i 7143:143:7993:993 -p 7110:110:7995:995 -H `zmhostname`
      

      7-Enable COnfiguration

      /opt/zimbra/libexec/zmproxyconfig -e -m -H zimbra.domain.com
      

      8-Restart Mailbox Service

      zmcontrol restart
      

      9-Setup REverse Proxy Setup

      zmprov ms `zmhostname` zimbraMailReferMode reverse-proxied
      zmmailboxdctl restart
      

      10-Upgrade Zimbra 8.5.1 to 8.7.10

      wget https://files.zimbra.com/downloads/8.7.10_GA/zcs-8.7.10_GA_1829.UBUNTU12_64.20170524161336.tgz
      tar -xvf zcs-8.7.10_GA_1829.UBUNTU12_64.20170524161336.tgz
      cd zcs-8.7.10_GA_1829.UBUNTU12_64.20170524161336
      

      11-Add Zimbra Repo

      apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 9BE6ED79
      

      12-Modify Source list

      cat > /etc/apt/sources.list.d/zimbra.list << EOF
      deb     [arch=amd64] https://repo.zimbra.com/apt/87 precise zimbra
      deb     [arch=amd64] https://repo.zimbra.com/apt/zv1 precise zimbra
      deb-src [arch=amd64] https://repo.zimbra.com/apt/87 precise zimbra
      >> EOF
      

      13-Run Upgrade

      sudo apt update
      ./install.sh
      

      14- Backup your Server

      15-Upgrade Ubuntu 12.04 to 14.04

      sudo apt-get update
      sudo apt-get dist-upgrade
      sudo do-release-Upgrade
      

      16- Download and install the Zimbra 8.7.10 Updates for Ubuntu 14.04

      wget https://files.zimbra.com/downloads/8.7.10_GA/zcs-8.7.10_GA_1829.UBUNTU14_64.20170524161336.tgz
      tar -xvf zcs-8.7.10_GA_1829.UBUNTU14_64.20170524161336.tgz
      cd zcs-8.7.10_GA_1829.UBUNTU14_64.20170524161336
      ./install.sh -s
      

      17- Then run the installer for Upgrade

      su zimbra
      ldap start
      

      18- Exit to Root
      19- Upgrade ZImbra from 8.7.10 to 8.7.10 for full Configuration

      ./install.sh
      

      20-Download and install the Zimbra 8.8.11 Update for Ubuntu 14.04

      wget https://files.zimbra.com/downloads/8.8.11_GA/zcs-8.8.11_GA_3737.UBUNTU14_64.20181207111719.tgz
      tar -xvf zcs-8.8.11_GA_3737.UBUNTU14_64.20181207111719.tgz
      cd zcs-8.8.11_GA_3737.UBUNTU14_64.20181207111719
      ./install.sh
      

      21- Backup your Server
      22- Upgrade Ubuntu 14.04 to 16.04

      sudo apt-get update
      sudo apt-get dist-upgrade
      sudo do-release-Upgrade
      

      21- Download and install the Zimbra 8.8.11 Updates for Ubuntu 16.04

      wget https://files.zimbra.com/downloads/8.8.11_GA/zcs-8.8.11_GA_3737.UBUNTU16_64.20181207111719.tgz
      tar -xvf zcs-8.8.11_GA_3737.UBUNTU16_64.20181207111719
      cd zcs-8.7.10_GA_1829.UBUNTU14_64.20170524161336
      ./install.sh -s
      

      19- Copy Localconfig.xml file back to the Configuration folder

      cp /opt/zimbra/.saveconfig/localconfig.xml /opt/zimbra/conf
      

      20- Run Upgrade from 8.8.11 binaries to update the installation

      ./install.sh
      

      Important Links
      https://wiki.zimbra.com/wiki/Recovering_from_upgrade_failure
      https://wiki.ubuntu.com/Releases
      https://help.ubuntu.com/community/EOLUpgrades
      http://sgros.blogspot.com/2014/02/messing-up-zimbra-upgrade-aka-dangerous.html
      https://wiki.zimbra.com/wiki/Recovering_from_wrong_platform_upgrade
      https://wiki.zimbra.com/wiki/Enabling_Zimbra_Proxy
      https://wiki.zimbra.com/wiki/Fix_zclient.IO_ERROR_-_invoke_Connection_refused
      https://wiki.zimbra.com/wiki/Zimbra_Proxy_Manual:Advanced_Proxy_Configuration_Examples_via_CLI
      https://wiki.zimbra.com/wiki/Ubuntu_Upgrades
      https://wiki.zimbra.com/wiki/Zimbra_Collaboration_repository
      https://www.zimbra.org/download/zimbra-collaboration
      https://wiki.zimbra.com/wiki/Zimbra_Releases/8.7.0/Upgrade
      https://wiki.zimbra.com/wiki/How_to_disable_SSLv3

      posted in IT Discussion zimbra zimbra 8.5 zimbra 8.7 zimbra 8.8 zimbra 8.8.11 ubuntu 12.04 ubuntu 14.04 ubuntu 16.04 upgrade update
      dbeatoD
      dbeato
    • Bookstack Backup to S3

      Since I have been using bookstack more and more and while I do VM backups, I just wanted to setup backup externally to S3.
      The UI or system doesn't have a way to do database backups from the GUI or schedule it. So I created my MariaDB backup to S3 as below and wanted to share and open to change as well.

      find /sql0-backups/ -type f -iname '*.sql' -mtime +1 -delete
      USER=usernanme
      PASS="password"
      DB=bookstack
      DATE=$(date +%Y-%m-%d-%H-%M)
      mysqldump -u $USER -p$PASS $DB > /sql-backups/backup-$DATE.sql
      aws s3 cp /sql-backups s3://bucket-name/ --endpoint-url=https://s3.wasabisys.com --recursive
      
      posted in IT Discussion bookstack mariadb mysqldump mysql script amazon s3
      dbeatoD
      dbeato
    • RE: Recovering SQL Server 2005 Databases

      @scottalanmiller said in Recovering SQL Server 2005 Databases:

      @Obsolesce said in Recovering SQL Server 2005 Databases:

      Why can't you restore the DB to a newer SQL server?

      Officially, at least, MS says that that doesn't work. Or that it requires doing it many times. Hoping that there is a known, simpler solution 🙂

      It does work, you need to mount it and as long as the newer SQL Server is a higher version it should work fine. You cannot go back to the old versions. Now the bigger question is what program used this Database or what was the interaction to this database. That is the biggest consideration here.

      posted in IT Discussion
      dbeatoD
      dbeato
    • RE: What Are You Doing Right Now

      Believe it or not, I am installing my first Fedora server 🙂

      posted in Water Closet
      dbeatoD
      dbeato

    Latest posts made by dbeato

    • RE: What Are You Doing Right Now

      @gjacobse I created this
      https://github.com/dbeato/scripts/blob/master/Windows/Maintenance/Delete-Old-User-Profiles.ps1

      You can change the URL to be your own URL of the ADProfileCleanup.exe from the link referenced above.

      posted in Water Closet
      dbeatoD
      dbeato
    • RE: What Are You Doing Right Now

      Working on a script to delete old profiles in Windows based on this tool
      https://rsn.home.blog/2023/02/09/ad-profile-cleanup/

      posted in Water Closet
      dbeatoD
      dbeato
    • RE: What Are You Doing Right Now

      I am back at posting and working on various upgrade projects.

      posted in Water Closet
      dbeatoD
      dbeato
    • RE: Random Thread - Anything Goes

      @Danp Lol

      posted in Water Closet
      dbeatoD
      dbeato
    • RE: Decrypting a LUKS encrypted drive at boot

      Did this work for you? https://www.malachisoord.com/2023/11/04/decrypt-additiona-luks-encrypted-volumes-on-boot/

      posted in IT Discussion
      dbeatoD
      dbeato
    • RE: Cloudflare DYNDNS updates now easy.

      For Windows I have used this PowerShell

      https://github.com/fire1ce/DDNS-Cloudflare-PowerShell

      posted in IT Discussion
      dbeatoD
      dbeato
    • RE: What Are You Doing Right Now

      @jt1001001 said in What Are You Doing Right Now:

      ost hope everyone has a great holiday seaon.

      So far so good, just taking a few days off.

      posted in Water Closet
      dbeatoD
      dbeato
    • RE: What Are You Doing Right Now

      Had to fix UNMS on multiple deployments because the latest Docker update breaks it lol https://www.reddit.com/r/Ubiquiti/comments/1hc3hff/docker_update_broke_unms/

      posted in Water Closet
      dbeatoD
      dbeato
    • RE: Anyone hosting your own S3 bucket?

      @travisdh1 Are you using a Scale Cluster or just a straight made up cluster of your own?

      posted in IT Discussion
      dbeatoD
      dbeato
    • RE: Anyone hosting your own S3 bucket?

      @travisdh1 I haven't done so, It would be interesting to review that option.

      posted in IT Discussion
      dbeatoD
      dbeato