http://wordpress.org/support/ WordPress › Support Tag: external-database-authentication en Tue, 24 Nov 2009 08:50:11 +0000 http://wordpress.org/support/topic/303017#post-1183000 Fri, 21 Aug 2009 11:45:49 +0000 thofuerl 1183000@http://wordpress.org/support/ <p>hi. i am hosting wordpress in a j2ee webapplication for newscontent. </p> <p>users a stored in my database and wordpress uses external db authentication for login.</p> <p>i works as i expected - except with some user containing german umlaut signs. (Ä,Ü,Ö,...). I do not allow them in the useridentificaton, but - the name and lastname fields contain them. </p> <p>Both databases are Mysql UTF-8 Databases.</p> <p>Does anybody know a solution for my problem?</p> <p>thank you. thomas</p> <p><a href="http://wordpress.org/extend/plugins/external-database-authentication/" rel="nofollow">http://wordpress.org/extend/plugins/external-database-authentication/</a> </p> http://wordpress.org/support/topic/277235#post-1153648 Tue, 28 Jul 2009 08:02:19 +0000 Hoodie 1153648@http://wordpress.org/support/ <p>Is this all that I would have to do to integrate my two databases? I can figure out how to change the links for registering and for logging in. I just want my users to only have to have on login. Thanks for any help. </p> http://wordpress.org/support/topic/285596#post-1122432 Wed, 01 Jul 2009 12:01:30 +0000 Jim R 1122432@http://wordpress.org/support/ <p>I have submitted the external database information, and it showed success. I'm trying to use the members from my SMF forum. It provides the backbone to my site, and I'm switching over to WP for my site. I still want to keep it as the forum and maintain all my member registrations (over 3,000), as I use SMF's membergroups and Paypal to control subscriptions and user access. </p> <p>I can easily utilize the code to control access, as well as cross over SMF registration onto a WP page, but I'd like to have integrated use of member information. In other words, have WP recoganize SMF users.</p> <p>Now what? </p> http://wordpress.org/support/topic/277235#post-1094231 Sun, 07 Jun 2009 10:15:38 +0000 kc2002 1094231@http://wordpress.org/support/ <p>$username = NULL;</p> <p>You need to add the above line at line 426 before the semicolon. </p> <p> else { //username exists but wrong password...<br /> global $ext_error;<br /> $ext_error = "wrongpw";<br /> $username = NULL;<br /> }</p> <p>Otherwise you can login with an old password in WPMU <em>after</em> it has been changed externally. </p> <p>Also I had to edit the ext_db_auth.php file and add default values because they blank out when new blogs are created. Here is my code (with default values added) that works with SMF (Simple Machines) 2.0 RC1-1 if anyone is interested.</p> <p> add_option('ext_db_type',"MySQL","External database type");<br /> add_option('ext_db_mdb2_path',"","Path to MDB2 (if non-standard)");<br /> add_option('ext_host',"localhost","External database hostname");<br /> add_option('ext_db_port',"","Database port (if non-standard)");<br /> add_option('ext_db',"wpsmf","External database name");<br /> add_option('ext_db_user',"root","External database username");<br /> add_option('ext_db_pw',"","External database password");<br /> add_option('ext_db_table',"smf_members","External database table for authentication");<br /> add_option('ext_db_namefield',"member_name","External database field for username");<br /> add_option('ext_db_pwfield',"passwd","External database field for password");<br /> add_option('ext_db_first_name',"");<br /> add_option('ext_db_last_name',"");<br /> add_option('ext_db_user_url',"website_url");<br /> add_option('ext_db_user_email',"email_address");<br /> add_option('ext_db_description',"");<br /> add_option('ext_db_aim',"aim");<br /> add_option('ext_db_yim',"yim");<br /> add_option('ext_db_jabber',"");<br /> add_option('ext_db_enc',"Other","Type of encoding for external db (default SHA1? or MD5?)");<br /> add_option('ext_db_error_msg','Register a new account <a href="http://charismatoday.com/wpforum/index.php?action=register">here.</a>',"Custom login message");<br /> add_option('ext_db_other_enc','$password2 = sha1(strtolower($username) . $password);');<br /> add_option('ext_db_role_bool','');<br /> add_option('ext_db_role','');<br /> add_option('ext_db_role_value','');</p> <p>I also see where you disabled the change password in WP; however, there is no error message or warnings. It states that the changes were saved. It's not a biggee. </p> <p>Your script has saved me a lot of time in developing a new site! Thank you.</p> <p>Keith Tysinger </p> http://wordpress.org/support/topic/255674#post-1024980 Tue, 24 Mar 2009 13:44:06 +0000 takuya 1024980@http://wordpress.org/support/ <p>I think it should be in the form of:</p> <p>$password2 = $password;<br /> $password2 = md5($password);</p> <p>but above two would never work.</p> <p>There're three different auth keys set at my config.php, but not sure which one is used for passwords encryption.</p> <p>any expert outhere? </p> http://wordpress.org/support/topic/255674#post-1024626 Tue, 24 Mar 2009 01:21:18 +0000 takuya 1024626@http://wordpress.org/support/ <p>I want to connect to another wordpress installation, but I'm stuck at configurations.</p> <p>So far the database information is correct as it can find the admin user from the external database. But even if I input admin password, it returns "invalid password."</p> <p>I assume the problem is at encryption method.</p> <p>I've tried MD5, SHA1 and none of them are working.</p> <p>I don't know what to write in Other encryption field if trying to connect to other wordpress installation.</p> <p>If you have any experience connecting two wordpress database using this plugin, please advise.</p> <p><a href="http://wordpress.org/extend/plugins/external-database-authentication/" rel="nofollow">http://wordpress.org/extend/plugins/external-database-authentication/</a> </p> http://wordpress.org/support/topic/250079#post-1006762 Thu, 05 Mar 2009 21:05:27 +0000 nonaesthetic 1006762@http://wordpress.org/support/ <p>Ah, my connection fields had spaces in their names. Surrounding the names with backticks fixed the problem. </p> http://wordpress.org/support/topic/250079#post-1006579 Thu, 05 Mar 2009 18:11:33 +0000 nonaesthetic 1006579@http://wordpress.org/support/ <p>After activating the External DB Authentication plugin and logging out of Wordpress, I receive the following error:</p> <p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Address = ''' at line 1</p> <p>Running WP 2.7, with plugin v.3.1<br /> MySQL client version: 4.1.22</p> <p>Any help would be appreciated. </p> http://wordpress.org/support/topic/209314#post-975541 Wed, 04 Feb 2009 13:01:31 +0000 Lari 975541@http://wordpress.org/support/ <p>Worked at least with the test user, thanks! </p> http://wordpress.org/support/topic/240107#post-974520 Tue, 03 Feb 2009 14:54:18 +0000 charlener 974520@http://wordpress.org/support/ <p>Title says most of it. Also some better error messages upon failed logins and fixed a hole so that only external db users can authenticate - existing accounts on WP are not used at all except for WP-related roles and personal details which get synced with the external database.</p> <p><a href="http://wordpress.org/extend/plugins/external-database-authentication/" rel="nofollow">http://wordpress.org/extend/plugins/external-database-authentication/</a> </p> http://wordpress.org/support/topic/209314#post-974486 Tue, 03 Feb 2009 14:02:43 +0000 charlener 974486@http://wordpress.org/support/ <p>Alrighty,</p> <p>Added into version 3.1. Give it a shot and let me know what you think.</p> <p>I just noticed WP-MU got the 2.7 release - I'll try the new plugin code with it too and see if it works for everyone... </p> http://wordpress.org/support/topic/209314#post-973456 Mon, 02 Feb 2009 12:25:52 +0000 Lari 973456@http://wordpress.org/support/ <p>In Activecollab there’s one table with the roles that have an id and another table with users. In the users table there’s a field <em>role_id</em>, which tells what role the user has. So the role ids come from the roles table. 1 to 7, currently.</p> <p>If I could tell your plugin the name of the field and a value that is required to add the user to Wordpress, that would be great. </p> http://wordpress.org/support/topic/209314#post-970788 Fri, 30 Jan 2009 05:57:02 +0000 charlener 970788@http://wordpress.org/support/ <p>Hmm. Are these role ids typically in some sort of numeric range, or only numeric? This doesn't sound hard to add, though you'd still have to go that extra step of setting up in WP what local WP role will assign for new accounts.</p> <p>Think it's doable with more info on what typical data type is used for role ids. </p> http://wordpress.org/support/topic/209314#post-964071 Fri, 23 Jan 2009 10:58:15 +0000 Lari 964071@http://wordpress.org/support/ <p>For me, it would suffice to set permissions based on the permissions of the external table. In my external users table there is a field that contains a role id. If I could restrict access to Wordpress to ids above some value or to a specific value, that would be sweet.</p> <p>Right now I can’t use the plugin because I don’t want to give access to all the users in the external database.</p> <p>I think this would be simpler than using a third table. </p> http://wordpress.org/support/topic/209314#post-872390 Thu, 09 Oct 2008 03:12:07 +0000 charlener 872390@http://wordpress.org/support/ <p>Got an email from someone asking about this - namely, using a third database/table/field that contains information about permissions for the accounts in question. </p> <p>In theory, this is a non-trivial addition, except for the complete lack of standardization of how to actually determine the permission levels. Right all user accounts are created with the same level of permissions as set in WP config section.</p> <p>Is this a feature that others would use? Is it necessary? Based on feedback, I'll work on adding it or not, as I personally don't use this. </p> http://wordpress.org/support/topic/206104#post-861228 Wed, 24 Sep 2008 16:25:36 +0000 charlener 861228@http://wordpress.org/support/ <p>Hi,</p> <p>Thanks for the feedback - I made some changes based on your comments above (almost identically) and 3.04 should take care of things. Please update and let me know if you hit any more roadbumps. I'm glad someone finally tried it out with MSSQL! </p> http://wordpress.org/support/topic/206104#post-860809 Wed, 24 Sep 2008 02:02:55 +0000 jklotz 860809@http://wordpress.org/support/ <p>I to connected to a MsSQL server and I believe I found two errors:</p> <p>1&gt; The term "limit" is not valid SQL in Microsoft. Deleting "Limit 1" from all of the quires seemed to resolve the issue.</p> <p>2&gt; When connecting to MsSQL URL the port is separated from the host using a colon ":" it was coded to use a comma "," on line 257.</p> <p>After making those changes it works great with MsSQL</p> <p><a href="http://wordpress.org/extend/plugins/external-database-authentication/" rel="nofollow">http://wordpress.org/extend/plugins/external-database-authentication/</a> </p> http://wordpress.org/support/topic/205232#post-857724 Sat, 20 Sep 2008 05:06:32 +0000 charlener 857724@http://wordpress.org/support/ <p>As far as I know, you no longer get an include file error re: MDB2 package whether you have it installed or not, I don't get login loop errors in 2.6.2 (or any other problems for that matter), and login special instructions now work again and password resets within wordpress' login page are disabled. For neatness' sake, let's post support-related things in wordpress rather than my personal blog so that everyone can more widely benefit. </p> http://wordpress.org/support/topic/196415#post-833080 Wed, 20 Aug 2008 05:18:28 +0000 charlener 833080@http://wordpress.org/support/ <p>Blah. All uploaded and ready to be used. </p> http://wordpress.org/support/topic/196415#post-828089 Wed, 13 Aug 2008 12:24:59 +0000 charlener 828089@http://wordpress.org/support/ <p>Due to updates in WP (I think) the hook I would now use doesn't quite work right when you have unsynchronized passwords. The workaround for this right now means that the custom error message doesn't appear if the login already exists in the WordPress user database. Otherwise everything works.</p> <p>This will be uploaded tonight most likely.</p> <p><a href="http://wordpress.org/extend/plugins/external-database-authentication/" rel="nofollow">http://wordpress.org/extend/plugins/external-database-authentication/</a> </p>