Apache :: PHP Couldn't Access PostgreSQL

Jan 26, 2013

I have installed Apache 2.4.3, and PHP 5.4.5 64-bit, and I have installed PostgreSQL 9.2 64-bits under my new system windows 7 64 bits. Apache and PHP could work nicely, and PostgreSQL run fine too. However, PHP couldn't access the PostgreSQL. pg_connect(), and followed by echo select version(), didn't give any error. When PostgreSQL module was not loaded (because my php dir was d:php, but inside httpd.conf i type D:/PHP), I got message saying something like "undefined pg_connect()." I fixed it, but select version() or any other echo after pg_connect() didn't give any output.

View 5 Replies


ADVERTISEMENT

Releasing External Access To PostgreSQL?

May 4, 2007

A customer is asking to open the port to access PostgreSQL on a shared server because he needs remote access to his database. Is it a good idea to grant remote access to PostgreSQL?

View 1 Replies View Related

Couldn't Reach Anyone From Razorservers

Jun 15, 2008

I couldn't reach anyone from razorservers for 2 weeks. I have 2 open tickets with no answer from staff for 2 weeks. I tried directly contact to Matt one week ago, but no answer too.

View 2 Replies View Related

Couldn't Kill A Process

Mar 27, 2007

There is a process on my server:

9897 root 20 0 1872 588 504 R 99.9 0.0 210:11.25 repquota

I tried kill -9 or kill -15, couldn't kill this,

View 4 Replies View Related

IMAP : Couldn't Open Stream

Apr 8, 2007

after installing a new security update on my windows box , i cant use imap_open any more

its showing following message :

Warning: imap_open() [function.imap-open]: Couldn't open stream {localhost:110/pop3/notls}INBOX

i tried with iis/apache and same error ! alse its showing same error for remote servers !

also i am able to connect pop3 using telnet

View 1 Replies View Related

Error: Couldn't Perform Authentication. AuthType Not Set!:

Oct 26, 2009

The domain is very new, and only known to me. it has http authetnication setup so you'd have to know the username and password to login to access the site.

[Sun Oct 25 17:37:38 2009] [crit] [client 88.191.76.63] configuration error: couldn't perform authentication. AuthType not set!:
/phpmyadmin/scripts/setup.php
[Sun Oct 25 18:57:47 2009] [error] [client 96.9.152.120] client sent HTTP/1.1 request without hostname (see RFC2616 section 14.23):
/w00tw00t.at.ISC.SANS.DFind:)

View 11 Replies View Related

Rsync Failed On Me..couldn't Recover The Data

Apr 14, 2007

I am putting this thread to take other people advise and to advise them about my bad experience with rsync. Lucky, I was able to get my data back through the old drive

Three times a day, I take mysqldump and then rsync that mysql dump to a drive located in a different state.

Everything was working fine..The rsync was transferring data daily and updating the backup on other server. Few days ago, there was a hard drive failure on my server and then i checked in my backup drive for mysql dump...It was 764 bytes instead of 5 Gb...

Then i went to my other server where I rsync, to my surprise that was also 764 bytes from 5 Gb as it synced the both database..

My backup strategy failed and would be in tears if I couldn't grap data from failed drive

I would like to hear everyone views on this and learn from it

View 4 Replies View Related

Couldn't Send And Receive Email This Morning

Sep 4, 2007

All status of pop and exim server are OK, no problem. but couldn't receive and send email, no error message.

View 9 Replies View Related

My Apache Access Log

May 25, 2008

As per subject, I have a cpanel server and lately there is something seems wrong with my apache access logs.
/usr/local/apache/logs/access_log

The problem is the log did not recorded website being accessed in details

Quote:

