udah bisa ternyata waktu create user harus bikin passsword lagi createuser adi -P
makasih On Tuesday 30 October 2007 19:09, adi nugroho wrote: > > > pertanyaan : > > > 1. kenapa tidak mau konek dengan phppgadmin ? kalo masalah dengan port > > > 5432 bagaimana cara aktifin port 5432:tcp nya ? > > > > Caranya edit file postgresql.conf yang terdapat didirektory datanya. > > masih inget perintah: $initdb --locale=C -D data, khan? > > > > disitu ada satu switch yang masih disable, yaitu: listen_addresses dan > > port. silakan dicoba, cara reload kalau sudah edit file > > postgresql.conf bisa pakai: > > > > $ /usr/local/bin/pg_ctl -D data reload > > aku ubah postgresql,conf di directory /var/lib/postgresql/7.4/main > saat aku nmap hasilnya > -------------- > [EMAIL PROTECTED]:/etc/init.d$ nmap 127.0.0.1 > > Starting Nmap 4.10 ( http://www.insecure.org/nmap/ ) at 2007-10-30 18:49 > EIT mass_dns: warning: Unable to determine any DNS servers. Reverse DNS is > disabled. Try using --system-dns or specify valid servers with > --dns_servers Interesting ports on localhost (127.0.0.1): > Not shown: 1675 closed ports > PORT STATE SERVICE > 80/tcp open http > 631/tcp open ipp > 3306/tcp open mysql > 5432/tcp open postgres > > Nmap finished: 1 IP address (1 host up) scanned in 0.167 seconds > [EMAIL PROTECTED]:/etc/init.d$ > -------------------- > > keliatan ada kemajuan namun jadi masalah berlanjut > jadi penasaran ni... > > > 1. aku kan sudah createuser adi dengan password 'adi' dan user postgres di > kasi password 'password' > 2. kalo pake psql bisa > -------- > [EMAIL PROTECTED]:/etc/init.d$ su postgres > Password: > [EMAIL PROTECTED]:/etc/init.d$ createuser adi > Shall the new user be allowed to create databases? (y/n) y > Shall the new user be allowed to create more new users? (y/n) n > createuser: creation of new user failed: ERROR: user "adi" already exists > [EMAIL PROTECTED]:/etc/init.d$ su adi > Password: > [EMAIL PROTECTED]:/etc/init.d$ psql adi > Welcome to psql 7.4.13, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help on internal slash commands > \g or terminate with semicolon to execute query > \q to quit > > adi=> \l > List of databases > Name | Owner | Encoding > -----------+----------+---------- > adi | adi | UNICODE > focus | postgres | UNICODE > template0 | postgres | UNICODE > template1 | postgres | UNICODE > (4 rows) > > > ------- > 3. sekarang aku pake phppgadmin.... masih > --> Login disallowed for security reasons. > sedang kalo pake pgaccess untuk akses ke db focus hasilnya > Error trying to connect to database 'focus' on host localhost > PostgreSQL error message : > Connection to database failed > FATAL Password authentication failed for user "adi" > > pakai pgadmin III juga errornya sama > pakai user postgres dan pass 'password' juga sami miwon (sama saja > errornya) > > 4. Mohon bantuannya keliatannya tinggal selangkah lagi nih... > > > > 4. mohon bantuannya SOS aku dah mau putus asa nih........ > > > > Jangan putus asa, sebab kalau putus asa ntar jadinya malas belajar > > lagi, kalau tidak putus asa mau terus mencoba, ntar akhirnya jadi > > expert juga... hehehe.... > > hehehe gak jadi putus asa deh... tapi bantuin ...... > > adi n -- FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab Unsubscribe: kirim email ke [EMAIL PROTECTED] Arsip dan info milis selengkapnya di http://linux.or.id/milis
