SQL Server Installation for a Distributed Availability Group

I am deploying a SQL Server 2019 Distributed Availability Group. I have created a WSFC at each of my two sites (spanning two servers each). Upon installing SQL Server, it is not clear to me if I should select the “SQL Server Stand-Alone” installation or the “SQL Server Cluster Installation”? I do not wish to deploy a SQL Server Failover Cluster Instance (FCI).

Thank you. J.

installation – Reinstalling Oracle 19c on Windows 10. Fatal Error in Oracle Database Configuration Assistant

I have tried many times to reinstall Oracle 19c. Every time, when I run setup.exe I get an error on the installation step that says [INS-20802] Oracle Database Configuration Assistant Failed. In error, there is said
[FATAL] Error while executing “C:UsersFarrukhDownloadsoracleORACLE_HOMErdbmsadmindbmssml.sql”. Refer to “C:UsersFarrukhDownloadsoraclecfgtoollogsdbcaoracledbmssml0.log” for more details. Error in Process: C:UsersFarrukhDownloadsoracleORACLE_HOMEperlbinperl.exe
Look at the log file “C:UsersFarrukhDownloadsoraclecfgtoollogsdbcaoracleoracle.log” for further details.
Oracle Database Configuration Assistant failed.

When I go to “C:UsersFarrukhDownloadsoracleORACLE_HOMErdbmsadmindbmssml.sql”, there is written CREATE OR REPLACE LIBRARY dbms_sumadv_lib AS ‘C:UsersFarrukhDownloadsoracleORACLE_HOMEbinoraqsmashr.dll’;
/.

When I go to “C:UsersFarrukhDownloadsoraclecfgtoollogsdbcaoracledbmssml0.log”, it’s blank.

I deleted Oracle manually several times. Maybe I did something wrong.
Is it possible to solve this problem?

installation – “General::sysffmpeg: Using a limited version of FFmpeg” won’t go away on Linux (MMA 12.3)

By hacking SystemFiles/Links/FFmpegTools/Kernel/Common.m I managed to get a meaningful error message.

the problem is that Mathematica bundles shared libraries which are incompatible with system shared libraries (ffmpeg -> kerberos -> openssl).

The solution is to rename the offending shared library which forces Mathematica to use the system library.

sudo mv Mathematica/12.3/SystemFiles/Libraries/Linux-x86-64/libcrypto.so.1.1 Mathematica/12.3/SystemFiles/Libraries/Linux-x86-64/libcrypto.so.1.1.backup

Restart the kernel and you should be ok.

