Server :: Unable To Connect To Remote PostgreSQL Database With Java.derby
Aug 26, 2010
Trying to get OpenbavoPOS to connect to my remote Postgresql database, but so far i've only been able to connect to the local postgres installation. I _am_ able to access the remote databases with psql. I've read literally dozens of pages, and am pulling my hair out. I'm trying jdbc:derby.//192.168.15.10:5432/bravo I get back java.sql.SQLException no suitable driver found for jdbc:derby.//192.168.15.10:5432/bravo If I use jdbc:derby./root/bravo - all is OK, using a local database created in /root I have jdk installed on the client; does it need to be on the server also?
Server = CentOS 5.4 PostgreSQL version 8.1.21
Client = CentOS 4.8 PostgreSQL version 8.1.4
[code]....
View 1 Replies
ADVERTISEMENT
Dec 26, 2010
i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password
createdb company
Password:
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
View 1 Replies
View Related
Sep 2, 2010
my database (PostgreSQL) has ever funtioned OK, but today don't let me insert a new row in a table and the record itsn't duplicated. I did a vacuum full and reindex the database and the problem continue. I don't know what the fuck is happening
View 2 Replies
View Related
Jun 21, 2009
I have recently Installed Fedora 11. I have installed postgres like yum install postgresql but I wonder there is no user created for postgres when I tried su postgres system says, no identity for user postgres. even when I tried to connect postgres server using psql then it says
Code:
psql: could not connect to server: No such file or directory
Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
View 1 Replies
View Related
May 11, 2010
I am not able to connect to the Remote VNC Server..Error: ConnectToTcpAddr: connect: Connection refused.
View 6 Replies
View Related
Jul 27, 2009
I install one server in my system(linux 5.0) and accessing that server through the 127.0.0.1 private ip address(lo). While i connect to a remote server for validating registry it gives me the error and unable to connect to remote server. here some of the files i give here in below to know my system network configuration
/etc/hosts
------------
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
127.0.0.1 cp.softidsolutions.org
[code]....
View 5 Replies
View Related
Jun 4, 2011
I installed dovecot on my server and now the imap and pop3 ports are open.But when I want to telnet it, it's not possible.Code: Trying 127.0.0.1...telnet: Unable to connect to remote host: Connection timed out.Also I can't any ports else. But I can connect to it from other computers. I tried to connect to this from my PC and it was successful.
View 7 Replies
View Related
Nov 16, 2010
I'm trying to connect to a remote database but can't connect directly (I think due to security reasons). Here's the setup:
Computer A - my computer
Computer B - server, I can SSH to this from computer A
Computer C - server that runs database, I can SSH to this from B but can't from A
Any ideas how I can can connect to C directly from A? I think I need to setup a tunnel or something like that but I can't figure it out.
View 3 Replies
View Related
May 2, 2011
I've got a 80 MB sql_acii backup database from our previous crashed down open solaris pc. I am trying to restore it to the postgresql of Fedora 13 but this error appears:pg_restore [custom archiver] could not uncompress data: incorrect data checkpg_restore*** aborted because of errorProcess retured exit code 1
View 1 Replies
View Related
Feb 24, 2011
While watching the text scroll by as I shut down I noticed that there is a PostgreSQL Daemon running somewhere. The question I have is, how do I add myself and my own database to this daemon or do I need to run one on my own user?
View 2 Replies
View Related
Oct 1, 2010
Am using mandriva 2008 i developed one simple application using cross platform = Qt3 Database = PostgreSQL
I want to share my database over peer to peer network.
server ip = 192.168.1.5
client ip = 192.168.1.6
Now how to share data over those ip?
View 1 Replies
View Related
Jan 5, 2010
I run Slackware 13.0 and I have an apache server 2.2.13 with a postgresql 8.4.1 database attached to it via php 5.3.0. Both the apache server and the postgresql database are on the same machine.
I have the apache server port 80 exposed to the WAN. It is not a fqdm, it's just a simple IP address. On my index page, a user can login with a user/password that encrypts to md5 via postgresql and takes them into the database.
Here is the vulnerability. Can't a hacker just scan port 80 and find my ip address running apache. Go to my index page, see that I accept user/password for authentication into my postgresql database. Then they could setup a script to simply inject html GET requests of random users and passwords and use those values on the php page(the one where the action link is pointing to in the form tag) that contains user login/password in php to login to my postgresql database. There's nothing stopping that. It would be a simple dictionary attack.
I checked out postgresql documentation and it suggested using ldap, kerberos, or md5 and not trust. I'm using md5 already. I currently use fail2ban for proftpd and sshd and it works great. After 6 failed user/pass attempts on either of these services, the IP gets banned via iptables for 24 hours. I love it. I was wondering if I could use that. Of course postgresql port is not exposed to the WAN which is a good thing. I know that when I put in a wrong user/pass from my index page, I get sent to a default postgresql pg_connect warning page. Perhaps I can increase the verbosity of postgresql's logger, find the phrase that it spits out when there's been a bad login and create a filter using that.
I understand that the way it is currently setup, my server is pretty secure, but where there's a will there's a way. I just feel that my postgresql database is unprotected even tho the postgresql port is not exposed to the WAN. They could just bruteforce from the apache server.
View 12 Replies
View Related
Jun 16, 2011
I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.
[code]...
View 10 Replies
View Related
Jan 16, 2010
I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 Replies
View Related
Jun 4, 2010
I need a shell script to back up and restore a postgresql database.
View 1 Replies
View Related
Jul 22, 2010
i want to right the on linux box which have postgresql and i what some data from the different table and put it in .csv file.
View 2 Replies
View Related
Aug 8, 2011
I have two Centos 5 servers one running Asterisk with PHP installed and another sever running as a MySql Database server, at the moment when I try run simple script to see if I can connect to the remote server I get the following error.Quote:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View 2 Replies
View Related
Jan 29, 2011
Enable remote access to MySQL database server I used the link above to enable remote access to mysql for a specific user. But when I try to telnet 3306 or user mysqladmin to connect, both just hang there. Using mysql 5.0 on opensuse 11.1
View 1 Replies
View Related
Jun 5, 2011
I have a database in SQL Server 2005 in my local Windows System and I want to import this database to my linux (ubuntu) server remotely using putty.
View 5 Replies
View Related
Sep 26, 2010
I have a centos 5.5 machine. I have forwarded both port 22 and 8080 on my router. I can connect on 22 via telnet ip 22 and even can remotely login into the machine. The problem when I start my java listener program which is listening on 8080 it cant not establish any connection (via telnet ip 8080). I have even add this into the iptables too -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 9000 -j ACCEPT. I have disabled the SELINUX too.
View 9 Replies
View Related
Feb 1, 2010
I'm trying to install postgresql 8.3 on Ubuntu 8.04 LTS server and I'm running into problems starting it. Commands I've done # apt-get install postgresql postgresql-common Things I've tried Starting it manually
# /etc/init.d/postgrsql-8.3 start
Nothing appears in my /var/run/postgresql When I try and start psql as the postgres user I get the following error psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? I've been following the docs at: https://help.ubuntu.com/community/PostgreSQL
View 2 Replies
View Related
Apr 28, 2011
how to connect the database to proxy server.example:: this is the acl in squid.conf to block the website.the keyword that want to block store in file .txt
acl block_advertisers urlpath_regex -i �/etc/squid/
block_advertisers.txt�
acl block_entertainment urlpath_regex -i �/etc/squid/
[code]...
a bit info, the data that stored in database is a keyword to block the website if a keyword in blacklist match with the url that want access by user. if match so then the user cannot access the website.
View 6 Replies
View Related
Mar 3, 2010
How to connect my mysql database server from outside network. because its locally works and i cant able to connect from outside and different networks. when i try i am getting like this error.
ERROR 2003 (HY000): Can't connect to MySQL server on '123.136.126.179' (113)
View 2 Replies
View Related
Sep 3, 2010
I've created a application,i tried to deploy in JBoss application server..that application working fine.so i tried to run my allication in apache web server,i have done some configuration in apache & installed apache-tomcat connector also..its working fine.but i will try access next page its showing error.
View 1 Replies
View Related
Oct 19, 2010
My boss has suggested installing the unixODBC driver in one of our Red Hat 5 servers in order to connect to a Microsoft SQL/SERVER database (Windows server).
View 1 Replies
View Related
Feb 24, 2011
I was able to connect linux server on windows through putty.But now i am unable to connect that,I can able to ping that IP.SSH daemon is also running. shall i need to change anything in configuration file...
View 5 Replies
View Related
Jan 1, 2010
I installed Ubuntu 9.10 on a friends computer when Windows died on it, and though she has had relatively few problems with it, she still occasionally has problems that are really hard to impossible to fix over the phone. She is also not very knowledgeable with computers, so I was trying to guide her through setting up so I could connect to her remotely and try to figure things out, but I cannot get it to work.
I personally don't use Ubuntu on my computer, I use openSUSE and KDE so that does add to the problem, though I have used Ubuntu and Gnome a lot in the past.
I had her go to remote desktop settings and allow connections from other computers and allow other users to control the desktop, and at first I had her require confirmation and a password but it didn't work without it either. When I try to connect, it just hangs for a while then times out. I tried using KRDC and just VNC in the terminal with the same result.
There should be nothing on my side preventing a connection, but I am not positive. I am not very familiar with remote desktop outside of a LAN either. I am just trying to connect using her IP address, I don't know if there is anything else I need to include. Is there maybe some other setting that needs to be changed or maybe her DSL modem/router is blocking me though I don't know why it would, especially since P2P programs work fine.
View 4 Replies
View Related
Oct 18, 2010
I have two machines. One is for web server and the other is for database server.I need to install php in the web server and postgresql in the database server. I installed postgresql. But could not install php as it needs postgresql library during configuration steps.
View 1 Replies
View Related
Oct 16, 2010
Web Server
================ I have been successful to set up the pic-1 server.
| | This requires only one machine.
| Apache |
[code]....
But now I have two machines.One for Database server and the other is for Web server.pic-2 describes it.
Server Database Server
================ ================
| | | |
| Apache | | |
[code]....
I have installed postgresql in one machine.Apache has also been installed in the other machine. But php requires postgresql library support during configuration.I cant remotely access the postgresql from the other machine during configuration.
View 2 Replies
View Related
Mar 25, 2010
I like to telnet from windows but unable to connect to the remote computer..
from windows i can ping the system its working
telnet service is on
from only i mentioned the windows IP...
View 3 Replies
View Related