218.111.202.105 - - [24/May/2008:22:53:37 +0800] "-" 408 -
127.0.0.1 - - [24/May/2008:22:55:01 +0800] "GET /whm-server-status HTTP/1.0" 200 31811
74.53.197.2 - - [24/May/2008:22:55:17 +0800] "-" 408 -
74.53.197.2 - - [24/May/2008:22:55:23 +0800] "-" 408 -
219.93.152.12 - - [24/May/2008:22:56:34 +0800] "-" 408 -
207.234.129.249 - - [24/May/2008:22:56:42 +0800] "-" 408 -
203.130.242.48 - - [24/May/2008:22:56:56 +0800] "-" 408 -
203.130.242.48 - - [24/May/2008:22:57:01 +0800] "-" 408 -
76.184.65.88 - - [24/May/2008:22:58:07 +0800] "t&rls=org.mozilla:en-USfficial&client=firefox-a" 501 -
127.0.0.1 - - [24/May/2008:23:00:01 +0800] "GET /whm-server-status HTTP/1.0" 200 32935
127.0.0.1 - - [24/May/2008:23:01:36 +0800] "GET / HTTP/1.0" 200 3473
58.186.201.58 - - [24/May/2008:23:02:22 +0800] "-" 408 -
203.130.242.48 - - [24/May/2008:23:04:11 +0800] "-" 408 -
203.130.242.48 - - [24/May/2008:23:04:15 +0800] "-" 408 -
127.0.0.1 - - [24/May/2008:23:05:01 +0800] "GET /whm-server-status HTTP/1.0" 200 32548
72.29.95.45 - - [24/May/2008:23:06:13 +0800] "-" 408 -
72.29.95.45 - - [24/May/2008:23:06:13 +0800] "-" 408 -
195.82.99.126 - - [24/May/2008:23:06:43 +0800] "-" 408 -
195.82.99.126 - - [24/May/2008:23:06:49 +0800] "-" 408 -
195.82.99.126 - - [24/May/2008:23:06:54 +0800] "-" 408 -
74.53.197.2 - - [24/May/2008:23:08:16 +0800] "-" 408 -
127.0.0.1 - - [24/May/2008:23:10:01 +0800] "GET /whm-server-status HTTP/1.0" 200 31890
127.0.0.1 - - [24/May/2008:23:10:18 +0800] "GET / HTTP/1.0" 200 3473
208.101.51.84 - - [24/May/2008:23:10:46 +0800] "-" 408 -
62.193.196.250 - - [24/May/2008:23:13:18 +0800] "-" 408 -
62.193.196.250 - - [24/May/2008:23:13:24 +0800] "-" 408 -
62.193.196.250 - - [24/May/2008:23:13:29 +0800] "-" 408 -
127.0.0.1 - - [24/May/2008:23:15:05 +0800] "GET /whm-server-status HTTP/1.0" 200 33145
127.0.0.1 - - [24/May/2008:23:19:08 +0800] "GET / HTTP/1.0" 200 3473
127.0.0.1 - - [24/May/2008:23:20:02 +0800] "GET /whm-server-status HTTP/1.0" 200 32720
67.15.205.17 - - [24/May/2008:23:22:26 +0800] "-" 408 -
127.0.0.1 - - [24/May/2008:23:25:16 +0800] "GET /whm-server-status HTTP/1.0" 200 31203
209.25.195.74 - - [24/May/2008:23:26:21 +0800] "-" 408 -
209.25.195.74 - - [24/May/2008:23:26:24 +0800] "-" 408 -
209.25.195.74 - - [24/May/2008:23:26:27 +0800] "-" 408 -
209.25.195.74 - - [24/May/2008:23:26:29 +0800] "-" 408 -
209.25.195.74 - - [24/May/2008:23:26:33 +0800] "-" 408 -
209.25.195.74 - - [24/May/2008:23:26:36 +0800] "-" 408 -
127.0.0.1 - - [24/May/2008:23:28:05 +0800] "GET / HTTP/1.0" 200 3473

My old logs /usr/local/apache_bacup/logs/access_log record them fine

Quote:

