Server :: Pam_mysql: Is The Database Connection Encrypted
Jan 24, 2010
I'm interested in using pam_mysql or pam_ldap for authentication with my vsftpd server on CentOS. Does anyone know if, when pam_mysql connects to a remote database, whether or not the connection is, or can be, encrypted with SSL or some other means? While I know that passwords are hashed, I'd rather not have my usernames or my pam-related SQL queries travel in the clear.
If pam_mysql DOES communicate only in the clear, what about pam_ldap? I'm more familiar with LDAP than pam_mysql, and have always secured my conversations with LDAP servers when using an LDAP client or my own LDAP connection libraries.
View 3 Replies
ADVERTISEMENT
Mar 2, 2010
I'm try to setup a database server using mysql, the server starts fine, and I can access it using the built in mysql client via console (adding databases and tables works fine), but the problem is... I always get a connection refused error whenever I access the database outside the built in mysql client (example, if I write a code that connects to mysql). So, I tried execute an nmap command and the only ports open are these ports:
[Code]....
there's no 3306 for mysql... I'm thinking that the firewall is just blocking the port that mysql is using, but my question is, how could the built in client connect to the server if there's no open port for mysql server? Don't clients usually access a servers through ports?
View 4 Replies
View Related
Jul 24, 2011
I'm having problems installing pam_msql on x64 Centos. Using yum, no packages for libpam_mysql or pam_mysql.
Is there any alternative to install this thing? I really need it for my OpenVPN authentication.
View 3 Replies
View Related
Aug 2, 2011
I'm having trouble with my pam_mysql authentication.'ve double checked my md5 password but its correct.What should I be looking at? My /etc/pam.d/system-auth is completely identical to my other server (that works), but this one is somehow reporting that my password is wrong.I've bolded out the questionable output.Here's my error log while trying to connect:
Code:
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - option verbose is set to "1"
Aug 2 16:16:21 la2 sshd[8006]: pam_mysql - option db is set to "hidden"
[code]....
View 3 Replies
View Related
Jul 8, 2011
I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?
View 2 Replies
View Related
Apr 14, 2011
I am using Redhat 9 and get the message error establishing an encrypted connection to log in. Error code 8155. How can I correct this as I cant access sites to check my mail.
View 6 Replies
View Related
Dec 8, 2010
When connecting to a database in a php script, where would be the safest place to store the connect.php file. I am thinking it should not be in public_html, but is it safe in sub folders or is there a method people generally use to keep such files secure and inaccessible.
The file I mean is one including the database name, user and password etc.
View 2 Replies
View Related
May 21, 2010
First i get drupal package :-
"sudo wget http://ftp.drupal.org/files/projects....tar.gz"
this will download the Drupal file into current directory.
> unpack the files issue the command
"tar -zxvf drupal-6.13.tar.gz"
this will extract the files into a folder in home directory > make a directory in the web root folder to keep the Drupal files in. To do this type in
"sudo mkdir /var/www/drupal"
> move the Drupal content over to the web folder. Type in
"sudo mv drupal-6.13/* drupal-6.13/.htaccess /var/www/drupal"
> set up folders for media associated with the site to do this issue "sudo mkdir /var/www/drupal/sites/default/files"
[Code]...
View 2 Replies
View Related
Jan 26, 2010
With Encrypted Wireless Connection Not Able to Access Internet - no pings, internet browsing, etc. However, without encryption I am able to browse the internet. I need encryption ..
I am pasting diagnostics collected by shell procedure collectNWdata.sh..
Code:
collectNWData.sh V0.6.2.0 (Rev: 1.193, Build: 2010/01/20 21:22:30 UTC)
--- Which type of your network connection should be tested?
--- (2) Wireless connection (WLAN)
--- What's the type of networktopology?
[Code].....
View 8 Replies
View Related
Jul 31, 2011
I've been having problems with the Atheros AR5001 wireless card in my EEE PC. Whenever I'm connected to an encrypted network of any description (WPA2 at home, WPA-PSK at work), the connection will drop out after some time, ask for the key again, then will drop out after a shorter time. This repeats until it's continuously asking for the key. This is no problem with an unencrypted connection. I've installed the madwifi module as per the instructions in this thread, but that doesn't seem to have helped.Ubuntu 10.04.3 LTS, 2.6.32-33-generic i686 kernel.
lspci:
Code:
01:00.0 Ethernet controller: Atheros Communications Inc. AR5001 Wireless Network Adapter (rev 01)
ifconfig:
Code:
wlan0 Link encap:Ethernet HWaddr 00:25:d3:12:c3:37
inet addr:192.168.2.4 Bcast:192.168.2.255 Mask:255.255.255.0
inet6 addr: fe80::225:d3ff:fe12:c337/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
[code]....
View 9 Replies
View Related
Jan 3, 2010
I downloaded the ubuntu server (command line only) iso and set up a server on a spare computer. The only partition is ubuntu. LAMP server installed, and runs. Its plugged into my home network and the router assigns it a DMZ. I use ptty and that allows me to connect the server from my Windows PC. I installed samba and that works, I set up the server as Z: to my windows PC, and I can now use Filezilla FTP to move gigs of files over from my windows PC to the ubuntu server. I have to log in to activate the connection to Z: but it works.
Problem is getting a database connection from my windows PC (client) to my ubuntu server. Server is running a MySQL server and an Apache Derby server but both give connection:refused every time I try to connect with a java app, or with ij from my client. I tried MySQL Workbench, as that has a GUI, that doesnt connect to MySQL either. Every time I start my server I have to add lots of jar files to the CLASSPATH just to get the Derby server running. The Derby client connection on my client PC is also properly set up with PATH and CLASSPATH etc etc all configured and tested. But the server refuses every attempt to connect even though it tells you the Derby server is up and runnign as listening on port 1527!!!
What I want is a script or app that will "unlock" my server so I can actually do something with it instead of constantly trying new settings and packages in the vain hope it will then actually 'serve'. I am missing something here. There is nothing of value on this server that cannot be 'exposed' to the internet, so I'd be happy to turn off all the security just so the damn thing allowed connections...!
View 2 Replies
View Related
Mar 23, 2011
Linux printing appeared to be working fine up until yesterday. Today typing lpq gives the following: lpq Printer 'sdst@other.domain' - cannot open connection - Connection timed out Make sure LPD server is running on the server
The /etc/cups/printers.conf file is properly set, the printers appear in localhost:631 and they are printing test pages. However, all command line print commands seem to be trying to print to sdst@other.domain I don't know why printers.conf is being ignored and why and how sdst@other.domain was added. Seems like it might have been auto-discovered?
# dit: sdst@other.domain was mentioned in /usr/local/etc/lpd.conf I'm not sure why lpd.conf is being used instead of /etc/cups/printers.conf
View 1 Replies
View Related
Nov 3, 2010
I'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.
View 6 Replies
View Related
Apr 15, 2010
I'm having trouble with my database server run with PHP & MYSQL; i just installed this system on a SUSE Linux Enterprise Sever; the Server its self is an HP Proliant ML370G with 4GB RAM
The system was fine for like 3 weeks until recently when it started slowing down. Apparently, eveything is normal when you are accessing the server, for example when you are browsing on the database web interface; but problem is when you start working in the database, when you try submitting into the database, its really slow on processing, i have to first restart the mysql;
Could it be RAM? or the SQL itself?
View 3 Replies
View Related
Mar 18, 2010
I'm looking for a way to put a MySQL database in a server's memory. The disks aren't fast enough to keep up with the usage and I don't feel like going for a splitted web&db server yet because of the costs.
Because this involves risks (unless there's a way to read from the memory and write to the memory AND disks?), so I'd prefer that the DB gets copied automatically every hour or so to the local disks.
View 1 Replies
View Related
May 20, 2010
I'm a frequent user of the shared connection feature of SSH. Usually i have two or three connections open at the same time through the connection sharing feature, but sometimes when i try to start another i get the message "Shared connection to <server< closed". All the connection that are established through the connection sharing feature are still active and not closed, but when i try to create a new one i get that message.. i've even got that message when i have only had two connections through the shared connection feature.
I've tried to search google but it doesnt seem like anyone else has had the same kind of problem, does someone know why i sometimes get this error ?
View 1 Replies
View Related
Mar 7, 2011
I installed Ubuntu 10.10 64 on my laptop with the entire 500gb setup as encrypted LVM. This has worked well for several months with no problems. During this time i have been backing up the data to an external usb drive (1tb) on a regular basis. The usb drive was not encrypted. So, I thought it would be a good idea to encrypt the backup drive too. I wiped out the backup drive and set it up as one large encrypted lvm and mbr. This seemed to work fine but immediately afterwards I decided to erase that and set it up as encrypted lvm guid instead of mbr. I couldn't delete it while logged into my desktop so i decided to do it from a bootable gparted usb stick. In gparted i erased the 1TB backup drive once again and planned on setting it up the way I wanted once I was logged back into my ubuntu desktop. Now I cant boot into my desktop with the following errors:
cryptsetup: evms_activate is not available b0d) does not begin with /dev/mapper/
Then after waiting for a few minutes I get an error followed by (initramfs)
When booting from a live version of ubuntu the 250MB boot patition is recognized and 500 partion is there but it is labeled as empty/unused.
Also, I did choose to use the exact same passphrase as what is used on the main bootable drive when I set up the encrypted partition on the external 1TB drive.
View 9 Replies
View Related
Jan 5, 2010
I've just started using ubuntu one. However, some of the files I store on there are sensitive so I encrypt them using seahorse. Right click, encrypt etc etc. My question is, is there a way to automatically get the encrypt process to delete the un-encrypted file when it makes the new encrypted copy?
View 6 Replies
View Related
Aug 15, 2010
I am now using SLES11. My web server now error mysql. However, when I restart mysql using "rcmysql restart" the message display:
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL done
but when I start to access via browser using my name virtual host (url) the message display "Error establishing a database connection"
when I go to mysql using command "mysql" the message display"
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
After that I try to edit file mysql.sock but on the bottom of file display message (permission denied)
View 6 Replies
View Related
Apr 19, 2011
I've installed PostgreSQL on Arch Linux & also self generated self signed certificates in /etc/ssl/ directory. My PostgreSQL 'data' directory is /var/lib/postgres/data & I've edited my postgresql.conf file to use SSL however I'm having permission / access problems starting my database using SSL. It can't access the certificates and errors out when I try and start the database engine:
Code:
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
FATAL: could not load server certificate file "server.crt": No such file or directory
code....
I don't know what I need to chown or chmod in order to get PostgreSQL to access my self signed certificates.
View 3 Replies
View Related
Nov 4, 2010
I am now able to create the database using PHP and SQL. But it seems I can only do it as MySQL root user.. $dbuser = 'root'; but is there a way to do that as a regular MySQL user?
View 2 Replies
View Related
Nov 8, 2010
I have got 2 postgresql databases on separate servers. i want to sync one database to the other. how it can be done ?
View 1 Replies
View Related
May 5, 2010
I burnt an Ubuntu Server 10.4 LTS iso to a CD and have started installing to my system: ASRock ION330, 4GB RAM, 320GB HDD. I'd be using it for web hosting, maybe mail, and programming. And possibly watching video (by HDMI into TV).
When I get up the the LVM part, I'm having trouble deciding what option to take. Some of them:
"Guided - use the entire disk and setup LVM"
"Guided - use entire and setup encrypted LVM"
"Manual"
After using google fu, I think I get the basic idea of LVM, that it abstracts the partitioning so I can change the size of them on the fly. This means I can change it later, but the installer also mentioned that once I choose something, I couldn't turn back or something, which made me panic.
Also, if I choose encrypted, how does that affect my day-to-day usage? Do I have to type in my password every time I access a file or save one? That doesn't seem right. Then what's the point of encrypting? Is encryption worth it? Google isn't telling me this sort of information (and I can't find it in help on the ubuntu website). Keep in mind that I'm really just guessing.
Given my above hardware, and usage, should I just take "Guided - use the entire disk and setup LVM"? Is encrypted a good idea?
View 1 Replies
View Related
Mar 7, 2011
am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies
View Related
Apr 19, 2011
I switched from Windows 7 to Linux and when I'm trying to import my database i get error 1044. It used to work when I was using Windows 7. I was able to export the database from my localhost. However, when I try to import it to the other server I get this:#1044 - Access denied for user ' '@'%' to database'.I have been trying for hours to upload my site from the localhost to another server without any luck..I'm using phpmyadmin to import it.
View 2 Replies
View Related
Dec 26, 2010
i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password
createdb company
Password:
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"
View 1 Replies
View Related
Dec 10, 2010
I have suse linux 10.1 that came with whats looks to be a incomplete sql server. If it works I don't know how to use it because w3schools instruction guide does not work with sql. Anyways I was wondering if there's any database software for linux that could be installed in my webpage directory and used by html files. Or if theres any free cgi database software for linux that i could use with html to create database web pages.
View 3 Replies
View Related
Feb 15, 2010
I'm migrating a mailserver from an old to a new mailserver. The new mailserver is based on ISPConfig 3.0.6.1.
I would like to migrate what spamassassin learnt in the past from the old mailserver to the new one. Now the question:
- The 2 spamassassin versions are different. Is it a problem?
- Can I just migrate the database with this commands???
Code:
sa-learn --backup > sadb.bkp
sa-learn --restore ./sadb.bkp
-how to migrate SpamAssasins Auto White List and all others SpamAssassins databases?
View 3 Replies
View Related
Jul 28, 2009
I tried creating a database in mysql but couldn't do so...here is the message i got from the shell:
Code:
View 4 Replies
View Related
Feb 21, 2011
I am having a problem restoring a database. Server is Ubuntu 8.04.4 LTS. It appears to wig out at a certain point, when this happens the output on the screen shows;Quote:
0,4),('2011-02-21 03:30:32','Queue Wait Outside (100)','Queue Wait Outside (100)',11,0,4),('2011-02-21 03:30:49','Queue Wait Sleep (30)','Queue Wait Sleep (30)',5,0,4),('2011-02-21 03:30:53','Queue Wait Sleep (30)','Queue Wait Sleep (30)',13,0,4)
[code]...
View 2 Replies
View Related
