Linux and Windows Servers Specialist Solutions

Linux Documentation Project

noreply@blogger.com (linwintech.blogspot.com) — Wed, 07 Feb 2024 14:37:00 +0000

Sites	Websites
tldp.org	LDP website
Guides	Document Format
Linux Installation and Getting Started Guide	DVI, PostScript, LaTeX, PDF, and HTML
Linux User’s Guide	DVI, PostScript, HTML, LaTeX, and PDF
Linux System Administrator’s Guide	PostScript, PDF, LaTeX, and HTML
Linux Network Administrator’s Guide	DVI, PostScript, PDF, and HTML
Linux Programmer’s Guide	DVI, PostScript, PDF, LaTeX, and HTML
The Linux Kernel	HTML, LaTeX, DVI, and PostScript
Linux Kernel Hacker’s Guide	DVI, PostScript, and HTML
Linux HOW-TOs	HTML, PostScript, SGML, and DVI
Linux FAQs	HTML, PostScript, and DVI
Linux Man Pages	Man page

Linux Information and News Sites

noreply@blogger.com (linwintech.blogspot.com) — Wed, 07 Feb 2024 11:24:00 +0000

URL	Site Description
tldp.org	Linux Documentation Project
lwn.net Linux	Weekly News
linux.com	Linux.com
linuxtoday.com	Linux Today
linuxplanet.com	LinuxPlanet
linuxfocus.org	Linux Focus
linuxjournal.com	Linux Journal
linuxgazette.com	Linux Gazette
linux.org	Linux Online
slashdot.org	Linux forum
opensource.org	Open source information

Linux Programming Sites

noreply@blogger.com (linwintech.blogspot.com) — Wed, 07 Feb 2024 11:18:00 +0000

URL	Site Description
gnu.org	Linux compilers and tools (gcc)
java.sun.com	Sun Java website
perl.com	Perl website with Perl software for Linux
developer.gnome.org	Website for GNOME developers
developer.kde.org	KDE library for developers

Network Server and Security Software

noreply@blogger.com (linwintech.blogspot.com) — Sun, 28 Jan 2024 11:24:00 +0000

URL	Software Description
apache.org	Apache web server
vsftpd.beasts.org	Very secure FTP server
proftpd.org	ProFTPD FTP server
isc.org	Internet Software Consortium: BIND, INN, and DHCPD
sendmail.org	Sendmail mail server
postfix.org	Postfix mail server
squid-cache.org	Squid proxy server
samba.org	Samba SMB (Windows network) server
netfilter.org	IP Tables firewall
web.mit.edu/kerberos/www	Kerberos network authentication protocol
openssh.com	Open Secure Shell (free version of SSH)

Third-Party Linux Software Archives, Repositories, and Links

noreply@blogger.com (linwintech.blogspot.com) — Sun, 28 Jan 2024 04:25:00 +0000

URL	Site Description
sourceforge.net	Lists open-source software development sites for Linux applications and software repositories
jpackage.org	Repository for Java applications and tools
gnomefiles.org	GNOME applications
kde-apps.org	KDE software repository
freshmeat.net	New Linux software
rpmfind.net	RPM package repository
gnu.org	GNU archive
happypenguin.org	Linux Game Tome
linuxgames.com	Linux games
fluendo.com	Gstreamer (GNOME) multimedia licensed codecs and plug-ins (MP3, MPEG2, and so on)

Linux Distribution and Kernel Sites

noreply@blogger.com (linwintech.blogspot.com) — Fri, 26 Jan 2024 02:37:00 +0000

URL	Site Description
redhat.com	Redhat Linux
fedoraproject.org	Fedora Linux
centos.org	Centos Linux
opensuse.com	openSUSE Linux
debian.org	Debian Linux
ubuntu.com	Ubuntu Linux
mepis.org	Mepis Linux
gentoo.org	Gentoo Linux
turbolinux.com	Turbo Linux
knoppix.org	Knoppix Linux
linuxiso.com	CD-ROM ISO images of Linux distributions
distrowatch.com	Detailed information about Linux distributions
kernel.org	Linux kernel

Cloud Cost Optimization: A Guide to Reducing Your Cloud Bill

noreply@blogger.com (linwintech.blogspot.com) — Thu, 10 Aug 2023 03:10:00 +0000

Cloud computing has revolutionized the way businesses operate, providing a scalable and cost-effective way to deploy applications and services. However, cloud computing can also be expensive, and it's important to take steps to optimize your cloud costs.

Cloud cost optimization is the process of reducing your cloud spending while maintaining or improving your level of service. There are a number of different strategies that you can use to optimize your cloud costs, including:

Rightsizing your resources: This involves ensuring that you are only provisioning the resources that you need, and that you are not over-provisioning.
Using reserved instances: Reserved instances are a type of cloud resource that offer a discounted price if you commit to using them for a certain period of time.
Eliminating unused resources: This involves identifying and removing any cloud resources that you are no longer using.
Automating your cloud billing: This can help you to track your cloud spending and identify any areas where you can save money.

