Running Postgres
Feb 20, 2008I 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
ADVERTISEMENT
Postgres Install
Feb 19, 2008I 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.
Cannot Add Postgres Database
Jul 9, 2007PostgreSQL (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
Restoring 1.5GB SQL Dump (Postgres)
Jan 23, 2007This 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?
Cron As Postgres User Not Working
Jun 14, 2007I 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.
Postgres: Restoring A Filesystem Backup
Feb 19, 2007i 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.
IDENT Authentication Failed For Postgres. Pg_hba.conf
Feb 15, 2007I 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.
Running XEN
Oct 5, 2009I want to purchase a dedicated server onwhich I can set up XEN and make few virtual machines.
how to manage backups - get a sepeare machine and configure it as a NAS, use R1Soft backups etc.
Running Out Of My 512 MB Of RAM With VPS
Apr 14, 2008I recently signed up for a VPS server with 512 MB of RAM. I will be hosting two sites on this VPS server. One is not online yet and I just have a Coming soon page up. The other is a Wordpress blog that is running. I don't have any users yet. But my VPS server is currently using ~410 or my 512 MB. This is with essentially nothing running yet. Does anyone else run their websites with only 512 MB or do I need to upgrade to at least 1 GB? I also checked out which processes are taking up the most
(% wise):
5.6 1 /usr/bin/spamd
5.4 2 spamd
3.8 1 /usr/bin/python
3.4 1 /usr/sbin/mysqld
1.7 1 /usr/local/apache/bin/httpd
1.7 1 cpsrvd
1.7 1 cpdavd
1.6 1 /usr/sbin/restorecond
I know I can't disable apache but what about the others? Spam Assasin is disabled in the WHM but the process restarts even after I kill it. Is Python necessary? I am using php apps..
Running Rtg
Nov 13, 2007after compiling rtg, I run this
/usr/local/rtg/bin/rtgpoll -v -t targets.cfg
and see the data is collected already. However, I cannot keep ssh window all the times. So, how to run rtg automatically as daemon?
Can't Get PHP 5 Running With IIS
Jul 20, 2007let alone with mysql. Have tried to install those both and have tried endless variations of php settings adn moving php.ini around and checked PATH in IIS adn teh extension .php is enabled.
Question:
Should php.ini be copied to Windows or Windows/system32 directory?
I have a test.php file in my virtual directory. I did have it working at one time but then I installed the extensions so I could have teh mysql extension and it hasn't worked since.
I am just a newbie trying to create a testing environment so I can teach myself PHP. I have endless books, have tried the Yanks method but I am not sure it applies to PHP5.
I have PHP at c:/program files/php/ is this a problem? Shoud it just be directly in the c directory? Does that matter?
Running Csf
Jun 17, 2007I installed csf as my server's firewall with using cpanel besides, I've customized configuration file and everything seems to be right but when i use csf -s it results this error :
iptables: No chain/target/match by that name
LOG tcp opt -- in * out * 0.0.0.0/0 -> 0.0.0.0/0 limit: avg 30/min burst 5 LOG flags 0 level 4 prefix `Firewall: *TCP_IN Blocked* '
Flushing chain `INPUT'
Flushing chain `FORWARD'
Flushing chain `OUTPUT'
Flushing chain `LOGDROPIN'
Flushing chain `LOGDROPOUT'
Flushing chain `acctboth'
Deleting chain `LOGDROPIN'
Deleting chain `LOGDROPOUT'
Deleting chain `acctboth'
Error: iptables command [/sbin/iptables -v -A LOGDROPIN -p tcp -m limit --limit 30/m --limit-burst 5 -j LOG --log-prefix 'Firewall: *TCP_IN Blocked* '] failed, at line 196
Running A Vps Within A Vps
Apr 27, 2007i'm thinking of installing virtualization software on a linux vps machine.
reason... windows vps vost so much and linux are much cheaper.
so within my cheap linux vps, i can install virtual windows using my pre-purchased win2000 license key.
has anyone tried this or is it completely not possible. also what linux-host virtualization software would you recommend?
note my linux vps already has kde with vnc running so i have a graphical interface to my linux vps at home.
Running A JVM On A VPS
Aug 13, 2007I'm aware of the limitations of using Sun's JVM on a VPS. Are there any good JVMs I can run besides Sun's?
View 14 Replies View RelatedRunning Out Of Bandwidth
Jan 19, 2008I have a question that's been bugging me for a few months now (which has gotten worse as traffic increases). I run a site that gets some decent traffic (about 9-10M pageviews per month), and is mostly made up of HTML pages with a lot of images (some pages have about 200k of images, others have maybe 1.5-2MB of them). I have a dedicated server that has 2TB of bandwidth per month, and I'm quickly approaching the 2TB point... what should I do?
Normally, I'd buy more bandwidth... but the host I have charges $400/month for 10mbps unmetered bandwidth -- more than the cost of the server each month! What other options do I have?
Running Unmanaged VPS
Apr 30, 2009I'm looking into purchasing a VPS, and I saw unmanaged are cheaper.
What would I need to know/learn to do maintain an unmanaged VPS?
Running Sshfs On A VPS
Apr 15, 2009I'm trying to run sshfs on my VPS but it seems to require the fuse module compiled on kernel. I already asked my host but they said that they won't change the kernel.
Is there an alternative to sshfs? I really need something to mount an external server.
SSH And Running Exe (or Any Other Application)
Jan 5, 2009I've written an application that acts as a game server for a simple game I'm creating. From what my friends tell me you can't run an exe on a webhost. They did however tell me that you can run java apps on a host that gives ssh access.
View 8 Replies View RelatedOpenVZ - SSH Not Running
Jul 22, 2007If I restart VPS (vzctl stop 1002 | vzctl start 1002 ) I can't join from ssh - not working, but remaining services start correctly: ftp, cpanel, etc.
View 9 Replies View RelatedRunning A DNS Server
Jan 17, 2008I currently have one dedicated server and four VPSs all using Plesk and all having their own name servers controlled by Plesk. What I'd like to do is consolidate everything so all my sites use one set of name servers.
I'm a PHP developer (and will be developing my own front end), and only have limited knowledge of administrating a server, so first of all if anyone has done this before and made mistakes in the process, please could you share them with me so I can avoid making them?
Secondly, I would like to use a MySQL database for storing the DNS info - I've found a tutorial at [url]which I'd like to use - could someone who knows what they're talking about have a skim through this and reassure me that everything there is correct and up to date (the article was written in early 2006 - just checking nothing in the world of DNS has changed since)?
I'm using Fedora.
Named Already Running
Jun 10, 2008I keep getting this error when trying to start named, bind 9.3.3 installed through yum (centos 5 x64).
# service named restart
Stopping named: [FAILED]
Starting named: named: already running [FAILED]
# ls /var/run/named
#
# ls /var/lock/subsys | grep named
#
I even uninstalled bind, restarted the system, and reinstalled and it is still giving me the same error.
There aren't any related errors in dmesg/messages and I couldn't find a named related file in /var/log.
Xen On Running Server
Nov 13, 2008I've a production server running web,smtp, ftp, cpanel...
Now I need to run different solutions on the same server (like PABX, games), of course I can't put all on the same place (to better control security, resource usage etc..)
Is it possible to install xen without affecting my production environment? It would be a good choice doing that?
Couriertcpd Is Not Running
Jun 20, 2008We have an OpenVZ VPS, And we have a problem with courier there.
The issue is that when we reboot the VPS, then we see the following error when trying to restart IMAP:
imap has failed, please contact the sysadmin (result was "couriertcpd is not running").
But if we use the following cPanel script, that get resolved until we reboot it (the vps) again:
/scripts/convert2maildir
* We have converted to maildir in the past, but should use that script and choose "3" option to get the issue resolved temporarily.
* I try to start courier with /scripts/courierup --force but that doesnt fix the issue.
* There is some other issues on that VPS which may be related to this one:
- We cannot modify the date on that VPS, I dont know why, It doesnt change ever.
- The results of mkpasswd root command is the same everytime we use it.
Operating System: CentOS 4.6
Control Panel: cPanel 11.23.2
Node Platform: OpenVZ
Running Web Server
Aug 13, 2008I want to start up my web server again. I have Windows XP hosting my web server right now. and, it's slow.
Should i stick with Windows, run IIS and use httpZip from Port80?
I really like microsoft, and don't want to change and adapt to something else.
give me advice
Or, should I run Linux
I would run Linux on it, but I don't know how.
And they have different version of Linux. Example Redhat, Ubuntu etc.
Which one should I go for?
Also, what do I do if I have a netgear ethernet card? Is that Linux? Is it compaitable with Redhat?
And last question, what do I use for security?
I'm a hacker, yeah.. I know what all people can do to websites. How do I stop them?
DoSing, Cross Scripting, XML Attacks, MySql Injection.. Etc.
If a linux fan can respond, that would be nice.
Running Zend On IIS 6.0
Aug 20, 2008I'm not sure if this is the best board for this question but I'll try anyway. We recently had an app built and the developer built it using the Zend framework.
Our server is running IIS. Does anyone have a link to information or know any tricks in getting Zend build apps to work on IIS?
We need to stick to IIS because other apps we have were built in asp so switching to apache is not an option.
Those Running DirectAdmin On VPS
Jun 25, 2008may I know which version of apache and mysql are you running on your production server? Will the latest apache or mysql conflict with DA?
View 9 Replies View RelatedWhat Is This Running Process
Feb 19, 2008I am showing hundreds of running processes for:
/usr/local/apache/bin/httpd -DSSL
Running Your Own Server
Jul 18, 2008why not just setup my own server. I have the connection and hardware necessary. So I am wondering why do people pay for web hosting? Why not just run your own website from your own server?
View 15 Replies View RelatedRunning A Vpn Service
Dec 10, 2008I am thinking of running a vpn service for a limited number of my clients, so that they can surf the web securely and anonymously through our VPS (routing all traffics through a vps). However I have no idea what features should I looking for, I mean how much BW or ram does it need.
Lets say I have 10~20 clients at all, Is a VPS with 300G monthly BW and 256(or 512)M of ram enough to have it work smoothly?