写作program课程程序、SQL程序语言程序

” 写作program课程程序、SQL程序语言程序Assignment 1Due: 30 June 2020 by 23:59:59 EDTGrade: 5% of final markDescription:As a system administrator, a substantial portion of your time will be spentworking with ticketing systems. Effective use of a ticketing system will helpyou prioritize work and understand how your organization functions as awhole when it comes to IT usage.This assignment will require you to provision a virtual machine and theninstall the OTRS ticketing system on it. Evaluation is broken down intoseparate criteria so that you can still receive a passing grade even if you donot get the system functioning fully.VM Setup:To start the assignment, you will need to create a virtual machine (VM)using your DigitalOcean account. Login to the dashboard and proceed byfollowing these instructions:1. At the top right of the dashboard, click the Create button, and thenselect Droplets.2. Under the Choose an Image section, click Snapshots.3. Select the Ubuntu itec2210.ca-base-image.4. Under Choose a plan leave Standard selected.5. Click the arrow to scroll to the left of the list of Droplettypes, e.g. the default will be $40/month, scroll to the farleft until you can choose $5/month6. At the very bottom under Choose a hostname, use your student number.For example, if your student number is 31415926, make the hostname31415926.itec2210.ca.7. Click Create. 写作program课程作业、SQL程序语言作业8. You will now be back at the dashboard. Once your VM is finishedprovisioning, look for it in the list and copy its IP address somewhere.9. In the menu on the very left, select Networking. Click on itec2210.ca.10. In the HOSTNAME field add your student number again. This step iscrucial for grading. If you do not do this your assignment cannot be graded.11. In the WILL REDIRECT TO field, input the IP address you recorded, orselect your VM from the list.12. Click Create Record.13. You may now use PuTTY or any SSH client to connect to your VM. Forthe hostname, use the DNS entry that you created e.g31415926.itec2210.ca. When prompted for the username, input itec2210.The password is limoncelli.For example, type `ssh itec2210@31415926.itec2210.ca` to connect as the`itec2210` user to the system identified by the DNS record31415926.itec2210.ca. The `@` sign designates user@hostname, and youare connecting as the itec2210 user in this case.OTRS SetupThe OTRS installation guide provides all the commands and informationthat you need to achieve 5/5 on this assignment (with some caveats, which Imention below). The installation guide is available here: httpss://doc.otrs.com/doc/manual/admin/6.0/en/html/manual-installation-of-otrs.htmlErrataThere are a number of caveats in the documentation that you must beaware of before starting the installation. These notes correspond to thenumbered steps in the OTRS documentation.DO NOT PROCEED until you have read through all the documentation first.If you start running commands without understanding the purpose of each,you will encounter problems and have to start again.Any time you see a shell line, you will use the command after the symbolin your terminal. For example, your PuTTY/SSH prompt will look somethinglike this for Step 1: root@instructor: # tar xzf otrs-x.x.x.tar.gzThe documentation assumes that you are working as the root user whenyou are typing commands in the shell prompt. Use sudo -i -u root tobecome the root user, then proceed with the installation. While you can usesudo to run each command as your regular user, for the purposes of thisassignment, it will be easier to just become root and follow the instructions.OTRS will then set appropriate permissions on files for you at the end of theinstall process.You MUST remember to use the Debian/Ubuntu specificversion of each command, not the RedHat or SuSEversions. If you use the latter then you will get stuck.To begin, become root (per above using sudo) and install some prerequisitepackages before starting at Step 1 (copy and paste the entire commandstarting at apt):root@instructor:~# apt update apt install libapache2-mod-perl2 \\rlibdbd-mysql-perl libtimedate-perl libnet-dns-perl libnet-ldap-perl \\rlibio-socket-ssl-perl libpdf-api2-perl libdbd-mysql-perl \\rlibsoap-lite-perl libtext-csv-xs-perl libjson-xs-perl \\rlibapache-dbi-perl libxml-libxml-perl libxml-libxslt-perl \\rlibyaml-perl libarchive-zip-perl libcrypt-eksblowfish-perl \\rlibencode-hanextra-perl libmail-imapclient-perl libtemplate-perl \\rlibcrypt-ssleay-perl libdatetime-perlStep 1: Install .tar.gz1. To get started, you will need to use a tool like wget to download theOTRS package onto your VM. You can get the latest release directly byrunning this command in your terminal (copy and paste it):wget httpss://ftp.otrs.org/pub/otrs/otrs-latest-6.0.tar.gz -O otrs.tar.gz2. Next, unpack the file you just downloaded with the followingcommand: tar xzf otrs.tar.gz3. Now run ls to examine the contents of your directory. You should seethe following (where otrs-6.0.22 is the unpacked source code in adirectory for the OTRS application):root@instructor:~# lsotrs-6.0.25 otrs.tar.gz4. Now run the mv command from the documentation:mv otrs-6.0.25 /opt/otrs5. Confirm the directory /opt/otrs exists using the ls and filecommands chained together (the ; marks the end of a command,adding another command after is very common): ls -Alh /opt; file/opt/otrsStep 2: Install Additional Perl Modules1. Run the perl script as shown. For any missing modules, follow theinstructions from the output, ensuring you follow the Debian/Ubuntuspecific commands. You should NOT have to run the CPAN shellcommands because the script will find all the required dependencies.Step 3: Create OTRS User1. Ensure that you use the Debian/Ubuntu specific version of thecommands.Step 4: Activate Default Config File1. Follow the given instructions.Step 5: Check if all needed modules are installed1. Run the scripts as indicated.Step 6: Configuring the Apache web server1. Step 6 is not well written and if you do not complete it correctly,nothing will work. On recent Debian and Ubuntu systems with Apache2.4, there is no /etc/apache2/conf.d directory. Instead, do the followingand then proceed with the a2enmod commands:cd /etc/apache2/conf-enabledln -s /opt/otrs/scripts/apache2- httpsd.include.conf zzz_otrs.conf1. Still in Step 6, you will receive an error like the following which youcan ignore: a2enmod versionERROR: Module version does not exist!Step 7: File Permissions1. In Step 7: File Permissions, youll see the shell prompt commandsbegin with bin. You must ensure you are working in the /opt/otrsdirectory for them to work. If you arent, type cd /opt/otrs.Step 8: Database Setup and Basic System1. Be sure to replace the localhost portion of the URL as specified. Forexample, https://localhost/otrs/installer.pl will become https://instructor.itec2210.ca/otrs/installer.pl. Use your studentnumber in place of instructor.2. Continue with the web installer instructions: httpss://doc.otrs.com/doc/manual/admin/6.0/en/html/web-installer.html2. When you reach the Database Settings step in the web installer, clickCheck database settings. You will receive a message like this:Result of database checkCant connect to database, read comment!Cant connect to MySQL server on 127.0.0.1 (111)3. In your terminal, run apt install mysql-server. Next run the command cat/etc/mysql/debian.cnf and copy the username password for thedebian-sys-maint user. Add both to the web installer prompt andcheck database settings again.4. Still on Database Settings, in your terminal do the following:nano /etc/mysql/mysql.conf.d/mysqld.cnfPaste the following 3 lines at the very bottom of the file:max_allowed_packet = 64Mquery_cache_size = 32Minnodb_log_file_size = 256Mcharacter-set-server = utf8collation-server = utf8_general_ciNow restart MySQL to get the new settings to take effect:systemctl restart mysql.service5. Continue the web installer using the MySQL debian-sys-maintpassword that you noted before.6. In the web installer, under step 3/4 (Mail configuration), choose Skipthis Step (bottom right).7. Note the final login details, login, and proceed to creating a user(changing the URL to match your student number as appropriate): https://12345.itec2210.ca/otrs/index.pl?Action=AdminUser;Subaction=AddBe sure to set a password and note it down to relay to me.8. Relay The login details for the evaluation user that you created to me(Jamon) on Slack.Step 9: First login1. You should already be logged in.Step 10: Start the OTRS Daemon1. Start it as instructed.Step 11: Cron jobs for the OTRS user1. You do not need to setup cron. Skip this step. Youre done!Step 12: Youre done!Evaluation Criteria:Requirement Test case GradeA working virtualmachineWe can see your VM in the DigitalOcean control panel 1A working webserver https://${###}.itec2210.ca is usable with a webbrowser1A working databaseserverWe can connect to MySQL or PostgreSQL on your VM 1OTRS is installed on yourVMAn otrs user exists on your VM, and the code hasbeen Downloaded and unpacked1Working login to OTRS We can login to https://${###}.itec2210.ca/otrs with atest user1Final notes:You may choose to use PostgreSQL as a database instead of MySQL. If youwould like some help using it I will be happy to guide you.For anyone Interested in using Docker to run MySQL and OTRS, there is anunofficial image and dockerfiles here: httpss://github.com/juanluisbaptiste/docker-otrs. If you would like to try itout please let me know.如有需要，请加QQ：99515681 或邮箱：99515681@qq.com

“