$VideoEncoders("MP4")((All, 1));
FFmpegTools`$SystemFFmpegQ
True

How to send all theme_mod customizer default values to the database upon theme installation?

I’m building a new theme with many customizer settings, which all have default values.

I need these default values to be sent to the database immediately upon theme installation, so that they appear on the front end of the website.

Is there a simple way to do this?

windows – Cant finish a win10 boot installation on HP 630 Laptop

I am trying to re install windows 10 on a hp 630 laptop that I bought and when I was in the old install and I was trying to start the setup, I was trying to login to the bios and change the boot order but as soon as I get to the bios I was unable to use the keyboard. So I runned the setup from the this pc and the format finished and then I went to the last stages but there was a message saying that for some reason it was impossible to open the fresh setup and it has to reboot, connect to wifi, update and could be fixed. the laptop did that around 10 times with no result then I tried to reset the pc from advanced options and with the option to erase all data the installation was finished on 30% and when I tried to keep the files and reset the pc I was prompt to a defaultuser0 with a password which I don’t have. Do anyone know how can give life to this laptop again?

thanks

installation – Install Drupal 9 on Ubuntu Server LTS 20.04: Any improvements to Article?

Used HP Smart Start to establish Raid1
Installed Ubuntu Server LTS 20.04 23/07/2021
Language: English
Keyboard: English(US) English(US) - English(US,Alt,Intl)
Network: enp3s4f1 IPv4
    Subnet 192.168.2.0/24
    Address 192.168.2.3
    Gateway 192.168.2.1
    Name Servers 203.109.191.1, 203.118.191.1, 203.96.152.4, 203.96.152.12, 8.8.8.8, 8.8.4.4
User:   Name Kevin
    Name Server kgwebsite
    User Name kevin
    Password
Installed OpenSSH
Import keys No
Installed Powershell
Reboot
$sudo passwd root
Cntl-D
# cd /
# apt purge cloud-init -y
# rm -Rf /etc/cloud
# apt remove open-iscsi
# apt autoclean && autoremove
# reboot
# apt install net-tools
# ifconfig -a
# apt install ntp
# ntpq -p
# mkdir /media/usb
# apt install unzip zip usbmount gpm
# apt install tasksel
# systemctl enable --now mysql
# systemctl enable --now apache2
# mysql -u root -p (entered pwd)
Cntl-L (clear screen)
# ufw app list
# ufw allow in "√Ąpache"
# ufw allow in "OpenSSH"
# ufw status
# ufw enable
Browser: http://192.168.2.3 (output "Apache Default Page"
# reboot
# nano /etc/sysctl.conf (Lookout for 100's of "i2c i2c-1 sendbytes" in console before log in)
    # Uncomment the following to stop low-level messages on console
kernel.print = 3 4 1 3
Cntl-O Cntl-X
# apt install mc
    Menu -> "Left -> Listing format"
    Enter User "full name:30 owner group perm space size space mtime space name"
    Menu "Options -> Panel options -> Auto Save Panels Setup" x
    F10
# nano /root/.screenrc
    "defscroll 5000"
Browser helpful: https://computingforgeeks.com/how-to-install-drupal-cms-on-ubuntu-linux/
# service mysql status ("active (running)")
# mysql_secure_installation
    VALIDATE PASSWORD no
    Enter root passwd
    Remove anonymous user yes
    Disallow root login remotely no
    Remove test databas yes
    Reload privilege tables yes
    All done exit
# mysql -u root
>UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root';
>FLUSH PRIVILEGES;
>exit;
# mysql_secure_installation
    VALIDATE PASSWORD no
    Enter root passwd
    All done exit
# mysql -u root -p (entered pwd accepted)
>REM DROP USER 'drupal'@'localhost';
>REM DROP DATABASE drupal;
>CREATE DATABASE drupal;
>CREATE USER 'drupal'@'localhost' IDENTIFIED BY 'Str0ngDrupaLP@SS';
>GRANT ALL ON drupal.* TO 'drupal'@'localhost';
>FLUSH PRIVILEGES;
>exit;
# cd /var/www
# mkdir rescuerobot
Windows Notepad++
<VirtualHost *:80>
     ServerName rescuerobot.org
     ServerAlias www.rescuerobot.org
     ServerAdmin admin@rescuerobot.org
     DocumentRoot /var/www/rescuerobot/web/

     CustomLog ${APACHE_LOG_DIR}/access.log combined
     ErrorLog ${APACHE_LOG_DIR}/error.log

      <Directory /var/www/rescuerobot/web>
            Options Indexes FollowSymLinks
            AllowOverride All
            Require all granted
            RewriteEngine on
            RewriteBase /
            RewriteCond %{REQUEST_FILENAME} !-f
            RewriteCond %{REQUEST_FILENAME} !-d
            RewriteRule ^(.*)$ index.php?q=$1 (L,QSA)
   </Directory>
</VirtualHost>
Menu -> Edit -> EOL Conversion (to Unix (LF)
Saved rescuerobot.conf to USB stick
# lsblk
# mount /dev/sdb1 /media/usb
# ls /media/usb
# cp -av /media/usb/rescuerobot.conf /etc/apache2/sites-available
# umount /media/usb
# apt install php-{cli,fpm,json,common,mysql,zip,gd,intl,mbstring,curl,xml,pear,tidy,soap,bcmath,xmlrpc}
# nano /etc/php/7.4/apache2/php.ini
    enter: memory_limit = 256M
    enter: date.timezone = Pacific/Auckland
    uncomment:  extension = openssh
            extension = curl
            extension = gd2
            extension = mbstring
    Cntl-O Cntl-X
# a2enmod rewrite
# apachectl -t
# a2dismod mpm_event
# a2enmod mpm_prefork
# a2enmod php7.4
# a2ensite rescuerobot (must copy rescuerobot.conf to sites-enabled)
# nano /etc/apache2/apache2.conf
    #Global configuration
    ServerName kgdomain.kgwebsite
# a2dissite 000-default (check sites-available and sites-enabled)
# apache2ctl configtest
# systemctl restart apache2
# mkdir /var/www/rescuerobot/web
# cp -av /media/usb/info.php /var/www/rescuerobot/web
Browser: http://192.168.2.3/info.php (Works!)
# rm -Rv /var/www/rescuerobot/*
Windows Notepad++ kginstall
Browser helpful: https://getcomposer.org/download/
php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
php -r "if (hash_file('sha384', 'composer-setup.php') === '756890a4488ce9024fc62c56153228907f1545c228516cbf63f885e036d37e9a59d27d63f46af1d4d07ee0f76181c7d3') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"
php composer-setup.php
php -r "unlink('composer-setup.php');"
# cp -av /media/usb/kginstall /var/www
# cd /var/www
# ./kginstall
# mkdir bin
# cp -av composer.phar ./bin
# ./bin/composer.phar create-project drupal/recommended-project:9.2.2 rescuerobot
# ./bin/composer.phar require drush/drush
# mkdir /var/www/rescuerobot/web/sites/default/files
# chmod drwxrwxr-x files
# cp -av default.settings.php settings.php
Browser: http://192.168.2.3/core/install.php (resolve Requirements problem: e.g. File System) find small link/button at bottom of the web page "Try again"
# cd /var/www/rescuerobot
# chown -R root:www-data .
"Try again"
Install completed.

None of the above is guaranteed to be correct and complete. The mysql script has been modified to run on mysql 8. Please treat this article as a guide. Any advice or corrections would be much appreciated.
Kevin.

magento2 – Magento 2.4 Installation issue (setup not working)

Actually when you setup mangento, you need to point magento to pub directory.

Now that you are using localhost and you haven’t used virtual host, you need to open your project with http://localhost/magento/m24/pub/

For images and CSS, access your database and you need to update table core_config_data
execute following commands:

UPDATE core_config_data SET `value`='http://localhost/magento/m24/pub/' WHERE path='web/unsecure/base_url';
UPDATE core_config_data SET `value`='http://localhost/magento/m24/pub/' WHERE path='web/secure/base_url';
UPDATE core_config_data SET `value`='http://localhost/magento/m24/pub/media/' WHERE path='web/unsecure/base_media_url';
UPDATE core_config_data SET `value`='http://localhost/magento/m24/pub/media/' WHERE path='web/secure/base_media_url';

Flush cache at the end

Hope this will resolve the issue

amazon ec2 – Automating cloudwatch agent installation for multiple arch types

I need to automate cloudwatch agent installation on new and existing instances created in EC2. We have a mix x86_64 and arm64 arch type vms as well different OSes(Ubuntu/Amazon Linux).

I found Chef cookbooks(https://github.com/gp42/aws_cloudwatch) and Ansible plays(https://github.com/christiangda/ansible-role-amazon-cloudwatch-agent) that do the install and config, and I can provide my config file for the agent

But going through the code both only support x86_64 endpoints.
I checked AWS System manager which also supports installing cloudwatch agent package however they require an additional SSM agent to be installed first. That seems like an unnecessary overhead.

Is there a broader automation either in chef or ansible or any aws tool that covers multiple os and arch type to install cloudwatch agent?

My other alternative is to modify the cookbook and update vars to include download links for arm64 installers listed at https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitoring/download-cloudwatch-agent-commandline.html

Unable to enter WordPress installation page

When trying to access the initial WordPress installation URL at "http://ip/wordpress" instead of the installation page a "wordpress" directory with files is shown.

How to access the install page?

[WTS] Host.co.in | 25% OFF SSL Certificate | Wildcard, Free Installation | 24/7 Support

Host.co.in was founded in 2005 and offered High Quality, Reliable, and Affordable Web Hosting Services in India. We are a fast-growing and wildly successful web hosting company focused on delivering high-performance, secure IT solutions and services.

For those webmasters, who are looking for Cheap Web Hosting, Host.co.in is the Best Solution. With Host.co.in, stand apart in the sphere of World Wide Web with hosting for all your business needs enabling you to undertake smooth execution of your core business.

Quote:

25% OFF on Digital SSL Certificate Plans, Use Code SSL25 Offer ends on 31’July 2021


Below is the list of Digital SSL Certificate Plans:

Alpha SSL

• Grate For Personal Website
• Standard Browser Padlock
• Product Feature
• Domain-Level Validation
• Secures Main Domain
• Secures www and non-www
• 2048-bit Encryption

>>>> Price ₹974/Year. With using code SSL25 | Buy Now

Domain SSL

• Our Best Selling SSL Cart
• Standard Browser Padlock
• Product Feature
• Domain-Level Validation
• Secures Main Domain
• Secures www and non-www
• 2048-bit Encryption

>>>> ₹3524/Year. With using code SSL25 | Buy Now

Organisation SSL

• With Organisation Validation
• Standard Browser Padlock
• Product Feature
• Domain-Level Validation
• Secures Main Domain
• Secures www and non-www
• 2048-bit Encryption

>>>> Price ₹5,699/Year. With using code SSL25 | Buy Now

Extended SSL

• With Organisation Validation
• Standard Browser Padlock
• Product Feature
• Domain-Level Validation
• Secures Main Domain
• Secures www and non-www
• 2048-bit Encryption

>>>> Price ₹23,099/Year.[/COLOR] With using code SSL25 | Buy Now

Alpha SSL Wildcard

• Grate For Personal Website
• Standard Browser Padlock
• Product Feature
• Domain-Level Validation
• Secures Main Domain
• Secures Sub Domain
• Secures www and non-www
• 2048-bit Encryption

>>>> Price ₹4,649/Year. With using code SSL25 | Buy Now

Domain SSL Wildcard

• Our Best Selling SSL Cart
• Standard Browser Padlock
• Product Feature
• Domain-Level Validation
• Secures Main Domain
• Secures Sub Domain
• Secures www and non-www
• 2048-bit Encryption

>>>> Price ₹12,824/Year. With using code SSL25 | Buy Now

Organisation SSL Wildcard

• Our Best Selling SSL Cart
• Standard Browser Padlock
• Product Feature
• Domain-Level Validation
• Secures Main Domain
• Secures Sub Domain
• Secures www and non-www
• 2048-bit Encryption

>>>> Price ₹15,347/Year. With using code SSL25 | Buy Now

Why CHOOSE US?

• Complete Control
• Host multiple websites
• Strong Platform
• Private Server Hosting
• Exceptional Performance
• Managed Servers
• Optional Control Panel
• 24×7 Live Support

Contact information:

In case you have any questions, you can contact the sales department by initiating a chat or by dropping an email to sales@host.co.in or call on 1800 212 6630.

.