Difference between revisions of "User:Alvonruff"
Jump to navigation
Jump to search
Line 50: | Line 50: | ||
===Issues to Resolve=== | ===Issues to Resolve=== | ||
* Need a better solution for the python2 makefile issues. | * Need a better solution for the python2 makefile issues. | ||
− | * International characters do not display properly. This is obviously a setting in MySQL somewhere. | + | * International characters do not display properly. This is obviously a setting in MySQL somewhere. Tried ''alter database isfdb character set latin1 collate latin1_swedish_ci;'' to match online ISFDB, but that didn't fix it. |
* Need to decouple the ISFDB from the Wiki. We currently use the account/login capabilities from the Wiki, and share them with the ISFDB. This makes upgrading either side independently more difficult. | * Need to decouple the ISFDB from the Wiki. We currently use the account/login capabilities from the Wiki, and share them with the ISFDB. This makes upgrading either side independently more difficult. | ||
Revision as of 10:47, 28 February 2022
Founder of the ISFDB.
Notes for Installing ISFDB on Ubuntu 20.04
SSH
- Issue: sudo apt-get install openssh-server
Apache 2.4.41
- Issue: uname -a, and note the name of your PC, which we will refer to henceforth as <<PCNAME>>.
- Issue: sudo apt-get install apache2
- Issue: sudo /etc/init.d/apache2 start
- Point your browser to <<PCNAME>>.local - you should see the default apache page.
- Issue: sudo systemctl enable apache2
Mysql 8.0.28-0ubuntu0.20.04.3
- Download a backup file
- Issue: sudo apt install mysql-server
- Issue: sudo mysql
- While in mysql, issue the command: create database isfdb;
- While in mysql, issue the command: use isfdb;
- While in mysql, issue the command: source <<backupfile>>;
Python 2.7.18
- Issue: sudo apt install python2
- Issue: sudo apt install curl
- Issue: curl https://bootstrap.pypa.io/pip/2.7/get-pip.py --output get-pip.py
- Issue: sudo python2 get-pip.py
- Issue: pip2 --version
- Issue: sudo apt-get install python2-dev
- Issue: sudo apt-get install default-libmysqlclient-dev
- Issue: sudo pip2 install mysqlclient
ISFDB Install
- Previously, python2 was installed by default as python on Linux, with python3 optionally installed as python3. Now python2 is installed as python2 and python3 is installed as python3'. As such the current ISFDB makefiles are broken, as they invoke /usr/bin/python, which is not present. This needs to be fixed, but for now change python install.py to python2 install.py across the local.mk files.
- Update common/localdefs.py, by using <<PCNAME>>.local for COOKIEHOST, HTMLHOST, and HTMLLOC, and update HTFAKE and WIKILOC.
- Update INSTALLDIRS to use /usr/lib/cgi-bin, which is the new preferred cgi-bin location
- cd to isfdb directory and issue: make
- cd to /etc/apache2/mods-enabled and issue: sudo ln -s ../mods-available/cgi.load - this will enable the execution of cgi-bin by Apache.
- if you reload the <<PCNAME>>.local in your browser, you should now see the ISFDB frontpage, with a down for maintenance message.
Link ISFDB to MySQL
- Issue: sudo mysql
- While in mysql, issue the command: create user 'isfdb1'@'localhost' identified by 'YourPassword';
- In the ISFDB, update common/localdefs.py to reflect the new USERNAME and PASSWORD.
- cd isfdb and issue make
- Issue: sudo mysql -u root -e "SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';" - this will allow MySQL to use strange dates, like 2010-05-00, which indicates sometime in May.
- Reload the ISFDB page in your browser. You should now see a mostly good web page (minus international character issues).
Issues to Resolve
- Need a better solution for the python2 makefile issues.
- International characters do not display properly. This is obviously a setting in MySQL somewhere. Tried alter database isfdb character set latin1 collate latin1_swedish_ci; to match online ISFDB, but that didn't fix it.
- Need to decouple the ISFDB from the Wiki. We currently use the account/login capabilities from the Wiki, and share them with the ISFDB. This makes upgrading either side independently more difficult.
Reading List
2020
- 06/07 - Paul S. Kemp - Deceived
- 04/19 - Drew Karpyshyn - Revan
- 03/28 - Drew Karpyshyn - Dynasty of Evil
- 03/21 - Drew Karpyshyn - Rule of Two
- 03/14 - Drew Karpyshyn - Path of Destruction
- 03/07 - James Luceno - Darth Plagueis
2019
- 04/03 - James S. A. Corey - Tiamat's Wrath
2018
- 06/10 - N. K. Jemisin - The Obelisk Gate
- 05/27 - N. K. Jemisin - The Fifth Season
- 02/20 - Paolo Bacigalupi - The Windup Girl
- 01/30 - James S. A. Corey - Persepolis Rising
2017
- 12/23 - James S. A. Corey - Babylon's Ashes
- 04/20 - Ann Leckie - Ancillary Mercy
2016
- 10/08 - Pierce Brown - Golden Son
- 09/30 - Pierce Brown - Red Rising
- 09/13 - Ernest Cline - Ready Player One
2015
- 10/18 - Cixin Liu - The Three-Body Problem
- 08/02 - Andy Wier - The Martian: A Novel
- 06/21 - James S. A. Corey - Nemesis Games
- 01/28 - Ann Leckie - Ancillary Sword
2014
- 08/31 - Scott Westerfeld - Behemoth
- 08/22 - Scott Westerfeld - Leviathan
- 08/07 - James S. A. Corey - Cibola Burn
- 07/24 - James S. A. Corey - Abaddon's Gate
- 07/14 - James S. A. Corey - Caliban's War
- 07/04 - James S. A. Corey - Leviathan Wakes
- 06/23 - Larry Correia - Warbound
- 06/13 - Larry Correia - Spellbound
- 06/03 - Larry Correia - Hard Magic
- 05/20 - Stephen King - 11/22/63
- 05/01 - Stephen King - Doctor Sleep
- 04/19 - Hugh Howey - Dust
- 04/11 - Veronica Roth - Allegiant
- 03/27 - Veronica Roth - Insurgent
- 03/17 - Veronica Roth - Divergent
- 03/10 - Hugh Howey - Shift
- 02/10 - Hugh Howey - Wool
- 01/20 - Ann Leckie - Ancillary Justice
2012
- 06/28 - Alastair Reynolds - Pushing Ice
- 03/18 - Suzanne Collins - The Hunger Games
2011
- 12/31 - Alastair Reynolds - Century Rain
- 10/07 - Alastair Reynolds - The Prefect
- 06/23 - Iain M. Banks - Surface Detail
2010
- 12/21 - Alastair Reynolds - Absolution Gap
- 10/10 - Alastair Reynolds - Redemption Ark
- 08/15 - Alastair Reynolds - Chasm City
- 06/15 - Alastair Reynolds - Revelation Space
- 04/08 - Scott Westerfeld - The Killing of Worlds
- 03/23 - Scott Westerfeld - The Risen Empire
2009
- 12/31 - Charlaine Harris - Definitely Dead
- 10/31 - Charlaine Harris - Dead as a Doornail
- 07/10 - Charlaine Harris - Dead to the World
- 04/26 - Charlaine Harris - Club Dead
- 04/22 - Charlaine Harris - Living Dead in Dallas
- 04/16 - Charlaine Harris - Dead Until Dark
- 04/10 - Philip Pullman - The Golden Compass
2008
- 11/03 - Richard Morgan - The Steel Remains.
- 08/29 - Mike Brotherton - Spider Star.
- 08/13 - Charles Stross - Saturn's Children.
- 07/30 - John Meaney - Context.
- 07/18 - John Meaney - Paradox.
- 07/11 - John_Meaney - Bone Song.
- 07/03 - Joel_Shepherd - Crossover.
- 06/03 - David_Gunn - Maximum Offense.
- 04/23 - Richard_Morgan - Thirteen.
- 04/11 - Peter_F._Hamilton - The Dreaming Void.
- 03/27 - Charles_Stross - Halting State.
- 03/23 - Ken_MacLeod - The Execution Channel.
- 03/18 - Iain_M._Banks - Matter.
- 03/03 - Peter_F._Hamilton - The Naked God.
- 02/12 - Peter_F._Hamilton - The Neutronium Alchemist, Part Two: Conflict.
- 02/05 - Peter_F._Hamilton - The Neutronium Alchemist, Part One: Consolidation.
- 01/29 - Greg_Egan - Distress.
- 01/26 - Robert_Charles_Wilson - Axis.
- 01/21 - Peter_F._Hamilton - The Reality Dysfunction, Part Two: Expansion.
- 01/14 - Peter_F._Hamilton - The Reality Dysfunction, Part One: Emergence.
- 01/07 - Robert_A._Heinlein - Glory Road.
2007
- 12/30 - Greg_Bear - The Forge of God.
- 12/23 - Arthur_C._Clarke - Childhood’s End.
- 12/21 - Peter_F._Hamilton - Judas Unchained.
- 12/09 - Peter_F._Hamilton - Pandora's Star.
- 11/26 - David_Gunn - Death's Head.
- 11/23 - Richard_Morgan - Woken Furies.
- 08/18 - Neal_Asher - Africa Zero.
- 08/11 - J._K._Rowling - Harry Potter and the Deathly Hallows.
- 07/31 - Neal_Asher - Hilldiggers.
- 07/01 - Richard_Morgan - Broken Angels.
- 06/25 - Michael_F._Flynn - Eifelheim.
- 04/20 - Peter_Watts - Blindsight.
- 02/04 - John_C._Wright - Orphans of Chaos.
- 01/28 - John_C._Wright - The Golden Transcendence.
- 01/21 - John_C._Wright - The Phoenix Exultant.
- 01/13 - John_C._Wright - The Golden Age.
2006
- 12/24 - Charles_Stross - Singularity Sky.
- 12/10 - Richard_Morgan - Altered Carbon.
- 11/19 - Neal_Asher - Prador Moon.
- 11/11 - Neal_Asher - Polity Agent.
- 11/05 - Neal_Asher - The Voyage of the Sable Keech.
- 10/21 - Neal_Asher - Brass Man.
- 09/29 - Neal_Asher - The Line of Polity.
- 09/12 - Neal_Asher - Cowl.
- 08/27 - Neal_Asher - The Skinner.
- 08/06 - Neal_Asher - Gridlinked.
- 07/09 - Ken_MacLeod - The Cassini Division.
- 07/01 - Ken_MacLeod - Learning the World.
- 06/17 - Robert_Charles_Wilson - Spin.
- 06/01 - John_Scalzi - Old Man's War.
- 05/30 - Ken_MacLeod - The Stone Canal.
- 05/14 - Vernor_Vinge - Rainbow's End.
- 05/07 - Vernor_Vinge - A Deepness Upon the Sky.
- 03/21 - Stephen_King - Cell.
- 01/02 - Iain_M._Banks - Inversions.