The Forbes Global 2000 is a categorization of the largest publicly listed companies in the world. Together they employ 72 million people, own $119 trillion in assets, and generate $30 trillion in revenues annually – approximately 46% of world GDP.

The Forbes Global 2000 is a list of the most successful publicly listed companies of the world. It is compiled annually by Forbes Magazine since 2004.

In a reflection of the globalization of the world, and the growing influence of emerging markets, the footprint of the Global 200 has grown. In 2004, companies came from 51 markets, but this had grown to 60 markets by 2008.

Forbes believe that the best way to categorize companies across markets is to measure a basket of factors and define a composite score. Total sales, after-tax profits, market value and total assets are all factored into the categorization.

The collective size of these corporations beggars belief, and is growing every year. Forbes Global 2000 companies now employ 72 million people worldwide, own $119 trillion in assets, are worth $39 trillion in market cap, earn $30 trillion in revenues and $2.4 trillion in profits. To put these figures in perspective, GDP for the United States of America was $13.84 trillion in 2007 according to the CIA World Factbook. Total World GDP (or Gross World Product) is estimated at $65.61 trillion. The Forbes Global 2000 therefore control about 46% of world output.

The US still dominates the list, but its share is shrinking, with 153 fewer companies than in 2004. For the first time, the top ranking company is no longer American – that spot has been taken by the London-based HSBC, which has achieved an impressive revenue compounded annual growth rate (CAGR) of 26% over the last five years, with earnings growing at 31% per annum. India, China and Brazil are the countries growing the fastest in their contribution. India has led this trend, with 48 companies this year compared to 27 companies in 2004.

Despite the credit crunch, the banking industry is still the largest in the Forbes Global 2000. It has 315 entries, with profits of $398 billion and assets of $58.3 trillion. The oil and gas companies lead the table for revenues of $3.76 trillion, generated by 123 companies. They accrued $386 billion in profits. With oil prices continuing to hit new highs, expect oil and gas to lead in both sales and profits in 2009.

A fascinating category of the list is the high performing companies whose growth rates outstrip their peers. On average, the 130 companies identified as global high performers are growing earnings at a 25% rate.

The Top 100 companies from the Forbes Global 2000 are as follows:

Rank

Company

Country

Industry

Sales ($Billion)

Profits ($Billion)

Assets ($Billion)

Market Cap ($Billion)

1

HSBC Holdings

United Kingdom

Banking

146.5

19.13

2,348.98

180.81

2

General Electric

United States

Conglomerates

172.74

22.21

795.34

330.93

3

Bank of America

United States

Banking

119.19

14.98

1,715.75

176.53

4

JPMorgan Chase

United States

Banking

116.35

15.37

1,562.15

136.88

5

ExxonMobil

United States

Oil & Gas Operations

358.6

40.61

242.08

465.51

6

Royal Dutch Shell

Netherlands

Oil & Gas Operations

355.78

31.33

266.22

221.09

7

BP

United Kingdom

Oil & Gas Operations

281.03

20.6

236.08

204.94

8

Toyota Motor

Japan

Consumer Durables

203.8

13.99

276.38

175.08

9

ING Group

Netherlands

Insurance

197.93

12.65

1,932.15

75.78

10

Berkshire Hathaway

United States

Diversified Financials

118.25

13.21

273.16

216.65

10

Royal Bank of Scotland

United Kingdom

Banking

108.45

14.62

3,807.51

76.64

12

AT&T

United States

Telecommunications Services

118.93

11.95

275.64

210.22

13

BNP Paribas

France

Banking

116.16

10.71

2,494.41

81.9

14

Allianz

Germany

Insurance

139.12

10.9

1,547.48

80.3

15

Total

France

Oil & Gas Operations

199.74

19.24

165.75

181.8

16

Wal-Mart Stores

United States

Retailing

378.8

12.73

163.38

198.6

17

Chevron

United States

Oil & Gas Operations

203.97

18.69

148.79

179.97

18

American Intl Group

United States

Insurance

110.06

6.2

1,060.51

118.2

19

Gazprom

Russia

Oil & Gas Operations

81.76

23.3

201.72

306.79

20

AXA Group

France

Insurance

151.7

7.75

1,064.67

70.33

21

Banco Santander

Spain

Banking

72.26

10.02

1,332.72

113.27

22

ConocoPhillips

United States

Oil & Gas Operations

171.5

11.89

177.76

129.15

23

Goldman Sachs Group

United States

Diversified Financials

87.97

11.6

1,119.80

67.16

24

Citigroup

United States

Banking

159.23

3.62

2,187.63

123.44

25

Barclays

United Kingdom

Banking

79.7

8.76

2,432.34

62.43

26

EDF Group

France

Utilities

81.6

7.69

271.66

170.81

27

E.ON

Germany

Utilities

94.04

9.86

200.84

126.22

28

ENI

Italy

Oil & Gas Operations

119.27

13.7

128.15

127.38

29

Petrobras-Petróleo Brasil

Brazil

Oil & Gas Operations

87.52

11.04

129.98

236.67

30

PetroChina

China

Oil & Gas Operations

88.24

18.21

111.7

546.14

31

Procter & Gamble

United States

FMCG

79.74

11.13

144.4

203.67

32

Deutsche Bank

Germany

Diversified Financials

95.5

7.45

1,485.58

56.27

33

UniCredit Group

Italy

Banking

63.67

7.19

1,077.21

77.46

34

Telefónica

Spain

Telecommunications Services

82.4

13

143.13

138.42

35

Mitsubishi UFJ Financial

Japan

Banking

49.49

7.5

1,591.56

98.14

36

Volkswagen Group

Germany

Consumer Durables

149

5.64

210.88

90.23

37

IBM

United States

Software & Services

98.79

10.42

120.43

157.62

38

ArcelorMittal

Luxembourg

Materials

105.22

10.37

133.65

108.82

38

Daimler

Germany

Consumer Durables

145.11

5.82

199.77

85.16

40

BBVA-Banco Bilbao Vizcaya

Spain

Banking

54.34

8.94

733.14

78.29

41

Wells Fargo

United States

Banking

53.59

8.06

575.44

96.37

42

ICBC

China

Banking

37.48

6.31

961.65

289.57

43

Credit Suisse Group

Switzerland

Diversified Financials

83.72

7.53

1,194.75

50.85

44

HBOS

United Kingdom

Banking

100.32

8.1

1,336.17

44.84

45

Crédit Agricole

France

Banking

101.59

6.49

1,662.60

45.73

45

Nestlé

Switzerland

Food Drink & Tobacco

94.76

9.38

99.06

188.11

47

Fortis

Netherlands

Diversified Financials

121.19

5.46

1,020.98

49.04

48

Verizon Communications

United States

Telecommunications Services

93.47

5.65

186.96

104.27

49

France Telecom

France

Telecommunications Services

77.31

9.2

137.09

87.89

50

Siemens

Germany

Conglomerates

103.2

5.42

126.72

118.47

50

Wachovia

United States

Banking

55.53

6.31

782.9

60.69

52

Sinopec-China Petroleum

China

Oil & Gas Operations

133.79

6.9

77.44

186.38

53

Hewlett-Packard

United States

Technology Hardware & Equip

107.67

7.85

88.57

122.04

54

Lloyds TSB Group

United Kingdom

Banking

58.74

6.53

701.08

50.95

55

Royal Bank of Canada

Canada

Banking

43.57

5.77

629.96

64.41

56

Bank of China

China

Banking

31.13

5.49

679.57

171.45

57

Pfizer

United States

Drugs & Biotechnology

48.42

8.14

115.27

152.17

58

Johnson & Johnson

United States

Drugs & Biotechnology

61.1

10.58

80.95

175.51

59

Samsung Electronics

South Korea

Semiconductors

92.26

8.56

87.49

87.84

60

StatoilHydro

Norway

Oil & Gas Operations

89

7.52

89.16

98.36

61

Generali Group

Italy

Insurance

102.16

3.17

486.43

60.79

62

CCB-China Construction Bank

China

Banking

29.16

5.93

697.44

126.55

63

Microsoft

United States

Software & Services

57.9

16.96

67.34

253.15

64

Suez Group

France

Utilities

64.96

5.37

114.89

83.56

65

Zurich Financial Services

