Menu

How to add CMPCS to existing Compiere 251h

Help
2005-02-03
2013-04-02
  • Paula Lishman International

    I'm assuming that I need to restore the database (.jar file) but I'm not sure what to do with the .tar file?
    Do I use this just like the regular Compiere instal/upgrade?
    Thanks for your help and I'm looking forward to seeing and using this extension!

     
    • Victor Perez Juarez

      Yes, Compiere251h.tgz is as regular Compiere and cmpcs.jar is the dump DB for the Compiere schema.

      Only follwing this step:

      1.-  uncompress tar -zxvf Compiere251h
      2.-  run RUN_Setup.sh
      3.-  jar -xvf cmpcs.jar into ./Data
      4.-  run uitls/RUN_DBRestore.sh
      5.-  run RUN_Compiere2.sh
      6.-  ready

      Victor
      www.e-evolution.com

       
    • Paula Lishman International

      Thanks for the help Victor,
      I'm still having an issue with the RUN_setup.sh though...
      the Test fails on the System password. It will no longer accept the password that I set during install.  Is there something I'm missing?
      Cheers,
      Kevin

       
      • Victor Perez Juarez

        Hi Kevin!

        You must  be sure this:

        1.- connect to your DB and test this sentence (sqlplus system/yourpassword@mydb)
        2.- If this is succesfull you must not have any problem
        3.- if this does not work ,  then check how did you  create your db
        4.- set export PATH=$PATH:$ORACLE_HOME/bin
        5.- set export ORACLE_SID=mydb
        6.- You try test tnsping mydb
        7.- goto 1

         
    • Paula Lishman International

      Thanks again, I was able to solve that issue...unfortunately I'm now having the same problem as RK812's posting above. My output from RUN_DBRestore.sh looks the same and I can't access the client using SuperUser/System, System/System or any variations on them (no caps etc).  Any suggestions?
      Cheers,
      Kevin

       
      • Victor Perez Juarez

        Hi guys!

        I sorry!

        The password for SuperUser is latitude, but all examples are made with GardenAdmin your password is GardenAdmin.

        An the other hand Compiere251h have a bug, this was implemented rowset.jar this does not have a file for other location only for en_US you have to login with English Language , this problem is resolve, if some one is interested I can send you the solution.

        Best Regardas.
        Victor
        victor.perez@e-evolution.com

         
    • Paula Lishman International

      Never mind... I restored my own test database and that fixed the SuperUser problem.
      I look forward to testing out your mods!
      Cheers,
      Kevin

       
    • Tiberiu ATUDOREI

      Hi guys,

      Victor, I'm very impressed by your work.
      You've told us in a previous post that:
      'Yes, Compiere251h.tgz is as regular Compiere'.
      Does this mean that there are no Java source code modifications and the all is done through application dictionary, new tables, stored procedures, triggers and functions?
      If this is the case, can you provide us the PL/SQL code for this in order to include your work in other database ports (mainly in Fyracle and MySQL, possible Sybase ASE)?

      Best regards,

      Tiberiu Atudorei
      tiberiu.atudorei at gmail.com

       

Log in to post a comment.