Sunday, October 11, 2015

MySQL Database login Access denied for user 'root'

MySQL Database login Access denied for user 'root'


Trying to login MySQL Database on Linux system getting Access denied issue in root user.

Error:-

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO).

Resolution:-

Try command on Linux prompt mysql -u root -p

[root@eznag bin]# ./mysql -u root -p

Enter password: --> Type Root Password

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.1.52 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from nagios_servicechecks;
ERROR 1046 (3D000): No database selected
mysql> 






Sunday, October 4, 2015

Add One Windows Server 2012 Domain User to Domain Admins Group


Add One Windows Server 2012 Domain User to Domain Admins Group


  • If you are promoting a domain user to a domain administrator just to allow the user to perform some administrative tasks, it is recommended that you use the Delegation of Control feature that the Windows Server 2012 provides. By using the delegation, you can allow a standard domain user to perform a few administrative tasks without adding the account to any administrative group, and granting unnecessary privileges that can be misused because of ignorance or bad intentions.
  • However, you can still add the domain user to the Domain Admins group if needed.

  • Here is how you can add a particular Windows Server 2012 Active Directory domain user to Domain Admins group in order to allow him to get all the domain administrator privileges:

  1. Log on to the Windows Server 2012 Active Directory domain controller with the Enterprise Admin or Domain Admin account credentials.
  2. If not already started, initialize the Server Manager window from the bottom left corner of the screen.
  3. On the opened Server Manager window, go to the Tools menu from the menu bar.
  4. From the displayed list, click Active Directory Users and Computers.
  5. On the opened Active Directory Users and Computers snap-in, from the left pane, expand the current domain name. (MOHANSUNDARAM.COM for this demonstration.).
  6. From the expanded tree, locate the target OU that contains the domain user account that you want to promote to the domain admin.
  7. Once located, from the right pane, right-click the target user account. (User-01 for this demonstration.).
  8. From the displayed context menu, click Add to a group.

9. On the opened Select Groups box, in the Enter the object names to select list, type Domain Admins and click the Check Names button.


            




Remove Protection Against Accidental Organizational Unit Deletion on Windows 2012 Server

Remove Protection Against Accidental Organizational Unit Deletion on Windows 2012 Server

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2, Windows Server 2008 R2 , Windows Server 2012 R2.

 You can use this procedure to remove the following access control entries (ACEs):

  • On the organizational unit (OU) for which you are removing protection, remove explicit Deny ACEs for the Delete and Delete Subtree advanced permissions for the Everyone group. 
  • On the parent container of the OU for which you are removing protection, remove an explicit Deny ACE for the Delete All Child Objects permission for the Everyone group.

  

To remove protection that prevents an OU from accidental deletion:-

 

 Method :1 

  1. Log on to the computer as a member of the Domain Admins group.
  2. Open Active Directory Users and Computers.
  3. Click View, and then click Advanced Features.
  4. First, clear permissions on the OU for which you want to remove protection. To do this, right-click the OU, and then click Properties.
  5. In OU Properties, click the Security tab, and then click Advanced.
  6. In Permission Entries, select the Deny entry for the Everyone group, and then click Remove.
  7. Click OK to close the Advanced Security Settings, and then click OK to close OU Properties.

    Method :2


  8. Second, clear permissions on the parent container of the OU for which you want to remove protection. To do this, right-click the parent container, and then click Properties.
  9. In ContainerProperties, click the Security tab.
  10. In Group or user names, select the Everyone group, and then clear the Deny check box for Delete All Child Objects, and then click OK to close ContainerProperties.

 

 

Saturday, September 12, 2015

Cisco IP Phone Not allowing Dialling 11 Digit

Cisco IP Phone Not allowing Dialling 11 Digit


Problem:-


Cisco any IP Phone Not allowing Dialling more then 11 Digit or not able make LAN line Number call.


Resolution:-


Change default Dial Plans below marked 'Red' colour.


Example: 044-234234

(*xx.|*xxx|*75xx|[3469]11|0|00|1xxx[2-10]xxxxxxS0|xxxxxxxxxxxx.|**275*x.)


Example: 0427-23423467

(*xx|[3469]11|0|00|[2-11]xxxxxx|1xxxx[2-11]xxxxxxxxS0|xxxxxxxxxxxx.)


Reference screenshot





Note:-


