January 31, 2011

Resetting MySQL Admin Password In Windows server?

Filed under: Miscellaneous — SupportPRO Admin @ 6:04 am

Steps to reset mysql admin password in windows server:

1) Log on to the Windows System where MySQL is running as Administrator. Stop MySQL server if it is running. Go to the Services manager:
Start Menu -> Control Panel -> Administrative Tools -> Services
Find MySQL service in the list and stop it.
2) Create a text file and place the following command within it on a single line:
SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(’NewPassword’);
Save the file with any name. For example the file will be C:\mysql-pass.txt.
3) Open the DOS command prompt:
Start Menu -> Run -> cmd
4) If MySQL is installed in C:\mysql. At the DOS command prompt execute this command:
C:\> C:\mysql\bin\mysqld-nt –init-file=C:\mysql-pass.txt
If MySQL is installed in another location, adjust the following commands accordingly
5) The contents of the file named by the –init-file option are executed at server startup, changing the root password. After the server has started successfully.
6) Stop the MySQL server and restart it in normal mode again. If MySQL server is ran as a service, start it from the Windows Services window.
7) Connect to MySQL server by using the new password.

AddThis Social Bookmark Button

Address already in use: make_sock: could not bind to address [::]:443

Filed under: Miscellaneous — SupportPRO Admin @ 6:03 am

(98)Address already in use: make_sock: could not bind to address [::]:443
(98)Address already in use: make_sock: could not bind to address 0.0.0.0:443
no listening sockets available, shutting down
Unable to open logs

Also check if Apache logs have exceeded 2GB of limit.

1)Kill All nobody process running on the server. Use the following script for doing that.
cijo@server [~]#for i in `ps auwx | grep -i nobody | awk {‘print $2′}`; do kill -9 $i; done
or
cijo@server [~]#for i in `lsof -i :80 | grep http | awk {‘ print $2′}`; do kill -9 $i; done
2) If apache is not restarting after this. Remove semaphore using the following script.
cijo@server [~]#for i in `ipcs -s | grep nobody | awk ‘{print $2}’`; do ipcrm -s $i; done
3) Restart apache.

AddThis Social Bookmark Button

Ionice

Filed under: Miscellaneous — SupportPRO Admin @ 6:01 am

The ionice command Is used to set I/O scheduling class and priority for a program.

The I/O schedule for a program can be changed to the following:

  1. CFQ
  2. Noop scheduler
  3. Anticipatory
  4. Deadline

(more…)

AddThis Social Bookmark Button

Webmail Shows Plesk Default Page

Filed under: Miscellaneous — SupportPRO Admin @ 5:57 am

Some time  your websites webmail shows “Plesk  Default Page”. This may occur because of webmail upgrade.

FIXES:

1.  Log into your domains control panel.

2.  Move on to Mail ->Mail settings.

3.  Under "Webmail" select "None" and click "OK".

4.  Select the "Mail settings" icon again.

5.  Under "Webmail" select "SmarterMail" or "MailEnable" or "Horde" and click "OK".

(more…)

AddThis Social Bookmark Button

"Disk usage 100% ? Retain latest ‘x’ number of entries of a file and delete the rest of the contents"

Filed under: Miscellaneous — SupportPRO Admin @ 5:55 am

Having issues with 100% diskspace in your Linux dedicated server. An easy and quick way is to clear the log files and thereby you can acquire quite a large amount of usable diskspace.
Check the following:
1. Check the total disk usage:
[root@testserver /]# df -h
2. Check the size of a each folder:
[root@testserver /]# du -sch * or du -sch /foldername command

 

(more…)

AddThis Social Bookmark Button
Next Page »

Powered by WordPress