Twinklespeak wrote:

Wait, do I HAVE to have MySQL too or is that optional?

I believe it will only work with MySQL (it runs on CakePHP which I believe takes care of the database abstraction), but the VM comes with it pre-installed.

The ban screen doesn't appear (you get a blank screen instead)

jvvg wrote:

I have created a VirtualBox appliance that runs ScratchR pre-configured. To install it, simply download and unzip the file, then go into VirtualBox and click “Import Appliance”, then find the file.

The following requirements need to be met:

• 1 GB RAM (at the bare minimum)
  
• 64-bit processor with hardware virtualization support
  
• A firewall that will allow VirtualBox through
  

If you meet all of the requirements, then you can install as detailed above. The admin username and password are included in the machine description. To access the website, simply go to http://localhost:8888/ in your web browser while the VM is running.

You can download the file here.

Some useful things from Jeffalo:

Jeffalo wrote:

- the username and password are on the vm description in virualbox
- you can ssh into your vm via:

ssh -p 2222 apacheadmin@localhost

- use sudo mysql to acess mysql shell, you'll want to know the database is called “scratchr”
- setting yourself as an admin is

UPDATE users SET role = 'admin' WHERE username = 'jeffalo';

Also note that the forums have their own user system. To make yourself a forum admin, first visit the forums while logged into the main site to create your forum account, then run this query, which was provided by Alphysse:

Alphysse wrote:

UPDATE punbb_users SET group_id = '1' WHERE username = '[your username]';

How do I change the port from 8888 to 80?

Can you please host the file on mediafire? It's the only file-hosting website that fully works for me. Other than assets, which I don't think works for non-images now.

ethernetexplorer wrote:

How do I change the port from 8888 to 80?

That should be in the VirtualBox port forwarding settings under “Networking” (for the specific machine).

DifferentDance8 wrote:

Can you please host the file on mediafire? It's the only file-hosting website that fully works for me. Other than assets, which I don't think works for non-images now.

I'm not going to host a file that's over a gigabyte in multiple different places, sorry.

Unnecessary necroposting.

how to make me admin on it?????

imsorryscratch564 wrote:

(#47)
how to make me admin on it?????

The original post has information about that.

For anyone who saw this post and wants to try to create their own, Assembla can be cloned without an account with username and password “nobody”

You should explain how to switch to the database for no-SQL users:

50_scratch_tabs wrote:

You should explain how to switch to the database for no-SQL users:

USE scratchr;

The entire app is built around a relational database, switching it to NoSQL would require a fundamental rewrite of a bunch of stuff, which isn't really the point of this.

jvvg wrote:

(#51)
The entire app is built around a relational database, switching it to NoSQL would require a fundamental rewrite of a bunch of stuff, which isn't really the point of this.

I'm sorry, is NoSQL the name of a thing? I just meant clarifying it for people who aren't used to or don't know how to use SQL.

I just meant clarify the command. You say “the database is called scratchr” but you don't explain how to get to the database before you update the users.

Also, whenever I log out, I lose forum admin. Any idea why?

50_scratch_tabs wrote:

jvvg wrote:

(#51)
The entire app is built around a relational database, switching it to NoSQL would require a fundamental rewrite of a bunch of stuff, which isn't really the point of this.

I'm sorry, is NoSQL the name of a thing? I just meant clarifying it for people who aren't used to or don't know how to use SQL.

Usually when people say something like “NoSQL” they're talking about document-oriented databases like MongoDB

ajskateboarder wrote:

(#53)

50_scratch_tabs wrote:

jvvg wrote:

(#51)
The entire app is built around a relational database, switching it to NoSQL would require a fundamental rewrite of a bunch of stuff, which isn't really the point of this.

I'm sorry, is NoSQL the name of a thing? I just meant clarifying it for people who aren't used to or don't know how to use SQL.

Usually when people say something like “NoSQL” they're talking about document-oriented databases like MongoDB

Ok I just meant to clarify for people who aren't used to SQL.

was checking out the forums and found this:

jvvg wrote:

Welcome to Jacob's copy of the Scratch website. I'm not sure how you got here…

i got here by USING YOUR VM!

how do i change the keyboard layout? i'm using a british keyboard layout and the VM seems to be using an american layout.

Nvm figured it out, for anyone who wants to ask this question in the future, you can do it by typing

i accidentally banned myself from the server, and can't figure out how to unban. even messing with a banned users table in phpmyadmin (yes the VM has that) doesn't get me anywhere. how to fix? nvm there's something else you had to change.

apparently can't share projects, going to the share page just gives a 404.

50_scratch_tabs wrote:

jvvg wrote:

(#51)
The entire app is built around a relational database, switching it to NoSQL would require a fundamental rewrite of a bunch of stuff, which isn't really the point of this.

I'm sorry, is NoSQL the name of a thing? I just meant clarifying it for people who aren't used to or don't know how to use SQL.

I just meant clarify the command. You say “the database is called scratchr” but you don't explain how to get to the database before you update the users.

Also, whenever I log out, I lose forum admin. Any idea why?

Ultimately I can't teach every aspect of a complex system in a forum topic. This requires some amount of technical knowledge to get up and running, including knowledge about how to use MySQL. I also haven't looked at the source code for ScratchR in years, so I have no idea why you lose forum admin.

jvvg wrote:

(#59)
Ultimately I can't teach every aspect of a complex system in a forum topic. This requires some amount of technical knowledge to get up and running, including knowledge about how to use MySQL. I also haven't looked at the source code for ScratchR in years, so I have no idea why you lose forum admin.

Ok, thanks. I'll start looking into the source myself then, I guess.