Difference between revisions of "User:Alvonruff"

From ISFDB
Jump to navigation Jump to search
 
(107 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
Founder of the ISFDB.  
 
Founder of the ISFDB.  
  
 +
== Large Projects ==
 +
* 2022: Update LAMP stack to latest version (except Python) and enable HTTPS. [https://isfdb.org/wiki/index.php/User:Alvonruff#System_Upgrade_Notes DONE]
 +
* 2023: Update site to Python3. [[User/Alvonruff/Python3_Conversion]]
 +
* 2024: Update charset to UTF-8.
  
−
==Notes for Installing ISFDB on Ubuntu 20.04=
+
== Python3 Status Trackers ==
 +
* [[User:Alvonruff/Debugging_Remarks|Debugging Remarks]]
 +
* Per-File Status: [[User:Alvonruff/Python3_Files|Python3 File Status]]
 +
* ISFDB2 Status: [[User:Alvonruff/Python3_ISFDB2|ISFDB2 Per-Script Status]]
 +
* Mod script test plans and status: [[User:Alvonruff/Python3 ModTests]]
 +
* Formal Tests: [[User:Alvonruff/ISFDB_Tests|Formal ISFDB Test Status]]
  
−
===SSH===
+
== System Upgrade Notes ==
−
* Issue: ''sudo apt-get install openssh-server''
 
  
−
===Apache 2.4.41===
+
Details on how to bring up a LAMP stack (on two different OSs), and how to setup https:
−
* 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===
+
* [[User:Alvonruff/ISFDB_Move]] - Our old hosting service was bought out by a larger hosting service, and they are pushing off our ancient server onto something up to date. We've already been staging such a move at isfdb2.org for a few months, and have most things operational on the new server. The actual move will start sometime after Labor Day.
−
* Download a backup file
+
* [[User:Alvonruff/ISFDB On Ubuntu 20.04]]
−
* Issue: ''sudo apt install mysql-server''
+
* [[User:Alvonruff/ISFDB2_Notes]] - Another Fedora Core variant.
−
* Issue: ''sudo mysql''
+
* [[User:Alvonruff/HTTPS Notes]] - Notes on moving to https on isfdb2
−
* While in mysql, issue the command: ''create database isfdb;''
+
* [[User:Alvonruff/Link Tests]] - Combinations of http/https www/no www links.
−
* While in mysql, issue the command: ''use isfdb;''
 
−
* While in mysql, issue the command: ''source <<backupfile>>;''
 
  
−
===Python 2.7.18===
+
[[User:Alvonruff/Test Page]]
−
* 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===
+
== Other Loose Notes ==
−
* 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.
+
* [[Development/HTTPS]] - Discussion area.
−
* Update INSTALLDIRS to use ''/usr/lib/cgi-bin'', which is the new preferred cgi-bin location
+
* [[User:Alvonruff/The_Charset_Problem]]
−
* cd to isfdb directory and issue: ''make''
+
* [[User:Alvonruff/Notes on MySQLdb]]
−
* cd to ''/etc/apache2/mods-enabled'' and issue: ''sudo ln -s ../mods-available/cgi.load''
+
* [[User:Alvonruff/Test_Pages]]
−
* if you reload the ''<<PCNAME>>''.local in your browser, you should now see the ISFDB frontpage, with a donw for maintenance message.
 
  
−
===Link ISFDB to MySQL===
+
== Articles Concerning Lee Mandelo ==
−
* Issue: ''sudo mysql''
+
* [[User:Alvonruff/A_Post-Mortem_on_the_Lee_Mandelo_Name_Change]]
−
* While in mysql, issue the command: ''create user 'isfdb1'@'localhost' identified by 'YourPassword';''
+
* [[User:Alvonruff/An_Open_Letter_To_The_SF_Community]]
−
* 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 amostly good web page.
 
−
 
 
−
===Issues to Resolve===
 
−
* International characters do not display properly. This is obviously a setting in MySQL somewhere.
 
−
* 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.
 
  
 +
== Obituary Sources ==
 +
* https://sf-encyclopedia.com/timeline.php?rip
 +
* https://ansible.uk/ - (R.I.P. section)
 +
* https://www.sfwa.org/category/excluded-categories/in-memoriam/
  
 
==Reading List==
 
==Reading List==
−
 
+
* [[User:Alvonruff/ReadingLists]]
−
===2020===
 
−
* 06/07 - {{a|Paul S. Kemp}} - [http://www.isfdb.org/cgi-bin/title.cgi?1182116 Deceived]
 
−
* 04/19 - {{a|Drew Karpyshyn}} - [http://www.isfdb.org/cgi-bin/title.cgi?1324012 Revan]
 
−
* 03/28 - {{a|Drew Karpyshyn}} - [http://www.isfdb.org/cgi-bin/title.cgi?1066972 Dynasty of Evil]
 
−
* 03/21 - {{a|Drew Karpyshyn}} - [http://www.isfdb.org/cgi-bin/title.cgi?707949 Rule of Two]
 
−
* 03/14 - {{a|Drew Karpyshyn}} - [http://www.isfdb.org/cgi-bin/title.cgi?184635 Path of Destruction]
 
−
* 03/07 - {{a|James Luceno}} - [http://www.isfdb.org/cgi-bin/title.cgi?1342177 Darth Plagueis]
 
−
 
 
−
===2019===
 
−
* 04/03 - {{a|James S. A. Corey}} - [http://www.isfdb.org/cgi-bin/title.cgi?2500259 Tiamat's Wrath]
 
−
 
 
−
===2018===
 
−
* 06/10 - {{a|N. K. Jemisin}} - [http://www.isfdb.org/cgi-bin/title.cgi?2019754 The Obelisk Gate]
 
−
* 05/27 - {{a|N. K. Jemisin}} - [http://www.isfdb.org/cgi-bin/title.cgi?1878015 The Fifth Season]
 
−
* 02/20 - {{a|Paolo Bacigalupi}} - [http://www.isfdb.org/cgi-bin/title.cgi?1017019 The Windup Girl]
 
−
* 01/30 - {{a|James S. A. Corey}} - [http://www.isfdb.org/cgi-bin/title.cgi?2274988 Persepolis Rising]
 
−
 
 
−
===2017===
 
−
* 12/23 - {{a|James S. A. Corey}} - [http://www.isfdb.org/cgi-bin/title.cgi?2083535 Babylon's Ashes]
 
−
* 04/20 - {{a|Ann Leckie}} - [http://www.isfdb.org/cgi-bin/title.cgi?1896926 Ancillary Mercy]
 
−
 
 
−
===2016===
 
−
* 10/08 - {{a|Pierce Brown}} - [http://www.isfdb.org/cgi-bin/title.cgi?1796923 Golden Son]
 
−
* 09/30 - {{a|Pierce Brown}} - [http://www.isfdb.org/cgi-bin/title.cgi?1664916 Red Rising]
 
−
* 09/13 - {{a|Ernest Cline}} - [http://www.isfdb.org/cgi-bin/title.cgi?1297291 Ready Player One]
 
−
 
 
−
===2015===
 
−
* 10/18 - {{a|Cixin Liu}} - [http://www.isfdb.org/cgi-bin/title.cgi?1779018 The Three-Body Problem]
 
−
* 08/02 - {{a|Andy Wier}} - [http://www.isfdb.org/cgi-bin/title.cgi?1678924 The Martian: A Novel]
 
−
* 06/21 - {{a|James S. A. Corey}} - [http://www.isfdb.org/cgi-bin/title.cgi?1855207 Nemesis Games]
 
−
* 01/28 - {{a|Ann Leckie}} - [http://www.isfdb.org/cgi-bin/title.cgi?1766349 Ancillary Sword]
 
−
 
 
−
===2014===
 
−
* 08/31 - {{a|Scott Westerfeld}} - [http://www.isfdb.org/cgi-bin/title.cgi?1154538 Behemoth]
 
−
* 08/22 - {{a|Scott Westerfeld}} - [http://www.isfdb.org/cgi-bin/title.cgi?1017352 Leviathan]
 
−
* 08/07 - {{a|James S. A. Corey}} - [http://www.isfdb.org/cgi-bin/title.cgi?1724836 Cibola Burn]
 
−
* 07/24 - {{a|James S. A. Corey}} - [http://www.isfdb.org/cgi-bin/title.cgi?1533870 Abaddon's Gate]
 
−
* 07/14 - {{a|James S. A. Corey}} - [http://www.isfdb.org/cgi-bin/title.cgi?1434585 Caliban's War]
 
−
* 07/04 - {{a|James S. A. Corey}} - [http://www.isfdb.org/cgi-bin/title.cgi?1272911 Leviathan Wakes]
 
−
* 06/23 - {{a|Larry Correia}} - [http://www.isfdb.org/cgi-bin/title.cgi?1608403 Warbound]
 
−
* 06/13 - {{a|Larry Correia}} - [http://www.isfdb.org/cgi-bin/title.cgi?1325065 Spellbound]
 
−
* 06/03 - {{a|Larry Correia}} - [http://www.isfdb.org/cgi-bin/title.cgi?1236173 Hard Magic]
 
−
* 05/20 - {{a|Stephen King}} - [http://www.isfdb.org/cgi-bin/title.cgi?1248655 11/22/63]
 
−
* 05/01 - {{a|Stephen King}} - [http://www.isfdb.org/cgi-bin/title.cgi?1554708 Doctor Sleep]
 
−
* 04/19 - {{a|Hugh Howey}} - [http://www.isfdb.org/cgi-bin/title.cgi?1618654 Dust]
 
−
* 04/11 - {{a|Veronica Roth}} - [http://www.isfdb.org/cgi-bin/title.cgi?1632421 Allegiant]
 
−
* 03/27 - {{a|Veronica Roth}} - [http://www.isfdb.org/cgi-bin/title.cgi?1403738 Insurgent]
 
−
* 03/17 - {{a|Veronica Roth}} - [http://www.isfdb.org/cgi-bin/title.cgi?1240075 Divergent]
 
−
* 03/10 - {{a|Hugh Howey}} - [http://www.isfdb.org/cgi-bin/title.cgi?1601930 Shift]
 
−
* 02/10 - {{a|Hugh Howey}} - [http://www.isfdb.org/cgi-bin/title.cgi?1519139 Wool]
 
−
* 01/20 - {{a|Ann Leckie}} - [http://www.isfdb.org/cgi-bin/title.cgi?1632550 Ancillary Justice]
 
−
 
 
−
===2012===
 
−
* 06/28 - {{a|Alastair Reynolds}} - [http://www.isfdb.org/cgi-bin/title.cgi?177864 Pushing Ice]
 
−
* 03/18 - {{a|Suzanne Collins}} - [http://www.isfdb.org/cgi-bin/title.cgi?872410 The Hunger Games]
 
−
 
 
−
===2011===
 
−
* 12/31 - {{a|Alastair Reynolds}} - [http://www.isfdb.org/cgi-bin/title.cgi?153321 Century Rain]
 
−
* 10/07 - {{a|Alastair Reynolds}} - [http://www.isfdb.org/cgi-bin/title.cgi?357261 The Prefect]
 
−
* 06/23 - {{a|Iain M. Banks}} - [http://www.isfdb.org/cgi-bin/title.cgi?1143220 Surface Detail]
 
−
 
 
−
===2010===
 
−
* 12/21 - {{a|Alastair Reynolds}} - [http://www.isfdb.org/cgi-bin/title.cgi?151679 Absolution Gap]
 
−
* 10/10 - {{a|Alastair Reynolds}} - [http://www.isfdb.org/cgi-bin/title.cgi?23075 Redemption Ark]
 
−
* 08/15 - {{a|Alastair Reynolds}} - [http://www.isfdb.org/cgi-bin/title.cgi?21055 Chasm City]
 
−
* 06/15 - {{a|Alastair Reynolds}} - [http://www.isfdb.org/cgi-bin/title.cgi?20131 Revelation  Space]
 
−
* 04/08 - {{a|Scott Westerfeld}} - [http://www.isfdb.org/cgi-bin/title.cgi?24699 The Killing of Worlds]
 
−
* 03/23 - {{a|Scott Westerfeld}} - [http://www.isfdb.org/cgi-bin/title.cgi?23644 The Risen Empire]
 
−
 
 
−
===2009===
 
−
* 12/31 - {{a|Charlaine Harris}} - [http://www.isfdb.org/cgi-bin/title.cgi?185666 Definitely Dead]
 
−
* 10/31 - {{a|Charlaine Harris}} - [http://www.isfdb.org/cgi-bin/title.cgi?168001 Dead as a Doornail]
 
−
* 07/10 - {{a|Charlaine Harris}} - [http://www.isfdb.org/cgi-bin/title.cgi?155475 Dead to the World]
 
−
* 04/26 - {{a|Charlaine Harris}} - [http://www.isfdb.org/cgi-bin/title.cgi?23798 Club Dead]
 
−
* 04/22 - {{a|Charlaine Harris}} - [http://www.isfdb.org/cgi-bin/title.cgi?22767 Living Dead in Dallas]
 
−
* 04/16 - {{a|Charlaine Harris}} - [http://www.isfdb.org/cgi-bin/title.cgi?21381 Dead Until Dark]
 
−
* 04/10 - {{a|Philip Pullman}} - [http://www.isfdb.org/cgi-bin/title.cgi?186525 The Golden Compass]
 
−
 
 
−
===2008===
 
−
* 11/03 - {{a|Richard Morgan}} - [http://www.isfdb.org/cgi-bin/title.cgi?829562 The Steel Remains].
 
−
* 08/29 - {{a|Mike Brotherton}} - [http://www.isfdb.org/cgi-bin/title.cgi?714845 Spider Star].
 
−
* 08/13 - {{a|Charles Stross}} - [http://www.isfdb.org/cgi-bin/title.cgi?829343 Saturn's Children].
 
−
* 07/30 - {{a|John Meaney}} - [http://www.isfdb.org/cgi-bin/title.cgi?21051 Context].
 
−
* 07/18 - {{a|John Meaney}} - [http://www.isfdb.org/cgi-bin/title.cgi?21520 Paradox].
 
−
* 07/11 - {{a|John_Meaney}} - [http://www.isfdb.org/cgi-bin/title.cgi?596525 Bone Song].
 
−
* 07/03 - {{a|Joel_Shepherd}} - [http://www.isfdb.org/cgi-bin/title.cgi?33118 Crossover].
 
−
* 06/03 - {{a|David_Gunn}} - [http://www.isfdb.org/cgi-bin/title.cgi?785377 Maximum Offense].
 
−
* 04/23 - {{a|Richard_Morgan}} - [http://www.isfdb.org/cgi-bin/title.cgi?223581 Thirteen].
 
−
* 04/11 - {{a|Peter_F._Hamilton}} - [http://www.isfdb.org/cgi-bin/title.cgi?694213 The Dreaming Void].
 
−
* 03/27 - {{a|Charles_Stross}} - [http://www.isfdb.org/cgi-bin/title.cgi?659009 Halting State].
 
−
* 03/23 - {{a|Ken_MacLeod}} - [http://www.isfdb.org/cgi-bin/title.cgi?373891 The Execution Channel].
 
−
* 03/18 - {{a|Iain_M._Banks}} - [http://www.isfdb.org/cgi-bin/title.cgi?640181 Matter].
 
−
* 03/03 - {{a|Peter_F._Hamilton}} - [http://www.isfdb.org/cgi-bin/title.cgi?19989 The Naked God].
 
−
* 02/12 - {{a|Peter_F._Hamilton}} - [http://www.isfdb.org/cgi-bin/title.cgi?11678 The Neutronium Alchemist, Part Two: Conflict].
 
−
* 02/05 - {{a|Peter_F._Hamilton}} - [http://www.isfdb.org/cgi-bin/title.cgi?11677 The Neutronium Alchemist, Part One: Consolidation].
 
−
* 01/29 - {{a|Greg_Egan}} - [http://www.isfdb.org/cgi-bin/title.cgi?3349 Distress].
 
−
* 01/26 - {{a|Robert_Charles_Wilson}} - [http://www.isfdb.org/cgi-bin/title.cgi?389901 Axis].
 
−
* 01/21 - {{a|Peter_F._Hamilton}} - [http://www.isfdb.org/cgi-bin/title.cgi?5788 The Reality Dysfunction, Part Two: Expansion].
 
−
* 01/14 - {{a|Peter_F._Hamilton}} - [http://www.isfdb.org/cgi-bin/title.cgi?5787 The Reality Dysfunction, Part One: Emergence].
 
−
* 01/07 - {{a|Robert_A._Heinlein}} - [http://www.isfdb.org/cgi-bin/title.cgi?1867 Glory Road].
 
−
 
 
−
===2007===
 
−
* 12/30 - {{a|Greg_Bear}} - [http://www.isfdb.org/cgi-bin/title.cgi?1910 The Forge of God].
 
−
* 12/23 - {{a|Arthur_C._Clarke}} - [http://www.isfdb.org/cgi-bin/title.cgi?180477 Childhood’s End].
 
−
* 12/21 - {{a|Peter_F._Hamilton}} - [http://www.isfdb.org/cgi-bin/title.cgi?180477 Judas Unchained].
 
−
* 12/09 - {{a|Peter_F._Hamilton}} - [http://www.isfdb.org/cgi-bin/title.cgi?154552 Pandora's Star].
 
−
* 11/26 - {{a|David_Gunn}} - [http://www.isfdb.org/cgi-bin/title.cgi?221441 Death's Head].
 
−
* 11/23 - {{a|Richard_Morgan}} - [http://www.isfdb.org/cgi-bin/title.cgi?158032 Woken Furies].
 
−
* 08/18 - {{a|Neal_Asher}} - [http://www.isfdb.org/cgi-bin/title.cgi?172132 Africa Zero].
 
−
* 08/11 - {{a|J._K._Rowling}} - [http://www.isfdb.org/cgi-bin/title.cgi?231461 Harry Potter and the Deathly Hallows].
 
−
* 07/31 - {{a|Neal_Asher}} - [http://www.isfdb.org/cgi-bin/title.cgi?198469 Hilldiggers].
 
−
* 07/01 - {{a|Richard_Morgan}} - [http://www.isfdb.org/cgi-bin/title.cgi?23374 Broken Angels].
 
−
* 06/25 - {{a|Michael_F._Flynn}} - [http://www.isfdb.org/cgi-bin/title.cgi?208301 Eifelheim].
 
−
* 04/20 - {{a|Peter_Watts}} - [http://www.isfdb.org/cgi-bin/title.cgi?186521 Blindsight].
 
−
* 02/04 - {{a|John_C._Wright}} - [http://www.isfdb.org/cgi-bin/title.cgi?171874 Orphans of Chaos].
 
−
* 01/28 - {{a|John_C._Wright}} - [http://www.isfdb.org/cgi-bin/title.cgi?155221 The Golden Transcendence].
 
−
* 01/21 - {{a|John_C._Wright}} - [http://www.isfdb.org/cgi-bin/title.cgi?23833 The Phoenix Exultant].
 
−
* 01/13 - {{a|John_C._Wright}} - [http://www.isfdb.org/cgi-bin/title.cgi?33273 The Golden Age].
 
−
 
 
−
===2006===
 
−
* 12/24 - {{a|Charles_Stross}} - [http://www.isfdb.org/cgi-bin/title.cgi?23623 Singularity Sky].
 
−
* 12/10 - {{a|Richard_Morgan}} - [http://www.isfdb.org/cgi-bin/title.cgi?23041 Altered Carbon].
 
−
* 11/19 - {{a|Neal_Asher}} - [http://www.isfdb.org/cgi-bin/title.cgi?181706 Prador Moon].
 
−
* 11/11 - {{a|Neal_Asher}} - [http://www.isfdb.org/cgi-bin/title.cgi?186461 Polity Agent].
 
−
* 11/05 - {{a|Neal_Asher}} - [http://www.isfdb.org/cgi-bin/title.cgi?186256 The Voyage of the Sable Keech].
 
−
* 10/21 - {{a|Neal_Asher}} - [http://www.isfdb.org/cgi-bin/title.cgi?186257 Brass Man].
 
−
* 09/29 - {{a|Neal_Asher}} - [http://www.isfdb.org/cgi-bin/title.cgi?23373 The Line of Polity].
 
−
* 09/12 - {{a|Neal_Asher}} - [http://www.isfdb.org/cgi-bin/title.cgi?167798 Cowl].
 
−
* 08/27 - {{a|Neal_Asher}} - [http://www.isfdb.org/cgi-bin/title.cgi?23061 The Skinner].
 
−
* 08/06 - {{a|Neal_Asher}} - [http://www.isfdb.org/cgi-bin/title.cgi?23591 Gridlinked].
 
−
* 07/09 - {{a|Ken_MacLeod}} - [http://www.isfdb.org/cgi-bin/title.cgi?12233 The Cassini Division].
 
−
* 07/01 - {{a|Ken_MacLeod}} - [http://www.isfdb.org/cgi-bin/title.cgi?171778 Learning the World].
 
−
* 06/17 - {{a|Robert_Charles_Wilson}} - [http://www.isfdb.org/cgi-bin/title.cgi?158099 Spin].
 
−
* 06/01 - {{a|John_Scalzi}} - [http://www.isfdb.org/cgi-bin/title.cgi?157782 Old Man's War].
 
−
* 05/30 - {{a|Ken_MacLeod}} - [http://www.isfdb.org/cgi-bin/title.cgi?5802 The Stone Canal].
 
−
* 05/14 - {{a|Vernor_Vinge}} - [http://www.isfdb.org/cgi-bin/title.cgi?181278 Rainbow's End].
 
−
* 05/07 - {{a|Vernor_Vinge}} - [http://www.isfdb.org/cgi-bin/title.cgi?19493 A Deepness Upon the Sky].
 
−
* 03/21 - {{a|Stephen_King}} - [http://www.isfdb.org/cgi-bin/title.cgi?180458 Cell].
 
−
* 01/02 - {{a|Iain_M._Banks}} - [http://www.isfdb.org/cgi-bin/title.cgi?12636 Inversions].
 

Latest revision as of 11:02, 16 September 2023

Founder of the ISFDB.

Large Projects

Python3 Status Trackers

System Upgrade Notes

Details on how to bring up a LAMP stack (on two different OSs), and how to setup https:

User:Alvonruff/Test Page

Other Loose Notes

Articles Concerning Lee Mandelo

Obituary Sources

Reading List

Retrieved from "https://isfdb.org/wiki/index.php?title=User:Alvonruff&oldid=671004"