Client Day! loose ends

November 9, 2007 – 12:09

Continued from client day.

1. Custom login

  • updated changed files in svn

2. Dedicated server setup

  • Installed awstats:
    • installed tar
    • mkdir var in wwwroot
    • run ./tools/awstats_configure.pl config dir created and virtual server setup
    • edited awstats.www.mysite.com.conf
    • added stats www dir to apache alias
    • process logs: awstats.pl -config=www.mysite.com -update (NOTE: logs should be in combined format -> set in httpd.conf. Cool post about converting common to combined log format)
    • awstats.pl -config=mysite -output -staticlinks > awstats.mysite.html
    • add to cronjob
  • Setup redirects on old server (index.php.bak)
  • Backups: copied backup dirs and directives from other server
  • Added backup to cronjob
  • Setup pw: os, mysql
  • Added info to admin database (mail)

3. Client group delete

  • client deleted group and can’t get it back
  • don’t really know what he means so replied with gen advice
  • ok, problem is clear now, user posted in forum as member of group, but after deleting group, groups were also removed from forum posts of that user. So now those posts don’t have a group. Try to enter groups manually in database
  • yep the prefix_forum_discussions table still contained the old groupids of the user. Did an update and everything works fine now.
  • update prefix_forum_discussions set groupid = newgroupid where userid = xx;
  • Don’t know if this is a bug actually, discuss with Hans?

Sorry, comments for this entry are closed at this time.