There are a number of different tools and services that can help you to optimize your cloud costs. These include:

Cloud cost management tools: These tools can help you to track your cloud spending, identify areas where you can save money, and automate your cloud billing.
Cloud optimization services: These services can help you to rightsize your resources, use reserved instances, and eliminate unused resources.

Cloud cost optimization is an ongoing process, and it's important to regularly review your cloud spending and make adjustments as needed. By following the strategies outlined above, you can save money on your cloud costs and improve your overall cloud computing ROI.

Here are some additional tips for cloud cost optimization:

Use a cloud cost calculator: This can help you to estimate your cloud costs before you make a commitment.
Set up alerts: This will help you to be notified if your cloud spending exceeds a certain threshold.
Involve your team: Cloud cost optimization is a team effort, so make sure that everyone is involved in the process.
Be patient: Cloud cost optimization takes time, so don't expect to see results overnight.

By following these tips, you can optimize your cloud costs and save money on your cloud computing bill.

Here are some case studies of organizations that have successfully optimized their cloud costs:

Netflix: Netflix was able to save $100 million per year by optimizing its cloud costs.
Spotify: Spotify was able to save $50 million per year by using reserved instances.
LinkedIn: LinkedIn was able to save $30 million per year by eliminating unused resources.

These are just a few examples of how organizations have successfully optimized their cloud costs. By following the strategies outlined in this article, you can too.

Cloud Computing: The Future of IT

noreply@blogger.com (linwintech.blogspot.com) — Thu, 10 Aug 2023 03:08:00 +0000

Cloud computing is the delivery of computing services—including servers, storage, databases, networking, software, analytics, and intelligence—over the Internet (“the cloud”).

With cloud computing, businesses can avoid the upfront costs of buying and maintaining hardware and software. They can also scale their IT resources up or down as needed, without having to worry about overprovisioning or underprovisioning.

There are many benefits to cloud computing, including:

Cost savings: Cloud computing can help businesses save money on IT costs.
Scalability: Cloud computing can be scaled up or down as needed, so businesses don't have to worry about overprovisioning or underprovisioning.
Flexibility: Cloud computing is flexible, so businesses can choose the services they need and pay only for what they use.
Security: Cloud computing providers offer a high level of security, so businesses can be confident that their data is safe.

Cloud computing is the future of IT. It is more efficient, more scalable, and more flexible than traditional IT. If you are not using cloud computing yet, you are missing out on a great opportunity to save money and improve your business.

Here are some of the specific benefits of cloud computing for businesses:

Reduced IT costs: Cloud computing can help businesses reduce their IT costs by up to 50%. This is because businesses do not have to purchase and maintain their own hardware and software. They can also avoid the costs of hiring and training IT staff.
Increased agility: Cloud computing can help businesses increase their agility by making it easier to scale their IT resources up or down as needed. This can be helpful for businesses that experience sudden spikes in demand.
Improved security: Cloud computing providers offer a high level of security, so businesses can be confident that their data is safe. This is because cloud providers have the resources to invest in security and they are constantly monitoring their systems for threats.

If you are considering using cloud computing for your business, here are some things to keep in mind:

Choose the right cloud provider: There are many different cloud providers available, so it is important to choose one that is right for your business. Some factors to consider include the type of services you need, the level of security you require, and your budget.
Start small: You don't have to move all of your IT to the cloud at once. You can start by moving a few key applications or services and then gradually move more to the cloud over time.
Educate your staff: Cloud computing can be a new concept for some businesses, so it is important to educate your staff on how to use it. This will help them to get the most out of the cloud and avoid any security risks.

Cloud computing is a powerful tool that can help businesses to save money, improve agility, and improve security. If you are not using cloud computing yet, you are missing out on a great opportunity to improve your business.

Do you want to learn more about cloud computing?

If you are interested in learning more about cloud computing, there are many resources available online and in libraries. Also, Kindly Bookmark this Blog to learn more about Technology. You can also find cloud computing courses offered by many colleges and universities.

I hope this article has caught your interest in cloud computing. If you have any questions, please feel free to leave a comment below.

Types of Cloud

noreply@blogger.com (linwintech.blogspot.com) — Thu, 10 Aug 2023 03:00:00 +0000

There are three cloud types, which are mentioned below:

Public Cloud: Here, the resources and services that are provided by third-party service providers are available to customers via the Internet.
Private Cloud: In a private cloud, the resources and services are managed in-house or by third parties exclusively for a particular organization.
Hybrid Cloud: It is a combination of public and private cloud types. The decision whether to run the services on public or private networks depends on some parameters such as the sensitivity of the data and applications, industry certifications, required standards, etc.

Cloud Computing