Switzerland

Insurance

55.05

5.63

387.67

45.76

66

Nippon Telegraph & Tel

Japan

Telecommunications Services

91.57

4.06

149.71

60.27

67

Sanofi-aventis

France

Drugs & Biotechnology

40.95

7.68

104.98

101.17

68

Honda Motor

Japan

Consumer Durables

94.35

5.04

101.82

56.82

69

Nokia

Finland

Technology Hardware & Equip

74.54

10.52

52.62

145.66

70

Munich Re

Germany

Insurance

67.57

5.63

306.03

37.34

71

Mizuho Financial

Japan

Banking

32.52

5.28

1,272.17

48.8

72

Novartis

Switzerland

Drugs & Biotechnology

40.22

12.62

71.89

111.62

73

MetLife

United States

Insurance

53.01

4.32

558.56

41.32

74

Roche Holding

Switzerland

Drugs & Biotechnology

40.65

8.6

67.72

169.32

75

Morgan Stanley

United States

Diversified Financials

85.33

2.56

1,045.41

46.53

76

Vale

Brazil

Materials

33.23

10.26

74.7

161.39

77

Rio Tinto

UK/ Australia

Materials

29.7

7.31

100.81

165.48

78

China Mobile

Hong Kong/China

Telecommunications Services

37.06

8.29

62.44

308.59

79

GlaxoSmithKline

United Kingdom

Drugs & Biotechnology

45.07

10.35

57.16

120.05

80

BASF

Germany

Chemicals

84.6

5.93

67.33

60.96

81

RWE Group

Germany

Utilities

56.17

3.64

119.5

68.19

82

Sumitomo Mitsui Financial

Japan

Banking

33.04

3.76

850.75

56.1

83

BHP Billiton

UK/ Australia

Materials

39.5

13.42

53.36

190.62

84

Time Warner

United States

Media

46.48

4.39

133.83

55.83

85

Banco Bradesco

Brazil

Banking

36.12

4.11

192.65

59.8

85

KBC Group

Belgium

Banking

35.22

4.66

517.98

43.66

87

Dexia

Belgium

Banking

140.78

3.47

889.98

28.04

88

Altria Group

United States

Food Drink & Tobacco

38.05

9.16

57.21

154.2

89

National Australia Bank

Australia

Banking

38.88

4.06

499.44

43.95

90

Cisco Systems

United States

Technology Hardware & Equip

37.68

8.07

55.3

145.39

91

Manulife Financial

Canada

Insurance

33.08

4.01

178.58

59.18

92

Bank of Nova Scotia

Canada

Banking

28.02

4.25

431.3

48.08

93

Intel

United States

Semiconductors

38.33

6.98

55.65

115.59

94

Unilever

Netherlands/ UK

Food Drink & Tobacco

54.82

5.3

53.4

92.75

95

Toronto-Dominion Bank

Canada

Banking

26.51

4.2

443.56

48.38

96

Nissan Motor

Japan

Consumer Durables

89.09

3.92

104.2

37.9

97

Lehman Bros Holdings

United States

Diversified Financials

59

4.19

691.06

27.05

98

Carrefour Group

France

Food Markets

112.4

3.15

75.73

49.95

99

Commonwealth Bank

Australia

Banking

26.48

3.8

360.42

51.86

100

Boeing

United States

Aerospace & Defense

66.39

4.07

58.99

63.32


live will be more beautiful with much plants around us. here some examples where people have a full atention to their environment by integrating living place and plants,..check this out

Musee du Quai Branly, Paris:

Musee du Quai Branly, ParisVertical gardens inhabit the walls of the Musee du Quai Branly in Paris. Created by P Blanc, botanist and a vertical landscape designer best know for this gorgeous living walls on the Musée du Quai Branly in Paris.

Restaurant Lined Wth A Living Green Wall:

Restaurant Lined Wth A Living Green WallDesigned by Serrano Cherrem Architects, the serene landscape seats in between a living wall, wood, and an incredible glass enclosure, at Restaurant Japonez in Mexico City.

Siam Paragon Shopping Center:

Siam Paragon Shopping Center (3) 1(Image credit: pingmag).

Siam Paragon Shopping Center (3) 2Siam Paragon Shopping Center (3) 3(Image credit: skyscrapercity).
Here is a beautiful demonstration how Plant Walls use water. “A network of perforated plastic pipes run throughout the structure. Every four minutes, under the control of an electronic timer, droplets of nutrient solution are released from the perforations, which are spaced 20 cm to 25 cm apart (approx. 8 in. -10 in.).”

Pershing Hall Hotel, Paris, France:

Pershing Hall Hotel, Paris, FranceThis wall in Paris’s boutique Pershing Hall Hotel.

Green Shop:

Green Shop (6) 1Here we have the green shop of the Belgian designer Ann Demeulemeester, a project by architect Minsuk Cho. The building is covered with real grass and plants. More

Green Fortune’s Plantwall:

Green Fortune's PlantwallPlantwall is a vertical wall of greenery. It allows for all of the enhancing elements of indoor greenery which doesn’t take much of the floor space too. Water comes in via an integrated drip irrigation system.

Schiavello’s Vertical Gardens:

Schiavello's Vertical GardensA perfect solution for those who wish to have indoor greenery but cant due to shortage of space.

Tower Flower:

Tower Flower (5) 1It looks like a huge display of potted plants – ‘Tower Flower‘ a 10-storey building by architect Edouard Francois, can also be called the ‘Bamboo Building’ for reasons that are immediately obvious. More

Changi Airport, Singapore:

Changi Airport, SingaporeThe Green Wall is a major feature at Singapore Changi Airport.

Oulu’s Living Wall:

Oulu's Living WallCited as Brooklyn’s first living wall, the Oulu attracts attention with its huge external living wall.

Green wall – Indoor Landscaping:

Green wall - Indoor Landscaping (5) 1Green Wall system for a laminar, vertical growth of small leaved plants, which has an astonishing effect on the interior design, both visual, and climatic. More

Consorcio Building Concepcion:

Consorcio BuildingLiving green walls wraps this building.

Gordon Graff’s Sky Farm:

Gordon Graff's Sky FarmIt has 2.7 million square feet of floor area, 8 million square feet of growing area with 58 floors and can produce as much as a thousand acre farm, feeding 35 thousand people per year.

World’s First 30 Story Vertical Farm:

World's First 30 Story Vertical Farm(Image credit: verticalfarm).
The $200 million dollar project is designed to be a functional and profitable working farm growing enough food to feed 72,000 people for a year.”

BHVHomme:

BHVHommeThe vertical garden at the Parisian department store.

Harmonia 57:

Harmonia 57Harmonia 57 by French-Brazilian architects Triptyque is an office building in São Paulo with a planted front irrigated by a mist system.

Green Building:

Green Building(Image credit: urbanplanningblog).

Genoa’s Nave Aquarium:

Genoa's Nave AquariumBlanc’s Plant Wall at the aquarium measures 18m x 4m.

Osaka Green Building:

Osaka Green Building(Image credit: quirkyjapan).

Qantas First Lounge, Sydney International Airport, Australia:

Qantas First Lounge, Sydney International Airport, AustraliaA vertical garden in the arrival area designed by international botanist P Blanc.

The Living Wall At Vancouver Aquarium:

The Living Wall At Vancouver Aquarium:The living wall at Vancouver Aquarium was designed to educate visitors about the benefits of green walls.

The Living Tower:

The Living TowerThe Living Tower, by Pierre Sartoux presents a beautiful solution to lack of space in urban centers in near future.

Organic Wallpaper Inside A Private Home:

Organic Wallpaper Inside A Private HomeCreated by P Blanc.

Girbaud, Paris:

Girbaud, ParisResidence Antilia:

Residence AntiliaIt’s designed by SITE and called Residence Antilia, the scheme is being developed by Indian tycoon Mukesh Ambani, chairman of Reliance Industries.

Parabienta Living Wall:

Parabienta Living WallThe living wall is called ‘Parabienta‘, is light, can be designed in different patterns and grids, and cools the building significantly and above all it’s cost effective.

Guggenheim Museum, Bilbao, Spain:

