Latest News: (loading..)
Sign in to follow this  
Followers 0
anderskiel

pbpBB2 and osC shared account creation

214 posts in this topic

It needs serious re-write to support separated db.

 

what files do i need to alter in forum files to direct it to oscommerce db so it uses the same db not seperate dbs?

Share this post


Link to post
Share on other sites

Frank, you need to copy all phpbb tables to your osCommerce database, with the default 'phpbb_' prefix. Then modify your phpbb2/config.php and change the db settings.

Share this post


Link to post
Share on other sites
Frank, you need to copy all phpbb tables to your osCommerce database, with the default 'phpbb_' prefix. Then modify your phpbb2/config.php and change the db settings.

 

 

<?php

 

$dbms = 'mysql' ;

 

$dbhost = 'localhost' ;

$dbname = 'craftyli_phpb1' ;

$dbuser = 'craftyli_phpb1' ;

$dbpasswd = '**********' ;

 

$table_prefix = 'phpbb_' ;

 

define ( 'PHPBB_INSTALLED' , TRUE ) ;

 

?>

 

 

is this the bit your talking about? so if my store db is called craftyli_osc1. does this need to go into $dbname & $dbuser? what about the $dbpasswd does this change to the same password for craftyli_osc1? does anything else needs changing?

Share this post


Link to post
Share on other sites

Frank, make sure you read my last post and the link to the phpbb2 knowledge base, and 'copy' your phpbb tables to your osCommerce database.

 

You can find your osCommerce database info in the file craftstore/includes/configure.php.

Share this post


Link to post
Share on other sites

Alex…..

First may I say, after 2 years of working with OsC and investigating more contributions than I care to remember….NEVER, have I seen a better presented installation guide.

 

You seem to have put almost as much effort into this aspect as you have the contribution itself.

Congratulations on a job well done.

 

With so much info made available I’m embarrassed to admit I still have a question or two.

 

Our site is membership based.

I have used Contribution Member_Approval_v1.5_1 (http://www.oscommerce.com/community/contributions,1339/category,all/search,Member_Approval_v1.5_1) to enable us to approve of all applications before they can purchase or view selected “Members Only” pages.

 

We also have phpBB 2.0.18 installed and have configured it so that only registered members can view any forum. I’ve done this via the groups function.

 

All new member applicants must apply via the OsC create_account.php page first.

Once approved, we then ask them to apply to join our forum.

Approval is automatic of course but in our control.

 

Quite obviously, this is not a very satisfactory method.

Your contribution almost has our name on it as just what the doctor ordered.

 

But….. At the bottom of your instructions you write…..

The account activation and Visual Confirmation features in phpbb forum have no chance to work since all new accounts are created in osCommerce.”

Visual confirmation is of little interest but account activation is vital.

I fail to see how your other contribution, “mail validation” will assist us.

 

I’m trying to visualise the result of your contribution.

 

Do you see any conflict with our member approval process?

If no, would approval in OsC automatically approve them for phpBB?

 

It’s imperative that members of the public cannot follow a link to the forum so only registered members can view the forums.

Would this function still work?

 

Lastly, how important is the relative path between OsC and phpBB?

Our main site is mydomain.net.au

Our forum is mydomain.net.au/forum/

 

I have created a subdomain of test.mydomain.net.au

The test forum is therefore test.mydomain.net.au/forum

This sub domain uses two separate databases from the main site.

 

I install all new contributions here first and once they work, copy entire files across to the main site.

Can you see any possible hiccups using this procedure with your contribution?

 

Lastly…since both phpBB and Osc now share one database, how do I transfer existing info from our current phpBB database into the new one or will we have to start from scratch and lose all 3300 existing articles?

I think our members would be decidedly unimpressed if this were the case.

There’s a lot of info in those forums.

 

Can we discuss these issues please?

Help me to understand?

I’m really looking forward to getting started in installing your contrib..

I’d just like to dot the I’s first and make sure it’s what we need.

Share this post


Link to post
Share on other sites
Do you see any conflict with our member approval process?
I'm not familiar with the Membership Approval contribution you're using, I have no idea.
If no, would approval in OsC automatically approve them for phpBB?
In this contribution, all customer accounts are created in osCommerce. If the account is not activated, the customer won't be able to login to either side.

 

It’s imperative that members of the public cannot follow a link to the forum so only registered members can view the forums.

Would this function still work?

I don't know how you managed this fuction to work in your store, I can't tell.

 

Lastly, how important is the relative path between OsC and phpBB?

Our main site is mydomain.net.au

Our forum is mydomain.net.au/forum/

This setup will work with sessions/cookies setting adjusted, but the fast login box in phpBB might not work.

 

Lastly…since both phpBB and Osc now share one database, how do I transfer existing info from our current phpBB database into the new one or will we have to start from scratch and lose all 3300 existing articles?
Please search in the last couple of pages this thread regarding moving database.

Share this post


Link to post
Share on other sites
I'm not familiar with the Membership Approval contribution you're using, I have no idea.

Fair enough.

I'll suck it and see.

 

This setup will work with sessions/cookies setting adjusted, but the fast login box in phpBB might not work.

This suggests to me that what I have in mind is not the ideal.

What would a better way to set it up be, if any?

 

Please search in the last couple of pages this thread regarding moving database.

Thankyou

I read all 10 pages of this thread prior to posting but I must admit by page 7 I was skimming.

I missed it.

Got it now.

 

Thank you for your time.

Share this post


Link to post
Share on other sites

Hi there, Congrats for one of the best contributions to the community EVER! I have gone through the install very carefully and have no errors on my site whatsoever, but cannot get the store login to work??? I have to say i am confused on the database admin issues where the phpBB admin and store customer have to both be #2, but with that aside I have no idea why my store login is not working???? Now i have ported this to CRELoaded and I am almost done with the install except for the login is not working. Any ideas on what i might have done wrong, or what i could do to get my login working. Just please let me know and I'll provide whatever info is needed :)

 

Thanks again for such a great contrib guys :)

 

