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?
I need a shell script to back up and restore a postgresql database.
View 1 Replies View RelatedWhile 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 RelatedI 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.
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"
i created a db_dump from PostgreSql-8.2 and trying to dump it into PostgreSql-8.4 new install. 2 of the 3 databases are fine, except for minor issues, but the 3rd database is giving me the following error message when i start a service calling on it, assist: "database disk image is malformed"
View 1 Replies View RelatedI just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 Replies View Relatedmy 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 Relatedi 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 RelatedTrying 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]....
i have installed mysql in ubuntu server 10.04 and want to access the database from windows xp.
View 1 Replies View RelatedI am new to Linux and ave installed Ubuntu on my system along with Windows XP (Dual boot). I would like to find out if there is a way to share a database between these two operating systems.
Currently, I have a Microsoft Access database which I would like to use in either OS. I understand that Access probably won't work in Linux so I am willing to go to a different DB application as long as I can access it from both operating systems. Database is very simple. It allows you to input into an Access Form and then allows you to print a simply one page report based on the data just entered.
am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies View RelatedI am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies View RelatedPostgresql 9 en OpenSuse 11.3 Starting Failed
[Code]....
I'm learning via baptism by fire method here, and need to test PHP connectivity to a local postgresql 8.3.9 setup. (CentOS 5.5 x86_64). I have got PHP and Postgres both working; I can pull up a test PHP page via web browser, and I can login to postgres via the command line. What I can't figure out is how to test PHP connectivity to the local DB.
I found this test script:
Code:
<?php
$conn = pg_connect ('dbname=template1');
?>
Which I've named, testdb.php - when I run ./testdb.php from the CLI though, I get:
Code:
./testdb.php: line 2: ?php: No such file or directory
./testdb.php: line 3: syntax error near unexpected token '"dbname=template1"'
./testdb.php: line 3: `$database=pg_connect ("dbname=template1");'
I've seen a LOT of pages describing the internal code of the PHP file, but as a newb to this, I don't know how to execute this test. I've ran chmod 755 against the file to verify permissions, but this didnt effect the results. I've also done a "chmod +x testdb.php"
Code:
PHP 5.1.6 (cli) (built: Mar 31 2010 02:39:17)
I realized I wasn't doing this:
Code:
php testdb.php
but when I do, I get this error message now:
"PHP Fatal error: Call to undefined function pg_connect() in /var/www/html/testdb.php on line 3"
I want to uninstall Postgresql on LINUX redhat. I have installed it from source. how do i do it?
View 5 Replies View RelatedI'm wondering how I start it automatically when I boot up the ubuntu 10.04? especially, when I created the user "postgres", I set a password to it. every time I issued "su - postgres" command, I need to give it a password.
View 2 Replies View RelatedI am using RHEL 5.0. I am having problem with postgresql service it is not starting, not stopping, not restarting.
View 5 Replies View RelatedI have made a cluster between two server.
In luci I can see that my cluster is green and the two nodes to.
I have make an IP resource and associate it to a service : green : I can relocate the service from a node to the other one and the IP appears in the list of IP addresses
The problem is that I have made the same in order to configure tomcat and postgresql and it does not work...
I put my configuration only for ip and tomcat:
My host configuration code...
Relational databases usually have their data over in /var/lib/something. Users are in /home (with data in /var/www). How can I apply a single total disk space quota across all of these independent software systems (file systems, RDBMS, etc.)?
P.S. There's a bet going on around me as to just how awesome SU is. Let's see what you've got.
Im using WPA with a TKIP pre-shared key...Can a client pc im sharing my key with access my files if im not file sharing? Router config?
View 2 Replies View RelatedI recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?
View 2 Replies View RelatedI have been ordered to transfer my database running on oracle 10g on linux 32 bit OS to linux 64 bit. I need to know the advantages of 64 bit over 32 bit. Besides i would like to know if would face any difficulty while i migrate the database from 32 bit to 64 bit.
View 3 Replies View RelatedSpecifically I'm looking for a native Linux program that is similar in functionality to Navicat or SQLYog. I.e. I need something good at editing data. Free would be best, but not essential.
View 9 Replies View RelatedI recently installed a portable WAMP server on my usb stick. Really nice, I can do some php programming on my girlfriend's windows7 laptop without installing anything on it.I also have a LAMP environnement on my linux computer.When I plug my usb stick on my linux box, I can easily mount -o bind /usbstick/wwwfolder ~/public_html and work on my php script from there.
But my question is, is there a way I could get the database from my usb stick's MySql server, to run on my linux MySql server? So I can modify data base schema from my Linux workstation, doing some INSERTS in some tables, and then plub my usb stick on the laptop and get my up-to-date database running from the portable environnement?I don't know where / how MySql stores its databases. Basically, I want to "mount" the database from the usb stick in my Linux' installed MySql server, without extracting and importing the data, so there is just ONE database used for BOTH environnement.
parsing the text file in perl.I have very large text file with plenty of columns and rows.how can i parse the file into Oracle database.
View 3 Replies View RelatedI would like 2 computers (same network) to use the same SQL database. How should I start?
View 2 Replies View RelatedI posted a thread regarding a CD Base Application. I can run the program, but for some reason It does not seem to work properly.
For some reason in exits the program back to the command prompt. I am using the code from Linux programming 4th edition which you can get it from here...and in the folder ch08/app you will find all you need to create the CD database application.
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.