Guggenheim Museum, Bilbao, Spain (Image: Credit).
Created by artist Jeff Koons, this forty-three foot ‘plant puppy’ is commissioned in 1992; it was created using a steel substructure with an internal irrigation system and numerous plants.

Living Walls, Netherlands:

Living Walls, NetherlandsUsing rock wool for the growing medium, this interesting living wall was developed.

21st Century Museum of Contemporary Art:

21st Century Museum of Contemporary Art(Image credit: businessweek).

Emporium Shopping Center:

Emporium Shopping CenterThis elevator in Bangkok’s Emporium shopping center stretches vertical horticulture to a height of more than 30m (98 ft.).


Sebagai bloger atau webmaster, jika ingin memasukkan gambar ke blog/web, kita harus memilih tipe gambar yang akan kita pakai, apakah JPG, GIF, atau PNG. Jika format yang dipilih tidak sesuai dengan jenis gambarnya, gambar tersebut ukurannya akan lebih besar daripada yang semestinya, dan menyebabkan waktu loading blog/website kita lebih lama. Padahal, pengunjung suka terhadap blog atau web yang loadingnya cepat dan tidak boros bandwidth. Untuk itu, kita harus mengusahakan agar gambar-gambar dalam blog atau website kita memiliki ukuran sekecil mungkin. Caranya bagaimana?

Memilih tipe dan memperkecil ukuran gambar

Jika kita menyimpan gambar dengan program pengolah gambar seperti Adobe Photoshop atau Microsoft Paint, maka kita dapat memlilih format gambar yang sesuai melalui menu File -> Save As dan pilih tipe file yang kita inginkan. Khusus untuk Adobe Photoshop ada feature tambahan yang lebih baik lagi dengan menu File -> Save For Web. Dengan Adobe Photoshop ini, selain dapat memilih tipe gambar, kita juga dapat mengatur kompresi dan kualitas gambar. Berikut ini tipe-tipe gambar yang sering digunakan.

BMP (Bitmap)

Tipe file BMP umum digunakan pada sistem operasi Windows dan OS/2. Kelebihan tipe file BMP adalah dapat dibuka oleh hampir semua program pengolah gambar. Baik file BMP yang terkompresi maupun tidak terkompresi, file BMP memiliki ukuran yang jauh lebih besar daripada tipe-tipe yang lain.
File BMP cocok digunakan untuk:

* desktop background di windows.
* sebagai gambar sementara yang mau diedit ulang tanpa menurunkan kualitasnya.

File BMP tidak cocok digunakan untuk:

* web atau blog, perlu dikonversi menjadi JPG, GIF, atau PNG.
* disimpan di harddisk/flashdisk tanpa di ZIP/RAR, kecuali space tidak masalah bagi Anda.

JPG/JPEG (Joint Photographic Experts Group)

Tipe file JPG sangat sering digunakan untuk web atau blog. File JPG menggunakan teknik kompresi yang menyebabkan kualitas gambar turun (lossy compression). Setiap kali menyimpan ke tipe JPG dari tipe lain, ukuran gambar biasanya mengecil, tetapi kualitasnya turun dan tidak dapat dikembalikan lagi. Ukuran file BMP dapat turun menjadi sepersepuluhnya setelah dikonversi menjadi JPG. Meskipun dengan penurunan kualitas gambar, pada gambar-gambar tertentu (misalnya pemandangan), penurunan kualitas gambar hampir tidak terlihat mata.

File JPG cocok digunakan untuk:

* gambar yang memiliki banyak warna, misalnya foto wajah dan pemandangan.
* gambar yang memiliki gradien, misalnya perubahan warna yang perlahan-lahan dari merah ke biru.

File JPG tidak cocok digunakan untuk:

* gambar yang hanya memiliki warna sedikit seperti kartun atau komik.
* gambar yang memerlukan ketegasan garis seperti logo.

GIF (Graphics Interchange Format)

Tipe file GIF memungkinkan penambahan warna transparan dan dapat digunakan untuk membuat animasi sederhana, tetapi saat ini standar GIF hanya maksimal 256 warna saja. File ini menggunakan kompresi yang tidak menghilangkan data (lossles compression) tetapi penurunan jumlah warna menjadi 256 sering membuat gambar yang kaya warna seperti pemandangan menjadi tidak realistis. Pada program MS Paint, tidak ada fasilitas penyesuaian warna yang digunakan (color table) sehingga menyimpan file GIF di MS Paint seringkali menghasilkan gambar yang terlihat rusak atau berubah warna. Pada program pengolah gambar yang lebih baik, seperti Adobe Photoshop, color table bisa diatur otomatis atau manual sehingga gambar tidak berubah warna atau rusak.

File GIF cocok digunakan untuk:

* gambar dengan jumlah warna sedikit (dibawah 256).
* gambar yang memerlukan perbedaan warna yang tegas seperti logo tanpa gradien.
* gambar animasi sederhana seperti banner-banner iklan, header, dan sebagainya.
* print shoot (hasil dari print screen) dari program-program simple dengan jumlah warna sedikit.

File GIF tidak cocok digunakan untuk:

* gambar yang memiliki banyak warna seperti pemandangan.
* gambar yang didalamnya terdapat warna gradien atau semburat.

PNG (Portable Network Graphics)

Tipe file PNG merupakan solusi kompresi yang powerfull dengan warna yang lebih banyak (24 bit RGB + alpha). Berbeda dengan JPG yang menggunakan teknik kompresi yang menghilangkan data, file PNG menggunakan kompresi yang tidak menghilangkan data (lossles compression). Kelebihan file PNG adalah adanya warna transparan dan alpha. Warna alpha memungkinkan sebuah gambar transparan, tetapi gambar tersebut masih dapat dilihat mata seperti samar-samar atau bening. File PNG dapat diatur jumlah warnanya 64 bit (true color + alpha) sampai indexed color 1 bit. Dengan jumlah warna yang sama, kompresi file PNG lebih baik daripada GIF, tetapi memiliki ukuran file yang lebih besar daripada JPG. Kekurangan tipe PNG adalah belum populer sehingga sebagian browser tidak mendukungnya.

File PNG cocok digunakan untuk:

* gambar yang memiliki warna banyak.
* gambar yang mau diedit ulang tanpa menurunkan kualitas.

File PNG tidak cocok digunakan untuk:

* gambar yang jika dikompress dengan JPG hampir-hampir tidak terlihat penurunan kualitasnya.

Raster vs Vektor

Semua tipe file gambar yang disebutkan di atas (BMP, JPG, GIF, dan PNG) termasuk jenis gambar raster (atau disebut juga Bitmap). Gambar raster terdiri dari titik-titik pixel yang jumlahnya tetap. Jika diperbesar, baik di-zoom atau diubah ukuran gambarnya, gambar akan terlihat pecah atau tidak sebagus aslinya. Jenis gambar yang lain adalah gambar vektor. Gambar vektor terdiri dari garis, bentuk, bidang, dan warna yang dituliskan dalam instruksi-instruksi matematis. Jika diperbesar, gambar vektor kualitasnya tetap. Aplikasi pengolah gambar vektor misalnya CorelDraw (CDR) dan Adobe Ilustrator (AI). Gambar vektor saat ini tidak dapat digunakan di web atau browser.

Demikian penjelasan mengenai tipe-tipe gambar, dengan memilih tipe gambar yang sesuai, ukuran file gambar jadi lebih kecil, dan pengunjung web/blog kita tidak perlu menunggu lama pada saat loading dan menghemat bandwidth pengunjung, sehingga pengunjung akan lebih kerasan singgah di web atau blog kita. Semoga bermanfaat.

sumber : dap.comlabs.itb.ac.id


yeah..mencoba posting tepat pukul 00.00  di hari jadiku yang ke -rahasia-, cuman pengen ngucapin selama ulg tahun bwt itb , 2 maret merupakan hari kelahiran ITB,. dengan umur 89 tahun ini semoga bisa menjadi word class university..