80.191.80.84 - - [18/Jul/2007:04:21:13 +0800] "GET /ss-xs/?action-spacelist-uid-356-type-blog-starttime-1181520000-endtime-1$
80.191.80.84 - - [18/Jul/2007:04:21:53 +0800] "GET /forum/archiver/tid-1303.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:22:18 +0800] "GET /forum/archiver/tid-819.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:22:37 +0800] "GET /ss-xs/?17/spacelist-blog.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:22:44 +0800] "GET /ss-xs/?viewthread-1745.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:23:21 +0800] "GET /forum/archiver/tid-2074.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:23:29 +0800] "GET /forum/forumdisplay.php?fid=35 HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:23:58 +0800] "GET /forum/archiver/tid-998.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:24:02 +0800] "GET /forum/archiver/tid-784.html HTTP/1.1" 404 -
127.0.0.1 - - [18/Jul/2007:04:25:01 +0800] "GET /whm-server-status HTTP/1.0" 200 21150
80.191.80.84 - - [18/Jul/2007:04:25:01 +0800] "GET /forum/archiver/tid-2100-page-1.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:25:10 +0800] "GET /forum/archiver/tid-1211-page-3.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:25:37 +0800] "GET /forum/archiver/tid-834.html HTTP/1.1" 404 -
127.0.0.1 - - [18/Jul/2007:04:25:40 +0800] "GET / HTTP/1.0" 200 2860
80.191.80.84 - - [18/Jul/2007:04:26:25 +0800] "GET /forum/archiver/tid-623.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:26:41 +0800] "GET /forum/archiver/tid-25.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:27:18 +0800] "GET /ss-xs/?10/viewspace-18 HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:27:44 +0800] "GET /forum/archiver/tid-802-page-2.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:27:48 +0800] "GET /forum/archiver/tid-1802-page-7.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:28:15 +0800] "GET /forum/archiver/tid-1569-page-2.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:28:31 +0800] "GET /forum/archiver/tid-1133.html HTTP/1.1" 404 -
127.0.0.1 - - [18/Jul/2007:04:30:02 +0800] "GET /whm-server-status HTTP/1.0" 200 21041
80.191.80.84 - - [18/Jul/2007:04:30:19 +0800] "GET /forum/archiver/tid-462-page-1.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:30:34 +0800] "GET /forum/archiver/tid-1900.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:30:42 +0800] "GET /ss-xs?693 HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:30:46 +0800] "GET /forum/archiver/tid-1501-page-2.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:31:48 +0800] "GET /forum/archiver/tid-2055.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:31:58 +0800] "GET /forum/archiver/tid-2050-page-2.html HTTP/1.1" 404 -
127.0.0.1 - - [18/Jul/2007:04:34:04 +0800] "GET / HTTP/1.0" 200 2860
80.191.80.84 - - [18/Jul/2007:04:34:32 +0800] "GET /forum/archiver/tid-2019.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:34:53 +0800] "GET /forum/archiver/tid-744.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:34:59 +0800] "GET /forum/archiver/tid-2135.html HTTP/1.1" 404 -
127.0.0.1 - - [18/Jul/2007:04:35:01 +0800] "GET /whm-server-status HTTP/1.0" 200 21102
80.191.80.84 - - [18/Jul/2007:04:35:11 +0800] "GET /ss-xs/archiver/ HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:36:38 +0800] "GET /forum/archiver/tid-781-page-2.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:37:04 +0800] "GET /forum/archiver/tid-1216.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:38:09 +0800] "GET /ss-xs/?viewthread-1879.html HTTP/1.1" 404 -
80.191.80.84 - - [18/Jul/2007:04:38:29 +0800] "GET /forum/archiver/tid-275.html HTTP/1.1" 404 -
127.0.0.1 - - [18/Jul/2007:04:40:02 +0800] "GET /whm-server-status HTTP/1.0" 200 21191

how do I make my apache to log the access log in details again?

View 1 Replies View Related

Too Many Open Files: Couldn't Spawn Child Process

Oct 25, 2008

"Too many open files: couldn't spawn child process"


"Too many open files: couldn't spawn child process". This is what I see in the logs.

I have a CGI application which I can't run anymore because it is giving me a 500 Internal Server Error.

Would disabling the logging on all domains solve this issue? (thinking that too many log files are opened)

I did: cat /proc/sys/fs/file-max and in return I got: 372235.

