-
Posts
16,316 -
Joined
-
Last visited
Content Type
Forums
News
20th
EduGeek EDIT Conference
Blogs
Everything posted by Garacesh
-
lmao with the awful out-of-game performance you'd have more chance of running the actual game bit than the menu bit!
-
Jump on Discord and join us lot
-
Yeah. I probably would've bought a Switch if they'd have made it backwards compatible with DS games, but I do understand why they didn't.
-
Precisely my thinking. The 2DSXL is exactly the same hardware as the 'New' 3DSXL (The ones that came out in 2015 with the coloured X/Y/A/B buttons and the little mini C-Stick), it just doesn't have the 3D bit. I don't use the 3D bit 'cause it mega sends my eyes funny, and it's the same hardware for about £50 cheaper. Easy choice. But it's still £120 I can't really justify as I don't use my regular 3DSXL enough.
-
OK yeah, that's fake then Tut tut, distributing pirated material. Naughty @Joanne ;D I've been thinking about picking up one of the New 2DSXL's for the better hardware, but I don't really play on my DS enough to justify it.
-
It might not be, they might have just been trying to score a cheap cart. What makes them say it's fake?
-
SQL woes (See also: "I have absolutely no idea what I'm doing.")
Garacesh replied to Garacesh's topic in Windows Server 2016
Yeah, I've heard from so many sources that LAMP servers are better suited to it than IIS, but the problem is I just don't know anything about Linux and I just end up confused and frustrated. Edit: After finally getting Booked working though.. It turns out it doesn't support multi-week schedules (at least, not that I could see...) so now I'm looking into MRBS and fighting with it to get LDAP working xD -
SQL woes (See also: "I have absolutely no idea what I'm doing.")
Garacesh replied to Garacesh's topic in Windows Server 2016
Hmm. Nope. With PHP 5.6 which includes php_mysql.dll: Fatal error: Call to undefined function mysqli_connect() in C:\inetpub\Booked\lib\Database\MySQL\MySqlConnection.php on line 53 edit: uncommenting both extension=php_mysql.dll and extension=php_mysqli.dll gets me the registration form! Woo! -
SQL woes (See also: "I have absolutely no idea what I'm doing.")
Garacesh replied to Garacesh's topic in Windows Server 2016
I'm starting to suspect it might be that I'm using too new a version of PHP.. It states to PHP 5.4+ but apparently php_mysql.dll was depreciated in v5.5 and completely removed in 7.0, replaced with php_mysqli.dll and I'm wondering if that might be part of the problem.. extension=php_mysqli.dll isn't commented out in my php.ini, but there's no extension=php_mysql.dll So.. If I change config.php so that $conf['settings']['database']['type'] = 'mysql'; reads $conf['settings']['database']['type'] = 'mysqli'; I get: Warning: require_once(../lib/external/pear/MDB2.php): failed to open stream: No such file or directory in C:\inetpub\Booked\lib\Database\MDB2\Mdb2Connection.php on line 23 Fatal error: require_once(): Failed opening required '../lib/external/pear/MDB2.php' (include_path='C:\inetpub\Booked\lib\Database\MDB2/../../../lib/external/pear/;../lib/external/pear/;.;C:\php\pear') in C:\inetpub\Booked\lib\Database\MDB2\Mdb2Connection.php on line 23 Which doesn't really help me make heads nor tails of it. I wonder if it's worth downgrading the PHP version the server uses.. -
SQL woes (See also: "I have absolutely no idea what I'm doing.")
Garacesh replied to Garacesh's topic in Windows Server 2016
Hmm... mysql> SHOW SCHEMAS; +--------------------+ | Database | +--------------------+ | information_schema | | booked | | mysql | | test | +--------------------+ mysql> USE booked; mysql> SHOW TABLES; +----------------------------+ | Tables_in_booked | +----------------------------+ | Lots | | of | | tables | +----------------------------+ So it looks like the SQL database is set up now, and my issue is elsewhere. Alas, it's still progress. Thank you (again) @Steve21! -
SQL woes (See also: "I have absolutely no idea what I'm doing.")
Garacesh replied to Garacesh's topic in Windows Server 2016
mysql> mysql -u booked_user -p booked < "C:/inetpub/Booked/database_schema/full-install.sql" -> _ (Just hangs here until aborted) Same result with mysql> mysql -u booked_user -p booked < "C:\\inetpub\\Booked\\database_schema\\full-install.sql" 'mysql' is not recognized as an internal or external command c:\inetpub\Booked\database_schema>"C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin\mysql.exe" -u booked_user -p booked < "C:/inetpub/booked/database_schema/full-install.sql" Enter password: ***************** ERROR 1045 (28000): Access denied for user 'booked_user'@'localhost' (using password: YES) Which doesn't make sense, because the script is supposed to make booked_user for me.... Wait a minute... I'm a idiot Why am I specifying -u booked_user when that hasn't been created yet?! And specifying the 'booked' database that hasn't been created yet either... c:\inetpub\Booked\database_schema>"C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin\mysql.exe" -u root -p < "C:/inetpub/booked/database_schema/full-install.sql" Enter password: ********************* [Wait] c:\inetpub\Booked\database_schema>_ No error! Progress! Still getting Unknown Error on the Register.php page though D: mysql> mysql -u booked_user -p doesn't get me a password prompt, though.. Just a -> _.. and if I finish it with ; I get ERROR 1064 (Syntax) Damnit, thought I might have had it, then! (It would be really nice if SQL didn't quit itself after I abort the current command.. ) Edit: mysql> mysql -u root -p < "C:/inetpub/Booked/database_schema/full-install.sql" gets me: -> _ instead of the password challenge for root. -
SQL woes (See also: "I have absolutely no idea what I'm doing.")
Garacesh replied to Garacesh's topic in Windows Server 2016
Looks like it, yeah.. It begins: DROP DATABASE IF EXISTS booked; CREATE DATABASE booked; USE booked; GRANT ALL on booked.* to 'booked_user'@'localhost' identified by '[b]REDACTED[/b]'; GRANT ALL on booked.* to 'booked_user'@'127.0.0.1' identified by '[b]REDACTED[/b]';SET foreign_key_checks = 0; mysql> mysql -u booked_user -p booked < C:\inetpub\Booked\database_schema\full-install.sql ERROR: Unknown command '\i'. ERROR: Unknown command '\B'. -> _ -
SQL woes (See also: "I have absolutely no idea what I'm doing.")
Garacesh replied to Garacesh's topic in Windows Server 2016
Wait, wut? Because naming software with separate names is just too easy I thought the 'Microsoft' bit in 'Microsoft SQL Server Management Studio' just meant it was for managing SQL servers on Microsoft OS' >.< Maybe I need to go back to basics.. The ReadMe gives the following prerequisites: PHP 5.4 or greater. MySQL 5.0 or greater. Web server (Apache2, IIS). OS - Windows, Mac, *nix I have Windows Server 2016, IIS 10 and PHP 7.1.9 set up and they all appear to be working fine now. I can get to the login page for Booked, but when I try to register a user I just get 'Unknown Error', which I assume is because it's trying to read/write from/to a SQL database that is either not properly configured or simply doesn't exist (since other static pages like the Help and About pages load fine). I installed MySQL Essentials 5.0.41 and MySQL Community 5.7.19 x86, 64-bit in my endeavour to get this working but truth be told I have no idea if I'm on the right track or not. There is a 'MySQL Command Line Client' in the start menu, yeah. So it looks like I have that. -
Trying to get Booked set up on a VM to test its capabilities and I've hit a wall with SQL, best described as "Duurrrrrrr... what?" I know literally nothing of SQL. Zip. Nil. Nada. I've never used it before. And documentation online seems to be lacking. Luckily this comes with what I assume is a script/pre-programmed sequence of commands to automatically set up the database for me. Awesome. DROP TABLE IF EXISTS `announcements`; CREATE TABLE `announcements` ( `announcementid` mediumint(8) unsigned NOT NULL auto_increment, `announcement_text` text NOT NULL, `priority` mediumint(8), `start_date` datetime, `end_date` datetime, PRIMARY KEY (`announcementid`) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; [b]Etcetera etcetera[/b] Their readme states: If you have database creation privileges in MySQL Open "/database_schema/full-install.sql" and edit the database name and username/password to match your config.php database values [Done that, thanks NotePad++] Run or import "/database_schema/full-install.sql" Optionally - run/import "/database_schema/testdata-utf8.sql" to bookedscheduler (sample application data will be created with 2 users: admin/password and user/password). These users are available for testing your installation. However Microsoft SQL Server Management Studio wants me to connect to a SQL server and I just can't seem to get that to work.. I've tried localhost, hostname, IP address, Windows Authentication, SQL server authentication (root//[root password specified when installing MySQL Essentials 5.0.41]).. nothing works. And all the things I'm reading all gloss over the bit where you need to connect to a database engine, they just assume you've done that bit. I've installed MySQL Essentials which had me set up a root password, so I assume that's made a database? But I don't even know how I'd check that. Help me Obi Wan Kenobi Edugeek, you're my only hope!
-
Aye, hopefully it just needs Modify whilst it sets itself up. My hope is that after everything is configured, I can drop it down to Read-only since the rest ought to just be modifying a SQL database done with credentials I provide the software. Anyway. Going home now. That's a job for tomorrow. Thanks again!
-
Yes, open_basedir = %SystemDrive$\inetpub\Booked Everything to do with this booking system exists in inetpub\Booked or a subfolder of it (or a subfolder of a subfolder.. you get it.) AHA! display_errors = On and open_basedir commented out gets me: Fatal error: Uncaught --> Smarty: unable to write file C:\inetpub\Booked\tpl_c\wrt59c286abc5a394_34023484 <-- thrown in C:\inetpub\Booked\lib\external\Smarty\sysplugins\smarty_internal_runtime_writefile.php on line 49 Giving Authenticated Users 'Modify' permissions and viola! Not an error! Woo! Should probably disable directory traversal if I have to put a password in a file, though.. Fantastic! Hopefully I shouldn't have any more issues. Thank you!
-
All of them? No. Just the one that Microsoft told me to, extension=php_mysql.dll (which I've just noticed is actually ;extension=php_mysqli.dll in my php.ini, for some reason....?) Should I de-comment any of the others? ;extension=php_bz2.dll ;extension=php_curl.dll ;extension=php_fileinfo.dll ;extension=php_ftp.dll ;extension=php_gd2.dll ;extension=php_gettext.dll ;extension=php_gmp.dll ;extension=php_intl.dll ;extension=php_imap.dll ;extension=php_interbase.dll ;extension=php_ldap.dll ;extension=php_mbstring.dll ;extension=php_exif.dll ; Must be after mbstring as it depends on it extension=php_mysqli.dll ;extension=php_oci8_12c.dll ; Use with Oracle Database 12c Instant Client ;extension=php_openssl.dll ;extension=php_pdo_firebird.dll ;extension=php_pdo_mysql.dll ;extension=php_pdo_oci.dll ;extension=php_pdo_odbc.dll ;extension=php_pdo_pgsql.dll ;extension=php_pdo_sqlite.dll ;extension=php_pgsql.dll ;extension=php_shmop.dll
-
Indeed. Request Path: *.php Module: FastCgiModule Executable (optional): C:\PHP\php-cgi.exe Name: FastCGI Request Restrictions: Mapping: [Checked] Invoke handler only if request is mapped to: File or folder Verbs: Specify the verbs to to be handled: All Verbs Access: Specify the access required by the handler: Script
-
Trying to set up a php booking system via IIS/PHP/MySQL and hitting some issues. The server has: IIS 10 with Web Server/Application Development/CGI also enabled. MySQL Essentials 5.0.41 PHP 7.1.9 Non-Thread Safe x64 Visual C++ Redistributable for Visual Studio 2015 Traversing the directory with a web browser, .html, .ico and .css files can all be opened , but .php files all return 'No input file specified.' Things the internet told me to try: Commenting out doc_root in php.ini [No effect.] Commenting out open_basedir in php.ini [Broke it, .php files returned Error 500. Reverted to %SystemDrive$\inetpub\Booked] setting .php MIME type 'text/html' [No effect.] Setting FastCGI Request Restrictions Mapping to 'File or Folder' [No effect.] %windir%\system32\inetsrv> cscript fcgiconfig.js -add -section:"PHP" -extension:php -path:"C:\PHP\php-cgi.exe" [Failed. File doesn't exist (Input Error: Can not find script file "C:\Windows\System32\inetsrv\fcgiconfig.js")] Setting cgi.fix_pathinfo = 1 in php.ini [Already set to 1] Granting 'Everyone' and 'Authenticated Users' Read & execute/List folder contents/Read permissions on C:\inetpub\ and all nested files/folders. [No effect.] Stuck for ideas and not finding any other potential solutions now. Someone with more knowledge than me got any ideas?
-
I keep forgetting to launch Discord so I'm on Team %NULL% because nobody invites me to games
-
Got myself another chicken dinner last night. Conclusion: Mini14 is OP.
-
Yeah that's what we've done. Ordered the Duracell one and we'll see how it goes. Slight pedant: I said Duracell make them but that's probably not the case. They're probably bought off a supplier that makes and tests them and sells them off to multiple different brands. That being said, I'd expect they'd hold their manufacturer to higher QA standards, just like what happens with things like SD cards. The ones that pass QA go to known-brand companies. The ones with slight failures go to off-brand names you find at your Saturday market stall.
-
It's getting to the point now where we're having to tweak certain policies for certain kids depending on what subjects they take at GCSE. More storage, removable device access, etc. Rather than keep nesting more OU's and fracturing our user accounts, I'm thinking would it be possible to create Security Groups for subjects with special permissions and have those apply policies as needed.. For example, the Photography students need access to their phones because we don't have the money to be buying cameras, so I create a GPO that enables Read permissions on WPD Devices. I want to have that apply if pupils are part of the 'GCSE Photography' security group, but if I put the Security Group in an OU and apply the policy to that OU, it doesn't apply to members of the Security Group. This article documents a similar approach, rather than applying the GPO to the OU containing the Security Group, apply it to all users but only allow users of the Security Group to process it by removing Authenticated Users permissions. I've tried that and it doesn't work either, even if the Security Group is in the same OU as the user. Kinda stumped now. Is what I'm after even possible, or am I just completely barking up the wrong tree? DERP! I'm an idiot. I completely removed Authenticated Users' permissions rather than just unchecking 'Apply group policy'. Once Authenticated Users had Read permissions again, it worked as intended.
-
We have 2 rather large MFD's in our reprographics department that all staff can print to, however the user must use a touchscreen interface on the printer to release the job. We're often finding ourselves in a situation where Staff A prints something to Prt01 and goes down to collect it, only to find Staff B is currently printing something pretty big on Prt01 and it's gonna be a while. So their choices are either wait, or trek back upstairs, re-print the job to Prt02 (leaving one copy just sat there on Prt01 that they invariably don't delete) and then come back down and release it. Is there a way to make both printers share the same print queue so any job can be picked up on either printer? I assume this would either involve automatically spooling the job on both printers, or having a server spool the job and not pass it to a printer until it's been released.