Perubahan status ITB menjadi Badan Hukum Milik Negara (BHMN) membawa banyak konsekuensi. Salah satunya yaitu subsidi dana pendidikan dari pemerintah dipandang tidak lagi mencukupi oleh rektorat. Guna menyeimbangkan neraca keuangannya, ITB harus mencari dana sendiri. Pencarian dan pengelolaan dana kemudian dilakukan oleh tiga satuan utama yaitu Satuan Akademik, Satuan Usaha Komersial (SUK) dan Satuan Kekayaan dan Dana (SKD). Satuan Akademik berfungsi mengelola keuangan, sumberdaya insani, dan sarana – prasarana, serta perencanaan untuk meningkatkan efisiensi dan koordinasi dalam bidang sumberdaya. Satuan Usaha Komersial berfungsi untuk mengelola usaha komersial ITB. Sedangkan Satuan Kekayaan dan Dana bertugas mengelola dana donasi dari alumni, pemerintah atau masyarakat. Program cinta ITB menjadi salah satu solusi yang dibuat oleh SKD untuk mengatasi persoalan keuangan tersebut. Dimulai pada tahun 2006 dengan alumni sebagai sasaran utama. Pemenuhan dana operasional akademik ITB menjadi tujuannya. Program ini berbentuk Dana Lestari yang juga telah diterapkan pada beberapa perguruan tinggi di luar negeri. Harvard University telah menerapkannya sejak tahun 1920 dan berhasil mengumpulkan dana sebesar 29.2 miliar dolar pada tahun 2006. Konsep Dana Lestari ITB tidak jauh berbeda dengan universitas-universitas kelas dunia. Dana pokok yang terkumpul dari donasi tidak digunakan secara langsung untuk operasional, namun diinvestasikan dalam bentuk deposito, saham atau surat hutang negara. Hasil investasi ini yang digunakan untuk operasional ITB dan SKD sendiri. Total investasi ITB pada tahun 2006 sebesar 850 juta rupiah dan meningkat menjadi 1.15 miliar rupiah setahun berikutnya. Pengggalangan dana Cinta ITB dilakukan terutama pada temu alumni. Namun pada penggalangan dana yang terakhir kali dilakukan, tidak hanya uang yang didapat melainkan juga perubahan nama pada beberapa gedung di ITB. Pada 27 September 2008 di Graha Niaga Jakarta, penggalangan Dana Lestari dan dies emas 50 tahun ITB diadakan. Acara ini dihadiri oleh para alumni dan dibuka oleh Hatta Radjasa selaku ketua Ikatan Alumni (IA). Awalnya,penggalangan dana hanya bertujuan untuk pembiayaan dies emas 50 tahun ITB. Namun, dengan difasilitasi Hatta Radjasa, rektorat ITB dan SKD berhasil mengumpulkan dana abadi dengan jumlah miliaran rupiah. “Kebetulan tahun 2009 ada Dies Natalis ITB, nah kita manfaatkan momentum tersebut.” Ujar Yoes Avianto, Direktur Eksekutif SKD. 4 alumni mengucurkan dana yang cukup besar malam itu. Sebagai bentuk penghargaan, nama empat laboratorium teknik (labtek) akan diganti dengan nama sesuai keinginan mereka; Aburizal Bakrie, Arifin Panigoro, Benny Subianto dan T.P Rachmat. Ide memberikan penghargaan berupa nama di laboratium teknik ITB berasal dari SKD sendiri. “Kebetulan juga, rektorat mempunyai ide yang sama. Jadi kita coba realisasikan.” Penjelasan Yoes. Penghargaan berupa nama itu diberikan sebagai umpan balik yang sesuai dengan besar donasi untuk Dana Lestari. Menurut deputi Arifin Panigoro, sumbangan yang tidak besar tidak diberi penghargaan seperti itu. Empat labtek yang akan diganti namanya adalah labtek 5 (FT dan KL), 6 (IF) , 7 (FA) dan 8 (EL). Labtek 5 berganti nama menjadi Benny Subianto.Labtek 6 akan diganti dengan nama T.P Rachmat. Labtek 7 untuk nama Arifin Panigoro dan labtek 8 akan dinamai ayah Aburizal Bakrie, Achmad Bakrie.

referensi :http://boulevarditb.org


Ada sebuah perusahaan besar yang sedang mencari karyawan. Dalam tes tertulisnya, mereka hanya memberikan satu kasus untuk dijawab:

Anda sedang mengendarai motor di tengah malam gelap gulita dan hujan lebat di sebuah daerah yang penduduknya sedang diungsikan semuanya karena bencana banjir. Pemerintah setempat hanya bisa memberikan bantuan 1 buah Bis yang saat ini juga sedang mengangkut orang-orang ke kota terdekat.

Saat itu juga Anda melewati sebuah perhentian Bis satu-satunya didaerah itu. Di perhentian Bis itu Anda melihat 3 orang yang

merupakan orang terakhir di daerah itu yang sedang menunggu kedatangan Bis :

- Seorang nenek tua yang sekarat

- Seorang dokter yang pernah menyelamatkan hidup Anda sebelumnya.

- Seseorang yang selama ini menjadi idaman hati Anda dan akhirnya Anda temukan

Anda hanya bisa mengajak satu orang untuk membonceng Anda, siapakah yang akan Anda ajak ? Dan jelaskan jawaban Anda mengapa Anda melakukan itu.

Sebelum Anda menjawab, ada beberapa hal yang perlu Anda pertimbangkan:

Seharusnya Anda menolong nenek tua itu dulu karena dia sudah sekarat. Jika tidak segera ditolong akan meninggal. Namun, kalo dipikir-pikir, orang yang sudah tua memang sudah mendekati ajalnya. Sedangkan yang lainnya masih sangat muda dan harapan hidup kedepannya masih panjang.

Dokter itu pernah menyelamatkan hidup Anda. Inilah saat yang tepat untuk membalas budi kepadanya. Tapi kalo dipikir, kalo sekedar membalas budi bisa lain waktu khan. Namun,kita tidak akan pernah tau kapan kita mendapatkan kesempatan itu lagi.

Mendapatkan idaman hati adalah hal yang sangat langka. Jika kali ini Anda lewatkan, mungkin Anda tidak akan pernah ketemu dia lagi. Dan impian Anda akan kandas selamanya.

Jadi yang mana yang Anda pilih ?

Untuk direnungkan :

Dari 2000 an orang pelamar hanya 1 orang yang diterima bekerja di perusahaan tersebut. Orang tersebut tidak menjelaskan jawabannya, hanya menulis dengan singkat :

Saya akan memberikan kunci motor saya kepada sang dokter dan meminta dia untuk membawa nenek tua yang sedang sekarat tersebut untuk ditolong segera. Sedangkan saya sendiri akan tetap tinggal disana dengan Sang idaman hati saya untuk menunggu Bis kembali menolong kami.

Ya..jawaban diatas adalah jawaban yang terbaik bukan? tapi kenapa sebagian besar hal tersebut tidak kita pikirkan sebelumnya ?? Apakah karena kita terbiasa dengan tidak mau untuk melepas apa yang sudah kita dapatkan ditangan dengan susah payah. Dan bahkan berusaha meraih lagi sebanyak-banyaknya?

Terkadang…dengan rela untuk melepaskan sesuatu yang kita miliki, mengakui segala keterbatasan yang kita miliki dan melepaskan semua keinginan kita untuk sesuatu yang lebih mulia, kita akan mendapatkan sesuatu yang jauh lebih besar ….

source : unknown


There’s been a lot written about Apple’s dramatic release of Boot Camp, a free download that lets you repartition your Intel-based Mac’s drive and install Windows XP as an alternative operating system, but even the magazine coverage I’ve seen doesn’t give you screen-by-screen details. So let’s see what we can do about that!

Your first step is to make sure you have an Intel-based Mac: any G4 or G5 Mac will not install Boot Camp and you won’t be able to dual boot into Windows XP. You can still run an emulator like Microsoft Virtual PC, but it’s an inferior solution and my own experience with VPC has been that it’s glacial and useless for all but the most simplistic of Windows applications. You’ll also need to be able to burn a CD during the process: make sure you have a blank, burnable CD disk on hand.

Now, download Boot Camp from the Apple site and double click on the “.dmg” disk image that’s dropped onto your desktop. Here’s what you’ll see:

Apple Boot Camp Windows XP Dual Boot Installer: Finder Folder View

Your first step, as highlighted in the “Read Before You Install” document, is to print a copy of the Boot Camp Beta Installation & Setup Guide. Trust me, you’ll want it!