Then I did echo 350000 > /proc/sys/fs/file-max*, because I thought I have file system limitation or something like that.

The problem starts even right after I reboot the server.

If I hit lsof a lot of files are shown.

The server load is tiny so nothing actually happens.

Would editing the httpd.conf or my.cnf files help ? Should I post the prefork and MPM settings here?

What else should I do to have my CGI application running again?

View 12 Replies View Related

Plesk 11.x / Linux :: Couldn't Find War Content In Server

May 15, 2014

I cannot find my files after deploy war files..

I need to create a directory after unpacking war file process..

I need to know where is my files in server..

View 1 Replies View Related

PostgreSQL 8+ And .NET 3.5

Oct 29, 2009

does anyone know about a windows web host with postgresql database (possibly running 8.4) and .net 3.5 ?

View 4 Replies View Related

Postgresql

May 26, 2008

I just bought a VPS to do some testing on.

I have cPanel installed, and I did the "/scripts/installpostgres" and the config/password in WHM.

Now when I login to a cPanel account, and create a user or database, it just simply doesn't show up on the page.

View 2 Replies View Related

Postgresql

Feb 19, 2007

i'm having isues with postgresql, 1 on 2 times i get this error:

Fatal error: Uncaught exception 'Exception' with message 'Unable to connect to database on localhost' in /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/AbstractDb.php:96 Stack trace: #0 /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/AbstractDb.php(321): AbstractDb->connect(NULL) #1 /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/Server.php(227): AbstractDb->execSqlUniqueRes('SELECT server_i...', NULL, false, true) #2 /home/lavals/public_html/auth1/wifidog-auth/wifidog/include/common.php(107): Server::getCurrentServer(true) #3 /home/lavals/public_html/auth1/wifidog-auth/wifidog/index.php(52): require_once('/home/lavals/pu...') #4 {main} thrown in /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/AbstractDb.php on line 96

the people of wifidog auth server told me to check Ulimit -a and to set it up a bit
but what should i change, here is my curent ulimit -a:

Code:
[/root]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1000
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
what should i boost?

i'm using a VPS with 256Ram, 1meg burst, cpanel,virtuozzo

View 13 Replies View Related

PostgreSQL

Feb 12, 2007

i have a domain running a Wifi auth server, my problem is that i find it very slow when i try to connect to the site.

i know i'm using postgreSQL 7.4, is there a way to speed up the connection?
maybe tweak Postgresql or something,i'm new to this database system.

the link is [url]

i'm running this on a VPS with 256Ram, 1024 burst, cpanel, virtuozzo, OPTERON 246

View 5 Replies View Related

Postgresql

Jul 18, 2007

When I try add data I got this error

INSERT INTO night_prices (id_prices, id_data, id_services, price_oldi, price_weekend, type_prices) VALUES (DEFAULT, 8, 18, '33', '12', 2)

[nativecode=ERROR: permission denied for sequence night_prices_id_prices_seq]

How to fix that?

I have root access.

View 1 Replies View Related

Cant Access Apache Update In WHM

Jul 10, 2008

Can't access apache update in WHM I get an http 500 error page.

View 4 Replies View Related

Apache File Access

May 30, 2007

I'm trying to set up Apache on CentOS 4. I'm using Apache 2.0 and it can't seem to access anything outside of the /var/www directory - it gives an Error 403.

I thought this would be down to SELinux but this is disabled. I've run the following command on the directory but with no luck:

Code:
chown apache /home/jmaskell -R

View 7 Replies View Related

Apache :: Can't Access Website Using Other IP On Same LAN

Dec 20, 2013

I m newbie to apache server. I have created a web site using apache server with theURL... tutorial. I m able to access my web site on my ip address bt unable to access it using other ip of linux system. I m CentOS user. I can ping that ip with my ip. I have edited files as described in the tutorial.

View 1 Replies View Related

Apache :: Cannot Access XAMPP From Another PC

Aug 1, 2013

Trying to access my website, which is running on my PC on Apache XAMPP, from another PC by typing:

