Petr Mensik's questions

I have encountered strange problem when I was deploying our application to AWS (more precisely Elastic Beanstalk which is based on EC2). We are using certain VOIP provided whose address is vh1107.ipex.cz. Application works normally on localhost (even on different hosting) however on AWS it fails to connect to this address. I also cannot ping it when I log to the instance, however it can ping any other internet address I tried. So what is wrong here? Could this address be on some AWS blacklist?

EDIT

Sorry I've put my question wrongly. I know difference between HTTP and ICMP, the thing is however I can ping it from my own machine so it means that server listens to ICMP and problem is in the AWS. Same goes for any HTTP client, e.g. curl vh1107.ipex.cz/calls -v runs fine on my machine but request hangs on AWS. Our former hosting can reach the server as well.

I decided to to run PostgreSQL on my Fedora 20, so I did

sudo yum install postgresql-server.x86_64 postgresql-libs.x86_64 postgresql.x86_64

Now if I do postgres -D /var/lib/pgsql/data under regular user I receive Permission denied for "/var/lib/pgsql/data/postgresql.conf", if I try it under root I get some error about that I shouldn't run postgres under the privileged user.

I understand these two errors, but now it's getting weird - sudo -u postgres postgres -D /var/lib/pgsql/data gives me error I am missing postgresql.conf - if I create it under root (because root owns the directory) it again complains about permissions during startup. If I try to run initdb -D /var/lib/pgsql/data it doesn't work too because if improper rights (dir is owned by root).

So I am really not sure what I am supposed to do, is there anything that I have done wrong? Because everything in /var/lib/ is owned by root and it's default place for configuration in Fedora (at least for postgres) so it seems to me really messed up.

We have a page on our intranet which is just plain/text encoded in UTF-8 and it contais insert scripts for database. And problem is, when I download this page to a file with wget or curl, my downloaded file has UTF-8 encoding but special characters(Czech language chars) are broken.

So where could be a problem?I can convert it to CP-1250 encoding which works fine(I also tried ISO8859-2, it doesn't work either), but I can't use it for db insert via SQL*Plus, because our DB is encoded in UTF-8.

Thanks a lot for answers

I have a problem with running SQL*Plus in the bash. Here is my code

#!/bin/bash

#curl http://192.168.168.165:8080/api_test/xsql/f_exp_order_1016.xsql > script.sql
wget -O script.sql 192.168.168.165:8080/api_test/xsql/f_exp_order_1016.xsql
set NLS_LANG=_.UTF8
sqlplus /nolog << ENDL
connect login/password 
set sqlblanklines on
start script.sql
exit
<<endl

I download the insert statements from our intranet, put it into sql file and run it through SQL*Plus. This is working fine. My problem is that when I save the file script.sql my encoding goes wrong. All special characters(like íášč) are broken and that's causing inserting wrong characters into my DB. Encoding of that file is UTF-8, also UTF-8 is set on the XSQL page on our intranet. So I really don't know where could be a problem.

And also any advices regarding to my script are welcomed, I am total newbie in Linux scripting:-)