noreply@blogger.com (linwintech.blogspot.com) — Thu, 10 Aug 2023 02:58:00 +0000

It is an internet-based computing service in which various remote servers are networked to allow centralized data storage and online access to computer services and resources.

"Ghost" monitors in Windows 10

noreply@blogger.com (linwintech.blogspot.com) — Tue, 07 Jan 2020 06:53:00 +0000

While using windows 10 operating system, sometimes you might see unnecessary monitors attached to your system in "Display Settings".

Steps to reproduce: Right click on your Desktop wallpaper > Click on "Display Settings"

Here you can see many monitors as follows. Normally these monitors are not attached to the system rather these popped up automatically.

What can these ghost monitor cause ?

If these 'Ghost' monitors are automatically enabled then if you are using 'Extended/Second Screen only' display then at sometimes the primary screen might alter up to the 'Ghost' monitors and thus you might not be able to see the screen. This will create confusion in setting up the display.

What is the root cause?

Intel(R) HD Graphics Driver is messed up.
Hyper-V is enabled in your windows 10

There might be different root causes for this, which can be known after detailed investigation.

What can be done?

If such monitors are displayed you can follow the following steps:

Click on "Start" > Type "Run"
"Run" window will popup

In the "Run" window, Type "devmgmt.msc" and press "Enter/OK"

After that the "Device Manager" Screen pops up:
Expand the "Display Adapters" and Right Click on the "Intel(R) HD Graphics xxxx" and then you can select the "Uninstall Device"
After clicking "Uninstall device" you can see the following screen which will assist in uninstalling the device.

Check the "Delete the driver software for this device" and then click on "Uninstall". This will uninstall the currently installed Intel(R) HD Graphics driver.

After performing the above steps kindly "Reboot" your machine. After rebooting Windows 10 will automatically resintall the Intel(R) HD Graphics driver and thus the 'Ghost' Screen will be fixed.

NOTE: Please note that the above steps worked for me. Kindly perform the above steps only if you are a technical person. I am not responsible for any brick in your device.

Recover Unallocated Partition of Hard disk

noreply@blogger.com (linwintech.blogspot.com) — Sat, 01 Jun 2019 14:59:00 +0000

Today was a hectic day for me. Today suddenly while accessing my External hard disk in latest Windows 10 May 2019 update the disk was not initialising. While trying to initialise disk with GPT/MBR from the "Disk Management" suddenly my hard disk started displaying as "Unallocated".

It was such a frustrating situation for me as I was worried about loosing my data. I have tried many solutions to fix it out but unfortunately it was increasing my frustration. At last, I found a freeware named as "TestDisk" which saved me. Initially while running this command line utility, I was unable to understand the processing even if it had pretty easy instructions but later I was able to fix my hard disk access.

In the world of data recovery it happens that your Operating System stops detecting your external hard disk. I have tried to use Ubunut Live CD to access the hard disk but it also shows me the same issue as on Windows.

In my case it was corrupted/damaged partition table, which is the reason the Operating system stopped detecting the External hard disk partition properly. To make it easier in working with TestDisk command line utility, following are the steps to recover the data, hope this helps you guys:

Testdisk https://www.cgsecurity.org/wiki/TestDisk

In order to recover a damaged partition table, kindly follow the following steps:

Start testdisk_win.exe
Create a new log file.
Scroll down to drive which contains the damaged partition table > Proceed
Intel/EFI GPT (Select the partition table type - usually the default value is the correct one as TestDisk auto-detects the partition table type.) > Analyse > Quick Search
Should TestDisk search for partition created under Vista ? > Y
If the lost partition was a primary partition, move arrows to change * to P and press Enter.[P may already be there, if it is, still go to the next step to 'Write partition table'.]
Move arrows to Write and press Enter.
Write partition table, confirm ? (Y/N) > Y
You will have to reboot for the change to take effect.

To recover individual files / individual directories from a hard drive which cannot display them in Windows because of a damaged partition table:

Copy Testdisk to hard drive with enough space to recover the lost files/directories then start testdisk_win.exe
Create a new log file
Scroll down to drive which contains the files/directories to recover > Proceed
Intel/EFI GPT (Select the partition table type - usually the default value is the correct one as TestDisk auto-detects the partition table type.) > Analyse > Quick Search
Should TestDisk search for partition created under Vista ? > Y
Instead of moving arrows to get to the letter P, physically press key P on your keyboard.This lists the files and directories
Now use arrows to move down to select any file or directory and press C on keyboard to copy selected file or directory.

or

To copy all files and directories, move the arrow to the top marked with one dot: .Then press C on keyboard and all files and directories will be copied to the location where you ran TestDisk from.

Use instructions above to recover files/directories from a hard drive with a damaged partition table. If partitions already exist, it may be recovered to an image file. To create an image of the entire partition:

