CentOS 5 Server :: Login As Postgres User And Enter Commands?
Sep 10, 2010
I've had a server setup working perfectly for the last 2 years. Today we installed a newer version of postgresql and recompiled apache/php.
Postgresql will not start now.
"service postgresql start" = /var/lib/pgsql/data is missing. Use "service postgresql initdb" to initialize the cluster first. To initdb we need to be as user postgres.
"su - postgres" = "no file or directory"
In /etc/passwd = postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash
how i can login as postgres user and enter these commands?
I made a system in CentOS5.5. I used Tomcat6 and PostgreSQL. But I couldn't enter my system. There are some error. And I don't understand what kind of error this. JDBCExceptionReporter.logExceptions(100) | SQL Error: 0, SQLState: null JDBCExceptionReporter.logExceptions(101) | Cannot create PoolableConnectionFactory (FATAL: Ident authentication failed for user "postgres") "postgres" is username. Is anybody knows anything about this error message.
I am running FC12 64bit on my desktop and the problem is that after I enter my credentials at graphicall login screen (Gnome) the computer hungs i cannot moove the mouse, CTRL+ALT+DEL won't work the Caps and Scroll lock on my keboard are blinking. Nothing responds. I am absolutelly cluless. Untill yesterday i was using FC12 i686 and never had this problem, but i got 4GB ram so in order to get those fully i installed the 64bit version. On clean install of the 64bit ver everything went fine, but i updated the system and followed theese instroctions [LINK]http://www.howtoforge.com/the-perfect-desktop-fedora-12-i686-gnome[/LINK] and that's all
I am running FC12 64bit on my desktop and the problem is that after I enter my credentials at graphicall login screen (Gnome) the computer hungs i cannot moove the mouse, CTRL+ALT+DEL won't work the Caps and Scroll lock on my keboard are blinking. Nothing responds. I am absolutelly cluless. Untill yesterday i was using FC12 i686 and never had this problem, but i got 4GB ram so in order to get those fully i installed the 64bit version. On clean install of the 64bit ver everything went fine, but i updated the system and followed theese instroctions [URL] and that's all.
Before i atempt to login i can ssh to the machine.
I installed Centos 5.5 on a home PC to be used remotely.
All server daemons work fine but only start if the user is logged in.
How do I set the SSH server to start whenever the PC is turned on, rather than when the user is logged in? I read the chkconfig man page online but couldn't find anything.
Plus I put a script in my startup services to be run whenever the computer boots (I'm guessing when the users logs in). How do I go about setting that to run too whenever the system boots instead?
I am trying to write one script. Purpose of my script is that it will login to particular user and it will execute some set of commands.What I was trying....
I have a new CentOS server install. I am trying to connect from a windows xp box using putty ssh. I can get as far as putting in the password for root user and then it tells me access denied.
I have a question that i want to make a normal user to execute the commands which the root user is able to execute, say if i have a user named siru and when i logged in using siru i cannot run commands like tracert,nmap@loccalhost and all but i can run when i have logged into root account so my question is how to make siru to run the command tracert,nmap@localhost.I have even edited the .bash_profile of siru's home directory from
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then
i have installed postgresql to my fedora10-distribution. when i would to access to this database by using the command #su postgres as is mentioned at [URL]..3/install/wiff/createcontext to install freedom , an error message is shown to tell me that user postgres does not exist. what is the likely problem.
i am using openssh 5.2-p1, i want to restrict user "admin" to login to the server from a specific IP address, for this purpose i have tried the following blocks in sshd_config file.Following is the part of the sshd_config file which i have modified
#The following commands will only allow specific IP to login to ssh.
#AllowUsers admin user1 user2
#AllowGroups
# override default of no subsystems.Subsystem sftp internal-sftp
Match Group sftpgroup ChrootDirectory /home AllowTCPForwarding no[code].....
i want to restrict admin user to login to the server only from 172.16.100.221 IP which can be done by using AllowUser line, but i dont want to use AllowUser line,
i have a linux server, the Operating system is SUZE 9 but i need to see all commands executed by any users connected on the server and the ip of the host in a log file.the history file does not contain all info that i need .please is there a way to write a script in order to save this problem .
I am a Mac/ Windows user, forced to use Linux for my college work. I do not know where to enter commands like $ sudo /usr/etc/eth0 mvntz -do4i or how to make them work
I had a problem - the Wi-fi card in my laptop was not working. All the forums were useless. They wanted me to READ about wireless networking !
Finally a good friend solved the problem in a simple way : it appears Ubuntu has not installed the drivers for my Broadcom wireless card since it was not open source. I had to download it myself. Here is how : Go to System menu on the top bar. Choose administration/ hardware devices. Tell it to activate the device. It will download the drivers through the cable attached to DSL modem and install.
Then clicked the network icon, selected edit connections, and entered my wireless network name and password. This solved all problems.
Why doesn't Linux give me a warning that the driver for something is not yet installed ? When I was struggling with the network setup wizard for the whole day, there was no clue about the missing driver.
I would like to learn basic linux commands and editors (eg : vi). Am using windows and it is difficult for me to install linux in ma laptop. So is there any free linux login servers available in internet so that I can login to server with putty and try using basic linux commands and editors.
I installed Fedora 12 in my PC and after that when I tried to use minicom it was not installed. I tried copying the executable of minicom in /usr/bin from another PC and tried using it. But, I was not able to enter any commands in minicom..
I just finished installing 10.10 on my pc. the problem is that i cant login to the desktop i enter the password, the login sound plays and im stuck looking at the wallpaper. nothing else. i tried logging in safe mode and it worked. how can i get it to work normally?
pc specs: Pentium 4 2.6 ghz 512mb ram ati radeon 9600 graphics card
I just bought this desktop from my friend and it runs win 7 and ubuntu 10.04. it worked very well the first two days until I changed the hostname of the system.
I did like: hostname myNewName
And everything worked fine. The problem now is when I start ubuntu and and reach username and password screen , I enter my password to login the screen becomes black and return me again to the screen where I put my password again. If I entered wrong password , the system message stating wrong password. On the other hand, when I try to run ubuntu from live-cd I can login easily and access my account.
My friend told me he removed Naultius package and reinstall it for some reason before he gave it to me. Note windows 7 is working properly.
I have no idea what happened to my OS(ubuntu10.04).it doesn't give me any option to enter my login name & passwd.i just get a blank(default) login screen.last time when it worked,i was trying to install GTK+2.8,but due to my mistake i deleted glib using cmd (sudo apt-get purge glib)and after that i even tried to launch terminal but it failed to launch.also tried to play media files using vlc but it didn't work.so i tried to restart my os and finally got stuck in the problem.i have no idea what to do,please help.Is there any cmd to see what problem occurred or which package is missing.
I am trying to determine if I should upgrade PHP's PEAR on my server. I am trying to check the version of PEAR currently installed. I am getting the following error when I use the pear -V command:Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s)(/usr/share/pear:/usr/share/php) in System.php on line 459I tried adding /tmp to my php.ini file, but then when I use the pear -V command it doesn't do anything. I do not get any errors or anything.I am also trying to install symfony and have the same situation described above when I use the following command: pear cannel-discover pear.symfony-project.comDoes anyone have any thoughts? If not the solution, does anyone have any suggestions on how to begin troubleshooting this?
Our CentOS 5 server had a weird issue last Friday. We couldn't run any bash commands, such as ls, vi. It said that it could not find /bin/ls. The only commands we can run are internal commands, such as ps, cd. After we reboot the server, everything is back.
I don't know what's wrong with it. Does anyone give me a explanation?
We have a disaster recovery solution for our database where a dump file is generated daily at 1:00 AM. We have tested importing the file, along with running another sql file that generates the appropriate database user accounts, into a database on a third-party server.
One question that came up was the following: Suppose the database crashes in the middle of the day, prior to that there were transactions that were entered into the database between the time the dump file was generated, and the crash occurred. We can restore the dump file to either the main or backup server. How can the transactions that were made between the time of the dump file and the crash be restored as well?
While backing up/restoring bacula clients. We were getting an error regarding database tables' version. The error message is given below.. "Found 10 needs 12".
After Googling, what we found is, we have to update the postgres database for bacula. So now we are in process to update the database via the update_bacula-tables script. We are not sure, if it will solve the problem or not. We have just upgraded bacula 2.4.4 to 5.0.1. Postgres version is upgraded from 8.3 to 8.4. It is Debian 6.0 squeeze.
I have a minor issue with permissions. There are a couple of devices that I need r/w access to in /dev. Whenever I first boot up and log in as end user (not root) and I need to access the devices permission is denied. Logging in as root there's no problem accessing these devices. However as an end user every time I need the devices I have to first su to root to change R/W permissions (chmod 666).
Now, the good thing is that the permissions stick even as I logout and then log back in, but as soon as I reboot my computer (every night) I have to go and chmod manually. I'm trying to find a way to avoid having to su and chmod manually but I'm not having much luck. The devices I am trying to access are /dev/ttyS1 and /dev/windrvr6, when I first boot up and login as end user the permissions look as follows:
crw-rw---- 1 root uucp 4, 65 May 27 04:11 /dev/ttyS1 crw-r--r-- 1 root root 253, 0 May 27 09:12 /dev/windrvr6
I had successfully installed centOS,i am able to login as root.I created local users.But unable to login via console and FTP.As per the logs there were some LDAP issue,so i disabled LDAP and disabled PAM config as well.Now i am able to login to the FTP with the local users created.unable to login to the centOS console with the local user.
When I login to my machine I can see a BLACK screen and my mouse pointer. This is not happening with other users.Few days ago when I tried login to my machine I noticed this. I can access ssh session and do stuff there but some time I need GUI.I can login fine using other users. This is only happening with one specific user.I have just noticed that if I try loggin with the same user which have issues using NX client it shows us a BLACK screen, then if I open xwin then I can see three new windows top panel, bottom panel and Desktop.
