I cannot connect postgresql using PHP on redhat5. I am using adodb library for database manipulations. It showing the error that could not open the stream adodb/adodb.inc.php file..
View 2 Replies
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"?
we did get php installed! Now for the next question...having trouble getting php to connect with postgresql database. I believe this has to do with the php.ini file. What directory do we put the php.ini file? and do we just use the php.ini-dist file that was downloaded during install rename it php.ini and add under dynamic extensions extension=pgsql.so?
Believe that php.ini should go under
/usr/bin
directory, because that is what we type when running php script
/usr/bin/php some_script.php
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]....
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
with internet configuration in linux Redhat5 server, i have inspiron 1525 with network adapter Marvell Yukon 88E8040.
View 5 Replies View RelatedWhere I get open office for redhat 5 and which version and how to install it.
View 3 Replies View RelatedWhen implement openswan in redhat5 and start ipsec appear this problem
whack: Pluto is not running (no "/var/run/pluto/pluto.ctl")
what this file contain
and when run this command
ipsec verify
Checking your system to see if IPsec got installed and started correctly:
Version check and ipsec on-path [OK]
Linux Openswan U2.4.10/K2.6.18-8.el5 (netkey)
Checking for IPsec support in kernel [OK]
Testing against enforced SElinux mode [FAILED]
SElinux is running in 'enforced' mode. Since no working SElinux
policies exist for Openswan, SElinux should be disabled.
echo "0" > /selinux/enforce (or edit /etc/sysconfig/selinux)
NETKEY detected, testing for disabled ICMP send_redirects [FAILED]
Please disable /proc/sys/net/ipv4/conf/*/send_redirects
or NETKEY will cause the sending of bogus ICMP redirects!
NETKEY detected, testing for disabled ICMP accept_redirects [FAILED]
Please disable /proc/sys/net/ipv4/conf/*/accept_redirects
or NETKEY will accept bogus ICMP redirects!
Checking for RSA private key (/etc/ipsec.secrets) [DISABLED]
ipsec showhostkey: file `/etc/ipsec.secrets' does not exist
Checking that pluto is running [FAILED]
whack: Pluto is not running (no "/var/run/pluto/pluto.ctl")
Two or more interfaces found, checking IP forwarding [FAILED]
whack: Pluto is not running (no "/var/run/pluto/pluto.ctl")
Checking NAT and MASQUERADEing [OK]
Checking for 'ip' command [OK]
Checking for 'iptables' command [OK]
I used to be Novell admin/CNE more than nine years. Since Novell sunset, I study myself and move to Linux...... At daily work, I face a lot challenges of Linux. I really need to get help from experienced Linux people. How to clean up disk space on /var partition Red Hat 5.
View 4 Replies View Relatedhow to find phpmyadmin read me file in redhat5
View 1 Replies View RelatedI have installed CentOS and Redhat5 on a LVM partition and selinux is enabled. Both OS's share the same /home partition with one user with the same login(gc) and same uid (1000). The problem I am having is that gc can login with all permissions etc on the OS that was installed first (CentOS). For the redhat OS gc can login but cannot write to the home directory (or startx since X needs to write to Xauthority)Here are outputs - 1st CentOS
[gc@shuttle ~]$ ll -Zd $HOME
drwx------ gc gc system_ubject_r:unlabeled_t /home/gc
[gc@shuttle ~]$ stat $HOME
[code]....
I am in very much need to resolve the issue of Upgrade redhat5 from glibc 2.5 to glibc 2.7. The problem is when I run a binary compiled on our build setup (glibc 2.11) on Suse 11 (glibc 2.9) it works fine...
But the same binary do not work on redhat enterprise version 5 telling error as need glibc2.7 or sometimes segmentation fault for the same binary execution.
I tried upgrading the redhat glibc 2.5 to glibc 2.7, but not successful.
I upgraded my server machine to F12 without realising that postgresql gets upgraded to 8.4, and without realising that 8.4 can't work with 8.3 databases.
Is there a way to install postgresql 8.3 on F12, preferably from Fedora repositories?
Alternatively, is there a way to migrate an 8.3 database to 8.4? I know that the recommended approach is to dump and restore the DB, but now that I have upgraded to F12, the pg_dump command doesn't work anymore.
There is also this open-source tool called pg_migrator but I couldn't find a package for it and it requires a complicated compilation and installation procedure.
The simplest solution seems to me to remove pg 8.4 and install 8.3 on Fedora 12.
I upgraded some days ago from F14 to F15, I once had postgresql-server configured and running, but now I'm getting errors when starting the service and I can't understand where the issue is.
Here some infos
Code:
# /etc/init.d/postgresql start
Starting postgresql (via systemctl): Job failed. See system logs and 'systemctl status' for details.
[FAILED]
Code:
# systemctl --failed
UNIT LOAD ACTIVE SUB JOB DESCRIPTION
[Code]....
This is what I get: think its partially removed or something.
Code:
server@A-srvr:~$ sudo apt-get remove --purge postgresql
Reading package lists... Done
[code]....
I am trying to install postgres on my system. The software center doesnt have postgres listed. Am I missing something?
View 1 Replies View RelatedProblem 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 RelatedIs there any simpler method to downgrading to PostgreSQL 8.2.x? I am installing an application that requires it. I have removed postgresql 8.3 and tried to install some older fedora packages, but it did not go well.
My next step was to compile from scratch. However, I'm not real experienced with make/compiling and am fond of the organizational structure of RPMs.
The other option I could pursue is keeping 8.3 and installing an isolated 8.2 server for exclusive use by this app.
I'm still new to PHP and SQL, but all the tutorials I've found connect to the database like this:
PHP Code:
Right now I'm just doing local network tests before exposing everything to the Internet.
Wouldn't leaving the password in there as plain text be a huge security issue? I tried downloading the php file off the server, and it just comes down blank. So does PHP already have a security feature that doesn't allow anyone to just nab PHP files off the server?
And for Postgre, I have pg_hba.conf set up to "trust" it's own IP address:
Code:
Would I need to use something like Kerberos, PAM, or ident authentication? Right now the only plan is to use it as login system for a website. The clients themselves won't be accessing the DB itself, because all the DB access will be through PHP.
I want to know how to start with postgresql
os using : fedora 10
installed postgresql with the DVD rom , by clicking the check box while installing fedora
i tried postmaster , initrd , psql commands.... (command not found error coming)
i created a local user ...........]#adduser postgresql password : 123456
for working with postgre.
as one of my friend told i installed phpPgAdmin also ...........]# yum install phpPgAdmin
now i just want to work with the postgresql....!!!
and i need full steps as i am a beginner...
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 RelatedI'm trying to install pg_config so I can get some simple reports regarding my PostgreSQL 8.4.7 installation.
I downloaded pg_config and its dependencies and tried to install them with the package installer, but it wouldn't go because it seems like something may be wrong with the libkrb5-3 and libkrb5support0 packages - they won't install and the package installer just zips through without reporting missing dependencies or anything. The MD5, SHA1, and SHA256 checksums all match, but they just won't install.
I downloaded all the packages from the ubuntu [security] repository.
Because my Ubuntu 10.04 (Lucid) machine is not connected to the internet, I download packages to my Windows 7 machine, transfer them across my network to a shared folder on my Ubuntu machine and double-click the package to install.
I've successfully installed postgresql-8.4, apache-2.2.14, php-5.3.2, drupal-6.16, and several other packages and all their dependencies this way without any problems before.
To make sure I wasn't having some new problem, I then tried installing libk5crypto3 - it installed fine.
I sent an email to frank@lichtenheld.de , the repository maintainer, but haven't heard back from him yet.
I have tried many variations of the following, but always get the same error.
Quote:
# aptitude install postgresql-8.3
Reading package lists... Done
Building dependency tree
Reading state information... Done
[Code]...
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 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"
when i give service postgresql status command. i get the following.ostmaster (pid xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx) is running...The issue is my postmaster service is running in multiple process ids.As a result my cpu usage becomes high.How to resolve this. my postmaster service need to be run under only one process id
View 3 Replies View RelatedWe've been using a Wiki server at the office for years. It was originally configured to use MySQL and finally after 8+ years we're
moving the Wiki to a new platform of hardware. My question is the Wiki software (MediaWiki) is the only thing still tied to and using MySQL which we want to decommission but we've been using it for years so I'm worried we will lose the data. I've done some Google'ing to find out how can I change the MySQL database dump and successfully export it into my new PostgreSQL database however I don't know how practical or recommended this process is. I found sites like the following:
[URL]
I don't mean the exact link above but just in general taking a database from MySQL and successfully migrating it for PostgreSQL use?From what I can see in the MySQL database, there appears to be 43 tables with lots of column data and who knows what else:
Code:
mysql> show tables;
+----------------------+
| Tables_in_wiki |
+----------------------+
| dp_archive |
| dp_category |
| dp_categorylinks |
[code]....
I am having trouble installing postgresql on my CentOS virtual machine. I am trying to compile from source by following this tutorial:[URL]..Here's the output and the commands that I have used thus far:
Code:
[root@localhost postgresql-8.4.4]# ./configure
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking which template to use... linux
[Code]...
Is there a software or procedure to migrate DB from COBOL to SQL ( or postgresql)
View 10 Replies View Related