Copy Testdisk to hard drive with enough space to store the image of the partition
Create a new folder inside which you want to save the image.dd file then start testdisk_win.exe
Create a new log file
Scroll down to drive which contains the partition to copy > Proceed
Intel/EFI GPT (Select the partition table type - usually the default value is the correct one as TestDisk auto-detects the partition table type.) > Advanced > Scroll down to partition to recover
Use right arrow to get to Image Creation > Enter
Select where to store the image.dd file > Press Enter then press the Y key on keyboard.
File image.dd will contain the recovered partition.

You can use freeware such as OSFMount to mount image.dd files to access files inside them directly.

MySQL and PostgreSQL identical commands

noreply@blogger.com (linwintech.blogspot.com) — Tue, 28 May 2019 08:29:00 +0000

Both MySQL and PostgreSQL are databases which are used. There are many similar commands and functionalities used in both with some differences. Users working with both are always confused with the equivalent commands that are used in both SQL’s. The following is a cheat sheet which will help users:

MySQL (mysql)	Postgres (psql)	Extra Notes
\e	\e	Edit the buffer with external editor. Postgres also allows \e filename which will become the new buffer
\g	\g	Send current query to the server
\h	\h	Gives help — general or specific
\n	\pset pager off	Turns the pager off. For PGSQL, the pager is only used when needed based on number of rows; to force it on, use \pset pager always
\d string	No equivalent	Changes the delimiter
\c	\r	Clears the buffer
\p	\p	Print the current buffer
\q or Quit or exit or [ctrl-c]	\q	Quit the client mysql> or psql>
\r [dbname] [dbhost]	\c [dbname] [dbuser]	Reconnect to server
\s	No equivalent	Status of server. Some of the same info is available from the pg_settings table
\u dbname or Use [db_name]	\c dbname	Connect to a database or use a different database.
\w	No equivalent	Do not show warnings. Postgres always shows warnings by default
\C charset Change the charset	\encoding encoding Change the encoding	Run \encoding with no argument to view the current one
\t Stop teeing output to file	No equivalent	However, \o (without any argument) will stop writing to a previously opened outfile
\G	\x	Display results vertically (one column per line). Note that \G is a one-time effect, while \x is a toggle from one mode to another. To get the exact same effect as \G in Postgres, use \x\g\x
\R string	\set PROMPT1 string	To Change the prompt. Note that the Postgres prompt cannot be reset by omitting an argument. A good prompt to use is:\set PROMPT1 '%n@%`hostname`:%>%R%#%x%x%x '
\P pagername	Environment variable PAGER or PSQL_PAGER	Change the current pager program
\. filename	\i filename	Include a file as if it were typed in.
\T filename	No direct equivalent	Sets the tee output file. Postgres can output to a pipe, so you can do: \o \| tee filename
\W	No equivalent	To Show warnings. Postgres always show warnings by default
\?	\?	Help for Internal Commands.
\#	No equivalent	To rebuild tab-completion hash. Not needed in Postgres, as tab-completion in Postgres is always done dynamically
\! command	\! command	To execute a shell command. If no command is given with Postgres, the user is dropped to a new shell (exit to return to psql)
Timing is always on	\timing Toggles timing on and off
No equivalent	\t Toggles “tuple only” mode	This shows the data from select queries, with no headers or footers
show tables; List all tables	\dt or /dt+	Many also use just \d, which lists tables, views, and sequences
desc tablename;	\d tablename	Display information about the given table.
show index from tablename;	\d tablename	Display indexes on the given table. The bottom of the \d tablename output always shows indexes, as well as triggers, rules, and constraints
show triggers from tablename;	\d tablename	Display triggers on the given table. The bottom of the \d tablename output always shows indexes, as well as triggers, rules, and constraints
show databases;	\l	List all databases
No equivalent	\dn	To List all schemas. MySQL does not have the concept of schemas, but uses databases as a similar concept
select version();	select version();	Show backend server version
select now();	select now();	Show current time. Postgres will give fractional seconds in the output
select current_user;	select current_user;	Show the current user.
select database();	select current_database();	Show the current database.
show create table tablename;	No equivalent	Output a CREATE TABLE statement for the given table. The closest you can get with Postgres is to use pg_dump --schema-only -t tablename
show engines;	No equivalent	To List all server engines. Postgres does not use separate engines
CREATE object ... Create an object: database, table, etc.	CREATE object ... Mostly the same	Most CREATE commands are similar or identical. Lookup specific help on commands (for example: \h CREATE TABLE)
SHOW INDEX FROM some_table; Show indices of some_table (in case of MySQL)	\di Show all indices of database (PostgreSQL)	Display Indices.
mysqldump	pg_dumpall	pg_dumpall is designed to dump all the databases and invokes pg_dump to do it. It can also be used to dump global values like roles and tablespaces. Example with mysql: mysqldump –all-databases > /path/to/file.sql Example with postgres: pg_dumpall > /path/to/file.sql
mysqldump	pg_dump	pg_dump is used for dumping individual databases. Example with mysql: mysqldump mydatabase > /path/to/file.sql Example with postgres: pg_dump mydatabase > /path/to/file.sql
innodb_top	pg_top	innodb_top does not ship with mysql and is a third-party executable. It shows you things like inserts per second, updates per second, transactions per second and gives a good overview as to what is going on with the server pg_top shows similar things but is laid out more similarly to the native linux “top” program.
mysql	psql	These commands allow to access the CLI utility.
Passing query with mysql (-e for execute): *mysql -e “select from table_name;”**	Passing query with postgres (-c for command): *psql -c “select from table_name;”**	Passing sql into the utility.
show databases;	\l or \list	This lists the databases on the server instance you are connected to or that you have access to.
*select from mysql.user;**	*select from pg_user;** or\du	Shows all users and their global permissions. Postgres lists the permissions as a comma separated string under a filed called attributes. Mysql shows a boolean value for each of the possible permissions.
show full processlist;	*select from pg_stat_activity;**	This will show all the queries that are currently running and how long they have been running for.
show variables;	show all;	This will show all the current values for the variables. Postgres even offers a brief description of what each variable is.
show engine innodb status\G	SELECT * FROM pg_stat_activity; SELECT * FROM pg_stat_database; SELECT * FROM pg_stat_user_tables; SELECT * FROM pg_stat_user_indexes; SELECT * FROM pg_locks;	There is no central place in postgres to get all the information obtained by running show engine innodb status in mysql. There are several queries you can run to get roughly equivalent data though.
show slave status\G	select * from pg_stat_replication; select now() – pg_last_xact_replay_timestamp() AS replication_delay;	Shows replication information. On idle write masters you can errantly see replication report as behind or lagging. This is showing you the current timestamp minus the timestamp of the last item applied on the slave. If the master hasn’t written anything, the slave has not applied anything and can show you that it is behind. It is recommended to use a written timestamp from cron every minute to gauge replication. This achieves 2 things, it will guarantee regular writes to the master which will replicate to the slave, and monitoring can look to the timestamp in a location to know if the server is behind.
stop slave; start slave;	select pg_xlog_replay_pause(); select pg_xlog_replay_resume();	Pause/resume/stop/start replication on the slave node
SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW';	\dv \dv schema_name.*	List views
SHOW [EXTENDED] [FULL] {COLUMNS \| FIELDS} {FROM \| IN} tbl_name [{FROM \| IN} db_name] [LIKE 'pattern' \| WHERE expr]	\dt+ \dv+ \d+ table_name Get extended information (add + to any command)	In MySQL, The optional EXTENDED keyword causes the output to include information about hidden columns that MySQL uses internally and are not accessible by users.The optional FULL keyword causes the output to include the column collation and comments, as well as the privileges you have for each column.

