General :: Mysql Authentication Does Not Work
Apr 6, 2011
My system is
Code:
We use courier mail server for pop3 mailboxes, and postfix for in/out mail delivery
Code:
Now Pop3 users, could not authenticate with there username/pass
It does not work now, and I have this message in my log file
Code:
I could see in my postfix.main
Code:
And I could successful run query from mysql
Code:
I tried to change the password for this user, insert new user to the same tables, but no success to authenticate
I suppose that the problem is authentication of courier mail demon (which in my mind ) should work with mysql 'mail' database in the way is postfix work
Code:
I could not find any reference with courir demon to mysql database username,password to authenticate users..
So, my quetions is, if it's possible to tracert mysql db to find out if courier demon 'asking' for authentication, or is there any error with this, and which configuration file should be checked, in order to find out what authentication method is courier mail demon use for.
View 1 Replies
ADVERTISEMENT
May 10, 2011
Pam-mysql can not connect to the database and below are my configurations.
saslfinger -s Output:
root@mailbackup:/# saslfinger -s
saslfinger - postfix Cyrus sasl configuration Tue May 10 10:12:10 EAT 2011
version: 1.0.2
mode: server-side SMTP AUTH
-- basics --
Postfix: 2.7.2
System: Slackware 13.1.0
-- smtpd is linked to --libsasl2.so.2 => /usr/local/lib/libsasl2.so.2 (0x00007f74ebfb7000)
-- active SMTP AUTH and TLS parameters for smtpd --
-- listing of /usr/lib64/sasl2 --
-- listing of /usr/local/lib/sasl2 --
-- content of /usr/lib64/sasl2/smtpd.conf --
-- content of /usr/local/lib/sasl2/smtpd.conf --
-- active services in /etc/postfix/master.cf --
-- mechanisms on localhost --
View 3 Replies
View Related
Nov 17, 2010
I am running Ubuntu 10.04 LTS. I am trying to run a query browser for mysql but keep receiving the following error:
X11 connection rejected because of wrong authentication.
The application 'mysql-query-browser-bin' lost its connection to the display localhost:10.0; most likely the X server was shut down or you killed/destroyed the application.
In ssh_config, I do have ForwardX11 set to yes.
View 4 Replies
View Related
Feb 14, 2011
I was testing my authorized_hosts setup, so deleted my local private key. I then successfully ssh'd into my remote server using RSA authentication. I was expecting to get a permission denied, seeing as there is no longer a private key to guarantee I'm me. Guessing I'm misunderstanding something fundamental. Anyone know what's going on? It doesn't look like ssh-add is holding my private key:jake@clyde:~$ sudo pkill -9 ssh-agent
View 2 Replies
View Related
Apr 8, 2015
I'm currently trying to set up FreeRADIUS with DaloRADIUS and I'm stuck at FreeRADIUS getting clients (as NAS-es) from the MySQL database.
FreeRADIUS will no longer start after uncommenting the following line in my /etc/freeradius/sql.conf (which is supposed to let it use the MySQL database):
Code: Select allreadclients = yes
I have ran "freeradius -X" to find out what's going on with this output:
Code: Select allrlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to radius@localhost:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
[Code] ....
So it seems that the radius user is not authenticated. However I have verified that the login details I entered in my sql.conf are the correct ones (I even tried manually logging in with them and it worked).
View 1 Replies
View Related
Jan 18, 2011
I'm using openSUSE 11.1 and would like to authenticate vsftp users against a mysql database. The newest version of pam-mysql I can find is from 2005. I'm concerned about using something from what appears to be a dead project. Is there an alternative? I'm trying to come up with a solution where I can manage FTP users from an application running from Windows desktops.
View 1 Replies
View Related
Jun 2, 2010
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
View 9 Replies
View Related
Aug 23, 2010
I have set up an apache 2 server, but can't seem to get authentication to work properly. I have set up this in my apache2.conf:
Code:
<Directory /var/www>
AllowOverride AuthConfig
</Directory>
<Directory /var/www>
AuthType Basic
[Code]...
I have created the passwords file with htpasswd and defiantly have the right password for bob. However, when I try to log in the box just comes up over and over again and never authenticates. What am I doing wrong? I'm a newbie, so please bear with me if I've missed something really stupid.
View 4 Replies
View Related
Aug 7, 2010
How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies
View Related
Feb 19, 2010
Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 Replies
View Related
May 13, 2011
I have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.
now a these days i am connect through ssh and excuting below command
#mytop mysql -u root -p <passwd>
In my mysql db i have added the userip & passwd (allowed the privileages for that ip)
If i use mysql-administrator i am getting below error
MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)
View 6 Replies
View Related
Jun 14, 2011
I have tried many different ways to interact with the mysql to reset the root mysql pass. This is what I got to right now
Code:
#!/bin/sh
newpass=$1
service mysqld stop
mysqld_safe --skip-grant-tables --skip-networking &
echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD("$newpass") where User="root";" >> /tmp/mysql_pass_reset.txt
[Code]...
View 6 Replies
View Related
Apr 6, 2011
After instalation of Suse 11.4, wifi worked totally correctly, until the first restart. Then it ceased to work. It looks like everything is working correctly until WPA authentication.
My wifi device
Code:
So until now it looks for me that everything works correctly, but after trying to connect the problems begin.
dmesg output:
Code:
So the wlan interface authenticates, and then disauthenticates by local choice? a bit about the reason points to wpa_supplicant. Many peoples report that they have multiple copies running, and killing them solves a problem. Sadly I've only one copy, and after being killed it restarts.
Here is wpa_supplicant.log on the first run after install(when it worked)
Code:
And here is log of what happens after restart:
Code:
I've no way to change from WPA authorization.
View 1 Replies
View Related
Apr 15, 2011
When I am upgrading, installing something or doing something that requires me to be Authenticated by using my password I just type it in and hit enter. However, each time I just click return after typing in the password it does not work. The window accepts my password but thats it and the window just sits there until it times out a few mins later. For this to work properly I have to type the password and then use the mouse to click the Authentication button. Why is this? Is there a way to solve this so I can just type in my password and click return like I do with everything else?
View 2 Replies
View Related
Aug 10, 2010
whenever my facebook client automatically logs off in pidgin i have to not only provide my password but a word authentication (where it shows you a picture with letters in it arranged in a strange way and theres 2 of them seperated by a space, but whenever i enter in the letters (i know that all of the letters entered into that text box are right) but for some reason it doesn't let me back in it just prompts me again to enter the words i see and still doesn't let me in
i had to uninstall it and re-install it to get it to come back up again
View 1 Replies
View Related
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Sep 5, 2010
I tried to run FreeRadius1.17 in RHEL5 using PEAP authentication.#radiusd -X Run fine.authenticating only one user.if "user" is authenticated and second user "user2" just looping and will not authenticated. Again if "user2" authenticated "user" is looping?here the logWaking up in 4.5 seconds.rad_recv: Access-Request packet from host 192.168.0.3 port 1028, id=239, length=219
User-Name = "user"
NAS-IP-Address = 0.0.0.0
Framed-MTU = 1488
[code]...
View 1 Replies
View Related
Mar 3, 2010
I have installed the MySQL server on two machines and got them to work as master - master over the internet. But since this is not very safe I wanted to get them to work over SSL. I first setup one machine and that worked. However, after setting the second machine to work over SSL it all stopped. I have checked many howto and faq documents without success.
It seems to be related to the certificate I think. This is a dump from the /var/log/syslog file for MySQL:
Mar 3 17:33:02 asterix mysqld: SSL error: Unable to get certificate from '/etc/mysql/mysqlcerts/remoteMaster/client-cert.pem'
Mar 3 17:33:02 asterix kernel: [ 7209.109831] type=1503 audit(1267633982.018:274): operation="open" pid=1324 parent=1071 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=102 ouid=102 name="/etc/mysql/mysqlcerts/remoteMaster/ca-cert.pem"
Mar 3 17:33:02 asterix kernel: [ 7209.109877] type=1503 audit(1267633982.018:275): operation="open" pid=1324 parent=1071 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=102 ouid=102 name="/etc/mysql/mysqlcerts/remoteMaster/client-cert.pem"
This is repeated many times...
I have copied the certificate files in a folder that is owned by mysql:mysql so I assumed that this would be ok.
View 4 Replies
View Related
May 22, 2009
This is a fresh install of CentOS 5.3 x86_64 with the following packages installed (using yum) as I have always done and has always worked in the past: httpd mysqld php php-mysql php-gd
However any pages requiring mysql fail and the following shows up in the httpd/error_log:
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/dbase.so' - /usr/lib/php/modules/dbase.so: cannot open shared object file: No such file or directory in Unknown on line 0
[Code].....
View 3 Replies
View Related
Apr 19, 2011
My OS is ubuntu and i'm having problems with MySQL:
[code]...
tried apt-get --purge remove mysql-server and then apt-get install mysql-server but still dont work
View 8 Replies
View Related
Feb 16, 2011
I am in the process of evaluating the move to a EC2 dynamic web server for East Coast West Coast to reduce the lag for interacting with mySQL.Right now we have had great success with mySQL running on our server.ight direction on where I can find documentation onhow to configure Navicat with CentOS 5 running on a EC2 I am suspecting that their is something special on the way it handles the SSH?I am not finding any documentation at all on this, I can not understand this at all. I am sure that someone here is using Navicat along side with an EC2 Amazon server. Well, at least I am hoping so.
I have to spent 5 days in trying to configure a EC2 with numerous Ubuntu setups WITH NO SUCCESS AT ALL. What blew me away was this articleYou should have this posted on your server for 1st time users with one small modification with the ending of the article on how to make it run on Localhost running ofa EC2 Amazon. It was truly a eye opener. For all the talk about Ubuntu and the numerous articles on installing a LAMP server was totally without success. But this article was truly a pleasant experience.
View 1 Replies
View Related
Jan 10, 2010
I want to configure SSH key-based authentication and SSH password Authentication in same machine for different user .
View 1 Replies
View Related
Mar 14, 2011
On Ubuntu server 10.10, with a relay smtp server with authentication via postfix; I keep getting 535: Incorrect authentication data. I'm sure my username and password is correct. Heres how I set up postfix: I created a file called smarthosts.conf in my /etc/postfix/ directory that contains the following:
[Code].....
my server uses plain text authentication on port 25. I would like to use security like SSL, but this particular server is unsecured.
View 9 Replies
View Related
Jan 21, 2011
I have some trouble when I build a DNS server. I need use mysql stored procedure work with the bind dlz mysql driver, but failed.
dlz "Mysql zone" {
database "mysql
{host=127.0.0.1 dbname=dnsdata ssl=false}
{select domain from domains where domain='$zone$' LIMIT 1}
[code]....
View 1 Replies
View Related
May 30, 2011
I am trying to make a PHP form where the user inputs a text string, and then it is stored in MYSQL db
1.php
Code:
<form action="2.php" method="post">
Your name: <input type="text" name="txt_name" />
<input type="submit" />
</form>
[Code]....
View 1 Replies
View Related
Jul 17, 2010
I just installed Centos 5.5 on one of my systems today and something is eluding me. Basically I had a web site and forum software (phpBB, but I don't think it's that, other forum software like Xoops does the same thing) running on Fedora 13, and I copied it over to the new Centos installation. Apache is running fine and displays a PHP test file and .html files just fine.
MySQL seems to be fine, I can log into that, show databases etc. Just can't get any forum software to know there is MySQL there. I did change the path of the site, and the databases, and edited /etc/my.cnf and /etc/httpd/conf/httpd.conf to reflect that. Thought I made the needed changes in /etc/php.ini but who knows. Seemed like everything should have tar'd up and moved easy, but not the case...
View 5 Replies
View Related
Apr 1, 2016
If I am running a script, let's say a install script. Is there a way to make Su repeat authentication rather then just returning "Authentication failed" and continuing the script?
View 3 Replies
View Related
Jan 17, 2011
I need to make a choice on what authentication protocol I want to use for Authentication and Authorization. I was looking at Radius and then literature suggested that Diameter was a better protocol. Keep in mind I need this on a hetrogeneous setup ( linux & windows together). Diameter seemed like a good fit until I discovered that the open source code no longer seems to be maintained ( C/C++).
I was also looking at Kerberos as an option though there is alot overhead with the server. SSL/TLS or EAP? I am looking for simple but secure and am new at the security protocols.
View 2 Replies
View Related
Feb 20, 2011
I'm having a hard time to access MySQL from the local or remote shell.
If I try to access MySQL, using mysql -u root -pxxxx I get the error 1045 Access denied...
MySQL is running and I can access it, using phpmyadmin.
There must be something blocking shell access. Can anybody confirm and tell me how to check/configure for shell access?
I'm using ca preconfigured CenOS from PBX in a flash and it seems they did some security settings - but I can't find any further information.
I know I should probably post there, but the Mods didn't activate my account yet. And you know how it is if you try to figure something out. You won't stop.
View 1 Replies
View Related
Mar 12, 2010
I have a problem with ldap client authentication in ubuntu. I am using rhel5 as openldap server and I configured ubuntu as client, when I am trying to login the following message is coming."su: Authentication service cannot retrieve authentication info. Sorry"
But when I do search through "ldapsearch" command output is coming without any errors, Can anybody explain what would be problem.
View 1 Replies
View Related