Tuesday, June 16, 2015

Modules got blocked in powershell v1.0

The best way to unblock in v1.0 is to remove the module from powershell location
eg: C:\windows\system32\windowspowershell\v1.0\modules\pswindowsupdate

and extract the downloaded module again into the same location.

Wednesday, January 21, 2015

Thursday, January 15, 2015

Mysql replication failure

when faced with mysql replication failure problem,
"Please check the replication failure from Master Host"

do the following steps,
connect to the slave machine, open command prompt, it is cmd in windows or go to terminal in linux

connect to mysql as "mysql -u username -p", when prompt for password, enter the password
issue the command, "show slave status \G" and check for the errors.  Check the parameter which tells how long the slave is behind the master.

Do then,
1. stop slave;
2. start slave;
3. show slave status \G. Again check for erros and no of seconds the slave is behind the master

Even if this doesn't work try restarting the mysql server in slave machine, in worst case try doing it in master and then repeat the above steps

If any of the mysql table is crashed, then execute the following command as

repair table db.tablename; 

Sunday, July 28, 2013

Error code 4064 - Cannot Open User Default Database (error 4064) - MSDN - Microsoft

This issue can be solve with the following command

sqlcmd -d master -U sa -P mypassword
and then:
alter login sa with default_database = master