Help, scidb.py initall problem


#1

[root@SvomSN etc]# scidb.py initall svomdb
Cleaning up old logs and storage files.
init(node 0 (192.168.28.50) instance 0)
Reinitializing and registering local scidb instance/storage.

sudo privileges are required to configure the postgres database.

log4cxx: Could not read configuration file [/opt/scidb/11.06/share/scidb/log1.properties].
log4cxx: No appender could be found for logger (scidb.entry).
log4cxx: Please initialize the log4cxx system properly.
terminate called after throwing an instance of 'scidb::SystemException’
what(): could not connect to server: Connection refused
Is the server running on host “192.168.28.50” and accepting
TCP/IP connections on port 5432?

[root@SvomSN etc]#
[root@SvomSN etc]# scidb.py startall svomdb
start(node 0 (192.168.28.50) instance 0)
Starting SciDB server.
[root@SvomSN etc]# iquery
298 [0x7f5f7216f820] FATAL scidb.services.network null - Error #system:111 when connecting to localhost:1239
298 [0x7f5f7216f820] FATAL scidb.services.network null - Error #system:111 when connecting to localhost:1239
iquery Error #system:111 when connecting to localhost:1239


#2

Hello,

You are seeing the error because SciDB cannot connect to the postgres database.
Postgres needs to be running in order for SciDB to work.

You should see active postgres processes and you should be able to login and query the postgres database:
For instance:

apoliakov@gepard:~$ ps axf | grep postgres
  808 ?        S      0:03 /usr/lib/postgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c config_file=/etc/postgresql/8.4/main/postgresql.conf
  819 ?        Ss     0:47  \_ postgres: writer process                                                                                                    
  822 ?        Ss     0:38  \_ postgres: wal writer process                                                                                                
  826 ?        Ss     0:09  \_ postgres: autovacuum launcher process                                                                                       
  827 ?        Ss     0:05  \_ postgres: stats collector process                                                                                           
 3002 pts/0    S+     0:00      \_ grep --color=auto postgres

apoliakov@gepard:~$ sudo su postgres
postgres@gepard:/home/apoliakov$ psql
psql (8.4.8)
Type "help" for help.

postgres=# \l
                                  List of databases
   Name    |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileges   
-----------+----------+----------+-------------+-------------+-----------------------
 mydb      | mydb     | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                             : postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                             : postgres=CTc/postgres
(4 rows)