Cisco IP Phone Restrictions Outgoing calls via Dail pattern No.1 fallowed by Mobile no or land no.

(*xx|[3469]11|0|00|[2-7]xxxxxx|1xxx[2-9]xxxxxS0|xxxxxxx.)




Nagios Could not bind socket: Address already in use

Nagios Could not bind socket: Address already in use


While restarting nagios services getting error message "ndo2db-3x"


Problem:-


[root@eznag objects]# service nagios restart
Running configuration check...done.
Stopping nagios: ndo2db-3x: no process killed
.done.
Starting nagios:Could not bind socket: Address already in use
 done.


Resolution:-


[root@eznag objects]# rm /usr/local/nagios/var/ndo.sock

rm: remove socket `/usr/local/nagios/var/ndo.sock'? y

[root@eznag objects]# service nagios restart
Starting nagios: done.


Sunday, August 30, 2015

Auto shutdown for Windows System

Auto shutdown for Windows System 

(Windows 7 / 8 / 10 / 2008 R2 Server / 2012 R2 Server)



If using Windows 7 / 8 /10 / 2008 R2 Server / 2012 Server, follow these steps to schedule your PC(Personal Computer) to shut down at a certain time at night:

1. Go to Start > Control Panel > System and Security > Administrative Tools and click on the Task Scheduler.

2. From the Action menu in Task Scheduler, click "Create Basic Task."

3. In the "Create Basic Task Wizard" windows that pops up, Type in a title and a description. Something basic like "PC Shutdown."



  
4. Click "Next."

5. On the "Task Trigger" screen, choose the frequency with which you want the Shutdown PC to run. For nightly shutdown, click on "daily" and click the Next" button.
6.On the "Daily" screen, enter the date and time you want your PC to shutdown. Click "Next."





7. On the "Action" screen, choose "Start a program" and click "Next."



Click Here Download auto_shutdown.bat




8. Copy or Move downloaded auto_shutdown.bat  fine into "C:\" drive.


 9. On the "Start a Program" screen, type C:\auto_shutdown.bat in the "Program/script" text field.


10. Click "Next."
11. Confirm your settings on the Summary screen and click "Finish."


Now your Windows 7 computer will automatically shutdown at the same time every day/night. before shutdown it will show pop message windows system going to shutdown next 2 minutes.





Sunday, August 2, 2015

PDF Compressor Free Tool

PDF Compressor Free Tool

Why is there a need to compress a PDF file? Some PDF files are large, especially PDF documents that contains many images, these files open very slowly, and are not easy to store, transfer and share. Now you can use this free PDF compression software to compress these files with an acceptable quality. At the same time, by reducing PDF files size, you can use PDF as your ebook format, easy to read PDF files on mobile phone, send by email as attachments, or upload and share with your friends.

PDF Compressor is a free PDF compression software to enable you to effectively reduce the size of PDF files. Software is simple and easy to use, select an existing PDF file, and hit button "Compress", a compressed PDF file will be created, page by page, a progress bar will show progress of the whole compression process.

This software supports five different compression settings:
  • Screen - low resolution, screen-view-only quality, 72 dpi images.
  • eBook - medium resolution, low quality, 150 dpi images.
  • Printer - high quality, 300 dpi images (Myself Tested this option).
  • Prepress - high quality, color preserving, 300 dpi images (Good Quality PDF output, 90 % Less file Size - Myself Tested this option).
  • Default - a wide variety of uses, possibly larger output file.

These five compression settings represent five different compression ratio, generally, you can get a smallest output file with "Screen" setting, and get a biggest output file with and "Prepress" setting. But, please note, for a few PDF files, the resulting file will be large with "Screen" setting, in this case, you need to try different settings.




Demo:-

1. Drag mouse point to PDF file  It will show Actual PDF file size "2.87 MB".


2.Open Free PDF Compressor tool and select source PDF file.


3. Select PDF Output file location and select compress setting "Prepress" then
    Click " Compress" option.




4. Few seconds compressed PDF file available on output file location.




5.  compressed PDF file details.

Actual Size - 2.87 MB
After compressed - 168 KB
98% Compressed without Losing on Quality.







Gitlab Automation Project Showcase

My GitLab Projects Showcase 🚀 Welcome to my portfolio of GitLab projects. Each repository reflects my journey as an engineer, focusing...