OpenSUSE Network :: Vsftp Authentication With Mysql ?
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.
I've been instructed to set up an sftp server this weekend. I was going to just use vsftpd b/c it's awsome, but then someone said it's supposed to use ssh. so here's my question:
Is Vsftpd the same thing as Sftp? is it the same openssh protocol for encryption and file transport? I've set up Vsftpd before and it just uses port 21, and it doesn't seem to ask all the same questions as ssh, so is it the same thing? or should/could I tunnel vsftpd through ssh?
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
I try to get authentication working from remote LDAP server (Novell eDirectory)So far I can get correct info from id user or using ldapsearch (so the connectivity is there)But what do I need to configure to get authentication working for SSH login & vsftp login?
when uploading a couple of files via ftp, it fails with
[code]...
But when performing this I got FATAL: Module capability not found. So what I'm using is openSuSE11.2 with 2.6.31.14-0.2-default kernel. Vsftp version is 2.0.7-5.2.1 How can I introduce this capability module into the kernel? Or do I not need it?
I have created a CA on my server then created a server certificate under that then exported it as a common server certificate.I have then gone to my LDAP server and enabled TLS and told it to use the common server certificate.Now on my client I have enabled LDAP TLS/SSL and it's asking me to download a certificate ... from where ? Do I export the certificate to a file and put it on a web server.If so what format as the export offers loads.
I'm trying in the company where I work to persuade my co-partners to move slowly into the world of linux, but because everything are set up on Windows is quite difficult. Though I can install at least in one PC openSuse or Ubuntu (I prefer openSuse), but the problem is that I have to find a way to make the authentication to a Windows Domain, which is running Windows Server 2003.
How is this possible? Is this procedure painless or I have to read a lot of staffs in order to make it work? I would be obliged if you could give me some steps on how to do it. I can't stand windows any more
On this moment i configure a testenvironment with 1 Microsoft active directory server and 1 Opensuse 11 samba filesharing server. But i have a issue. The samba server is add to the domain and the servers can communicate with eachother. I can login to the domain on the samba server and the LDAP settings tab on yast2 samba configuration tool tell me that samba and the MS LDAP server can communicate with eachother. I can see the shares on the samba server but i can't autenticate myself. When i whant to logon than see i always "domain: domainname.local" and "access denied". My question is now how can i give the MS administrator account rights to view the shares and configure the rights for the other users.Samba config file
I'm extremely new to SuSE Linux. I wanted to move away from Windows and so I decided to reload my Desktop with SuSE linux.I have had no trouble until now. I'm trying to connect to my work VPN connection. From my laptop (which unfortunately is Vista) I'm able to connect without any issues. However, when I tried out the KVPN application on my SuSE linux, it just doesn't work. I get the error: Authentification has failed. As a side note, when I type ping google, the packets are received 100% but when I ping my company address, no packets are received. Hope this info is useful.
I set up the 'Proxy' from Yast and they tested successfully. I can connect to internet, but why am I getting 'ERROR 407 proxy authentication required'?
FYI, my comp is the part of company .NET network with bunch of firewall and security...
I am posting this as I have tried several times to work this out. I have read article after article, post after post and tutorial after to tutorial to sort this issue. I have an Ubuntu 10.04 machine running as the LDAP and NFS server with two Opensuse 11.3 desktop machines. Both of the Opensuse machines can login using the LDAP server for authentication and this works fine. The server also exports the NFS Shares no problem but I am unable to mount the shares from the Opensuse machines. I have been using Yast, NFS Client to mount them.
Yast NFS Client can see the shares and lists them however when I apply the settings it states:
'Unable to mount entries in etc/fstab' I need to mount the shares according to the LDAP details as I want the users to be able to access their files no matter which machine they login at. Can anyone shed any light on the issue. Any help would be great and I would be enternally grateful as I am now beginning to pull my hear out slightly.
I have a problem with the NTLM proxy we use in school. YAST proxy configuration won't work, it just says authentication error. We have to login with the user in DOMAINuser style and a password, in Firefox it works.
I would like to know what is OpenSuse application that does the same job of RH's system-config-authentication application. I need to test Active Directory authentication while setting up Samba file server to use AD accounts and ACLs.
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).
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.
MySQL gets installed with root user by default, root user can administer every mysql database installed in the system. Question is how to create a new user that will not be able to administer all the databases in the system the way as root user is? Can it be done using webmin?
Dear all, I have system running LAMP and acting as a regular webserver.After running the setup for quite some months, I start having major issues:Symptoms:1. Applications do not respond neither from LAN nor WAN - SSH daemon, Apache, MySQL, FTP2. Network still seems to work for ping and port listeners3. Telnet is still successful for 21, 22, 80, 33064. Server has to be restarted manuallyTrying to find out the issue, I went through /var/log/ looking for major issues or warnings. But nothing seemed plausible to me to understand the issue - except I knew I was running out of disk space a few times.Not being able to identify nor replicate the issue, I replaced the hardware running 24x7 since quite a few years. Doing this, I migrated at the same time from OpenSUSE 10.1 to 11.3.The machine itself is behind a firewall and only the above mentioned standard ports are accessible
i am trying to set up LAMP on an old pc i have installed linux, apache, mySQL and PHP following this guide Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 11.3 (LAMP) | HowtoForge - Linux Howtos and Tutorials. i have installed phpMyAdmin but when i try and acess it i get this error
Error MySQL said: Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
I have a server machine that is running SUSE Linux Enterprise Server 11. I set up a mysql server there. Now I want to access this mysql server from my laptop. I used the following command,
> mysql -h 12.246.5.70 -u davidehs -p
I found if the firewall on the server machine is running, I can not connect the mysql server from my laptop. If I stop the firewall first, and the do the connection, I can access the mysql. how to keep the firewall running and allow the remote mysql incoming requests?
I have a server machine that is running SUSE Linux Enterprise Server 11. I set up a mysql server there. Now I want to access this mysql server from my laptop. I used the following command,
> mysql -h 12.246.5.70 -u davidehs -p
I found if the firewall on the server machine is running, I can not connect the mysql server from my laptop. If I stop the firewall first, and the do the connection, I can access the mysql. Do you guys have any idea how to keep the firewall running and allow the remote mysql incoming requests?
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.
I am looking for a way to set a default for new users for the akonadi mysql.conf file that is created for each user for the akonadi database. Usually this file contains a inno_db_log_file_size of 64MB. Because of this the database eats up 64MB storage even if its still empty. I would like to decrease this size globally for each "new" user since we have very tight storage restrictions on our NFS home directories now. And 64MB make up already have the quota each user has. So this is to much. where is this default mysql.conf file taken from?
I found hints that there used to be a /usr/share/config/akonadi/mysql-global.conf file that was simply copied but I cannot find such a file on my 11.4 system. It seems things have changed. how akonadis user specific mysql.conf file in ~/.local/share/akonadi/ is generated for a new user? How can I use my own template file here?
I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I thought that the problem is in the phpMyAdmin not in the mysql. But now i think different. It seems that the problem is right in the mysql. I think that there was no root user, when mysql was freshly installed. Unfortunately i did everything i can find on internet (some tutorials) but they don`t helped me at all, maybe i fu**ed up the mysql service. So i reinstalled it, and when i want to start it there is no file mysql.sock and i get the following:
linux-nepg:~ # service mysql restart Restarting service MySQL Shutting down service MySQL done Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds