Expat-IT Tech Bits

Home

Contact

Links

Search this site:

Categories:

/ (287)
  Admin/ (122)
    Apache/ (10)
      HTTPS-SSL/ (4)
      PHP/ (3)
      performance/ (2)
    Cherokee/ (1)
    LAN/ (4)
    LVM/ (6)
    Monitoring/ (2)
      munin/ (2)
    SSH/ (6)
    SSL/ (1)
    Samba/ (1)
    VPN-options/ (6)
      OpenVPN/ (1)
      SSH-Proxy/ (3)
      Tinc/ (1)
      sshuttle/ (1)
    backups/ (17)
      SpiderOak/ (1)
      backuppc/ (5)
      dirvish/ (1)
      misc/ (6)
      rdiff-backup/ (1)
      rsync/ (1)
      unison/ (2)
    commandLine/ (24)
      files/ (8)
      misc/ (10)
      network/ (6)
    crontab/ (1)
    databases/ (15)
      MSSQL/ (2)
      MySQL/ (8)
      Oracle/ (3)
      PostgreSQL/ (1)
    dynamicDNS/ (2)
    email/ (11)
      Dovecot/ (1)
      deliverability/ (1)
      misc/ (1)
      postfix/ (7)
      puppet/ (1)
    iptables/ (3)
    tripwire/ (1)
    virtualization/ (9)
      VMware/ (1)
      virtualBox/ (8)
  Coding/ (14)
    bash/ (1)
    gdb/ (1)
    git/ (3)
    php/ (5)
    python/ (4)
      Django/ (2)
  Education/ (1)
  Hosting/ (27)
    Amazon/ (18)
      EBS/ (3)
      EC2/ (10)
      S3/ (1)
      commandline/ (4)
    Godaddy/ (2)
    NearlyFreeSpeech/ (3)
    Rackspace/ (1)
    vpslink/ (3)
  Linux/ (30)
    Android/ (1)
    Awesome/ (3)
    CPUfreq/ (1)
    China/ (2)
    Debian/ (8)
      APT/ (3)
      WPA/ (1)
    audio/ (1)
    encryption/ (3)
    fonts/ (1)
    misc/ (6)
    remoteDesktop/ (1)
    router-bridge/ (3)
  SW/ (45)
    Micro$soft/ (1)
    browser/ (2)
      Chrome/ (1)
      Firefox/ (1)
    business/ (28)
      Drupal/ (9)
      KnowledgeTree/ (6)
      Redmine/ (2)
      SugarCRM/ (7)
      WebERP/ (2)
      WordPress/ (1)
      eGroupware/ (1)
    chat/ (1)
    email/ (1)
    fileSharing/ (2)
      btsync/ (1)
      mldonkey/ (1)
    graphics/ (2)
    research/ (2)
    website/ (6)
      blog/ (6)
        blosxom/ (3)
        rss2email/ (1)
        webgen/ (1)
  Security/ (15)
    IMchat/ (2)
    circumvention/ (2)
    cryptoCurrency/ (1)
    e-mail/ (4)
    greatFirewall/ (1)
    hacking/ (1)
    password/ (1)
    privacy/ (2)
    skype/ (1)
  Services/ (1)
    fileSharing/ (1)
  TechWriting/ (1)
  xHW/ (14)
    Lenovo/ (1)
    Motorola_A1200/ (2)
    Thinkpad_600e/ (1)
    Thinkpad_a21m/ (3)
    Thinkpad_i1300/ (1)
    Thinkpad_x24/ (1)
    USB_audio/ (1)
    scanner/ (1)
    wirelessCards/ (2)
  xLife/ (17)
    China/ (9)
      Beijing/ (5)
        OpenSource/ (3)
    Expatriation/ (1)
    Vietnam/ (7)

