I have a server running Cpanel and I have added postgres through /scripts/installpostgres, also I have set it over WHM and can access phppgadmin but I got this error when connecting throug a script
Fatal error: Call to undefined function: pg_connect() in /home/rer1223/public_html/process/Connection.php on line 4
I checked and postgres is not listed in phpinfo output.
I have installed postgres over my cpanel account but I am unable to find php_pgsql.so file
I am running Centos 4 Apache 1.3 PHP 4.3 Postgres 7.3
PostgreSQL (Cannot add new user or database). It will return "User/DB added successfully" but no new user or database is added.
root@server [~]# rpm -qa | grep postgre
postgresql-devel-8.1.4-3PGDG
postgresql-contrib-8.1.4-3PGDG
postgresql-8.1.4-3PGDG
postgresql-server-8.1.4-3PGDG
postgresql-libs-8.1.4-3PGDG
postgresql-python-8.1.4-3PGDG
I've already compiled apache after postgres was upgraded months ago.
I'm using cpanel 10x
This seemed like the most appropriate place so I decided to post here.
SYSTEM:
Fedora Core 4, 3GHz, 2GB RAM
Postgres 8, Apache 2, PHP 4
The issue is that I have with me a 1.5GB SQL dump from Postgres 8 which I extracted using pg_dump.
Restoring it seems to be an issue on this PC. I've tried modifying memory directives in postgresql.conf as well as the kernels SHMAX value but no go.
I tried a bunch of other things such as gzipping the file so that it was only 100mb and doing:
Code:
gunzip -c dump.sql.gz | psql my_db
But I recieved many errors saying "invalid command N" and I also got a syntax error notice and the process terminated.
I tried to at least try and enter some data manually but vim is incredibly slow since this is a 1.5GB file.
Is there a way I could perhaps split up my db dump and then import them into the db one by one?
I was hoping someone could shed some light on a cron related issue I'm having.
I've been using linux for a while...but never really used crons.
My cron is supposed to dump a postgres db in tar.gz format every minute (for testing purposes) but it doesn't.
I opened my cron in vim via:
Code:
postgres@myhost:~$ crontab -e
And here's the cron:
Code:
* * * * * /usr/bin/pg_dump -D warranty_1_6_test | gzip -c > /var/www/test/postgres/backup$(date +"%Y%m%d_%H%M").tar.gz
Also:
Code:
postgres@myhost:~$ ls -lah /var/www/test/postgres/
total 8.0K
drwxrwxrwx 2 postgres postgres 4.0K 2007-06-14 12:01 .
drwxr-xr-x 3 user user 4.0K 2007-06-14 11:47 ..
Running the backup command via CLI works fine.
i had to do a file system back up because of the size of my database.
i shutdown postmaster and tar'd the files.
i recently reloaded my OS and now i'm attempting to restore the backups. i first shut down postmaster, restored the backups to the data folder and restarted postmaster.
i then su'd from root to postgres user:
Code:
[postgres@austin1 pgsql]$ psql service_2_3
psql: FATAL: database "service_2_3" does not exist
DETAIL: The database subdirectory "base/16385" is missing.
the backups had a database named service_2_3 but upon restoring the backups, it doesn't seem to be available.
my data directory is /var/pgsql/data.
Code:
[postgres@austin1 pgsql]$ ls -lahR /var/pgsql/ | grep 16385
but that yielded nothing.
have i done something wrong while backing up? i don't think i have since i followed the postgres manual when backing up. but the administrators have not been very thorough with how they've set the system up for me.
how i can resolve this issue if you have the time.
I just reloaded the OS on our production server and I'm having issues configuring postgres.
the user postgres exists in the system (i.e. 'su postgres' switches me to that user)
i attempted to connect to my database 'service_2_3' via CLI:
Code:
$ su postgres
$ psql service_2_3
and i recieved the following error:
Code:
psql: FATAL: IDENT authentication failed for user "postgres@service_2_3"
the database is installed on the machine on which i was attempting to connect to it with.
therefore, i edited my pg_hba.conf so that it looks like this:
Code:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all ident sameuser
# IPv4 local connections:
host all all 127.0.0.1/32 ident sameuser
# IPv6 local connections:
host all all ::1/128 ident sameuser
host all all 0.0.0.0 0.0.0.0 password
and reloaded with (as user postgres):
Code:
bash-3.00$ pg_ctl reload -D /var/lib/pgsql/data -l /var/lib/pgsql/data/temp.log
but i still get the same error. am i editing the wrong file, perhaps?
how would i know which is the correct pg_hba.conf file?
locate pg_hba.conf seems to give me a few results.
Is it possible to install Plesk 12 to Debian Jessie with the autoinstall script?
View 7 Replies View Relatedproblem with install suhosin and ...
how i can install Mod_security
What difference between yum install php or manually install php from scrach (build, make and install)?
I know manually install could configure lots of parameters and paths, like --iconv, --mbsting, etc. I don't know anything behind yum install php. If I want to install php everything in the following:
./configure --prefix=/usr/local/webserver/php --with-config-file-path=/usr/local/webserver/php/etc --with-mysql=/usr/local/webserver/mysql --with-mysqli=/usr/local/webserver/mysql/bin/mysql_config --with-iconv-dir=/usr/local --with-freetype-dir --with-jpeg-dir --with-png-dir --with-zlib --with-libxml-dir=/usr --enable-xml --disable-debug --disable-rpath --enable-discard-path --enable-safe-mode --enable-bcmath --enable-shmop --enable-sysvsem --enable-inline-optimization --with-curl --with-curlwrappers --enable-mbregex --enable-fastcgi --enable-fpm --enable-force-cgi-redirect --enable-mbstring --with-mcrypt --with-gd --enable-gd-native-ttf --with-openssl --with-sendmail=/usr/sbin/sendmail
to installing linux software and have been beating my head for a couple of days. I just learned that I can use something on my CENTOS 5 - which is the same as RHEL 5 - to install the rpm and all dependencies.
Numeric-24.2-1.i586.rpm is the rpm I want to install, if that matters.
How can I do install it AND any dependencies?
I am trying to install the kernel source.
I have downloaded kernel-2.6.20-1.2948.fc6.src.rpm
I am using fedora 6 64bit.
here are my current kernels:
kernel-headers-2.6.20-1.2948.fc6
kernel-devel-2.6.20-1.2944.fc6
yum-kernel-module-1.0.3-1.fc6
kernel-2.6.20-1.2944.fc6
kernel-devel-2.6.20-1.2948.fc6
kernel-2.6.20-1.2948.fc6
here is what I seen when I installed kernel-2.6.20-1.2948.fc6.src.rpm
rpm -ivh kernel-2.6.20-1.2948.fc6.src.rpm
1:kernel warning: user brewbuilder does not exist - using root
warning: group brewbuilder does not exist - using root
warning: user brewbuilder does not exist - using root
########################################### [100%]
warning: user brewbuilder does not exist - using root
warning: group brewbuilder does not exist - using root
then when I ran:
rpmbuild -bp --target=$(uname -m) /usr/src/redhat/SPECS/kernel-2.6.spec
I seen this error:
+ Arch=x86_64
+ make ARCH=x86_64 nonint_oldconfig
In file included from /usr/include/sys/socket.h:35,
from /usr/include/netinet/in.h:24,
from /usr/include/arpa/inet.h:23,
from scripts/basic/fixdep.c:117:
/usr/include/bits/socket.h:310:24: error: asm/socket.h: No such file or directory
make[1]: *** [scripts/basic/fixdep] Error 1
make: *** [scripts_basic] Error 2
error: Bad exit status from /var/tmp/rpm-tmp.93770 (%prep)
I need to have this installed to get a app installed etc...
suggestions or ideas?
thanks
So i have a dedicated server and here are the specs:
AMD64 X2 7750+
8192 MB DDR2 RAM
500 GB 7.200 RPM
2000 GB Traffic p/m
CentOS 5.3
I want to install several VPS's on this server so i have one for shared users, one for reseller users and then the rest can be purchased. Unfortunately i have no idea how to install VPS's. Which is the best visualization software for VPS's? And how do i install and how to get whmcs to create them. Or are they already created?
I am also wondering about control panels and do vps's have to have their own separate control panel or do they all run of the main control panel.
Also what is the rule of thumb on how many vps's per server.
I'm willing to setup a new dedicated server that hosts only one website. before I just used Centos, it was free and worked perfect.
I dont want to spend any money for OS.
Which OS do you use?
Well I ordered a virtuzzo server and I am wondering on how do you install yum. Its a centos
View 7 Replies View RelatedI tried to : yum install gcc
Quote:
root@name [~]# yum install gcc
Traceback (most recent call last):
File "/usr/bin/yum", line 28, in ?
import yummain
File "/usr/share/yum-cli/yummain.py", line 30, in ?
from yum import _
ImportError: cannot import name _
command : rpm -q yum
Quote:
root@name [~]# rpm -q yum
yum-3.2.8-9.el5.centos.2.1
command : rpm -ap | grep yum
Quote:
root@name [~]# rpm -aq | grep yum
yum-3.2.8-9.el5.centos.2.1
yum-fastestmirror-1.1.10-9.el5.centos
yum-metadata-parser-1.1.2-2.el5
command : rpm -e yum-metadata-parser-1.0-8.fc6
Quote:
root@name [~]# rpm -e yum-metadata-parser-1.0-8.fc6
error: package yum-metadata-parser-1.0-8.fc6 is not installed
I've tried to work with yum. but if I "yum install .." enter, then i get this error :
PHP Code:
error: no dbpath has been set
error: cannot open Packages database in /%{_dbpath}
Traceback (most recent call last):
File "/usr/bin/yum", line 30, in ?
yummain.main(sys.argv[1:])
File "/usr/share/yum/yummain.py", line 163, in main
(log, errorlog, filelog, conf, cmds) = parseCmdArgs(args)
File "/usr/share/yum/yummain.py", line 75, in parseCmdArgs
conf=yumconf(configfile=yumconffile)
File "/usr/share/yum/config.py", line 155, in __init__
self.yumvar['releasever'] = self._getsysver()
File "/usr/share/yum/config.py", line 285, in _getsysver
idx = ts.dbMatch('provides', self.distroverpkg)
TypeError: rpmdb open failed
I'm playing around with a test server, install Xen on a Centos 5 box.
[url]
I've tried two methods to create a vm.
virt-install
and
virt-install -x "ip=xxx.xxx.70.212 gateway=xxx.xxx.70.211 subnet=255.255.255.248"
If I do virt-install, it asks me this:
(first screenshot).
I have no idea what to put it. I did try this:
Quote:
IPv4 address: xxx.xxx.70.212__ / 255.255.255.248_
Gateway: xxx.xxx.70.211___________________________
Name Server: _________________________________________
note: only here in my post am I actually putting "xxx" in the IP for privacy reasons only. The 70.212 is the main server IP that I ssh into.
See 2nd screenshot for error. Same thing with various *valid* mirrors I tried.
This is my ifcfg-eth0 info:
DEVICE=eth0
BOOTPROTO=static
IPADDR=xxx.xxx.70.212
NETMASK=255.255.255.248
ONBOOT=yes TYPE=Ethernet
I have bought Dell Optiplex 760 and i would like to in stall Virtual Private Server (VPS) on it.. can anybody please tell me step by step tutorial to install VPS in my computer and have my own webserver?
View 14 Replies View Relatedi want to install custom os in Xen.
what do i do?
i want install Mikrotik , Cenos and ... in it.
also how can i create image from it to use it again?
can i use this image for hypervm?
i intsalled clipshare script, and this is the server requirments:
# Mplayer + Mencoder
# Flv2tool
# Libogg + Libvorbis
# LAME MP3
how yo install it?
i have a domain from namecheap and a virtual private server.
I want to have ns1.domain.com and ns2.domain.com and domain.com for my homepage.
I use lxadmin.How can i do this?
How to install DOM XML on php 5.1.6?
View 5 Replies View Relatedone of my server forgot to install yum, as a result, i am unable to use yum to install packages. The os is centos 5,
View 11 Replies View RelatedI was trying to install CSF/LFD on to my VPS but I'm having problems. Its coming out with the error:
iptables v1.3.5: Unknown arg `-j'
Try `iptables -h' or 'iptables --help' for more information.
Error: iptables command [/sbin/iptables -A LOGDROPIN -j ] failed, at line 213
Rus over at CheapVPS assures me his servers support CFD/APF fully so its not something on his end and I've thought of everything on my end. Has anyone come across this problem before?
What should a person install on a Linux based server to run a VPN.
In other words I want to connect my home computer to a VPN located elsewhere. I know how to connect to a VPN, just not how to get the remote computer to act as a server and accept VPN connections.
I need to install site studio
[url]
It says to install java / jdk
I'm not 100% sure if I have that, but I have cpanel installed (not tomcat, disabled), centos 4.6
I see this:
Code:
root@server [/usr/java]# ls -lh
total 18M
drwxr-xr-x 9 root root 4.0K Dec 21 18:41 ./
drwxr-xr-x 43 root root 4.0K Dec 21 17:29 ../
drwxr-xr-x 2 root root 4.0K Dec 21 17:28 bin/
drwxr-xr-x 10 root root 4.0K Dec 21 17:29 demo/
drwxr-xr-x 3 root root 4.0K Dec 21 17:29 include/
drwxr-xr-x 7 root root 4.0K Dec 21 17:28 jre/
drwxr-xr-x 2 root root 4.0K Dec 21 17:29 lib/
-r--r--r-- 1 root root 13K Jun 14 2007 LICENSE
drwxr-xr-x 4 root root 4.0K Dec 21 17:29 man/
drwxr-xr-x 9 root root 4.0K Jun 14 2007 sample/
-rw-r--r-- 1 root root 18M Jun 14 2007 src.zip
root@server [/usr/java]# which java
/usr/local/jdk/bin/java
can java (or jdk) be installed via whm > apache compile?
I see this under /usr/local
Code:
lrwxrwxrwx 1 root root 22 Dec 21 17:29 jdk -> /usr/local/jdk1.6.0_02/
drwxr-xr-x 9 root root 4.0K Aug 26 2005 jdk1.5.0_05/
drwxr-xr-x 9 root root 4.0K Dec 21 18:41 jdk1.6.0_02/
-rwx------ 1 root root 56M Dec 21 17:28 jdk-6u2-linux-i586.bin*
lrwxrwxrwx 1 root root 18 Aug 14 2006 jre -> /usr/local/jdk/jre/
i want to install gd library on m linux server.. basically i wanted to use it with ffmpeg to create thumbnails of videos.. i have installed ffmpeg but not able to install gd..
i tried yum install php-gd but its not working
i tried /scripts/easyapache but it asks for something in the mid way so not getting through it.. my cpanel is not working
I have had to install one thing after another to get one thing running... I have to install...
Zend Optimizer 3.3.0 beta
and
Zend Guard after that...
Can anyone help me install this? I did read over the readme it doesnt help at all like all other readme's...
I did contact the support and they just copied and paste the read me...