Connect to Office 365 email, Calendar & Lync 2013 from Ubuntu 14

I have installed Ubuntu 14.04 LTS on a laptop. I was wondering how to connect to my Office365 account. Here you go!

Thailand Dance!

Emails:

Use your thunderbird to connect to the following IMAP server

Server name: outlook.office365.com
Port: 993
Encryption method: SSL

Calendar

Install Lightning plugin for thunderbird from the following location.

https://addons.mozilla.org/en-US/thunderbird/addon/lightning/

Install the thunderbird plugin for Exchange Servers from the following location

http://www.1st-setup.nl/wordpress/?page_id=551

I’ve used the latest beta version.

Outlook 365 Addressbook

The thunderbird addon downloaded from the 1st-setup site given above works!

Lync 2013

Pidgin IM client comes by default in Ubuntu. Install the following plugin for Pidgin from the Ubuntu Software Center.

“Pidgin plugin for MS Office Communicator and MS Lync”

Add a “Office Communicator” account.

Basic Tab

Username: pandian@grassfield.org

Login:pandian@grassfield.org

Password: xxxxx

Advanced Tab

Server [port]: leave this as blank

Connection Type: SSL/TLS

User Agent: UCCAPI/15.0.4420.1017 OC/15.0.4420.1017 (Microsoft Lync)

Authentication Scheme: TLS-DSK

Leave the rest.

Good Luck!

Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’

Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /var/www/egmonitor/index.php on line 11

The socket file is not found on the default /tmp folder in ubuntu. Rather, it was placed inside /var/run/mysqld/mysqld.sock

You can get this from /etc/mysql/my.cnf file

http://www.tech-recipes.com/rx/762/solve-cant-connect-to-local-mysql-server-through-socket-tmpmysqlsock/

Reset mysql root password

Sharing the root password is a suicide, somebody changed the password today 😦
Here are the steps to reset it.

Ref: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

I will explain the steps in ubuntu!

 

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

login as the user, who is running mysql

Generally the username would be mysql.

$su
#su - mysql
$

Stop the mysql service

$service mysql stop

Create a new file with the following contents

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

you need to execute this commands using safemode

root@ubuntu250:/var/lib/mysql# mysqld_safe --init-file=mysqlpasswd &

You will see the server is starting as below

[1] 2901
root@ubuntu250:/var/lib/mysql# 120106 21:35:48 mysqld_safe Logging to syslog.
120106 21:35:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

login now with the new password. it should work now.