Double-click on the “BootCampAssistant.pkg” icon and you’ll be able to install the Boot Camp assistant:

Apple Boot Camp Windows XP Dual Boot Installer: Installing the Assistant

As with all Mac software installs, this will require you to type in your administrative password. It’s probably the same as your default account password:

Apple Boot Camp Windows XP Dual Boot Installer: Authenticate

A few seconds of activity later, you’ll have the software successfully copied onto your computer and can quit this first installer.

Now your first challenge: finding the new installation assistant! It turns out that the program is installed on your computer in Applications –> Utilities –> Boot Camp Assistant. Launch it and it’s quite possible you’ll see the same message I did:

Apple Boot Camp Windows XP Dual Boot Installer: Update Firmware

No huge problem. Quit by clicking the “Quit” button, then go to Apple’s Support Downloads and check their Available Firmware Updates list to click directly to the firmware update for your own Intel system. For my Mini, I simply go back to the downloads page and scan down for the name of my system.

Once the correct firmware update is installed, you need to reboot, but not in the usual fashion. Instead, press and hold the power button on the Mini itself — it takes about ten seconds — until the power indicator light flashes repeatedly to begin the update. Your system will boot and you’ll see the Apple icon and a progress bar:

Apple Boot Camp Windows XP Dual Boot Installer: Supplemental Photos

That will advance, it took me about 90 seconds total, and you’ll reboot again, ready to go!

Finally, we’re ready to actually start working with Boot Camp itself. The first step is to read all of Apple’s warnings:

Apple Boot Camp Windows XP Dual Boot Installer: Warnings and Welcomes

Okay, now let’s proceed. First choice: do we want to burn a Macintosh Drivers CD, which contains important device drivers for Windows XP so it can access the various hardware parts of the Mac, or do we already have one. I don’t already have one, so I’ll choose the default of “Burn a Macintosh Drivers CD now”:

Apple Boot Camp Windows XP Dual Boot Installer: Burn Windows Drivers CDROM

I slip in the blank disk and the system tells me it’s “ready to burn”. Click “Burn” and it’ll do everything necessary to create the Windows XP drivers CD. This took a few minutes on my Mini, but it wasn’t terribly long.

Next step is much more exciting: it’s time to partition the hard disk!

Partitioning is a geeky buzzword for something that will actually make a lot of sense to you, believe it or not. The idea is that if you have a large hard disk, why not configure it to act like two small hard disks? Or three? In this way, smart system administrators can isolate accounts, minimize out-of-disk-space errors and disruptions, and so on. With Apple Boot Camp, we’ll want to partition the default disk to allow us to have one “disk” that represents the Windows XP world, and another “disk” that represents Mac OS X.

By default, Boot Camp offers up a pretty tiny partition for Windows, as you can see:

Apple Boot Camp Windows XP Dual Boot Installer: Create Second Partition

I’d recommend that you make it bigger if you’re actually going to use Windows for anything important; Microsoft recommends 10GB as the smallest reasonable and functional partition, for example. If you’re just playing, however, 5GB will probably work fine (until your first big game install). I’ll make mine 8GB to be somewhere in the middle.

Change the partition sizes by clicking and dragging on the vertical bar between the two areas until you have the size or sizes you desire. With my Mini configuration, it left me with 66GB for Mac OS X, of which 20GB is free, and 8GB for Windows XP.

Once the partitions are set up as you desire, click on “Partition” and keep your fingers crossed (there is a slight chance it’ll actually mangle everything on the disk. Not likely, but I would definitely recommend you do one good, clean backup before you start experimenting with Boot Camp).

The disk partition is what we Windows folk call non-destructive or dynamic, which means that you don’t have to reformat and then reinstall everything on both “sides” of the partition. That’s a very, very good thing. :-)

Once the partitioning is done, you’re ready to install Windows itself:

Apple Boot Camp Windows XP Dual Boot Installer: Ready to Start WinXP Install

Fortunately, I have a pristine new copy of Microsoft Windows XP Pro with SP2 included for PCs without Windows (who would have thought I’d think of my Mac as a PC without Windows?) and that’s what I’ll use. My thanks to Microsoft for sending it along…

Insert the WinXP installation DVD, wait for it to be recognized by Mac OS X (it’ll show up on your desktop with a cheery name like “VRMFPP_EN”), click on “Start Installation” and kiss Mac OS X goodbye.

After a bit, you’ll see the unfamiliar blue screen of a Windows installation:

Apple Boot Camp Windows XP Dual Boot Installer: Supplemental Photos

Press ENTER or Return on the keyboard to continue, agree to the Microsoft warnings and legal restrictions page, and you’ll finally get to the “choose partition” list:

Apple Boot Camp Windows XP Dual Boot Installer: Supplemental Photos

Take your time here to ensure that you pick the correct partition! You want to use Partition C: which should match the size you just set too: notice on my screen it’s 8407MB, which is about 8GB, as expected. Move the highlight bar down to the correct partition and press Enter to actually install WinXP.

Now you need to pick a partition formatting option. The two main choices are NTFS or FAT. NTFS is more modern and supports very large partitions, but can’t interoperate with Mac OS X. FAT, on the other hand, can’t support partitions larger than 32GB, but is compatible with the Mac. You’ll see why that’s important later. For now, select FAT and do a full, not a quick, format:

Apple Boot Camp Windows XP Dual Boot Installer: Supplemental Photos

Now some time will pass while the partition is formatted using the Windows FAT32 format. It took my system about five minutes to fill in the progress bar:

Apple Boot Camp Windows XP Dual Boot Installer: Supplemental Photos

I won’t document every single step involved in installing Windows XP as it’s pretty straightforward. Just make sure you have your product key available for the verification step of the process. It’s in the package within the Microsoft Windows XP disk, and it’s really a good idea to use a new version of the OS rather than the same key you’ve used with other PCs in your office or home. Worst case, you can skip the verification step and have 30 days of “trial period” before you have to deal with finding a valid key to enter for verification purposes.

Once you’ve finished the full Windows XP install, which can take rather quite a while, your system will reboot and you’ll want to eject the WinXP install disk and slip in the Mac drivers CD you burned earlier in the process.

With Windows, this is done by going to My Computer and right-clicking on the optical drive D: then selecting Eject. Slip in the Mac disk and everything should just automatically launch and start up. If not, look for and double click on the file Install Macintosh Drivers for Win XP.exe. Here’s what you’ll see:

Apple Boot Camp Windows XP Dual Boot Installer: Supplemental Photos

I admit, it’s kind of weird to see a Mac installation program running within Windows XP on a Mac computer, but it’s a brave new world out there.

Probably, during the installation process, you’ll learn that various components of your Intel-based Macintosh haven’t passed the Microsoft Windows compatibility test:

Apple Boot Camp Windows XP Dual Boot Installer: Supplemental Photos

Apple assures us that it’s safe to continue anyway, so I did. Three times!

Then you get to go through a few waves of “new hardware found”, and in all cases you can simply accept all the default settings for each wizard, as those guys in Redmond call ‘em, and proceed. Finally, you’ll get to the last configuration screen:

Apple Boot Camp Windows XP Dual Boot Installer: Supplemental Photos

Click “reboot now” and if the hardware compatibility Gods are smiling upon you, the Mac will reboot right into Windows and you’ll be the proud owner of a Macintosh that can run Windows natively, astonishingly enough.

One last tip: to select which OS you want to run, hold down the OPTION key when you start up the Mac and you’ll be able to see both Mac OS X and Windows XP:

Apple Boot Camp Windows XP Dual Boot Installer: Supplemental Photos

Use the arrow keys to move to the choice you desire, then press Enter or RETURN to select it and zoom into that mode.

When you do boot into Mac OS X, you’ll notice that there’s a new hard disk on your desktop too, called “NO NAME”. Click on the name, count to five, and click again, then type “Windows XP” and you’ll forevermore realize what it is. And yes, you can navigate through it and find your data files from when you’re running Windows, but I’ll talk about that in another article!

It’s a long, tricky process, but I hope this explains exactly how to install and get running with Apple Boot Camp. Also, don’t miss my tutorial on how to install Parallels to run Windows XP within Mac OS X, rather than having to reboot each time you want to switch systems.

source : http://www.askdavetaylor.com/how_do_i_install_windows_xp_on_my_mac_using_boot_camp_1.html