Feel free to add in a comment if some commands are not listed. I have not listed the other queries like SELECT, ALTER, DELETE and etc as most of the syntax are similar just follow the documentations mentioned in Postgresql and Mysql websites

MIUI 10 Second batch Stable upgrade Rolling Out

noreply@blogger.com (linwintech.blogspot.com) — Thu, 08 Nov 2018 06:01:00 +0000

It is a good news for MIUI users with 4 year old Models as Xiaomi MIUI updates will be available for them according to the reports.

The MIUI 10 update is now available for 39 smartphones including the 4-year old Xiaomi Mi 4 handset. The MIUI 10 is the enhanced version of the MIUI 9 that brings support for gestures and full experience, AI enhancements for photography, improved UI and more. This upgrade adds a new natural sound system, starting with a variety of notification sounds, helping healthy millet white noise and anthropomorphic dynamic wake-up bells to create a new sound experience.

May 31: Xiaomi Officially released the MIUI 10 system.

June 9: Xiaomi officially launched the development version of the batch upgrade.

September 10 : Xiaomi officially launched the MIUI10 stable version upgrade.

The MIUI 10 upgrade is being provided by Xiaomi in batches.

First batch: In September this batch received the MIUI 10 upgrade and the phones supported were as following:

Mi series

Mi 8, Mi 8 Explorer Edition, Mi 8 SE, Mi 8 Lite, Mi MIX 2S, Mi MIX 2, Mi MIX, Mi Max 3, Mi 6, Mi 6X, Mi Note 2 and Mi 5.

Redmi and Redmi Note series

Xiaomi Redmi 6 Pro, Redmi 6 and Redmi 6A, Redmi S2, Redmi 5, and Redmi Note 5.

Second Batch: The second batch which is being released this month includes the following phones, which are expected to receive the MIUI 10 upgrade:

Mi Series:

Mi 4, Mi 4C, Mi 4S, Mi 5s, Mi 5s Plus, Mi Max, Mi Max Prime, Mi Max 2

Redmi and Redmi Note Series:

