Rainy weather fails to dampen spirits ahead of Olympics opening ceremony