Postgres Install
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.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Cannot Add Postgres Database
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
View Replies!
View Related
Cron As Postgres User Not Working
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.
View Replies!
View Related
Postgres: Restoring A Filesystem Backup
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.
View Replies!
View Related
Restoring 1.5GB SQL Dump (Postgres)
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?
View Replies!
View Related
IDENT Authentication Failed For Postgres. Pg_hba.conf
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.
View Replies!
View Related
How Do I Install With RPM To Install Dependencies Also
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?
View Replies!
View Related
Yum Install Php Or Manually Install Php
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
View Replies!
View Related
Kernel Source Install Help Needed On Fc6 X64I Am Trying To Install The Kernel Source.
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
View Replies!
View Related
Which OS To Install
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?
View Replies!
View Related
How To Install Ns
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?
View Replies!
View Related
Install Gd
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
View Replies!
View Related
Install
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...
View Replies!
View Related
Want To Install Imagemagick
I try to follow http://www.photopost.com/howtoinstall-php.html and got hit by a wall at: [root@as libpng-1.0.6]# make I got error: gcc -I../zlib -Wall -O3 -funroll-loops -c -o png.o png.c make: gcc: Command not found make: *** [png.o] Error 127 From this, i know that gcc is not install in my system. How do i install gcc? Anyone?
View Replies!
View Related
How To Install VPS's
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.
View Replies!
View Related
Install Spamassassin ..?
here to install spamassassin but however have a few questions as im new to doing technical things in ssh. [url] On step 3 of the tutorial, we are asked to change things in the /etc/exim.conf file, what is the proper command to navigate to this file and how to replace those text? Quote: The global spamassassin config file is in /etc/mail/spamassassin/local.cf You'll want to make sure that you have the correct call to spamc in the spamcheck transport in your exim.conf: transport_filter = /usr/bin/spamc -u ${lookup{$domain}lsearch*{/etc/virtual/domainowners}{$value}} For the lines i quoted, im not sure what i have to do here and how to do it. Lastly how do i know if im installing latest version of spamas and how to test weather it is working against spam?
View Replies!
View Related
Yum Install
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
View Replies!
View Related
How Install Suhosin
i have try: wget [url] tar -zxvf suhosin-0.9.27.tgz ./configure make make install then: ls –lah /usr/local/lib/php/extensions/no-debug-non-zts-20060613/ mkdir /usr/lib/php/extensions/ cp /usr/local/lib/php/extensions/no-debug-non-zts-20060613/suhosin.so /usr/lib/php/extensions/ no-debug-non-zts-20060613 vi php.ini But i havent: :/usr/lib/php:/usr/local/lib/php:/usr/lib/php/extensions:/usr/lib/php/extensions/no-debug-non-zts-20060613 in my php.ini and i have this: ;include_path = ".:/php/includes"
View Replies!
View Related
Network Install
is any software out there on helping me do a network install of centos or any other Linux base OS. I want to avoid downloading and burning CD for centos. And when I want install it on multiple machines I would need to put in the several CD to do a complete install of the OS.
View Replies!
View Related
Xen Install
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
View Replies!
View Related
Best Way To Install ClamAV?
I run a CPanel environment, and want to know the best way to install and configure ClanAV. I know CPanel has an install for it under WHM, but is that the best way? How hard is it to keep updated and does it scan all directories for viruses ect...?
View Replies!
View Related
Install Tomcat
in cPanel 11.24.4-R35075 I have installed tomcat using the manage plugin in whm now could anyone let me know how do i test it and what will be the webapp;lication directory for tomcat, Does the steps performed to install is inadequate?
View Replies!
View Related
How To Install VPS
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 Replies!
View Related
Install Os In Xen
i 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?
View Replies!
View Related
Scripted Install
Is there a way that when you say someone places an order on your site for a package, then either by a single click or automatically we can have an account created on CPANEL, along with an install of wordpress?
View Replies!
View Related
How To Install Mod_desevasive
my site is under ddos attack and i found via google this article duntuk.com/preventing-dos-attacks-using-moddosevasive But i can't install mod_dosevasive via nuclearelephant.com/projects/dosevasive/ , maybe they remove it,hmmm... Is there anyway to install mod_dosevasive?
View Replies!
View Related
How To Install GD Library
how to install gd library via ssh OS = centos5 I tried ( found on some site ) but still my script showing same gd error - yum install php-gd service httpd restart if the above command effect my server performance? if yes then how could i uninstall ( Undo ) it...
View Replies!
View Related
GreenSQL Install
Iam trying to install GreenSQL to protect my databases . But when i start the installation i get this error msg : root@server [~]# rpm -ihv greensql-fw-1.0.0-13.1.x86_64.rpm warning: greensql-fw-1.0.0-13.1.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1674ae8b error: Failed dependencies: libmysqlclient.so.15()(64bit) is needed by greensql-fw-1.0.0-13.1.x86_64 libmysqlclient.so.15(libmysqlclient_15)(64bit) is needed by greensql-fw-1.0.0-13.1.x86_64 I have CENTOS 5.3 x86_64 mysql (4.1.22-standard-log)
View Replies!
View Related
How Install Lxadmin
i want to install lxadmin i have run this comand: #echo 0 >/selinux/enforce #wget http://download.lxlabs.com/download/...tall-master.sh #sh ./kloxo-install-master.sh but http://ip:7777 is not up. h have disable iptables.
View Replies!
View Related
Can't Install Mbstring
# yum install php-mbstring Setting up Install Process Setting up repositories update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 addons 100% |=========================| 951 B 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package php-mbstring.i386 0:4.3.9-3.22.9 set to be updated --> Running transaction check --> Processing Dependency: php = 4.3.9-3.22.9 for package: php-mbstring --> Finished Dependency Resolution Error: Missing Dependency: php = 4.3.9-3.22.9 is needed by package php-mbstring i tried to install mbstring on my server and wat's goin on here?
View Replies!
View Related
Red5 Install
red5 install SUbject: Red5 0.7.0 Final dependencies can not be found or downloaded from googlecode I am trying to install Red5 0.7.0 Final, however I am having a problem finding one of the Dependencies it need, Below is the read out from SSH of the problem [ivy:resolve] [ivy:resolve] :: problems summary :: [ivy:resolve] :::: WARNINGS [ivy:resolve] module not found: javax#jpda; [ivy:resolve] ==== default: tried [ivy:resolve] /root/.ivy2/cache/javax/jpda/ivys/ivy-.xml [ivy:resolve] -- artifact javax#jpda;!jpda.jar: [ivy:resolve] lib/jpda.jar [ivy:resolve] ==== googlecode: tried [ivy:resolve] -- artifact javax#jpda;!jpda.jar: [ivy:resolve] [url] [ivy:resolve] [url] [ivy:resolve] :::::::::::::::::::::::::::::::::::::::::::::: [ivy:resolve] :: UNRESOLVED DEPENDENCIES :: [ivy:resolve] :::::::::::::::::::::::::::::::::::::::::::::: [ivy:resolve] :: javax#jpda;: not found [ivy:resolve] :::::::::::::::::::::::::::::::::::::::::::::: [ivy:resolve] [ivy:resolve] :: USE VERBOSE OR DEBUG MESSAGE LEVEL FOR MORE DETAILS BUILD FAILED /red5/build.xml:205: The following error occurred while executing this line: /red5/build.xml:221: The following error occurred while executing this line: /red5/build.xml:165: impossible to resolve dependencies: resolve failed - see output for details
View Replies!
View Related
How To Install Phpsysinfo
I am trying to install this on my server but I am getting this error Warning: Unknown: open_basedir restriction in effect. File(/usr/local/cpanel/3rdparty/phpsysinfo/index.php) is not within the allowed path(s): (/home/xxx:/usr/lib/php:/usr/local/lib/php:/tmp) in Unknown on line 0 Warning: Unknown: failed to open stream: Operation not permitted in Unknown on line 0 Fatal error: Unknown: Failed opening required '/usr/local/cpanel/3rdparty/phpsysinfo/index.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in Unknown on line 0
View Replies!
View Related
Install EAccelerator
I've got a CentOS 5.0 machine running PHP 4 & 5 in FastCGI mode with suPHP. I've read the instructions to install eAccelerator at: InstallFromSource - eAccelerator - Trac However there is a line at the beginning that says it is safe to follow those directions if you have ONE php install. I have php5 as default and php4 optional. Does this count as 1 or 2 installs?
View Replies!
View Related
How To Install HyperVM
we have a dedicated server.we installed cPanel/WHM and have many webhosting customers on our server. now we want to install HyperVM tools, to sell VPS. i have some questions. 1- is it a Free software or no? (HyperVM) 2- can i install it whenas i run and installed webhosting service for example (cPanel/WHM)? if your answer is positive, please help me to what should i do, because i dont know how to install softwares for create a VPS account. i'm expecting for a help step by step with a command execute.
View Replies!
View Related
How To Install Jpgraph?
how to install jpgraph? i have installed GD with ttf (truetype) and put jpgraph directory under /var/www/jpgraph and i have also put jpg-config.inc.php CACHE_DIR /tmp/jpgraph_cache/ TTF_DIR /usr/local/fonts/ttf how to install it.its not working ? error :-- General PHP error : Assigning the return value of new by reference is deprecated
View Replies!
View Related
Red5 Install
We're setting up a youtube type site with streaming video on a VPS. We have installed all the requirements for Red5 application including 'Java', Apache ANT', and 'Subversion'. During the installation of Red5 I am getting the following error: -- BUILD FAILED /usr/local/src/red5-trunk/build.xml:235: The following error occurred while executing this line: /usr/local/src/red5-trunk/build.xml:258: Error running /usr/java/jdk1.6.0_02/bin/javac compiler Total time: 5 minutes 48 seconds -- All the previous steps have been followed correctly and configurations are correct but still the Red5 compilation is throwing the above error.
View Replies!
View Related
Suhosin Install
According to this Guide I installed Suhosin Extension [url] After installation each time I add ;;;;;;;;;;;;;;;;;;;;;;;;; ; Paths and Directories ; ;;;;;;;;;;;;;;;;;;;;;;;;; include_path = ".:/usr/lib/php:/usr/local/lib/php:/usr/lib/php/extensions:/usr/lib/php/extensions/no-debug-non-zts-20020429:" ; extension_dir = /usr/lib/php/extensions/no-debug-non-zts-20020429/ ; directory in which the loadable extensions (modules) reside Http fail and php -v don't show that Suhosin installed How can i check if Suhosin installed and working fine ?
View Replies!
View Related
|
TRACKER