Redmi 4, Redmi 4 Prime, Redmi 4A, Redmi 4X, Redmi 5A, Redmi 5 Plus, Redmi Pro, Redmi Note 3, Redmi Note 4, Redmi Note 4X, Redmi Note 4X MediaTek variant, Redmi Note 4X Qualcomm variant, Redmi Note 5A, Redmi Note 5A Prime

According to Chinese media the second batch phones would start receiving the Stable Rom yesterday onwards. It looks like the update may only be available in China for the time being. For the global phones we need to wait a bit more longer.

Note: Please use this for information purpose only. While the Information is considered to be true and correct at the date of publication, changes in circumstances after the time of publication may impact on the accuracy of the Information. Linwintech.blogspot.com is not in any way liable for the accuracy of any information here and printed and stored or in any way interpreted and used by a user.

The Information contained in this site includes information derived from various third parties just for the sake of sharing information.

"ADXTaskPane" popping out of outlook main window

noreply@blogger.com (linwintech.blogspot.com) — Thu, 01 Nov 2018 03:47:00 +0000

Symptom:

Whenever Outlook is opened, the Azure Information Protection (AIP) toolbar pops up in another window named as "ADXTaskPane" other than Outlook windows. Which will look something like following:

When you put your Mouse cursor on the Outlook icon in the Windows Taskbar you can see something like following:

Cause:

This issue is related with Azure Information Protection (AIP) Toolbar compatibility.

Solution:

In Order to resolve the above issue, you can follow the following steps:

Open the Office Application (Here it is Outlook) and navigate to File > Options > General > User Interface optionsYou can see the following option selected:
Select Optimize for compatibility (application restart required)
Restart Office Applications i.e Outlook and other office apps.
Now Verify the issue will be fixed.

Clear all Text boxes and Combo Boxes using a Clear button (VBA)

noreply@blogger.com (linwintech.blogspot.com) — Sat, 27 Oct 2018 09:41:00 +0000

Goto Developers Tab.
Click on "Insert"
Select Button (Form Control)
Right Click on the button created and select "Assign Macro"
Give the Macro Name and select OK.
Then add the following Macro code:

Private Sub CommandButton2_Click()

Dim c As Control

Dim a As Control

For Each c In UserForm1.Controls

    If TypeName(c) = "TextBox" Then

    c.Value = ""

    End If

Next c

UserForm1.TextBox1.SetFocus

For Each a In UserForm1.Controls

If TypeName(a) = "ComboBox" Then

a.Value = ""

End If

Next a

UserForm1.TextBox1.SetFocus

End Sub

Open a User form by clicking a Button in Excel (VBA)

noreply@blogger.com (linwintech.blogspot.com) — Wed, 24 Oct 2018 09:36:00 +0000

Goto Developers Tab.
Click on "Insert"
Select Button (Form Control)
Right Click on the button created and select "Assign Macro"
Give the Macro Name and select OK.
Then add the following Macro code:

Sub Button1_Click()

UserForm1.Show

End Sub

How to filter for null values with Get-ADUser cmdlet

noreply@blogger.com (linwintech.blogspot.com) — Sun, 27 May 2018 11:46:00 +0000

How to filter for null values with Get-ADUser cmdlet using Powershell Active Directory Module

Get-ADUser -Filter {title -notlike "*"}

Fix "System.Object[]" output when exporting to csv

noreply@blogger.com (linwintech.blogspot.com) — Sun, 27 May 2018 11:31:00 +0000

Fix "System.Object[]" output when exporting to csv

export data to csv is sometimes broken because everything that is passed to Export-Csv cmdlet is casted as a string before the export.

one solution is to create a pscustomobject and use -Join operator on the troubling property:

$user = Get-ADUser username -Properties memberof
[pscustomobject]@{
DN = $user .DistinguishedName
GivenName = $user .GivenName
MemberOf = $user .MemberOf -Join ','
Name = $user .Name
SamAccountName = $user .SamAccountName
UserPrincipalName = $user .UserPrincipalName
} | Export-Csv -NoTypeInformation .\user.csv

for a better arrangement Out-String cmdlet can be use in replace of Join operator

$user = Get-ADUser user -Properties memberof
[pscustomobject]@{
DN = $user.DistinguishedName
GivenName = $user.GivenName
MemberOf = ($user.MemberOf | Out-String).Trim()
Name = $user.Name
SamAccountName = $user.SamAccountName
UserPrincipalName = $user.UserPrincipalName
} | Export-Csv -NoTypeInformation .\user.csv

Unhide/Hide Multiple sheets at once in excel using VBA Macro

noreply@blogger.com (linwintech.blogspot.com) — Mon, 09 Oct 2017 10:25:00 +0000

While working on excel, we all face similar situations when we do have multiple worksheets hidden and we spend half of our day to unhide them one by one. Instead of unhiding them one by one we can use the following techniques to unhide them at once.