Fakultas

Prodi

Pasing Grade SPMB 2006

Pasing Grade USM I 2007

Pasing Grade USM II 2007

Pasing Grade SPMB 2007

FSRD

Seni Rupa, Kriya, Disain dll

758

737

SBM

SBM

708

713

STEI

Elektro & Informatika

831

842

863

844

FITB

Meteorologi, Oceanografi, Geology

700

715

749

676

FTTM

Tambang, Geofisika, Metalurgi, Perminyakan,

714

791

816

768

FMIPA

Matematika, Kimia, Fisika

667

686

727

698

FTI

Teknik Fisika

700

758

817

764

FTI

Teknik Industri

780

830

847

814

FTI

Teknik Kimia

785

841

856

835

FTI

Teknik Material

695

733

774

726

FTI

Teknik Mesin

745

780

828

780

FTI

Tek.Penerbangan

700

741

808

726

FTSL

Sipil, Tek.Lingkungan, Tek.Kelautan

696

758

778

743

SAPPK

Arsitektur

695

764

717

747

SAPPK

Planologi, Perencanaan Wilayah Kota

693

731

757

732

SF

Farmasi

766

786

814

796

SITH

Biologi, Mikrobiologi

705

723

701

726

1.Passing Grade adalah NILAI PESERTA TEST MASUK YANG DITERIMA DAN BERADA DI PERINGKAT TERBAWAH DI SUATU FAKULTAS ATAU PRODI TERTENTU.

Nilai peserta test masuk dinyatakan melalui suatu pengolahan data statistik, yang didapat berdasar pemeringkatan secara nasional dari seluruh peserta SPMB 2006. Nilai IPA dan IPS dipisahkankan. BUKAN NILAI ASLI.

2.Metoda perhitungan Nilai SPMB :

Nilai mengacu pada nilai rata-rata dan deviasi standar dari nilai asli semua peserta Ujian secara nasional, tetapi perhitungan nilai peserta IPA dan IPS dipisahkan. Peserta IPC mempunyai dua macam nilai dan peringkat, yaitu nilai nasional IPA dan nilai nasional IPS

Pada SPMB tahun 2006 dan tahun 2007 ada 150 soal,masing-masing bernilai +4 bila dijawab benar, masing-masing bernilai -1 bila dijawab salah dan nilai 0 bila tidak dijawab. Jadi nilai asli maksimum = 600 ; dan nilai asli minimum = minus 150).

Berikut diberikan ilustrasi perhitungannya :

Contoh : Misal Amir adalah peserta kelompok IPC ; Misal nilai asli rata-rata nasional kelompok IPA= 250; Misal deviasi standar nasional, kelompok IPA= 50 ; Misal nilai asli rata-rata nasional kelompok IPS= 240; Misal deviasi standar nasional kelompok IPS= 60

Misal : NIlai IPA Amir yang didapat dari nilai ujian hari pertama ditambah nilai ujian hari ke dua kelompok IPA (seluruhnya ada 150 soal), misal , menjawab 100 soal, benar = 75 soal , salah = 25 soal; tidak dijawab = 50 soal. Maka nilai asli Amir = (75 x4) + (25 x -1) + (50 x 0) =275 –> selisih nilai asli Amir dan nilai rata-rata = 275- 250 = +25 ;

MAKA nilai SPMB nasional IPA dari Amir = 500 + (25/50)x100 = 600

Misal : NIlai IPS Amir yang didapat dari nilai ujian hari pertama ditambah nilai ujian hari ke dua kelompok IPS(seluruhnya ada 150 soal)misal, menjawab 80 soal, benar = 40 soal , salah = 40 soal; tidak dijawab = 70 soal. Maka nilai asli Amir = (40 x4) + (40 x -1) + (70 x 0) =120 –> selisih nilai asli Amir dan nilai rata-rata = 120- 240 = minus 120 –>

MAKA nilai SPMB nasional IPS dari Amir = 500 – (120/60)x100 = 300

setelah bca baru nyadar ternyata itungannya sedikit berbeda dari yg terfikirkan sejak sma..ya tp udahlah udh masuk,..hi2x

sumber : http://telecom.ee.itb.ac.id/~sigit


about sql

27Feb09

MySQL creating users and setting permissions using phpMyAdmin

MySQL is a multi-user database, you can set up several different accounts on the same server with many varied permissions given to each user. This ability is part of what makes MySQL so powerful. You can use either MySQL console or phpMyAdmin to create users and grant permissions. This page focuses on using phpMyAdmin.

MySQL Privileges

MySQL privileges allow each of the users to access and utilize only the areas they need to perform their tasks. This prevents a user from accidentally accessing an area where he or she should not have access this adds to the security of the MySQL server.

When you connect to a MySQL server, the host from which you connect and the user name you specify determines your identity. With this information, the server then grants privileges based upon this identity.

phpMyAdmin

phpMyAdmin is an extremely powerfully MySQL database management tool you use either locally or remotely to set up your MySQL database. Uniform Server 3.3 currently uses version 2.6.4-pl4 while 3.5-Apollo uses version 2.10.2 both have the capability of multi-user authentication.

Starting phpMyAdmin

There are several ways to start phpMyAdmin:

  • From apanel: When you start the servers (using either Server_Start.bat or Disk Start.vbs) apanel starts in a browser window.
    To start phpMyAdmin click on its link from the menu c).
  • Directly: To directly start phpMyAdmin type the following into your browser: http://localhost/apanel/phpMyAdmin/
  • Remotely via the Internet: I cover this in more detail on hosting MySQL accounts page.
    For security a centeral copy of phpMyAdmin is run from the root directory.
    To start phpMyAdming they type their domain name into abrowser, for example http://their_domain.com/phpMyAdmin.
    They will be challenged for a name and password to gain access to phpMyAdmin..

Tip: You can re-run apanel by typing http://localhost/apanel/ into your browser address bar.

Note: Menu links A) and B) Start and stop the MySQL server.

Image:Uc_mysql_apanel_menu.gif

Top

phpMyAdmin – Home

If you loose your bearings in phpMyAdmin click on the home link 1) at anytime, takes you back to the index (start) page. Image:Uc_phpmyadmin_1.gif

Top

Creating a database

Creating databases with phpMyAdmin is straightforward in this example we will create three databases named mpg3_db, mpg4_db and mpg5_db. The choice of name is a mater of taste.

Starting from phpMyAdmin home page:

1) Enter mpg3_db into the create new database field.
2) Click on create this creates the database. Click Home to take you back to the index page.

Repeat the above steps create two more databases named mpg4_db and mpg5_db we will need these later.

Image:Uc_phpmyadmin_3.gif Viewing database list:

  • A drop down menu displays all databases on your MySQL server.
  • To select a database simply click on its name.
  • Number of tables in a database is shown in brackets.
Image:Uc_phpmyadmin_2.gif

Top

Deleting a database

In the above example we created a database named mpg5_db this is not required it was created to show you how to delete a database.

Uniform Server3.3

Starting from phpMyAdmin home page: – The little house image link

3) Click on databases (see above image). This opens the database page.

A) Check (tick) databases to delete.
B) Click on Drop (Delete) when challenged “Do you really want to :” Click on Yes

Note: There are several places through out this program that duplicate tasks this page is no exception. At the bottom of the page, you find an option to create a new database.

Privileges: To view privileges set for that database click the padlock icon to the right of each database name


Uniform Server 3.5-Apollo

Starting from phpMyAdmin home page: – The little house image link

3) Click on databases (see above image). This opens the database page.

A) Over your mouse pointer over the database to delete and left click this opens a new page.
B) Click on Drop (Delete) this is located top right of page.
When challenged “You are about to DESTROY a complete database..” Click on OK this takes you back to the home page.

Note: I am sure each new version of phpMyAdmin its interface will change. This change I do like because it is logical stops you from killing more than one database in one go!

Image:Uc_phpmyadmin_4.gif

Top

Setting up a new user – with global privileges

For our first example we have a user named power_mad with a password mad123 we trust! this person so we will grant all privileges. He wants access from any host.

Starting from phpMyAdmin home page: – The little house image link.

4) Click on privileges (see above image creating databases).
This opens the User overview page.

