View Issue Details

IDProjectCategoryView StatusLast Update
0018417phplist applicationAll Otherpublic11-12-17 19:41
Reportersamtuke 
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Version 
Target VersionFixed in Version 
Summary0018417: Upgrade dev.phplist.com demo site to 3.2.6 and database
DescriptionUpgrade the version of phpList running on the public demo site here:

http://dev.phplist.com/lists/admin/

And update the version of the database also.
TagsNo tags attached.

Activities

michiel

21-11-16 21:09

manager   ~0058486


the demo.phplist.org and dev.phplist.com sites are restored from backup every hour.

the cron is on sysadmin-svn/servers/cedar2/cron/hourly/restore-phplistdemodb.sh

it restores from two files:

sysadmin-svn/servers/cedar2/phplistdemodb.sql and
sysadmin-svn/servers/cedar2/phplist-devdb.sql.gz

To update the sites to a later version:

1. go to the site, eg demo.phplist.com/lists/admin/
2. click upgrade
3. dump the database "mysqldump -uroot -p phplistdemodb > phplistdemodb.sql
4, copy the dump to your local machine and overwrite the file in SVN
5. commit the change to SVN

for the DEV one, you need to gzip it, so that it's phplist-devdb.sql.gz

samtuke

19-12-16 14:09

administrator   ~0058562

See also https://hosteddev.phplist.com/dokuwiki/doku.php?id=infra-update-demo-site

samtuke

20-12-16 13:04

administrator   ~0058563

I have updated the demodb file.

For the dev db file, which of the following databases on cedar corresponds to phplist-devdb?:

phosted3svndb
phosted4svndb
phplistdemodb
phplistsvndb

Also, how is the phplist codebase of demo.phplist.org updated? It is currently running phplist 3.2.5.

michiel

20-12-16 21:38

manager   ~0058564

The phplist-devdb is phplistsvndb

I'll check demo.phplist.org

michiel

20-12-16 21:56

manager   ~0058565


the demo is on cedar and uses

/home/phplist/versions/demo/public_html

as the document root. You can move the symlink to any version you want.

samtuke

21-12-16 10:27

administrator   ~0058568

Wiki documentation updated:

https://hosteddev.phplist.com/dokuwiki/doku.php?id=infra-update-demo-site

samtuke

21-12-16 10:29

administrator   ~0058569

The symlink indicated on cedar (/home/phplist/versions/demo/) targets the following folder:

demo -> hosted6/phpList3/

However the demo site is using neither a hosted version of phpList, nor the current hosted6 codebase (v3.2.6-hosted). The demo site is currently v3.2.5. What could explain this?

michiel

28-12-16 11:55

manager   ~0058576

in this case the version is taken from
cat /home/phplist/versions/hosted6/phpList3/VERSION

which says 3.2.5

samtuke

11-12-17 19:41

administrator   ~0059742

Updated phplist-devdb.sql.gz today again