SQL statements

[Migrated From Jforum.net]

Hello all,

I have a question about the values from the database. Where can I put my sql statements to retrieve values from my database. And how can I call the variables.

I wan't to create a single sign on to edit the checkCookies() method. But I wan't to use my usernamen and password. But before I can use it I must retrieve the value from the database.

Please help,

Henk
[originally posted on jforum.net by henkie]

[Migrated From Jforum.net]

I have been thinking about the easiest way to make a single sing on. So here is what I think.

When I create a new user in my web apps in my own database, I also put the information in the jforum_users table and the jforum_user_groups table.

So the values of usernamen and password equals in both databases. When I wan't to approach the forum I get the username and password from my system and post them in a form to the forum. Like this:

  <form action="forums/list.page" method="GET" target="main">
            <input type="hidden" name="module" value="user" />
  <input type="hidden" name="securityHash" value="aef7e9f6ec1e73ee282a0374c5aaaa43" />
  <input type="hidden" name="action" value="validateLogin" />

<input type="hidden" maxlength="40" size="25" name="username" value="Henk"/>
<input type="hidden" maxlength="25" size="25" name="password" value="Henk"/>
<input type=submit name=login vlaue=login>
</form>

So now I login to the forum with the username and password.

Let me know what you think about the idea.

Thanks,

Henk
[originally posted on jforum.net by henkie]

[Migrated From Jforum.net]

HHmm.. If you make your own implemenation of LoginAuthenticator (default implementation is DefaultLoginAuthenticator.java), then you don't need to do this replication of users by hand. JForum will automatically check if the incoming user exist in its database and, if it does not, insert it.

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

What do you mean by making your own implementation. what for a query should I create then. One that gives al the users in my database or something.

Because there is an preparedstatement with an username and password. But what does that preparedstatement.

What for implementation should I do.

Please help,

Henk
[originally posted on jforum.net by henkie]

[Migrated From Jforum.net]

Rafael Steil wrote:HHmm.. If you make your own implemenation of LoginAuthenticator (default implementation is DefaultLoginAuthenticator.java), then you don't need to do this replication of users by hand. JForum will automatically check if the incoming user exist in its database and, if it does not, insert it.

Rafael

In my case I'll have 3 sets of users (students, teachers & staff) so I'm planning to replicate them in the JForum DB, just to make sure that the groups are in sync and give them the appropriate permissions depending on the group they belong to.

Is there any way to prevent new users to be created in JForum at all, except by directly inserting them in the DB? I just want those controlled users to be able to access the forums. I'd like also to prevent them to change the user settings in their profile (email & password) as that will be determined at the original system.

Are there any properties or settings in JForum to configure it like that?

Cheers"
D.
[originally posted on jforum.net by GreenEyed]

[Migrated From Jforum.net]

Yep. Go to Admin Panel -> Configurations, and set "Enable registration of new users" to "false"

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

To return to my first question. Where can I find the sql statements. And where can i put mine?

Please help.

Thnx,

Henk
[originally posted on jforum.net by henkie]

[Migrated From Jforum.net]

They are in WEB-INF/config/database/generic and WEB-INF/config/database/<your_db>

Rafael
[originally posted on jforum.net by Rafael Steil]