A) Click on Add a new User this displays the add new user page
Image:uc_phpmyadmin_5.gif

Add new user page:

B) Enter user name power_mad
C) From the drop down menu select Any host
  • Note: Inserts a % code.
D) Enter password mad123
E) Re-enter password mad123
  • An alternative to entering a password into D) and E) is to click on Generate Password:
  • This automatically generates a password for you and looks something like TRwAXKhwLLHfGX:G
  • Click on Copy this inserts the password into D) and E)
F) Scroll down and click on Check All selects all privileges note these are Global (never give a user this power)
G) Click GO to create user a conformation message is displayed.

Quick Check:

Starting from phpMyAdmin home page:- The little house image link.

  • Click on databases This opens the database page.
  • Click the padlock icon to the right of each database name you will find our power_mad user has access to all databases. (remember you can use your browser back button to viewthe previous page)

Note 1: This is a serious user with identical power as root think about the implication!

Image:uc_phpmyadmin_6.gif

Note 2: At step F) Click on UnCheck All this will create a user with no global privileges. You can revoke or change the global privileges at any time.

  • Letting other users to have global privileges is a recipe for disaster.
  • It is safer to un check all priveledges and set privaliges on specific databases see next section.

Note 3: After adding a new user an additional menu becomes accessible allowing you to set Database-specific privileges. This appears at the bottom of the global privileges selection form.

Top

One database per user

A user named power_mad must raise suspicions, preempt any malicious attacks remove all global privileges and restrict this user to having access to a single database in this example mpg4_db.

Starting from phpMyAdmin home page: – The little house image link.

  • Click on privileges. This opens the User overview page.
  • To the right of user power_mad click on the edit privileges icon this opens the user page. Make sure all Global Privileges are un checked if necessary click on the Uncheck All link and click Go. With all global privileges removed continue to the next step.
  • Scroll down the page to Database specific privileges form.
Image:uc_phpmyadmin_7.gif
H) From the drop down menu
I) select database mpg4_db (database you wish to assign to this user)
J) Click on Go this opens the edit privileges page for that database.
K) Select privileges to allow.
L) Click on Go to complete

Quick Check:

Starting from phpMyAdmin home page: – The little house image link.

  • Click on databases this opens the database page.
  • Click the padlock icon to the right of each database name you will find our power_mad user
    has been restricted to access only one database mpg4_db.

Note: You can repeat this process to assign another or as many databases to a user.

Image:uc_phpmyadmin_8.gif

Top

Refresh the MySQL grant tables

Information you have changed or created when executing the above statements is stored in a database called mysql. This database was automatically created during MySQL installation. It contains several tables that hold all of the information pertaining to each user, the databases they have access to, the hosts they can connect from, and the privileges allowed for each.
The only time MySQL reads data in these tables is when it first boots (runs). It does not read those tables again unless it is told to do so. Without this step, none of your newly created users or changes to existing users will take effect.
At the bottom of the User overview page

  • Click the little house image link.page
  • Click privileges
  • You will see the following statement:

“phpMyAdmin gets the users’ privileges directly from MySQL’s privilege tables. The content of these tables may differ from the privileges the server uses, if they have been changed manually. In this case, you should reload the privileges before you continue.”

Click on reload the privileges link contained in the above statement this executes the query

SQL query:
FLUSH PRIVILEGES ;

Instructing the MySQL server to take another look at the user tables and hence puts all of your new users and privileges into operation.

That extra database

Have you discovered an extra database you cannot remove! This page explains why information_schema.

Back to MySQL User Accounts MySQL user accounts

Top


sebagai konsekuensi profesi sebagai admin,halah …disuruh nginstall email server p mash belum berhasil j…duhhh,…googling dpt source ini deh tp kok belm dpt juga solusinya,..anyone can help

I recently heard about a new webmail client from my friend Justin, who’s infatuated with it. RoundCube, a “browser-based multilingual IMAP client with an application-like user interface,” is the latest and greatest webmail client. It’s only in the alpha stage of development, which explains the jagged installation procedures, but that doesn’t mean it can’t kick some major squirrels. RoundCube is much smaller, scalable, and less resource intensive than another competitor, Zimbra, which weighs in at 150 megabytes. The interface is the stunning with lots of AJAX magic as well as user configurable via XHTML and CSS 2 skinning. I love RoundCube so much, I’m declaring it better than Gmail. Yes, you read that correctly. Hopefully by the end of this article you will have a fully functioning RoundCube webmail client on your server.

Why You Want To Install It

Take a look at some of the screenshots. It’s just as great as it looks once its on your server. I recommend you start with a RoundCube Demo. Please keep in mind the demo is heavily used and will be slow. It will be much faster on your own server. It’s got lots of the new-fangled web programming language-hybrid, AJAX, which is an acronym for Asynchronous Javascript And XML. A strong feature that AJAX totes is being able to send and receive little bits and pieces of data without having to reload the page, making for clean page transitions in RoundCube. Also the AJAX in RoundCube makes a nice floating, translucent banner on the top of the page when it is loading or has an error to display. Check out this article on Adaptive Path if you want to find out more about AJAX. Still not blown away by RoundCube? Check out Mark Boulton’s review.

