Programming :: Right The Shell Script Which Talk To Postgresql Database?
Jul 22, 2010i 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
ADVERTISEMENT
General :: Shell Script To Back Up A Postgresql Database?
Jun 4, 2010I need a shell script to back up and restore a postgresql database.
View 1 Replies View RelatedProgramming :: Checking Database It Running Or Not By Using Shell Script?
Jul 21, 20111. i need to check whether the oracle database is running or not if it is running it will run auto mount script.nohup /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbfs_client dbfs@xxxxx -o allow_other,direct_io /u01/app/oracle/DBFS/XXXXX < /home/oracle/passwd_dbfs.txt&nohup /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbfs_client dbfs@xxxxxx -o allow_other,direct_io /u01/app/oracle/DBFS/XXXXX < /home/oracle/passwd_dbfs.txt &2. For every 1 hour i need to check above mount points is mounted or not if it is not mounted it should be mounted.
View 3 Replies View RelatedProgramming :: Shell Script To Copy Database Archivelogs Sequentially From One Directory To Another?
Jun 2, 2009want to write a shell script to copy database archivelog files sequential from one directory to another directory within a server. I am hereby enclosing the sample archivelog file name. Archive log filename : log_0000118432_1.arc (Here number 0000118432 will be sequentially incremented by 1 for next filename). Here the catch is all Archivelogs must be copied to destination directory. Previously copied files should not be copied.
View 3 Replies View RelatedProgramming :: Make Shell Script To Use Sqlplus To Update Some Database Table?
Feb 8, 2010How can I make shell script to use sqlplus to update some database table? This is what I'd like to make:
- login to db server (I have create ssh-keygen to bypass the login session)
- login sqlplus / as sysdba
- update status set status='END' where status='BEGIN';
- commit;
- quit;
I'm using oracle 10g database and SLES 9.0
Ubuntu :: Add Database To PostgreSQL Daemon
Feb 24, 2011While 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 RelatedGeneral :: Sharing Postgresql Database
Oct 1, 2010Am 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?
Security :: Securing My Postgresql Database ?
Jan 5, 2010I 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.
Server :: Cannot Create Database In PostgreSQL
Dec 26, 2010i 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"
Ubuntu Servers :: How To Clear Postgresql Database Cache
Jan 16, 2010I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 Replies View RelatedServer :: Can't Insert A Record In A Table On Postgresql Database?
Sep 2, 2010my 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 RelatedServer :: Unable To Connect To Remote PostgreSQL Database With Java.derby
Aug 26, 2010Trying 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]....
General :: PostgreSql Error "database Disk Image Is Malformed" After Db Dump
Dec 9, 2010i 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 RelatedProgramming :: It's Possible To 'talk To' A Website Like Faceboo
Nov 11, 2010it's possible to "talk to" a website like facebook, and that's how games such as farmville have been built - i was wanting to know how this is architected, i.e. how does a website decide how to "offer up" its data to the outside world?i'd like your favourite web links, or even paper book recommendations, though i don't if those will be available or affordable over here, or, what would be especially great would be video lectures, maybe on videos?
View 4 Replies View RelatedProgramming :: C Program - To Make Scripts That Can Talk To Server's Parallel Port
Jun 27, 2010I need to make some C program under linux to make some scripts that can talk to my Server's Parallel port by sending some quare signal as high or low, so what i can do ?
View 4 Replies View RelatedProgramming :: Postgresql Put '' In Column?
Apr 9, 2010Problem is simple but I can't figure out how to solve it, I tried any possible way that I know but with no result.I'm using simple perl script with DBI and do select from one table and do update in other table with results from select, but I can't preserve my '' returned from select when doing update. I simply want my '' from first table to be '' in second but postgres makes them real new lines. I tried to escape '' with , '',"",E(I mean E'value here') in front of value that updating but they are always real new lines not '' in new table.
View 2 Replies View RelatedProgramming :: Migrate DB From COBOL To Postgresql?
Jun 27, 2011Is there a software or procedure to migrate DB from COBOL to SQL ( or postgresql)
View 10 Replies View RelatedGeneral :: Restore 200+ Mysql Database With Shell Script?
Jul 22, 2011I have 200+ mysql database dump in tar.gz format. Restoring all of them one by one is very time consuming. Is there any way so I can restore all these database in a single transaction.
View 1 Replies View RelatedProgramming :: Editing Text Files With Information From PostgreSQL DB?
May 16, 2011Is there any way to edit text files with information in a database? The file is supposed to be always the same.. the information is going to be addedd in a specific format
View 2 Replies View RelatedServer :: Change The Owner Of The Mysql Database With Shell Commands?
Jun 19, 2010i want to know how can i change the owner of the mysql data base with shell commands.
View 3 Replies View RelatedProgramming :: Shell Scripting / Create A Shell Script Similar To Ls?
Jun 5, 2011I am trying to create a shell script similar to ls, but which only lists directories. I have the first half working (no argument version), but trying to make it accept an argument, I am failing. My logic is sound I think, but I'm missing something on the syntax.
Code:
if [ $# -eq 0 ] ; then
d=`pwd`
for i in * ; do
if test -d $d/$i ; then
echo "$i:"
code....
Programming :: Bash-shell-like Less Functionality In The Python Shell?
Jun 25, 2010Is there some type of functional way to read things in the Python shell interpreter similar to less or more in the bash (and other) command line shells?
Example:
Code:
>>> import subprocess
>>> help(subprocess)
...
[pages of stuff to read]
...
I'm hoping so as I hate scrolling and love how less works with simple keystrokes for page-up/page-down/searching etc.
General :: Create A New Mysql User And A Mysql Database At The Shell Prompt?
Aug 7, 2010How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedProgramming :: What Database To Use For C++
Jan 27, 2010What database can I use for c++?,this is my first week programming in c++.
View 14 Replies View RelatedProgramming :: Prevent "leak" Into Shell From A Customized Shell Menu Script?
Dec 15, 2009I've created a simple script based menu. This menu will be accessed by only a certain users via ssh.When user logs in, the menu will automatically run. (configured at user's .bash_profile).How do I force the session to close when user hits Ctrl-C or Ctrl-Break ?In a nutshell, I don't want user to have access to shell.
View 11 Replies View RelatedProgramming :: Check If There Is Such A Value In The Database
Feb 10, 2010sql statement. I am trying to check if there is such a value in the database.
Code:
string NewMovie = "ww";
string queryText ;
queryText = "Select * from movie_info WHERE movie_title = '"+ NewTitle +"'";
MYSQL *conn;
conn=mysql_init(NULL);
mysql_real_connect(conn,host,username,password,database,0,NULL,0);
[Code]......
return 0; The problem i am facing is how do i check if the value is found. I read up and found that a query will return a value of TRUE if the query is a success and a FAIL if there is an error. How do i call these values and then based the check on it?
Programming :: Creating Database Using C Language
Apr 7, 2011How to create a database using c language it includes structures, pointers, arrays and switch..
View 4 Replies View RelatedProgramming :: Ping Hosts From Database?
Apr 26, 2011I have a php scriptI want it to ping list of ips from a databse(using fping) and based on the status of the values to put them in a field(status) into the database(0 if down,1 if up)i executed tghe script and it gives me this error:Thread 1 - 17:51:01 26-04-2011 4.2.2.2 alive Couldn't execute query.I cant see what 's wrongthis is the source of the php script:
<?php
require_once("conf.php");
$connection1 = mysql_connect($h, $u, $p) or die("Couldn't connect.");
[code]....
Programming :: PHP & MySQL - Query A Database From The Web?
Apr 26, 2010I have created a database which stores students grades for different stages of a project. One of the stages of the project is the specification part. I have a simple bit of html code which is going to be used as the searching facility. I want the user to be able to enter their ID and then it will display only their results. At the moment, it is displaying the results for EVERY student because I cant seem to find the correct syntax for my statement.
Heres the HTML code
<html>
<head>
</head>
<body>
<body bgcolor="#6881bb">
<center>
[Code]....
At the moment when i click the button, no matter what I enter every students marks appear on the screen.
I think, but obviously dont know for sure because if i did i would know how to solve the problem, the code that i need to change is in green.
Programming :: Shorten The Long URL Without Using Database?
Aug 9, 2010How to shorten the long URL without using database(i.e. without storing url entries in DB)?
View 2 Replies View Related