1. Using VBA immediate window:

The fastest way to make all the sheets visible in Excel is to use a macro (VBA). The following line of VBA code uses a For Next Loop to loop through each sheet in the active workbook and make each sheet visible.

For Each ws In Sheets:ws.Visible=True:Next

You can run this code in the VB Editor’s Immediate Window in three easy steps:

Alt+F11 (opens the VB Editor Window)
Ctrl+G (opens the Immediate Window)
Paste the following line of code in the Immediate Window and press Enter

For Each ws In Sheets:ws.Visible=True:Next

The above line of code loops through all the worksheets in the workbook and sets each sheet’s visible property to “True”. This makes each sheet visible, which is the same as unhiding each sheet.

The colon character “:” used in the code allows you to basically combine multiple lines of code into one line. This makes it possible to run in the Immediate Window because the Immediate Window only evaluates one line of code at a time.

2. Using VBA macro to unhide/Hide multiple sheets:

The following macro is basically the same line of code mentioned in point 1, but it is broken up into multiple lines. This makes it much easier to read and understand.

Sub Unhide_Multiple_Sheets()

Dim ws As Worksheet

For Each ws In ActiveWorkbook.Worksheets

ws.Visible = xlSheetVisible

Next ws

End Sub

The lines in the above code that start with “For” and “Next” represent a For-Next Loop Statement. The first line “For Each ws In ActiveWorkbook.Worksheets” tells the macro to loop through each worksheet in the worksheets collection of the workbook.

That line also references the variable “ws” and sets it to represent the worksheet object. This means that “ws” temporarily represents the current worksheet in the loop.

When the “Next ws” line of code is hit, the macro jumps back up to the first line of code within the loop and evaluates it again. It continues to loop through all the sheets in the workbook’s worksheet collection (Activeworkbook.Worksheets).

We can then use “ws” inside the loop to change the current worksheet’s properties. In this case we are setting the “Visible” property of the sheet to be visible (xlSheetVisible).

The visible property has three different properties to choose from:

xlSheetHidden
xlSheetVeryHidden
xlSheetVisible

You can also set the property to “True”, which works the same as xlSheetVisible.

3. Unhiding Sheets with a Specific Name

Also at times we need to unhide the sheets that contain a specific word.

Lets imagine that the word “xyz” in the sheet name?

We can add a simple IF statement to the macro to only unhide sheets that contain a specific name or text.

Sub Unhide_Sheets_Containing()

Dim ws As Worksheet

For Each ws In ActiveWorkbook.Worksheets

If InStr(ws.Name, "xyz") > 0 Then

ws.Visible = xlSheetVisible

End If

Next ws

End Sub

The InStr function searches for text in a string and returns the position of the first occurrence of the text. It is short for InString, and the function is like the SEARCH or FIND functions in Excel.

So, in this case we are looking for any sheet that contains the word “xyz” in the sheet name. The “ws.name” reference returns the name of the worksheet that is currently being evaluated in the For-Next loop.

So this line “If InStr(ws.Name, “xyz”) > 0 Then” basically says, if the word “pivot” is found in the sheet name then the Instr function will return a number greater than zero. The IF statement will evaluate to True and the next line of code will be run to unhide the sheet.

If the word “xyz” is NOT found in the sheet name, then the IF statement will evaluate to False and the code will skip all lines until it gets to the “End If” line. Therefore, the sheet that is currently being evaluated in the loop will keep its current visible property (visible or hidden).

These macro’s will be more helpful if you are hiding and unhiding sheets every day/week/month for a report. Run the macro to unhide specific sheets when you open the workbook. If you want to re-hide the sheets back then run the same code but change the visible property to xlSheetHidden.

Auto Update Current Date to a Cell in Excel when Double clicked (VBA Macro)

noreply@blogger.com (linwintech.blogspot.com) — Mon, 02 Oct 2017 13:18:00 +0000

Updating today's date to a Cell when double clicked using Mouse.

Follow the link to add the VBA Macro Codes to the Excel.

Add the following Macro Code to the Woksheet Module:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Not Intersect(Target, Range("B:B")) Is Nothing Then
        Cancel = True
        Target.Formula = Date
    End If
End Sub

Values:
B:B -> Is the Column/Row range in which you want the date to appear.

How to create a user in MySQL and grant a permission

noreply@blogger.com (linwintech.blogspot.com) — Tue, 23 Aug 2016 13:36:00 +0000

In MySQL we can have multiple databases created which can be associated with some specific
functions. MySQL is the default database which is created while initial installation of the database. Using the following steps you will be able to create a user for a specific database and also if you want you can assign a password to it.

1. First of all create a user in the MySQL Database after log into it, using the following query:

mysql> CREATE USER 'abcd'@'localhost' IDENTIFIED BY '1qazXSW@';

2. Grant all or specific privileges to the new user and also assign a password as required.

