Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: VBulletin 3.8 to Discourse on Docker Migration Test Take Four
The Lounge What is on Your Mind? VBulletin 3.8 to Discourse on Docker Migration Test Take Four Post 303045312 by Neo on Monday 16th of March 2020 10:17:53 AM
Old 03-16-2020
I have a solution to this issue, or at least a workaround:

EDIT: This method only works on posts with no bbcode because discourse preprocesses the raw posts and changes the post. Hence, the MD4 (or matching methods in general, do not work).

Code:
raw = preprocess_post_raw()

On discourse (after migrating):

Code:
discourse=> select md5(raw) from posts where raw like '%where can i get a free copy of unix? any kind... plz send %';
               md5                
----------------------------------
 e136704539982b094d8d1d4229884583
(1 row)

On vb forums:

Code:
mysql> select md5(pagetext) from post where pagetext like '%where can i get a free copy of unix? any kind... plz send %';
+----------------------------------+
| md5(pagetext)                    |
+----------------------------------+
| e136704539982b094d8d1d4229884583 |
+----------------------------------+
1 row in set (1.07 sec)

So, the MD5() function in post mysql and postgres returns the same hash on the same post in two different DBs (it's should, but always good to check).

This means that we can match the posts in both DBs without unique post ids using MD5() and the user name who created the post.

The
Code:
MD5

hash combined with the user name should does not work because the post is preprocessed for bbcode and markdown.
 

7 More Discussions You Might Find Interesting

1. Web Development

Removing VBSEO for vbulletin – Reverting back to vbulletin URLs

Please note, this information was copied from vbseo.com, now showing a database error. This is posted for reference since vbSEO seems to be going out of business: If you ever need to uninstall vBSEO , you can use the following instructions. Make sure you carefully follow each step. Login... (37 Replies)
Discussion started by: Neo
37 Replies

2. Linux

Docker and pipework,ip with other subnet

Recently i found this for give to docker a "personal" ip ip addr del 10.1.1.133/24 dev eth0 ip link add link eth0 dev eth0m type macvlan mode bridge ip link set eth0m up ip addr add 10.1.1.133/24 dev eth0m route add default gw 10.1.1.1On container i did ... (0 Replies)
Discussion started by: Linusolaradm1
0 Replies

3. AIX

AIX - FC Switch migration, SAN Migration question!

I'm New to AIX / VIOS We're doing a FC switch cutover on an ibm device, connected via SAN. How do I tell if one path to my remote disk is lost? (aix lvm) How do I tell when my link is down on my HBA port? Appreciate your help, very much! (4 Replies)
Discussion started by: BG_JrAdmin
4 Replies

4. Shell Programming and Scripting

Problem in extracting yocto SDK for docker

Actually I was facing the following issue while building my Yocto SDK on Docker container sudo docker build --tag="akash/eclipse-che:6.5.0-1" --tag="akash/eclipse-che:latest" /home/akash/dockerimage.yocto.support/ Sending build context to Docker daemon 26.93MB Step 1/5 : FROM eclipse/cpp_gcc ... (3 Replies)
Discussion started by: Akash BHardwaj
3 Replies

5. Docker

Docker learning Phase-I

Hello All, I had recently learnt a bit of Docker(which provides containerization process). Here are some of my learning points from it. Let us start first with very basic question: What is Docker: Docker is a platform for sysadmins and developers to DEPLOY, DEVELOP and RUN applications ... (7 Replies)
Discussion started by: RavinderSingh13
7 Replies

6. What is on Your Mind?

VBulletin 3.8 to Discourse on Docker Migration Test Take Two

OK. Like we all do, we learn a lot from tests, test migrations, and so forth. Today, I started from scratch on test migration 2, armed with a lot more knowledge, The main differences are as follows: Installed discourse plugin ruby-bbcode-to-md before starting the install Modified... (30 Replies)
Discussion started by: Neo
30 Replies

7. What is on Your Mind?

Under Consideration: Migrate the Forums to Discourse

Dear All, After being active on the Node-RED forum for the last few weeks, I have been very impressed with Discourse, and my eyes have been opened. https://www.discourse.org/ but not the paid /hosted offering, but using the open distribution: https://github.com/discourse/discourse ... (52 Replies)
Discussion started by: Neo
52 Replies

LEARN ABOUT DEBIAN

blaze-list

BLAZE-LIST(1)						    BlazeBlogger Documentation						     BLAZE-LIST(1)

NAME

       blaze-list - lists blog posts or pages in the BlazeBlogger repository

SYNOPSIS

       blaze-list [-cpqrsCPSV] [-b directory] [-I id] [-a author] [-t title] [-T tag] [-d day] [-m month] [-y year] [-n number]

       blaze-list -h|-v

DESCRIPTION

       blaze-list lists existing blog posts or pages in the BlazeBlogger repository. Additionally, it can also display basic repository
       statistics.

OPTIONS

       -b directory, --blogdir directory
	   Allows you to specify a directory in which the BlazeBlogger repository is placed. The default option is a current working directory.

       -I id, --id id
	   Allows you to display a single blog post or a page with the specified id.

       -a author, --author author
	   Allows you to list blog posts or pages by the selected author.

       -t title, --title title
	   Allows you to list blog posts or pages with matching title.

       -T tag, --tag tag
	   Allows you to list blog posts or pages with matching tag.

       -d day, --day day
	   Allows you to list blog posts or pages from the specified day of a month. The value has to be in the "DD" form.

       -m month, --month month
	   Allows you to list blog posts or pages from the specified month. The value has to be in the "MM" form.

       -y year, --year year
	   Allows you to list blog posts or pages from the specified year. The value has to be in the "YYYY" form.

       -n number, --number number
	   Allows you to specify a number of blog posts or pages to be listed.

       -p, --page
	   Tells blaze-list to list pages.

       -P, --post
	   Tells blaze-list to list blog posts. This is the default option.

       -S, --stats
	   Tells blaze-list to display statistics.

       -s, --short
	   Tells blaze-list to display each blog post or page information on a single line.

       -r, --reverse
	   Tells blaze-list to display blog posts or pages in reverse order.

       -c, --color
	   Enables colored output. When supplied, this option overrides the relevant configuration option.

       -C, --no-color
	   Disables colored output. When supplied, this option overrides the relevant configuration option.

       -q, --quiet
	   Disables displaying of unnecessary messages.

       -V, --verbose
	   Enables displaying of all messages. This is the default option.

       -h, --help
	   Displays usage information and exits.

       -v, --version
	   Displays version information and exits.

EXAMPLE USAGE

       List all blog post:

	 ~]$ blaze-list
	 ID: 11 | 2010-07-05 | Jaromir Hradilek

	     Title: Join #blazeblogger on IRC
	     Tags:  announcement

	 ID: 10 | 2009-12-16 | Jaromir Hradilek

	     Title: Debian and Fedora Packages
	     Tags:  announcement

	 etc.

       List all blog post in reverse order:

	 ~]$ blaze-list -r
	 ID: 1 | 2009-02-10 | Jaromir Hradilek

	     Title: BlazeBlogger 0.7.0
	     Tags:  release

	 ID: 2 | 2009-02-11 | Jaromir Hradilek

	     Title: BlazeBlogger 0.7.1
	     Tags:  release

	 etc.

       List all pages:

	 ~]$ blaze-list -p
	 ID: 5 | 2009-02-10 | Jaromir Hradilek

	     Title: Downloads

	 ID: 4 | 2009-02-10 | Jaromir Hradilek

	     Title: Themes

	 etc.

       List each blog post on a single line:

	 ~]$ blaze-list -s
	 ID: 11 | 2010-07-05 | Join #blazeblogger on IRC
	 ID: 10 | 2009-12-16 | Debian and Fedora Packages
	 etc.

       Display a short version of blog statistics:

	 ~]$ blaze-list -Ss
	 There is a total number of 11 blog posts and 5 pages in the repository.

SEE ALSO

       blaze-config(1), blaze-add(1)

BUGS

       To report a bug or to send a patch, please, add a new issue to the bug tracker at <http://code.google.com/p/blazeblogger/issues/>, or visit
       the discussion group at <http://groups.google.com/group/blazeblogger/>.

COPYRIGHT

       Copyright (C) 2009-2011 Jaromir Hradilek

       This program is free software; see the source for copying conditions. It is distributed in the hope that it will be useful, but WITHOUT ANY
       WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

Version 1.2.0							    2012-03-05							     BLAZE-LIST(1)
All times are GMT -4. The time now is 04:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy