AsmBB

Power
Login Register

AsmBB v3.0 has been released.
3

#16336 (ツ) johnfound
Last edited: 11.06.2023 by johnfound, read: 7313 times

The source and binary releases v3.0 are available for clone and download.

The official version 3.0 has been released yesterday.

Here is a link to the repository: https://asm32.info/fossil/asmbb/timeline?t=v3.0

The binary package

You can download the recent binary package from the permanent link: asmbb.tar.gz

What is AsmBB?

AsmBB is very fast and lightweight web forum engine. (You are reading this article on AsmBB demo forum).

AsmBB is fully written in assembly language and uses SQLite as a database back-end. That is why it can work on really weak hosting and in the same time serve huge amount of visitors without lags and delays.

AsmBB is very secure web application, because of the internal design and the reduced dependencies. But it also supports encrypted databases, for even higher security.

In addition, AsmBB has very few requirements to the running environment:

  • x86 Linux server.

  • No matter 32 or 64bit. No need to have any specially preinstalled libraries.

  • The smallest/cheapest VPS is fine. Shared hosting is fine as well (if supports FastCGI).

  • A web server supporting FastCGI interface. AsmBB has been tested with Nginx, Apache, Lighttpd, Hiawatha and of course RWASA.

AsmBB is easy for customizing and modifying - it uses pretty powerful template system that allows easy customizing of the forum without actually modifying the code. (which is not so hard though).

Install

The installation instructions are the same as in the older versions:

How to install AsmBB on VPS with Nginx and systemd

or here:

AsmBB how to download, compile and install

The most important changes.

  1. Many new features was added. Direct paste images as an attachments, support for YouTube video embedding, unified post/thread editor (which simplifies the code and the templates), threads ranking.

  2. The skin "Modern" was removed from the project, because of its low quality.

  3. v3.0 introduces incompatibilities with the older versions.Both in database and template structures. How to migrate, see later in this post.

  4. Because of the SQLeet project discontinuation, was added support for SQLite3MultipleCiphers encryption extension. (the binary release package is compiled with it)

  5. All the bugs and vulnerabilities revealed was fixed. The most several bugs was discovered as a result of the hxp CTF event. It is a work of 181 CTF teams.

  6. Only 7 teams out of 181 solved the challenge and found some vulnerabilities in AsmBB. Кudos to the winners!

    • 🥇 justCatTheFish

    • 🥈 idek

    • 🥉 Never Stop Expliting

    • Katzebin

    • copy

    • Blue Water

    • 796f75

    (The team Straw Hat solved the task, but found vulnerability in the test bot (in Python), not in AsmBB. ;-) So, it is not in the above list.)

    Update of the database from v2.9.1 to v3.0:

    As long as the database structure was changed, before updating the binaries to v3.0, modify the existing databases:

    1. Decrypt the database, before modifying. Notice, that the new SQLite3MultipleCiphers library is used in a mode not compatible with the previous SQLeet library. You must decrypt the database before migrating to v3.0 and then you can encrypt it again with the new library.

    2. Make a backup in case something goes wrong.

    3. Execute in the SQLite console the following commands (simply copy and paste, there is no parameters to adjust):

    4. insert into Params values ('nu_post_interval', 0);
      insert into Params values ('nu_post_interval_inc', 0);
      insert into Params values ('nu_max_post_length', 0);
      
      alter table Users add column LastPostTime    integer default 0;
      alter table Users add column PostInterval    integer default 0;   
      alter table Users add column PostIntervalInc integer default 0;   
      alter table Users add column MaxPostLen      integer default 0;
      
      alter table Attachments add column userID integer references Users(id) on delete cascade;
      
      create index idxAttachmentsCombined on Attachments(postID, userID);
      create unique index idxAttachmentsUnique2 on Attachments(userID, md5sum);
      
      drop index idxUserLogGroup;
      
      alter table Threads add column Rating integer default 0;
      
      create table ThreadVoters (
        threadID integer references Threads(id) on delete cascade on update cascade,
        userID   integer references Users(id) on delete cascade on update cascade,
        Vote     integer
      );
      
      create unique index idxThreadVoters on ThreadVoters(threadID, userID);
      
      create trigger ThreadVotersAU after update on ThreadVoters begin
        update Threads set Rating = Rating - old.Vote + new.Vote where id = new.threadID;
      end;
      
      create trigger ThreadVotersAD after delete on ThreadVoters begin
        update Threads set Rating = Rating - old.Vote where id = old.threadID;
      end;
      
      create trigger ThreadVotersAI after insert on ThreadVoters begin
        update Threads set Rating = Rating + new.Vote where id = new.threadID;
      end;
      
      drop trigger PostsAI;
      drop trigger PostsAD;
      
      CREATE TRIGGER PostsAI AFTER INSERT ON Posts BEGIN
        insert into PostFTS(rowid, Content, Caption, slug, user, tags) VALUES (
          new.id,
          new.Content,
          (select Caption from Threads where id=new.threadid),
          (select slug from Threads where id = new.threadid),
          ifnull((select nick from users where id = new.userid), new.anon),
          (select group_concat(TT.Tag, ", ") from ThreadTags TT where TT.threadID = new.threadid)
        );
        insert into PostCNT(postid,count) VALUES (new.id, 0);
        insert or ignore into ThreadPosters(firstPost, threadID, userID) values (new.id, new.threadID, new.userID);
      
        update Users set PostCount = PostCount + 1, LastPostTime = strftime('%s', 'now'), PostInterval = max(0, PostInterval + PostIntervalInc) where Users.id = new.UserID;
        update Threads set PostCount = PostCount + 1 where id = new.threadID;
        update Counters set val = val + 1 where id = 'posts';
        update Tags set PostCnt = PostCnt + 1 where Tags.tag in (select tag from ThreadTags where ThreadID = new.ThreadID);
      END;
      
      CREATE TRIGGER PostsAD AFTER DELETE ON Posts BEGIN
        delete from PostFTS where rowid = old.id;
        delete from ThreadPosters where threadid = old.threadid and userid = old.userid;
        insert or ignore into ThreadPosters(firstPost, threadID, userID) select min(id), threadid, userid from posts where threadid = old.threadid and userid = old.userid;
      
        update Users set PostCount = PostCount - 1 where Users.id = old.UserID;
        update Threads set PostCount = PostCount - 1, LastChanged = (select max(P.postTime) from posts as P where P.threadID = old.threadID) where id = old.threadID;
        update Counters set val = val - 1 where id = 'posts';
        update Tags set PostCnt = PostCnt - 1 where Tags.tag in (select tag from threadtags where threadid = old.threadid);
      
        insert or ignore into PostsHistory(postID, threadID, userID, anon, postTime, editUserID, editTime, format, Content) values (
          old.id,
          old.threadID,
          old.userID,
          old.anon,
          old.postTime,
          old.editUserID,
          old.editTime,
          old.format,
          old.Content
        );
      END;
      
      insert into Messages VALUES ('error_too_early','Simple, deep, and still.
      The old masters were patient.
      Without desires.','Try to do it later!',NULL);
      
      
    5. After updating the database scheme you can stop the engine and replace the binary files ( engine, ld-musl-i386.so and libsqlite3.so)

    6. While engine stopped, replace the whole templates/ directory with the new one.

    7. Start the engine again.

    8. Check the updated forum for problems.

    9. If everything seems to works OK, you can encrypt the database again (if you prefer so) from the AsmBB settings page.

    Enjoy!

#16369 (ツ) icantbelieveitsnotbutter
Created 06.12.2023, read: 3051 times

the board won't fully load after a fresh install on a subdomain and there's nothing in the error log

Apache 2.4.37 PHP 7.2.24

page source:

[case:[special<div class="set_page">
<form class<div class="footer">
<p>
<a href="/!users_online"

file permissions...

images 
manny:apache 0755 --------------e----- 
templates manny:apache 0755 --------------e----- 
.htaccess
125 bytes manny:apache 0644 --------------e----- 
_index.html
78.2 KiB manny:apache 0644 --------------e----- 
asmbb_ipc.lock
0 bytes manny:apache 0644 --------------e----- 
asmbb_queue.lock
0 bytes manny:apache 0644 --------------e----- 
board.sqlite
388 KiB manny:apache 0644 --------------e----- 
board.sqlite-shm
32 KiB manny:apache 0644 --------------e----- 
board.sqlite-wal
257.53 KiB manny:apache 0644 --------------e----- 
engine
154.11 KiB manny:apache 0755 --------------e----- 
ld-musl-i386.so
789.8 KiB manny:apache 0755 --------------e----- 
libsqlite3.so
841.3 KiB manny:apache 0755 --------------e----- 
manifest.uuid
41 bytes manny:apache 0644 --------------e----- 

AsmBB v3.0 has been released.
3

AsmBB v3.0 (check-in: a316dab8b98d07d9); SQLite v3.42.0 (check-in: 831d0fb2836b71c9);
©2016..2023 John Found; Licensed under EUPL. Powered by Assembly language Created with Fresh IDE