mysql> GRANT ALL PRIVILEGES ON abcd_designs.* TO 'abcd'@'localhost';

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX ON abcd-designs.* TO 'abcd'@'localhost' IDENTIFIED BY 'abcd@123';

3. After performing all the above operations, in-order to tell the server to reload the grant tables, perform a flush-privileges operation. This can be done by issuing a FLUSH PRIVILEGES statement or by executing a mysqladmin flush-privileges or mysqladmin reload command.

A grant table reload affects privileges for each existing client connection as follows:

Table and column privilege changes take effect with the client's next request.
Database privilege changes take effect the next time the client executes a USE db_name statement.

Note:
Client applications may cache the database name; thus, this effect may not be visible to them without actually changing to a different database or flushing the privileges.

Global privileges and passwords are unaffected for a connected client. These changes take effect only for subsequent connections.

If the server is started with the --skip-grant-tables option, it does not read the grant tables or implement any access control. Anyone can connect and do anything, which is insecure. To cause a server thus started to read the tables and enable access checking, flush the privileges.

mysql> FLUSH PRIVILEGES;

If there is a "-" hyphen between the names then we can use backtick to bypass it like `abcd-designs`

Attributes:

Database name = abcd_designs
User name = abcd
Password = abcd@123

Recover MySQL root Password

noreply@blogger.com (linwintech.blogspot.com) — Mon, 22 Aug 2016 13:48:00 +0000

MySQL is an open-source relational database management system(RDBMS).MySQL is a central component of the LAMP open-source web application software stack (and other "AMP" stacks). LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python".

All My SQL databases on a server are always protected by a root password for better security. Server Administrator's have access to such information's for better troubleshooting of any issue. In case's where you forget the My SQL root password, you can use the following method to reset the My SQL root password.

# /etc/init.d/mysql stop

# mysqld_safe --skip-grant-tables &

# mysql -u root

mysql> use mysql;

mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';

mysql> flush privileges;

mysql> quit
# /etc/init.d/mysql stop

# /etc/init.d/mysql start

# mysql -u root -p

How to replace MySQL with MariaDB in cpanel.

noreply@blogger.com (linwintech.blogspot.com) — Sat, 20 Aug 2016 15:11:00 +0000

MariaDB is an enhanced drop-in replacement for MySQL. MySQL 5.1 is compatible with MariaDB 5.1, 5.2 and 5.3. MySQL 5.5 is compatible with MariaDB 5.5.

Make sure to save all existing data just in case there are any issues.

cp -Rf /var/lib/mysql /var/lib/mysql-old

mv /etc/my.cnf /etc/my.cnf-old

Disable all the targets so cPanel no longer handles MySQL updates. The following will mark the versions of MySQL we distribute as uninstalled so they are no longer maintained by cPanel/WHM:

/scripts/update_local_rpm_versions –edit target_settings.MySQL50 uninstalled

/scripts/update_local_rpm_versions –edit target_settings.MySQL51 uninstalled

/scripts/update_local_rpm_versions –edit target_settings.MySQL55 uninstalled

Remove existing MySQL RPM’s so there's a clean slate for MariaDB. The below command will uninstall the MySQL RPM’s

/scripts/check_cpanel_rpms –fix –targets=MySQL50,MySQL51,MySQL55

Create a yum repository for MariaDB

vi /etc/yum.repos.d/MariaDB.repo

Place the following inside of it depending on the DISTRO (https://downloads.mariadb.org/mariadb/repositories/):

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/5.5.29/centos6-amd64/

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

Remove php from the /etc/yum.conf file then run the following commands

yum install MariaDB-server MariaDB-client MariaDB-devel

/etc/init.d/mysql start

mysql_upgrade

/etc/init.d/mysql restart

Add php back to the /etc/yum.conf file to ensure future php updates don’t get clobbered
Rebuild easyapache/php to ensure modules are intact/working

/scripts/easyapache –build

Auto-Sort a range in excel according to a column value, which is dynamic.

noreply@blogger.com (linwintech.blogspot.com) — Sat, 20 Aug 2016 11:30:00 +0000

Sometime, you want to automatically sort the data in a range according to the values in a specific column where the data is dynamic (changes every time). The following code will auto-sort data in range A3:C20 according to the values in column C (C3:C20) when there is a change in the values in the column C (C3:C20):

Private Sub Worksheet_Change(ByVal Target As Range)

If Intersect(Target, Range("C3:C20")) Is Nothing Then Exit Sub

Application.EnableEvents = False

Me.Sort.SortFields.Clear

Me.Sort.SortFields.Add Key:=Range("C3:C20"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal

With Me.Sort

.SetRange Range("A3:C20")

.Header = xlGuess

.MatchCase = False

.Orientation = xlTopToBottom

.SortMethod = xlPinYin

.Apply

End With

Application.EnableEvents = True

End Sub