Before we begin the installation there are some things you are going to need.

  • PHP and MySQL support on your server
  • An FTP client or some other way of uploading files to your server
  • Access to a terminal or command line application if you want the latest CVS build of RoundCube
  • Installation

    I will show you how to install the CVS build of RoundCube. However, if you would like a simpler way to get the files, go to this page on RoundCube and download the latest release. If you are willing to continue with the CVS download, open up a terminal. Copy and paste the following command into your terminal.

    cvs -z3 -d:pserver:anonymous@roundcube.cvs.sourceforge.net:/cvsroot/roundcubemail co -P roundcubemail

    This will automatically download the latest CVS build of the “roundcubemail” folder to your home directory. If you look inside of these folders you will see that CVS has put many files and directories all over the place (I counted 46) to keep track of things. This really just makes it slower for you to upload to your server, so you may consider deleting those before you upload it. For those of you that downloaded the tar.gz version, unzip that in your favorite decompression utility or use the terminal command tar xzf [roundcube].tar.gz

    CVS doing its thing.
    The CVS command doing its thing.

    Open up the roundcubemail folder and navigate to the config folder. In here you will find two files, db.inc.php.dist and main.inc.php.dist. Rename both of them to remove .dist. You now have db.inc.php and main.inc.php.

    Config Files

    Before we proceed, you are going to have to edit a few things in these two files. First, you need to login to your web host’s control panel so that you can create the new MySQL database that RoundCube requires. This varies greatly between hosting services, so I cannot go into too much detail. However, for Media Temple shared server customers you log into accountcenter.mediatemple.net and click on MySQL Databases in the left sidepanel and then Create Databases. Keep your browser open to this page as we are going to use it again.

    In the dialog that loads, type in the name of the database you would like to use for RoundCube. Once you’ve completed that make sure to copy the full name of the database. Most web hosts, especially on shared servers, prepend your websites name to the database name. The login and password for the MySQL database will usually be the same one you used to log into the control panel with. If not, you can contact your hosting provider and they will gladly give you that piece of information. You should probably check the emails you received when you purchased the hosting first.

    Now we can begin editing the configuration files. Open db.inc.php in a text editor. The only thing we are concerned about right now is giving RoundCube a way to access our newly created database. It’s going to need to know your login information. Find the line that says

    $rcmail_config['db_dsnw']=’mysql:// roundcube:pass@localhost/roundcubemail’;

    You are going to replace the part that says roundcube with your database login and pass with the database password. The localhost should remain the same on most configurations. The last thing to change is roundcubemail by replacing it with your database’s full name. That’s all we need to edit in this file, so now we can save and close it.

    Open main.inc.php in a text editor and change the items below to the values I have listed. We will be adding a value to default_host so that we don’t have to type it into RoundCube everytime we want to access email. It will just use localhost as the default. The session time is 10 minutes by default, but I like keeping it at 30 minutes. I’ve noticed that if you write an email and try to send it after those 10 minutes it will go back to the login page and lose your email; probably a small bug for now. The next two just change the way the dates are display and is more of a preference than anything else; it’s not necessary. Visit this page on php.net to see the parameters for setting up the date formats. The next part with useragent also isn’t necessary but it makes me happy. And then the last thing to edit is your timezone. I put -5 as I currently reside on the East Coast, so it depends where you live.

    // the mail host chosen to perform the log-in
    // leave blank to show a textbox at login, give a list of hosts
    // to display a pulldown menu or set one host as string.
    // To use SSL connection, enter ssl://hostname:993
    $rcmail_config['default_host'] = ‘localhost’;
    // session lifetime in minutes
    $rcmail_config['session_lifetime'] = 30;
    // use this format for short date display
    $rcmail_config['date_short'] = ‘l g:i A’;
    // use this format for detailed date/time formatting
    $rcmail_config['date_long'] = ‘m/d/Y g:i A’;
    // add this user-agent to message headers when sending
    $rcmail_config['useragent'] = ‘RoundCube Webmail’;
    // use this timezone to display date/time
    $rcmail_config['timezone'] = -5;

    Save the file and exit your text editor. Now that we are done configuring some things, you can upload the roundcubemail folder to your webserver. There are a few things to note. You are able to rename the folder to anything you likely without affecting the operation of RoundCube, which is nice to know because typing www.myurl.com/roundcubemail can get annoying. Renaming it to something like mail should be just fine. Fire up your FTP program and upload the folder to the root of your html directory. Note for (mt) customers: If you put your folder in the root of the html directory and name it mail.yoursite.com, roundcube will be accessible via that sub-domain; http://mail.yoursite.com. You can read up on creating a sub-domain on (mt)’s Knowledge Base.

    After the upload has completed, use your FTP program to chmod the temp and logs directories to 777. This is generally done by right clicking on the directory and then selecting info, edit or chmod. You can also chmod them with chmod -R 777 [dir] via command line if you are so inclined.

    You’re one step away from playing around with RoundCube. You need to create the tables required by RoundCube in your database. Go back into that open brower you had on the control panel page of your web host and look for a phpMyAdmin link. PhpMyAdmin is a fantastic MySQL database management tool and is pretty much the industry standard. For Media Temple customers, you can find phpMyAdmin under MySQL Databases. When you find the link, click it and log into phpMyAdmin. There will be a dropdown menu on the left pane; click on it and select your RoundCube database.

    Then, click on the SQL tab. There will be an empty box labeled Run SQL query/queries on database. In this box you are going to paste the contents of the mysql.initial.sql file located in the roundcube folder within the SQL folder.

    Once that has been pasted, click the Go button.


    This is what you should get.

    RoundCube cannot create new email users, that is done by your host. If you do not like the default email address given to you, as in it has your full name and you just want to use your first name (as was the case with me), go back to your web host’s control panel. Look for a link to adding a user. Most of the time just adding a user gives that user an email address as well. If you’re using Media Temple, expand Email/Users and then click on Add User. Fill out information on that page and click save. Your email login information should be the name of the user you just created and the password will be the same as the what you used to login to the control panel.

    Moment of Truth

    You should now be able to access your RoundCube installation by pointing your browser to the directory where you placed your roundcube folder. Once the page has loaded, login and don’t forget to append your domain to the end of your login name. For example, your login will be yourname@yourdomain.com.

    RoundCube Login Page
    You should be greeted by a page like this.

    RoundCube Tweaks

    Click on Personal Settings, then the Identities tab. Double-click on the email entry it has for you and add your name as well as any other info you wish to provide and save. From there you may click New Identity if you wish to send emails that appear to be from one of your other email addresses. Click on the Folders tab and create any folders you want to organize your emails. Also, make sure RoundCube has the proper time zone in the Preferences tab.


    Before you go, we need to test RoundCube. Send an email to your RoundCube managed email address from another email account and try to send one from RoundCube.

    Everything should work fine, unless your web host has PHP Safe Mode enabled which means that PHP’s mail() function may not, uh, function. Don’t worry, there’s a good alternative. Instead of using PHP to send your email you can route it through an external smtp service, which is only marginally slower than PHP mail(). Open your main.inc.php in a text editor and look for the following entries:

    // use this host for sending mails.
    // if left blank, the PHP mail() function is used
    $rcmail_config['smtp_server'] = ”;
    // SMTP username (if required) if you use %u as the username RoundCube
    // will use the current username for login
    $rcmail_config['smtp_user'] = ”;
    // SMTP password (if required) if you use %p as the password RoundCube
    // will use the current user’s password for login
    $rcmail_config['smtp_pass'] = ”;
    // SMTP AUTH type (DIGEST-MD5, CRAM-MD5, LOGIN, PLAIN or empty to use
    // best server supported one)
    $rcmail_config['smtp_auth_type'] = ”;

    You should contact your web host to find out the information for the first entry, smtp_server, but I just used localhost and it worked fine. Update: Media Temple just responded to my inquiry, and the real location is mail.paulstamatiou.com, so for other (mt) customers it should be the same format. The next two entries are likely going to be the same as the login/password you used to get into the web host’s control panel, so you can enter in %u and %p respectively. The last entry is usually best left alone, unless your web host says otherwise. Once you fill that information in and save the file, hopefully RoundCube will be happy.

    Now that you have the time and ability to play around with RoundCube, I suggest getting to know the Address Book. Currently, it is very simple but will soon be able to store and receive contacts in the popular vCard format and keep track of more information than just their name and email address. I like it better than Gmail, which automatically adds people to your contacts if you send them an email once. Keep in mind that this is an Alpha release, promising you much more in the future. Visit RoundCube often to keep tabs on newer versions and the roadmap to see what’s in store for the future of RoundCube. When a new version is released simply download it and overwrite all files in your roundcube folder except the config files. Make sure that the temp and logs directories are still chmod 777. Don’t take me for granted on that, you might have to keep the temp files as well. I’ll probably update this article when a new version of RoundCube comes out and I get the change to upgrade my installation.

    CSS Modifications

    Navigate to skins>default within your roundcube folder. This directory contains all of the images and CSS files that determine how RoundCube’s GUI looks. There are way too many things that could be edited to cover, so I’ll just get you started. Open up mail.css and look for #messagelist tr.selected td. The attribute background-color is responsible for the color of a selected email. By default it is a deep red #CC3333, however, I prefer blue over red so I put in a value of #3388CC. Save that and then open up common.css and add the same color value, #3388CC, to background-color for table.records-table tr.selected td and #rcmKSearchpane ul li.selected. I also decided to change the “loading” message to blue from gray. I changed background-color in #message div.loading to a light blue, #AFD7F8, and border to #3388CC. Save again.

    If you want to change the color of something in particular, find out what the hex code for that color is likely going to be (e.g., a dark gray would likely be #333333) and then search for it. Once you find it, replace it with the color you want. If you don’t know what you are doing, you shouldn’t really be playing around in the CSS files. For example, if you want to keep the original color commented out but you use only //, RoundCube won’t load properly. The correct way to comment out would be using /* */. The CSS files for RoundCube are lengthy and complex, so trial and error alone would take time. That being said, I’ll try to update this once I’ve hacked around with the CSS some more.

    I decided to brand my installation of RoundCube while I was in the customizing the CSS. By branding I mean changing the RoundCube logo image to something that pertains more to you. I opened up the roundcube_logo.gif in skins/default/images/ in my beloved Photoshop CS2. You can do the same thing. Edit the logo however you like and save it in gif, png, and a grayscale gif for the print CSS.

    I also personalized the log out message. If you would like to do the same or edit any other messages, find the messages.inc file in /program/localization/en/. Edit the $messages['loggedout'] entry as you please and then save. Mine now reads You have successfully logged out of PaulStamatiou.com. Good bye!

    Fini

    I hope you learned as much about RoundCube in this article as I did while writing it. The first time I touched RoundCube was today, so all this is new to me too. I really do believe that RoundCube has some massive potential. Given an active developer community on SourceForge, I expect RoundCube will be up-to-speed with competiting webmail applications shortly. It blows the doors off of the industry standard, SquirrelMail, which has a hideous user interface. If you enjoyed this article, please contact me. I love hearing from my readers. I’m always open to suggestions for review or how-to articles. If you should have any further RoundCube questions, the RoundCube forum is an excellent resource.

    sumber : http://paulstamatiou.com/2005/10/29/how-to-setup-roundcube-webmail-on-your-server