Oh the site is http://prositedemos.com and the forum link is in the information box per the instructions :) CYA!

Edited by ggbig

Share this post


Link to post
Share on other sites

Just thought i would mention that even if i create a new user which is successful by checking the database, i stilkl cannot login to the store with a freshly created and validated account??? Maybe that will help?

Share this post


Link to post
Share on other sites

Thanks a million Alex!

 

I didn't notice at first that in the code for CRELoaded that is as follows:

 

echo tep_draw_form('login', tep_href_link(FILENAME_LOGIN, $login_action, 'SSL')); ?>

<table border="0" width="100%" cellspacing="0" cellpadding="<?php echo CELLPADDING_SUB; ?>">

 

 

being the mirror code in the install instructions:

 

<!-- body_text //-->

<td width="100%" valign="top"><?php echo tep_draw_form('login', tep_href_link(FILENAME_LOGIN, 'action=process', 'SSL')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">

 

that the CRE code is inside php tags, and the osC code is in html. Thus the reason for not logging in was a simple syntax oversight of having the $login_action inside single quotes as such:

 

FILENAME_LOGIN, '$login_action', 'SSL'

 

and resulting in the php parsing it as text and not a variable.

 

I now have a fully functional forum in sync with CRELoaded and will now begin my descent into template hell, or possibly an include statement that will put the forum within the store templating system somehow :)

 

Once again thanks a million :)

Share this post


Link to post
Share on other sites

Just an update to this Great Script...... I have it seemingly fully functional here:

 

http://prositedemos.com/trans_phpbb.php

 

or go to the home page and create an account and login :)

 

i would also like to know if anyone has issues with going to the forum first and then trying to login, seems you have to go to the store first and login, or the forum wont log you in when going to the store unless you logoff a couple times??? maybe session issues. Is there a setting in my store or forum admin i need to change to get this minor annoyance out of the way :) I hope someone can help with this?

 

Thanks for the help everyone on a great script :)

Edited by ggbig

Share this post


Link to post
Share on other sites
Gerald, there is something wrong with your sessions/cookies setting. You can see the problem simply by logging in to your store, and then in the upcoming page (i.e. index.php) remove the trailing '?osCsid=xxxxxx...' in the URL line and load that page again, you're not logged in anymore.

Share this post


Link to post
Share on other sites
Gerald, there is something wrong with your sessions/cookies setting. You can see the problem simply by logging in to your store, and then in the upcoming page (i.e. index.php) remove the trailing '?osCsid=xxxxxx...' in the URL line and load that page again, you're not logged in anymore.

 

 

I would agree with you that this contrib is really good. However, I seem to be having the same problem with cookies. In oscommerce, I modified one of the session parameters to "force cookie use". I did this to determine what might be going on with cookies. As a result, I get a warning page saying that cookies are not enabled in the browser. I checked and both IE and Firefox have cookies enabled. So, I think the problem is in the configuration of Oscommerce itself.

 

I checked the cookie path and it looks fine. I'm not sure what I need to check next or how to debug this further.

Any assistance would be helpful.

Share this post


Link to post
Share on other sites
Our site is membership based.

I have used Contribution Member_Approval_v1.5_1 (http://www.oscommerce.com/community/contributions,1339/category,all/search,Member_Approval_v1.5_1) to enable us to approve of all applications before they can purchase or view selected “Members Only” pages.

 

You replied

I'm not familiar with the Membership Approval contribution you're using, I have no idea.

In this contribution, all customer accounts are created in osCommerce. If the account is not activated, the customer won't be able to login to either side.

 

Purely to let you know....Your contribution and Member Approval work together beautifully and with no modification required

 

Everything now installed, and first impressions are that everything is working as it should.

I've had a couple of issues but the first rule of installing contributions got me out of trouble.

"If all else fails, re-read the instructions"

Works 99 times out of 100.

 

Alex....just a couple of questions please.

Am I missing something? or is there no way to edit the forum username?

Its not in account_edit or profile.php.

I realise its not usually an option in a standard PhpBB installation but I was wondering if you knew of any reason for this?

How hard would it be to add it into catalog/account_edit?

 

Also, it would be very useful to have at least a read-only field for username in admin/customers.php

Before I go hacking in my usual manner, can you assist in any way?

Share this post


Link to post
Share on other sites
I think that message boards don't like changing usernames, and most of them don't allow it at all. Of course it is possible to be editable. I usually modify the username directly in phpMyAdmin, didn't think it worth of coding. In admin/customers.php you need to query the username from TABLE_PHPBB_USERS, there is a column 'username'.

Share this post


Link to post
Share on other sites

Thanks Alex,

I'll give it a go.

In our case, I think it's going to be a necessity.

 

Cheers

Jim

Share this post


Link to post
Share on other sites

What's going on Alex,

I just spent a very long hot afternoon installing PhpMyAdmin to run a small, then a couple more hours making sure I installed the Integration patch properly. I'm finally at the end and I can't login to the store or the board. Any idea what could be wrong?

Share this post


Link to post
Share on other sites
What did you get when you tried to login to the store? Edited by AlexStudio

Share this post


Link to post
Share on other sites
I think there must be something wrong with your installation. Your server maybe blocking the error messages so you got blank pages.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0