I am having trouble installing postgresql on my CentOS virtual machine. I am trying to compile from source by following this tutorial:[URL]..Here's the output and the commands that I have used thus far:
Code:
[root@localhost postgresql-8.4.4]# ./configure
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking which template to use... linux
I have made a cluster between two server.In luci I can see that my cluster is green and the two nodes to.I have make an IP resource and associate it to a service : green : I can relocate the service from a node to the other one and the IP appears in the list of IP addresses The problem is that I have made the same in order to configure tomcat and postgresql and it does not work...I put my configuration only for ip and tomcat:
In luci I can see that my cluster is green and the two nodes to. I have make an IP resource and associate it to a service : green : I can relocate the service from a node to the other one and the IP appears in the list of IP addresses
The problem is that I have made the same in order to configure tomcat and postgresql and it does not work...
I've installed PostgreSQL 8.4 via yum and I haven't edited any conf file. Just did the following: CREATE USER nagios WITH PASSWORD 'nagios'; createdb --owner nagios nagdb But then I try to log in like this as postgres user: psql -d nagdb -U nagios And I get the error message -> FAILED: Ident authentication failed for user 'nagios' Why is this happening? My pg_hba.conf is as following (this is the original config):
The installer can't see my raid controller (I assume) as I'm getting the following error:"Error opening /dev/mapper/isw_jbhgjgjj_Vol0: No such device or address"It just sees them as 4 individual drives: sda, sdb, sdc and sdd.Please note that I have set up the RAID 5 in the controller bios interface and the image name is Vol0, which it seems that it tries to load but for some particular reason it can't.I have also tried different bios settings and nothing worked.
My problem is that I'm trying to install CentOS 5.4 x86_64 DVD ISO on Supermicro X7SBI server with installed Adaptec RAID 3405 controller.
I created RAID 5 array and is working fine (adaptec status says Optimal) but I can't install CentOS to that array (1.5TB size).
Whenever I try to install with: linux dd
I'm asked for a driver, which I have downloaded from Adaptec site and extracted contents to USB drive (in installation found as /sba1) which has now a lot of IMG and some ISO files on it.
I try to load (I simplified names) RHEL5.img, CENTOS.img... with x64 names (one exact name: aacraid driverdisk-CentOS-x86_64.img) and I always get the error message: "No devices of the appropriate type were found on this driver disk"
This is going on for a week now and I can't find the right driver or something I'm doing wrong to get install done.
I am trying to install CentOS-DS on version 5.4 x86_64. I cannot get to the Extras repo due to lack of wired Internet access. I have wireless (except to server) and I have big UFD drives.
I need your help urgently. I will shortly install Centos 5 on a HP DL380R05 E5420 Server with two HP 146GB 10k 2.5 SAS HP SP hard disks running hardware RAID-1. I am a newbie on CentOS, please advise me:
1. Do I need a Centos RAID device driver for hardware RAID-1 on the HP DL380R05 E5420 Server? 2. Should I use Centos i386 or Centos x86_64 in this case? Which one: CentOS 5.2 or CentOS 5.3? 3. Does Centos support Embedded NC373i Multifunction Gigabit network cards?
The following is my server's hardware configuration:
HP DL380R05 E5420 2GB Base AP Server(1) Quad-Core Intel Xeon Processor E5420 Two Embedded NC373i Multifunction Gigabit / 2 GB (2 x 1 GB) PC2-5300 Fully Buffered DIMMs (DDR2-667)/HP Smart Array P400/256MB Controller /Rack (2U)/Hot Plug Fully Redundant Fans Standard Two HP 146GB 10k 2.5 SAS HP SP HDD HP 1000W IEC C14 Cord RPS Kit
I want to install CentOS from netinstall CD, but it doesn't work for wireless connection, because it just looks up for eth0 connection. Well, I connected server to wired USB connection and it's named eth1. I want to use netinstall CD but using eth1 connection. Is there any way for doing it?
I am having new hardware and IDE driver for that hardware as drive disk image (it8213_centos53.img). CentOS 5.3 installation is working fine with drive disk image at USB and CentOS 5.3 at DVD. Our application uses CentOS 5.3 and we build a custom kick-start ISO for installations. Using that ISO client is going to install on all hardware boxes.
Note while installing : a) No network connection is avalible. b) No USB isavalible. c) No floppy is avalible. d) Only single CD-ROM is avalible.
So, is it possible to build single custom kick-start CentOS 5.3 ISO which contains dirve disk image and entire installation will be done using that image. If so please let me know the steps to build it.
I've been trying to install the Fuppes media server onto CentOS and have had a few difficulties. I had to do a build from the source (svn build 578), then configure, make and make install. So far so good.Once I try to run fuppes, I get the error:[ERROR] Failed to bind socket to : 8.15.7.107:0.The documentation I've searched so far suggests that there is a config file that needs to be set with the appropriate ip address, but the file doesn't exist as the program hasn't started up yet!
I've Got one Problem with My Computer soon after success installation of when the boot-loader ask me to choose OS at CENTOS 5.4, multi boot boot-loader if i choose windows then computer tries to boot windows but fail and give the error message that there is a problem on reading the hard disk, But when i restart it and start with LINUX then computer start successful with no error message, now i do not know what to do cause i need to use Windows and all my programs are in windows..
I'm trying to install CentOS 5.5 on an old Pentium 4 desktop PC I have, which is not being used for much other than being a MTA, and I want to migrate this functionality onto the CentOS platform for stability (Windows is a perpetual nightmare. I partitioned a spare 20GB to experiment with, and I want to install CentOS into here to play around with first so I can move my files around between Windows and CentOS, until I'm happy all of the stuff is gone, then I can scrub the Windows partition and claim the space for CentOS.
So, I've downloaded and burned the DVD and tried to install. I start the install with no args from the main install menu, and the process goes through some probing and then comes up with the "Welcome to CentOS" menu. I go through this, and then it tries to start X Server. It fails, and falls back to text mode. I get the "Welcome to CentOS" screen again, and then proceed through it. I set my keyboard layout to UK, then this message comes up at the bottom of the screen:
"_X11TransSocketINETConnect() can't get address for localhost:6001: Temporary failure in name resolution"
then on the next line: "Cannot open display :1" If I force the install to text, by typing "linux text" at the first menu, I get about the same way through, but the install just hangs doing nothing, and no disc access to the install disc.
I've noticed this happen with every CentOS installation I've done in the past and it's confusing me. On the software template screen select, I always select "Server" and leave the extras option unchecked, I also check "Customise now". The only things I choose are the editors (to get vi), Web server and server configuration tools (and this time also Java). I didn't select any GUI programs, yet it still installs things like X, GNOME components and also samba. Why does it do that? There no way they're needed for dependencies. Is there something I'm missing when selecting the software components? Why does it still install samba when I didn't select it from under "Servers" components? Or have I misunderstood what software selection does and it installs all those components regardless but doesn't automatically turn the services on?
I have been running CentOS 5 as my primary desktop for about 6 months now, and have been very pleased with it. Since I work as a hardware designer most of the tools I need only provide support for RHEL, and I have found these tools (once you hack the installer anyway) generally work very, very well indeed on CentOS.
I recently bought a new computer and I thought I'd share my experiences of installing CentOS 5.2 on it. Here's the specs - Core i7 920, 12Gig DDR3, Radeon 4780, Gigabyte EX58-UD4. The first issue I encountered was a very early boot crash. This was a known problem with the onboard Gig-E chipset and I eventually found the solution on your wiki site. Using a separate network card I was able to install the new kernel module and it now works great. I believe this is now sorted in 5.3.
Next up was a problem with the Radeon card I think - after installing the ATI driver (proprietary), X would come up with a white screen and the computer would lock up. Going back to VESA would get me going again, but frankly I can't stand X without video acceleration. This turned out to be a problem with "RHGB" (not the first time I've had problems with this to be honest). Disabling it in the grub command line sorted that out.
The next problem was the performance of the harddisk - I was only getting a few MB read/write speed out of it according to hdparm. This seriously slowed down the PC. To fix that I had to enable AHCI in the bios which got things running much better - about 55 MB/sec.
The last problem was with the virtualization. I run VirtualBox with a windows instance and it kept crashing every time I booted it (I'd copied it across from my old workstation). This was because of FlexLM drivers used for USB dongle based licenses. Now, these will only work if you enable the VT extensions on the processor. I thought I had - the VM certainly had it enabled and so had the bios. Going through the VirtualBox log's it seemed like they were being detected but not enabled. From what I understand, VT-x was enabled, but the BIOS is supposed to also set up some form of locking mechanism or these virtual machines wont use it. It seems this wasn't done properly with the BIOS revision supplied with the motherboard (F2). Upgrading to the latest BIOS got it working properly.
My only outstanding issues now aren't really CentOS related - enabling AHCI has stopped my (proper, dual boot) Windows installation from working. At the moment I have to disable it in the BIOS before booting Windows - no big problem as I don't do that often (I maybe need to reinstall it). The other issue is GRUB wont work with my USB keyboard even though the BIOS seems happy enough with it. Odd in that the same keyboard worked fine with GRUB on my old workstation.
Finally, a couple of general remarks about using CentOS - it's never crashed on me and I do thrash the thing at times when I'm doing hardware synthesis or P&R! Base software is a bit limited, but adding some external repos (RPMForge and EPEL in particular) generally sorts that out. The only thing I (personally) miss is a more up-to-date version of mono.
I upgraded my server machine to F12 without realising that postgresql gets upgraded to 8.4, and without realising that 8.4 can't work with 8.3 databases.
Is there a way to install postgresql 8.3 on F12, preferably from Fedora repositories?
Alternatively, is there a way to migrate an 8.3 database to 8.4? I know that the recommended approach is to dump and restore the DB, but now that I have upgraded to F12, the pg_dump command doesn't work anymore.
There is also this open-source tool called pg_migrator but I couldn't find a package for it and it requires a complicated compilation and installation procedure.
The simplest solution seems to me to remove pg 8.4 and install 8.3 on Fedora 12.
I upgraded some days ago from F14 to F15, I once had postgresql-server configured and running, but now I'm getting errors when starting the service and I can't understand where the issue is.
Here some infos
Code: # /etc/init.d/postgresql start Starting postgresql (via systemctl): Job failed. See system logs and 'systemctl status' for details. [FAILED] Code: # systemctl --failed UNIT LOAD ACTIVE SUB JOB DESCRIPTION
Problem is simple but I can't figure out how to solve it, I tried any possible way that I know but with no result.I'm using simple perl script with DBI and do select from one table and do update in other table with results from select, but I can't preserve my '' returned from select when doing update. I simply want my '' from first table to be '' in second but postgres makes them real new lines. I tried to escape '' with , '',"",E(I mean E'value here') in front of value that updating but they are always real new lines not '' in new table.
I cannot connect postgresql using PHP on redhat5. I am using adodb library for database manipulations. It showing the error that could not open the stream adodb/adodb.inc.php file..
Is there any simpler method to downgrading to PostgreSQL 8.2.x? I am installing an application that requires it. I have removed postgresql 8.3 and tried to install some older fedora packages, but it did not go well.
My next step was to compile from scratch. However, I'm not real experienced with make/compiling and am fond of the organizational structure of RPMs.
The other option I could pursue is keeping 8.3 and installing an isolated 8.2 server for exclusive use by this app.
I'm still new to PHP and SQL, but all the tutorials I've found connect to the database like this:
PHP Code:
Right now I'm just doing local network tests before exposing everything to the Internet.
Wouldn't leaving the password in there as plain text be a huge security issue? I tried downloading the php file off the server, and it just comes down blank. So does PHP already have a security feature that doesn't allow anyone to just nab PHP files off the server?
And for Postgre, I have pg_hba.conf set up to "trust" it's own IP address:
Code:
Would I need to use something like Kerberos, PAM, or ident authentication? Right now the only plan is to use it as login system for a website. The clients themselves won't be accessing the DB itself, because all the DB access will be through PHP.
While watching the text scroll by as I shut down I noticed that there is a PostgreSQL Daemon running somewhere. The question I have is, how do I add myself and my own database to this daemon or do I need to run one on my own user?
I'm trying to install pg_config so I can get some simple reports regarding my PostgreSQL 8.4.7 installation.
I downloaded pg_config and its dependencies and tried to install them with the package installer, but it wouldn't go because it seems like something may be wrong with the libkrb5-3 and libkrb5support0 packages - they won't install and the package installer just zips through without reporting missing dependencies or anything. The MD5, SHA1, and SHA256 checksums all match, but they just won't install.
I downloaded all the packages from the ubuntu [security] repository.
Because my Ubuntu 10.04 (Lucid) machine is not connected to the internet, I download packages to my Windows 7 machine, transfer them across my network to a shared folder on my Ubuntu machine and double-click the package to install.
I've successfully installed postgresql-8.4, apache-2.2.14, php-5.3.2, drupal-6.16, and several other packages and all their dependencies this way without any problems before.
To make sure I wasn't having some new problem, I then tried installing libk5crypto3 - it installed fine.
I sent an email to frank@lichtenheld.de , the repository maintainer, but haven't heard back from him yet.