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?
View 2 Replies
ADVERTISEMENT
Mar 29, 2011
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.
View 4 Replies
View Related
Mar 23, 2010
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
View 13 Replies
View Related
Mar 23, 2010
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.
View 7 Replies
View Related
Oct 4, 2010
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?
View 1 Replies
View Related
Mar 19, 2011
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....
#!/bin/bash
su - tom
ls -lrt
[code]...
View 6 Replies
View Related
Apr 18, 2011
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.
View 2 Replies
View Related
Jul 3, 2010
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
[code]...
View 1 Replies
View Related
Jul 21, 2010
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.
View 15 Replies
View Related
Jun 9, 2009
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,
View 1 Replies
View Related
Jan 3, 2011
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 .
View 2 Replies
View Related
May 5, 2010
When i enter ip or address nslookup does not reply any answer. It shows no server found. "servfail". This is my named.conf file:
[Code]....
View 3 Replies
View Related
Aug 28, 2010
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.
View 6 Replies
View Related
Jan 29, 2011
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.
View 4 Replies
View Related
Jan 31, 2011
Ok so I need to Search for a postgres database File on a CentOs System. Is their a command i can run in the terminal to search for postgres files?
View 2 Replies
View Related
Nov 3, 2010
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..
View 1 Replies
View Related
Jan 21, 2010
I am not a new user of linux but the last time I used linux was five years ago.
I am having a hard time using less. It dont want to accept commands immediately. I need to press 'Enter' to accept the command.
Like if I press 'q' to quit, it will echo 'q' and dont do anything. I have to press 'Enter' to make it quit. Same with other commands.
I am using Windows PuTTy 0.60 with ssh to connect to linux machine.
The linux system is: Linux <removed> 2.6.18-53.el5 #1 SMP Wed Oct 10 16:34:19 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux
The less version is :
less 394
Copyright (C) 1984-2005 Mark Nudelman
I dont have any problem with vim and more. Only with less.
I have also tried changing the TERM from xterm to vt100. But still the same problem with less.
View 3 Replies
View Related
Oct 10, 2010
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
And i installed it using wubi.
View 9 Replies
View Related
Apr 15, 2011
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.
View 6 Replies
View Related
Jan 1, 2011
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.
View 14 Replies
View Related
Feb 22, 2009
Is there a way to run CentOS 5.2 update system using the shell, avoiding the GUI (I want to do it remotely using SSH?
View 1 Replies
View Related
Feb 7, 2010
finally i found the script for telnet automated login session...<<Mod edit: questionable link removed>>
View 4 Replies
View Related
May 22, 2009
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?
View 2 Replies
View Related
Dec 21, 2009
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?
View 2 Replies
View Related
Jun 9, 2010
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?
View 2 Replies
View Related
Mar 24, 2011
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.
View 2 Replies
View Related
Jan 28, 2010
Whenever i restart postgres in my server, Selinux is not letting it log anything. In /var/log/messages, it says.
Quote: Jan 28 14:15:43 dataserver kernel: audit(1264709743.263:38): avc: denied { append } for pid=5986 comm="postmaster" name="pgsql.log" dev=sda8 ino=3932166 scontext=root:system_r: postgresql_t tcontext=root: object_r:var_log_t tclass=file
Jan 28 14:15:43 dataserver kernel: audit(1264709743.263:39): avc: denied { append } for pid=5986 comm="postmaster" name="pgsql.log" dev=sda8 ino=3932166 scontext=root:system_r: postgresql_t tcontext=root: object_r:var_log_t tclass=file
I cannot disable SeLinux in this server.
View 1 Replies
View Related
May 27, 2009
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
View 3 Replies
View Related
Feb 25, 2011
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.
View 2 Replies
View Related
Apr 12, 2011
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.
View 12 Replies
View Related
