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 Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
How To Add An IP In VMWare Server 2? Add On The VPS Directly Or First On The Host?
I have configured and install VMWare Server on my server and currently trying to install Plesk. I have gotten the network working so I can download. I want to give the VMWare Virtual Machine it's own IP so I can connect via PuTTY instead of the console, which e.g. does not let me paste url's (plesk download url is long). I am planning to host a few websites on the Plesk Virtual Machine. I have added the IP my network provider given me using 'setup' in CentOS and it's listed in /sbin/ifconfig, but does not work yet. Do I first need to add the ip to the host server self? Or can a VPS directly use an ip? (PS: Do I use too many hard breaks in my texts?)
View Replies!
View Related
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 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 To Merge A Database Into A New Empty Database
How to merge a database into a new empty database? I used this method and its not working mysqldump --opt -uusername -p databasename > databasename.sql mysqldump --opt -uusername -p databasename < databasename.sql but get this error /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
View Replies!
View Related
Cannot Add Domain
everytime I try to add a subdomain it says "Error from park wrapper: domainname.com is already configured." I already check the 4 option in the domain category.. (Subdomains,Addon domains, Park domains and Redirects) the domain i was adding is not there...
View Replies!
View Related
Add A Nameserver
For some reason in WHM (root) (Fresh install) I'm trying to add a name server into ":2086/scripts2/listassignednsips" area and it just loads.... Never errors or anything just loads and loads for 30 minutes and never adds it. I have already add the IP's to the server. (6 IP's)
View Replies!
View Related
An Add-on Domain
I've this site: serverq.ws as an add-on domain with bluemeel.com Now go to serverq.ws and click on any link there, you would find that the URL has switched to be bluemeel.com/serverq/,
View Replies!
View Related
Add-on Domains
I signed up for a hosting account somewhere and they include unlimited add-on domains. Does this mean I can add any domain, direct my nameservers there and have as many hosting accounts that I want?
View Replies!
View Related
Add On Domain(s)
I think my question is probably really obvious, but in all the years of my hobby I've never known how to do this. Add-on Domains. Quote: Originally Posted by My host An add-on domain makes it possible for you to have an additional website (with email) on just one account. I own domains each with a different host account, and to save some money and simplify things I'd like to move to Add-Ons domains with 1 account. All of these sites are low traffic and so load is not a concern. However I really have no idea how to do this. I'd really like to preserve each domains name in the url. Just what do I do make this happen?
View Replies!
View Related
Add On Domain
I've enabled add on domains for one of my server accounts and set up the add on domain addondomain1.com using CPanel. After setting it up the main URL works fine. However, any URL that ends with a directory path but no file name constantly redirects to a URL that's on the subdomain of the main account, not the add on domain... This problem doesn't happen if the URL path ends with a file name like file.php Would there be a server configuration error causing this?
View Replies!
View Related
How To Add Different IPs In Different VLANs
how to add different IPs in different VLANs My customer requests different IPs in different class C, that are belong to different VLANs in the switch. Let's say - they have 1.1.1.10 already on their server with gateway value is 1.1.1.1 - now they want to have 1.1.2.10 too. I have no trouble to provide them a new IP, but wonder how to setup on server now? Different range will use different gateways.
View Replies!
View Related
How To Add Domains To VPS
I have one registered domain on VPS with DNS hosting and would like to host more domains (sites) on that VPS. As I understood, I don't have to buy DNS hosting for the other domain, so how do I host more domains? It's Windows VPS with Plesk. Can anyone explain in detail? Do I need to create NS records for my registered domain (ns1.mydomain.com and ns2.mydomain.com) and then point other domain to those nameservers?
View Replies!
View Related
How Do I Add Namservers On WHM
I've got a dedicated linux server running the latest WHM. I've got a domain I want to use for a website hosted on the domain. I've created a new account for the website/domain on the server but I'm not sure how continue from there. I need to know how to get ns1.mydomain.com ns2.mydomain.com with corresponding IPs. I'm aware I need more than 1 IP to do this and I have them. The server is all setup and ready as I've had it for over 2 years (yes and I still don't know how to do this). I've been paying a server administrator to take care of all server stuff for me but he's not available for the next couple weeks and I think it's about time for me to learn. I know how to create the account for the domain on the server and enter the details in my domain's registrar (godaddy) but I don't know how to do everything in between. I've looked through the documentation for WHM but it is not as detailed as I need it to be and other guides I've found on the net haven't been too helpful for a newb like me.
View Replies!
View Related
How Can I Add Ip Addresses To Node
i'm using hypervm/openvz and i have the main package of ips which i have received from datacenter i orderd other package ips (13) ips i have add them to ip pools in hypervm and it didn't working Note : netmask are different for the first ips and the second ips when i create vps i can't login and when i ping ip it didn't ping ( requested timed out ) i have one server from softlayer and the other from limestonenetworks when i order additonal ips from softlayer it works proberly .. now when i orderd those ips from limestonenetworks ; i think it must be modified manually
View Replies!
View Related
Why Does .NET Add So Much Cost
My current hosting company - hostmysite.com - offers two Windows (IIS) hosting plans, that are almost identical except that one supports ASP.NET and the other only supports old-fashioned ASP, but not ASP.NET. The former is $20/month and the latter is $12/month. Why would adding support for .NET increase the price by 67%? I run IIS on my network here and it's not obvious to me why .NET per-se increases cost, server loads, etc, by anything like that.
View Replies!
View Related
CPanel Domain Add-on
I found that the domain name add-on I had before in my cPanel account is missing, so I tried to add-on a domain name back, it says: Error from domain wrapper: Domain already exists, it was not added.: the.domainaddon.com The question is how do I clear them all off related to this domain? I tried to edit /etc/userdomains, /etc/trueuserdomains and found nothing httpd.conf only shows the subdomain and nothing else. I editted /var/cpanel/users/{username} and remove the last line XDNS1=domainaddon.com
View Replies!
View Related
Migrating A Add-on Domain
Basically I have one website hosted (add-on domain) on a shared server. Now this domain has to moved to another server on its own. I have no doubt backing up the database from the current server and restoring it but is there an easy way to move the website, mailbox contents? Both servers are cPanel plans, I would just use copy account in WHM if it was not an add-on domain.
View Replies!
View Related
Add-on Domain And Subdomain
Let's say my domain, for which I have shared hosting, is www.mydomain.com I have also registered the domain www.yourdomain.com My hosting has cPanel I add www.yourdomain.com as an add-on domain. Inside my root folder the folder /public_html/yourdomain/ is created. When I create the subdomain subdomain.yourdomain.com, the folder /public_html/subdomain/ is created instead of /public_html/yourdomain/subdomain/ Can I assign the /public_html/yourdomain/subdomain/ folder to be the root of subdomain.yourdomain.com? e.g. I have the file image.jpg at /public_html/yourdomain/subdomain/image.jpg and it's accessed from subdomain.yourdomain.com/image.jpg Is this possible? Having a lot of folders directly under /public_html/ would get annoying for me.
View Replies!
View Related
How To Add & Assign IP
I want to know how do I add new IP to my server via SSH command? I am using cPanel and I am aware I can do that inside WHM but the problem now is I have just changed my server IP and my cPanel license IP is not updated yet. It shows me "Invalid License" when I login. I also want to know how can I assign the new IP manually via SSH?
View Replies!
View Related
How To Add CNAME For Domains.live.com
I'm new for cpanel and I want to add CNAME for domains.live.com and the requiered information DNS Record Type: CNAME Host: 250953144 Value: domains.live.com I enter edit dns zone like the picture attached I don't know if i should delete the www and mail or leave it like this please told me how to do to make it valid with domains.live.com
View Replies!
View Related
Add Network Location Over VPN Possible
We have two servers, one in our office, and the other in a colocation. There is a site-to-site VPN connection between them. I want to add the server in the office as a network place/drive to the server in the colocation, but I can't get it to work. I tried putting the local ip of the server in the office, didnt work. Then I tried OFFICESERVERNAMESHARENAME and that didnt work either. Office Server Local IP: 192.168.0.202 Colocation Local IP: 192.168.1.2
View Replies!
View Related
Webmin Add FTP Users
with webmin can I use it to add FTP users to say pure ftpd? and does it work with lighttpd? If I'm thinking about it right webmin just allows us to control the service and modify the configuration files right?
View Replies!
View Related
Add Domain Via Direct Admin
When I introduce myself as a newbie, I do not exaggerate. Hope to slowly change that, thought. I have recently rented a dedicated server from worldstream and have paid for a lifetime usage of Directadmin. My goal is just to host my own site. Now I am trying to transfer the my domain to this server. From what I can tell, I need to change the DNS for the domain from it's current DNS. In the Directadmin control panel under "DNS Administration", I see "Add Zone" which I assume is the step to take. Under "Add zone", it asks for (1) Domain name (what format would I enter this) (2) IP Address (I was supplied with three IP's when I signed up with worldstream. Do I just pick one of these?) (3) Name Server 1 (Unsure of what to enter here) (4) Name Server 2 (Ditto as above) I realize this is quite basic for most.
View Replies!
View Related
Should I Add 2nd Nameserver IP On Server
My provider just gave 1 IP and to be use as shared IP for every accounts created in the server. I also assigned that IP for my nameserver ns1.domain.com at my registrar. I was instructed also by my provider to use the next IP for the second nameserver which I also created at my registrar and created dns zone at the whm. All of the domains using that two IPs are working but I dont know why when I ping the second dns its not working. from Intodns.com its also showing nameserver 2 as an error.. My question is, do I need to add the second IP on the server/whm? you see when I go to WHM and click Show IP Address Usage I only see the first IP shared to all other domains. Somehow I'm expecting to see the second IP on the screen. Anyone can enlighten me? the server I got should have been a full management but my provider is somehow responding so slow.
View Replies!
View Related
Add-On Domain Park Wrapper
I moved my whole account from one server to another but now the add-on domains inside the main domain are not working. When I try to re-add the domains in the new host's cpanel, it says: Quote: Error from park wrapper: domain.org is already configured. What file is it on the server that holds this information? I really need to remove this domain name from there so I can re-add it.
View Replies!
View Related
Proper Way To Add Multiple Sites
Right now I have maybe 6 personal sites that I keep on my new VPS. They are mixed together in the public_html file. Ex: coolsite.com and anothersite.com are found in public_html/coolsite/ and public_html/anothersite/ so the result is somewhat messy with many folders. What is the proper way to add sites so I have access to each site separately so it is not so cluttered? Or am I doing this right?
View Replies!
View Related
Add Parked Domains Without Any Panel
i am using a VPS which does not have any panel currently (slightly low budget and dont want to waste RAM). can u please tell me two basic steps which i am sure have been discussed before but i could not find them? 1. how to add domains to the server? I have already added them as virtual server in apache config file but i think some other file also needs to be changed for "DNS configuration?" please correct me if i am wrong? only editing the apache config file and then restarting is not working 2. how to add parked domains to the main domain manually? I am on centos 5
View Replies!
View Related
Can You Add Too Many Aliased Domain Names
Is it possible to add too many aliased domain names on a Dedicated server? I have Hostgator's most powerful dedicated server and I added probably 150 domain names as aliases to one of my websites. Now today all of the sudden none of my other sites will load on the web. When I try to go to one of my sites it just thinks and thinks but never loads. I'm using WHM with cPanel. Can aliased names cause too much server load? Some of those 150 domains get a little traffic but not much.
View Replies!
View Related
Hacking Buildapache To Add Mod_deflate (for 1.3.37)
apparently a mod_deflate patch has been available for apache 1.3.37 for some time but since I rely on cpanel as a huge time/knowledge saver, I'd like to hack it into buildapache/easyapache so it's an option just as easy as mod_gzip is (with a simple checkbox) after poking around I learned that all the magic happens in /home/cpapachebuild/buildapache I've studied how mod_gzip is activated/installed but some steps are beyond me mod_deflate for 1.3.37 is here [url]the critical files inside are of course mod_deflate.patch and mod_deflate.c so I assume stick those files into a directory under buildapache, but where do I hack in the patch and build steps?
View Replies!
View Related
Add A Domain To My Dedi Box
About 4 days back i ordered and got a Xeon dedicated box from Softlayer BUT i am stuck adding one domain. First i tried making a new account for this domain through WHM but problem was not solved, so today i parked this domain to a domain's cPanel account but after that also problem was not solved So, let me first explain you whole problem. Suppose my domain is my-domain.com This domain my-domain.com was added to shared hosting account at ace-host.net. But after purchasing dedicated server, i shifted whole site data to new server and changed the nameservers of my-domain.com with new ones and atlast i removed this domain from my Ace-host.net account. Then i waited for about 2days to domain to propagate with new server's namesevers. But when nothing happened (i checked the domain whois record, they were showing my new server's nameservers), atlast i contacted Softlayer regarding this and after sometime they replied We have given the correct server alias for your domain my-domain.com in apache configuration and it was working fine that monent. But after sometime i checked that my-domain.com is loading fine but it is taking whole data (including database and templates) from my OLD HOST ... Ace-host.net! As i have already mentioned that i have already deleted my-domain.com from Acehost account and also updated the my-domain.com's nameservers with new dedicated server's. And i checked many times WHOIS records from different websites at that moment. All were showing nameserver records of my new server. I now contacted PSM and they after sometime replied that its working now as they just had to restart dns server. BUT NOW , today again samething is happening! (on the 4th day) so, i terminated my-domain.com's account from my server's WHM. and then parked in other domain cPanel account on same (Softlayer) server but still problem is still there!! Domain is registered at Namecheap.com NOTE: I am not saying anything against PSM or Softlayer and their support staff. They are both THE BEST in the market! and they have helped me a lot manytimes. I also have two more domains on this new server and both are working fine from very first day. They are registered with local registrar not with namecheap.
View Replies!
View Related
|
TRACKER