Archives:

  • 2016/07
  • 2016/05
  • 2016/02
  • 2016/01
  • 2015/12
  • 2015/11
  • 2015/06
  • 2015/01
  • 2014/12
  • 2014/11
  • 2014/10
  • 2014/09
  • 2014/07
  • 2014/04
  • 2014/02
  • 2014/01
  • 2013/12
  • 2013/10
  • 2013/08
  • 2013/07
  • 2013/06
  • 2013/05
  • 2013/04
  • 2013/02
  • 2013/01
  • 2012/12
  • 2012/10
  • 2012/09
  • 2012/08
  • 2012/07
  • 2012/06
  • 2012/05
  • 2012/04
  • 2012/03
  • 2012/01
  • 2011/12
  • 2011/11
  • 2011/10
  • 2011/09
  • 2011/08
  • 2011/07
  • 2011/06
  • 2011/05
  • 2011/04
  • 2011/02
  • 2010/12
  • 2010/11
  • 2010/10
  • 2010/09
  • 2010/08
  • 2010/07
  • 2010/06
  • 2010/05
  • 2010/04
  • 2010/03
  • 2010/02
  • 2010/01
  • 2009/12
  • 2009/11
  • 2009/10
  • 2009/09
  • 2009/08
  • 2009/07
  • 2009/06
  • 2009/05
  • 2009/04
  • 2009/03
  • 2009/02
  • 2009/01
  • 2008/12
  • 2008/11
  • 2008/10
  • 2008/09
  • Subscribe XML RSS Feed

    Creative Commons License
    This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
    PyBlosxom

    This site has no ads. To help with hosting, crypto donations are accepted:
    Bitcoin: 1JErV8ga9UY7wE8Bbf1KYsA5bkdh8n1Bxc
    Zcash: zcLYqtXYFEWHFtEfM6wg5eCV8frxWtZYkT8WyxvevzNC6SBgmqPS3tkg6nBarmzRzWYAurgs4ThkpkD5QgiSwxqoB7xrCxs

    Sat, 11 Apr 2009


    /SW/business/WebERP: Installing WebERP Language Packs

    From http://www.weberp.org/ download the desired language pack zip files and unzip them in your WebERP instances' "locale" directory. Then change ownership of all files to www-data.

    Make sure the server has a locale for each of the languages you want to use[1]:

    dpkg-reconfigure locales

    Note that there must exist a system locale that is EXACTLY THE SAME as the WebERP locale, ie. zh_CN is NOT the same as zh_CN.utf8.

    Now you can login to WebERP as admin and create users with language defaults for any of the supported languages (which will be apparent in the language drop-down list in the user profile editor).

    Note that I had to install the ttf-arphic-gkai00mp package to get simplified Chinese (zh_CN) working, but Firefox and Opera do not seem to autodetect the GB2132 font well and encoding must be selected manually from the browser menu.

    [1] http://www.weberp.org/FrequentlyAskedQuestions

    posted at: 02:34 | path: /SW/business/WebERP | permanent link to this entry

    Sun, 05 Apr 2009


    /SW/business/WebERP: webERP Installation

    Download the latest version from http://www.weberp.org/

    Create a directory for webERP and copy the downloaded zip file into that directory, and unzip it. (Do not try to unzip from a parent directory, as the last time I tried, webERP unzipped all the files into the current directory, not a subdirectory.)

    Correct the ownership of the files:

    chown -R www-data:www-data ../webERP_3.10.3/

    Have a look at the installation/upgrade notes in webERP_3.10.3/doc/. For new installations, we must create a database and user for the new installation first, manually:

    mysql -p Enter password: mysql> create database apps_weberp; mysql> GRANT ALL on apps_weberp.* TO 'apps_weberp'@'localhost' IDENTIFIED BY 'appsPassword';

    Then edit weberp-new.sql to add a line at the top:

    use apps_weberp;

    where apps_weberp is the name of the database you just created, and then from the shell command line (not from the MySQL command line) run:

    mysql --user=apps_weberp --password='appsPassword' < /var/www/vsc/apps/webERP_3.10.3/sql/mysql/weberp-new.sql

    to import a clean new database (NOT the demo database). A "show tables;" on the new database should now show a lot of tables. Create and edit the config.php:

    cp config.distrib.php config.php
    vi config.php

    Change the following settings in config.php:

    $DefaultLanguage ='en_US';
    $dbuser = 'apps_weberp';
    $dbpassword = 'appsPassword';

    Per [1] Q14, webERP supports having one or more companies using the same instance of webERP. Inside the "companies" directory, there is exactly one subdirectory per company, with the name of the subdirectory exactly the same as the corresponding MySQL database. (I am assuming then that there is only one MySQL user per instance of webERP, and that single user controls all the databases / companies associated with that instance.) The default install has a single subdirectory named "weberpdemo" in the "companies" directory, so this must be renamed to agree with a MySQL database:

    cd /var/www/vsc/apps/webERP_3.10.3/companies
    mv weberpdemo apps_weberp

    The subdirectory names under the "companies" directory are apparently what is used to populate the "company" drop-down menu on the login screen. If the company you select does not have a corresponding database, you will get the error:

    "The company name entered does not correspond to a database on the database server specified in the config.php configuration file"

    which is actually a bit non-sensical because it has nothing to do with the config.php file.

    Now you should be able to login as the admin user with default password of "weberp". Change that password. And in config.php:

    $allow_demo_mode = False;

    to get rid of the password display on the login screen.

    [1] http://www.weberp.org/FrequentlyAskedQuestionsInstallation

    posted at: 09:49 | path: /SW/business/WebERP | permanent link to this entry