http://IP:80 and I get a simple page not found error.

Firewall on router and PC are disabled.
Port forwarding is done.
Apache is running on port 80 and port 444

Added to httpd-xampp.conf:

View 3 Replies View Related

Apache :: Httpd Can't Access SSL

Sep 28, 2014

I can't reach my website, I get a "corrupted content" error message in the browser.Looking into apache (version 2.4.7), I get

Code:
~$ apachectl -S
AH00526: Syntax error on line 22 of /etc/apache2/sites-enabled/000-default.conf:
SSLCertificateKeyFile: file '/etc/ssl/private/owncloud.key' does not exist or is empty
Action '-S' failed.

However, I double checked that the file is in the appropriate location and does contain the key, so maybe apache has no permission. afaik, it doesn't run as root all the time - or only for a short time?

permissions for the key file are as follows:

Code:
~$ sudo ls -l /etc/ssl/private/owncloud.key
-rw-r--r-- 1 root ben 1704 Sep 28 04:01 /etc/ssl/private/owncloud.key

, where ben is my normal user.

It was suggested to me on the httpd IRC channel that maybe apparmor was doing something wrong, but I don't know how to investigate that.

View 6 Replies View Related

Plesk 11.x / Windows :: APS Catalog Error - Couldn't Connect To Host

Nov 20, 2013

APS Catalog gets no contact with the server...

View 2 Replies View Related

Tomcat / Postgresql

Dec 3, 2008

I would like to install a tomcat application on my domain. Where do I upload the .war file and how can I manage the tomcat and access this application? I have root access to my Cpanel/WHM box. Also, I did apply a servlet already via WHM.

Also, I need to restore my postgres backup file as well but its too big to be done via pgmyadmin. How can I go about doing this via command line?

I'm aware of how to restore a mysql db via command line (1st create db in cpanel, 2nd run command in ssh). Never done so with a postgresql database.

View 2 Replies View Related

Support For PostgreSQL *and* ASP.NET

Apr 30, 2009

I am looking for a webhost with a package that supports both ASP.NET *and* Postgres. So far, I have been able to find ones that support one but not the other.

View 8 Replies View Related

PostgreSQL Or MySQL

Apr 7, 2008

I wanted to get a sense of the usage of Postgres versus MySQL. Does anyone here prefer Postgres over MySQL?

View 14 Replies View Related

PostgreSQL Performance

Oct 18, 2007

for running PostgreSQL on a VPS,

Take a look what moderator of MySource Matrix forums says (enterprise-CMS based on PHP4+pgSQL):

Quote:

Yes, installing onto a virtual server is great, because its like you have an entire server to yourself. However, running PostgreSQL in a VM is not recommended for performance reasons. Obviously this isn't a concern on low-traffic sites. The ultimate solution would be a virtual server for Apache/PHP/MySource Matrix and a dedicated server for PostgreSQL. Though, I don't know of any virtual server providers that also provide dedicated database server access.

(...)

The problem with PostgreSQL (or any database) under virtualisation is that there is no IO prioritization given. So, the database just waits along with everything else for the hypervisor to deliver IO, with no consideration for priorities. This leads to a performance hit of about 70-80%. In testing, we've seen PostgreSQL under VMware ESX/GSX perform horribly, even with fibre-attached SAN storage. Though, sticking PostgreSQL on a Xen DomU seems better. The sysadmins have done some testing on this too.

If you run PostgreSQL across multiple virtual servers on the same hardware, you're just compounding the IO bottlenecks, so I can't recommend it at all.

Source: forums.matrix.squiz.net/index.php?showtopic=3929&st=15&start=15

Can anyone comment and share thoughts on using PostgreSQL on private virtual server?

View 3 Replies View Related

Upgrading Postgresql

Feb 5, 2007

way to upgrade postgresql 7.4 to 8.1, i heard that V8 is less consuming

View 6 Replies View Related

Postgresql Log File

Feb 7, 2007

i cant find Postgresql log file
can any1 tell where to find it (v. 7.3)

i have cpanel,virtuozzo installed

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved