Thread Rating:
  • 3 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Tutorial] Sync your users with another MyBB board
#21
Can this be used to sync with a non-mybb user table? I'm assuming it can be right? I would like to see an example where a user table from a basic authentication system is used to sync to the forum so that when you register on the site it creates a forum account for you.
Reply
#22
(01-21-2014, 02:18 AM)Synthetisoft Wrote: Can this be used to sync with a non-mybb user table? I'm assuming it can be right? I would like to see an example where a user table from a basic authentication system is used to sync to the forum so that when you register on the site it creates a forum account for you.

Good question, but sorry...
The SQLyog Job Agent (SJA) for Linux needs both tables to have matching schema (columns)

Welcome to MyBB Smile
#
MyBB is the best forum software! Exclamation

Reply
#23
Excuse me for bumping a very old thread, but I could use some advice.

I used email to check the error tho it also generates log:

Error Message:
Quote:SQLyog Job Agent v12.2.1 (32 bit) Copyright© Webyog Inc. All Rights Reserved.

Sync started at Sun Mar 20 10:55:03 2016

ERROR: 2005, Unknown MySQL Server Host 'http://www.mydomain.xyz' (-2) Check sja.log for complete error details.


Here is xml file:
Quote:<job version="8.21">
<syncjob>
<abortonerror abort="yes" />
<fkcheck check="yes" />
<twowaysync twoway="no" />

<source>
<host>localhost</host>
<user>db_username</user>
<pwd>db_password</pwd>
<port>3306</port>
<database>db_name</database>
</source>

<target>
<host>http://wwww.mydomain.xyz</host>
<user>db_username</user>
<pwd>db_password</pwd>
<port>3306</port>
<database>db_name</database>
</target>

<tables all="no">
<table> <name>prefix_users</name>
<columns all="no">
<column>uid</column>
<column>username</column>
<column>password</column>
<column>salt</column>
<column>loginkey</column>
<column>email</column>
</columns>
</table>
</tables>

</syncjob>
</job>


MyBB config files for both database have localhost as hostname: $config['database']['hostname'] = 'localhost';

So what am I doing wrong or missing?


Thnx
Reply
#24
(03-20-2016, 06:00 PM)bpt Wrote: Excuse me for bumping a very old thread, but I could use some advice.

I used email to check the error tho it also generates log:

Error Message:
Quote:SQLyog Job Agent v12.2.1 (32 bit) Copyright© Webyog Inc. All Rights Reserved.

Sync started at Sun Mar 20 10:55:03 2016

ERROR: 2005, Unknown MySQL Server Host 'http://www.mydomain.xyz' (-2) Check sja.log for complete error details.


MyBB config files for both database have localhost as hostname: $config['database']['hostname'] = 'localhost';

So what am I doing wrong or missing?


Thnx

Hi, sorry I didn't see this before.
Your remote DB connection has issues.

I've used this with both DB's on the same server. Remote should work if you get the connection details correct and the database has permissions allowing a remote connection, perhaps only from one or two "white-listed IP's" which you control?
#
MyBB is the best forum software! Exclamation

Reply
#25
Nothing seems to work. The Google files don't exist.
www.volvl.com | Get your first month of hosting for $0.01 USD with Promo Code: Hexeus
[Image: 12946833.gif]


Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)