Ubuntu Servers :: Postgresql Not Starting - Error "psql: Could Not Connect To Server: No Such File Or Directory"
Feb 1, 2010
I'm trying to install postgresql 8.3 on Ubuntu 8.04 LTS server and I'm running into problems starting it. Commands I've done # apt-get install postgresql postgresql-common Things I've tried Starting it manually
# /etc/init.d/postgrsql-8.3 start
Nothing appears in my /var/run/postgresql When I try and start psql as the postgres user I get the following error psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? I've been following the docs at: https://help.ubuntu.com/community/PostgreSQL
I have installed PostgreSQL 9.0 in Ubuntu 11.04.The following is a bit long-winded and cross-relates to PostgreSQL,I ran the PostgreSQL installation thus:
Code: sudo su ./postgresql-9.0.4-1-linux.bin[code]....
The problem, obviously, is the "Permission denied" error. What/where am I going wrong? From my directory listing I can see that the permissions for gjd_sentinel_data are drwxrwxrwx with owner/group of postgres. On that basis I can't see why there is the problem.I am wondering if it has something to do with the psql process running as, or owned by, user postgres? Or that I am running as the wrong user? Or something else beyond my experience?
--- Ubuntu 11.04 with GNOME2 classic desktop Single user. Dual boot with Windows XP Home
we did get php installed! Now for the next question...having trouble getting php to connect with postgresql database. I believe this has to do with the php.ini file. What directory do we put the php.ini file? and do we just use the php.ini-dist file that was downloaded during install rename it php.ini and add under dynamic extensions extension=pgsql.so?
Believe that php.ini should go under
/usr/bin directory, because that is what we type when running php script /usr/bin/php some_script.php
What is the magic that needs to be done to be able to record in audacity?
- Fedora 15 x86_64 2.6.35.12-88.fc14.x86_64 - SoundBlaster X-Fi card. -I have added rpmfusion to yum repos.
When I start audacity the following is printed to the concole:
Code:
Cannot connect to server socket err = No such file or directory Cannot connect to server socket jack server is not running or cannot be started Expression 'stream->capture.pcm' failed in 'src/hostapi/alsa/pa_linux_alsa.c', line: 3653
I am trying to get SQL-Ledger installed and running on my computer, which needs PostgreSQL installed to run.Currently, I am having trouble with it starting at boot-up. How can I access the appropriate log files in order to figure out what's wrong?
Also, I need to know what httpd is, and who the owner and groups using that might be on my system.
I'm trying to install a copy of Postgres using the .bin(I want pg Admin III as well which is why I'm not using apt-get). It's sitting in downloads so I did the following:
$ cd /home/ryan/Downloads $ sudo chmod +x postgresql-9.0.4-1-linux.bin $ ./postgresql-9.0.4-1-linux.bin
but I keep getting: -bash: ./postgresql-9.0.4-1-linux.bin: No such file or directory I did -ls and the file is there and I can't figure out how to get this installed.
I have recently Installed Fedora 11. I have installed postgres like yum install postgresql but I wonder there is no user created for postgres when I tried su postgres system says, no identity for user postgres. even when I tried to connect postgres server using psql then it says
Code:
psql: could not connect to server: No such file or directory
Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I am trying to share files between Windows XP machine, ubuntu server, debian server and ubuntu desktop. But mainly between ubuntu server and Windows XP computer.I also like to learn samba, because probably I could do all this with ftp server as well.I set up and configured samba following the instruction on Online Ubuntu Server Guide.But when I run the command:sudo /etc/init.d/samba restartI get:bash: /etc/init.d/samba: No such a file or directory I don't know what is wrong?
rcon@li121-251:~/b3$ ./b3_run.py : No such file or directory rcon@li121-251:~/b3$ l;
[Code].....
as you can see up top it gives me an error when i try to run the file. it is a Ubuntu error and i don't what the heck is causing it. had it before but don't remember how i resolved it.
There is like one month since dig fails running after some upgrade. Platform: Ubuntu-Server 6.06.1 _Dapper Drake_ - Release amd64 Error: Code: dig: error while loading shared libraries: libdns.so.21: cannot open shared object file: No such file or directory.
We are running into issues with a File Upload script written in PHP. We can upload files without issues except with .*x files (such as .docx) We are getting permission denied errors. The error occurs when we use move upload file, to the new directory within our PHP app. If we give the uploads folder 777 access, it works fine without error. I dont like that. So I set it to 775 (Also dont like this), but it didnt work until I gave group ownership to www-data (I really dont like this)
This issue only happens on our production server, which is Ubuntu 9.04, running Apache2.2 and PHP5 will all the newest updates. We also have all MIME's configured, and are able to download the file from Apache without error. The first thing we noticed before the file permissions error, was that the MIME type changed to .zip when we used mime content type function. But yet using the FILES array, it still showed .docx.
Trying to get OpenbavoPOS to connect to my remote Postgresql database, but so far i've only been able to connect to the local postgres installation. I _am_ able to access the remote databases with psql. I've read literally dozens of pages, and am pulling my hair out. I'm trying jdbc:derby.//192.168.15.10:5432/bravo I get back java.sql.SQLException no suitable driver found for jdbc:derby.//192.168.15.10:5432/bravo If I use jdbc:derby./root/bravo - all is OK, using a local database created in /root I have jdk installed on the client; does it need to be on the server also?
Server = CentOS 5.4 PostgreSQL version 8.1.21 Client = CentOS 4.8 PostgreSQL version 8.1.4
I am merely trying to change the port for my ssh server.However it isn't changing.I edited my ssh_config file to:
Code:
# This is the ssh client system-wide configuration file. See # ssh_config(5) for more information. This file provides defaults for[code]...
When i try to connect to my server via port 443 i get a connection refused error. However when i try to connect via port 22 it connects. Since that didn't work, i tried restarting the entire server.To restate, i changed the config file and restarted ssh then the computer, however the port didn't change.Ohh and yes my router is set to port forwarding on port 443, though it doesn't matter since I'm inside the network.
I have openssh installed and it works great right out of the box. However, I don't want people accessing everything on my machine. My machine is behind NAT and ufw firewall. I have configured both so that port 22 is open. I've added the new users I want to have limited access and assigned them to group "sambashare" (just because its convenient.)
When the bottom bit of my config file "/etc/ssh/sshd_config" is set as shown below, everything works great:
Quote:
#Subsystem sftp /usr/lib/openssh/sftp-server Subsystem sftp internal-sftp UsePAM yes Match Group sambashare
[code]...
Whenever I make the change to enable "ChrootDirectory" so that it limits the users access, I simply remove the # and it looks like this:
Quote:
#Subsystem sftp /usr/lib/openssh/sftp-server Subsystem sftp internal-sftp UsePAM yes Match Group sambashare
[code]...
However, thats when I start running into problems. When I try logging in with Filezilla; I am not able to connect and this is the response I get from Filezilla:
Quote:
Status: Connecting to ##.###.###.###... Response: fzSftp started Command: open "user@##.###.###.###" 22
i'm not the most knowlegable person but i have successfully installed mysql in the past. but now that i am attempting to install it again i'm getting this error during installation. has anyone seen this before?
mysql error: *Starting MySQL database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.0 (--configure): subprocess post-installation script returned error exit status 1
we have postgresql database in our server. when i tried to install our application it throws some error like "org.postgresql.util.PSQLException: ERROR: encoding UTF8 does not match locale en_US Detail: The chosen LC_CTYPE setting requires encoding LATIN1". the locale which is set in our server is
I'm trying to run X11 windows over ssh but I get this error:
Code:
ssh -X -C server@192.168.1.103 Warning: No xauth data; using fake authentication data for X11 forwarding. server@server:~$ xclock connect /tmp/.X11-unix/X0: No such file or directory Error: Can't open display: localhost:10.0
I managed to connect with another computer. That computer has a /tmp/.X11-unix/X0 socket. Is there a way to create a socket on this computer?
We have a couple of Windows file servers that just share files. It is all they do. We'd like to use Ubuntu on two replacement servers allowing Windows XP and Windows 7 clients to access the files. Our network is active directory based due to Exchange and homegrown .NET apps, so it is important that active directory is used to authenticate the clients. Samba doesn't need to be a pdc or bdc, but provide pass through authentication.I understand that Samba can communicate with active directory through security-ads and security-domain.
Here are my questions to see if I should proceed:1) Folder permissions:If we move all our files to the Ubuntu server how do we set folder permissions and will we see the active directory accounts when we do this?2) Skipping ubuntu accounts: I know the domain and ads allow you to skip creating ubuntu accounts, right? If not, how do you keep the passwords synchronized?3) Easiest way? Is there a very easy way to pull this off that I've missed? My goal is to eliminate the Windows based file servers while ensuring the admin part of it is as easy as possible.To date I've been able to get the sharing to work with an ubuntu account mirroring the active directory account. I've been able to get Samba to talk to the pdc, but not successfully through domain security. ADS security was a complete cluster with winbindd
I have an ubuntu fileserver and an ubuntu laptop both running 10.10.For some reason I can't connect to the server (file or remote terminal) from the laptop, even though I can access ssh through terminal on my mac and have been able to mount the filesystem on another computer running the ubuntu liveCD. I just get the error 'no route to host'.I've tried turning off the firewall on the laptop and re-installing ssh on both computers, but I don't have a clue what to do next!
I have FileZilla installed on this machine, and OpenSSH (with an open port 22) on another machine on my home network. When I try and connect, I get: Quote: Status:Connecting to 192.168.2.3... Response:fzSftp started Command: open "alphatwo@192.168.2.3" 22 Error:Connection refused Error:Could not connect to server
Which has left me puzzled as I have an open port. Does the username have to be defined somewhere? E.g. the machine acting as my SFTP server can be logged on to locally as alphatwo so that's what I logged in as (with the correct password). Is this correct? If so, does anyone have any ideas as to how I might rectify it? I want SFTP set up so I can copy PHP files from my laptop to /var/www/html/ on another PC (across the home network).
i am trying to install symantec endpoint on a linux server by this command rpm -ivh sav-1.0.3-8.i386.rpm but it gives me the following error error: unpacking of archive failed on file /opt/Symantec/bin/navdefutil;4ceb8d6b: cpio: mkdir failed - No such file or directory
cups does not start with the server. When I try to start from the terminal I get the error message
cupsd: Unable to read configuration file '/etc/cups/cupsd.conf' - exiting! cupsd: Child exited with status 1!
The log files show nothing. cupsd.conf exists. It is user - root and group - root with permissions set at 0644.
My interpretation of this is that the program is not launching from either boot or terminal for a fundamental reason. I do not quite see what that reason is .
I have installed vnc-server on my CentOS 5.6 virtual machine. I can connect to it with a java web browser so it seems to be working. However, I get the following error message when I start, stop or restart the vnc-server process. Quote: Starting VNC server: 1:ken xauth: timeout in locking authority file /root/.xauthkk661q
every time I try to connect to the ftp server I setup i am recieving this error Response:*** buffer overflow detected ***: /usr/sbin/vsftpd terminated Error:Could not connect to server
Using CentOS 5.5. I have a handful of users that I need to have connect to my server via sftp and start in the same directory. for example, user1, user2, user3, etc.. will connect via sftp and upon connection will all be in the /some/dir/path/ftp-root directory.I know one way is to create these users all with the same 'home' directory, since by default a user starts in their home directory when connecting via sftp, but before just doing that, I wanted to find out if that is really the appropriate method to use? alternatives? Is there some setting on the sftp server end that could direct all users to one starting directory so that these users don't have to have the same 'home' dir? I'm using the sshd daemon that comes with CentOS 5.5 (with all current updates/patches)
make install then i got this error: postfix: fatal: chdir(/usr/libexec/postfix): No such file or directory make: *** [install] Error 1 I don't understand why it's checking the usr/libexec folder for the daemons although I've set the folder to /opt/product/postfix-2.6.5/libexec in the makefile. Here is also the cat of my makedefs.out:
