VM LiveView Lite for rFactor & rFactor2

Discussion in 'Plugins' started by Frank Geyer, Feb 20, 2012.

  1. fastorro

    fastorro Registered

    Joined:
    Oct 8, 2010
    Messages:
    79
    Likes Received:
    0
    thanks, tomorrow i will test it.
     
  2. fastorro

    fastorro Registered

    Joined:
    Oct 8, 2010
    Messages:
    79
    Likes Received:
    0
  3. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Hi Augusto,

    right now I am taking a break from all this. But what u can do is the following:

    - Create a central database, e.g. `vmliveall` with a `hotlaps` table only.
    - Create a stored procedure for each other `vmliveview` databases which is triggered when a lap within the `hotlaps` table is inserted or updated, which will update the `hotlaps` table within the `vmliveall` databases accordingly to display your desired results.

    Hope this helps.

    Cheers
    Frank
     
  4. Busy

    Busy Registered

    Joined:
    Nov 18, 2010
    Messages:
    9
    Likes Received:
    0
    Hi Frank,

    I updated liveview plugin from 20120506.inofficial to 20130411.utf8:

    1º Replaced rFactorSL and it works well
    2º I have replaced old VMHotlaps.dll on plugins folder, currentscoring.xsl on VMHotlaps folder and copied new VMHotlaps.ini into root rF folder.
    3º Apache server: I have deleted all files from old version and copied new files (and applied db access configuration).

    You can view monitor.php here: http://www.olimpusf1.es/index.php?option=com_wrapper&view=wrapper&Itemid=502

    rFactor2 server and rFactorSL is working but Liveview shows "No Session Data". Hotlaps and track view works well.

    I need some help!

    Thanks.
     
  5. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Hi Busy,

    what does the logs say?

    Thanx & Cheers
    Frank
     
  6. Busy

    Busy Registered

    Joined:
    Nov 18, 2010
    Messages:
    9
    Likes Received:
    0
    Hi Frank,

    Logs say "Nothing", I mean... on logs folder I only have 2 files:

    20130516.inc.mysqli.conn.php.error.log

    "2013-05-16 01:32:19";"Connect to SQL Server";"Error No: (1045) Error Msg: (Access denied for user 'vmliveview01dbw'@'localhost' (using password: YES))";"REMOTE_ADDR: 83.50.5.85";"HTTP_USER_AGENT: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)"

    20130516.inc.requests.php.error.log

    "2013-05-16 01:32:19";"Connect to sql server";"ERROR: (Access denied for user 'vmliveview01dbw'@'localhost' (using password: YES))";"REMOTE_ADDR: 83.50.5.85";"HTTP_USER_AGENT: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)"

    But those errors ocurred because I did not configure correctly my user, dbname, etc, and now it is totally configured and working.

    You can see error date "2013-05-16 01:32:19", exactly when I installed the plugin.

    Thanks for your help,

    Cheers!
     
  7. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Hi Busy,

    ok, can u then send me the log from the loader please?

    Thanx & Cheers
    Frank
     
  8. Busy

    Busy Registered

    Joined:
    Nov 18, 2010
    Messages:
    9
    Likes Received:
    0
    200 MB of log file !!!

    This is the error I have read into...

    Scoring was laoded for the first time from (file://C:/serv/olimpusf1rf2/VMHotlaps/CurrentScoring.xml).
    2013-05-16 01:46:20.370 (+02:00) | ERROR | {SqlSessionUpdateStatus} Unknown column 'ServerState' in 'field list' - Query: (UPDATE `sessioninfos` SET `ServerState` = '0', `SessionStart` = '0' WHERE `ID` = '1')

    Thanks.
     
  9. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Hi Busy,

    it looks like the database doesn't match the loader version. Did u do an upgrade of the db? For testing, just create a new db with a different name and try to make it work this way ...

    Thanx & Cheers
    Frank
     
  10. Busy

    Busy Registered

    Joined:
    Nov 18, 2010
    Messages:
    9
    Likes Received:
    0
    I created a new db and it works well :cool: but do not show previous hotlaps records now :eek:
     
  11. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    You can either update the old db with the update script ..\mysql\vmliveview.db.update.2004.sql or transfer the records from the old db to the new db in different ways (e.g. table data export/import, insert into (select), ...) ...
     
  12. Busy

    Busy Registered

    Joined:
    Nov 18, 2010
    Messages:
    9
    Likes Received:
    0
    Thank you very much, it works!

    I can help you with spanish lang, it will be interesting for spanish championships.

    Cheers!
     
  13. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Glad u made it. :)

    Just use the ..\lang\en.php as a template for translation.

    Thanx & Cheers
    Frank
     
  14. Busy

    Busy Registered

    Joined:
    Nov 18, 2010
    Messages:
    9
    Likes Received:
    0
    View attachment 7722

    I think this is a logical translation. Hope this helps...

    Cheers.
     
  15. Bruno Goulier

    Bruno Goulier Registered

    Joined:
    Oct 5, 2010
    Messages:
    6
    Likes Received:
    0
    hi

    is it possible to use those scripts on separates serveurs ?

    I explain :

    I do not have a webserver apache+mysql on the game server (which host the rfactor race), and i would like to use the vmliveview (the php files) on a separate (external) web server.

    Is it possible ? Thank for your answer :)
     
  16. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Hi Bruno,

    Let the loader (rFactorSL.exe) run on the game server and configure the mysql part of the loader to point to the remote mysql+web-server.

    Hope this helps ...

    Cheers
    Frank
     
  17. Pascal Martin

    Pascal Martin Registered

    Joined:
    Apr 3, 2013
    Messages:
    46
    Likes Received:
    0
  18. Pascal Martin

    Pascal Martin Registered

    Joined:
    Apr 3, 2013
    Messages:
    46
    Likes Received:
    0
    Hello Frank,
    I have a trouble connecting MySQL with version 2.1 that I do not have the version 2.0!
    Also with rfactorSL !!!

    Strange, you have an idea ?

    Pascal
     
  19. Frank Geyer

    Frank Geyer Registered

    Joined:
    Oct 5, 2010
    Messages:
    222
    Likes Received:
    3
    Hi Pascal,

    without any logs from the loader it will be a little hard for me to tell you what might causes your problems.

    Cheers
    Frank
     
  20. Pascal Martin

    Pascal Martin Registered

    Joined:
    Apr 3, 2013
    Messages:
    46
    Likes Received:
    0
    Sorry Frank,

    2013-06-05 22:31:10.906 (+02:00) | ERROR | {SqlConnOpen} Authentication to host 'xxx.xxx.xxx.xxx' for user 'mysqluser' using method 'mysql_native_password' failed with message: Access denied for user 'mysqluser'@'%' to database 'vmliveview06'

    For rfactor 1 the config for rfactorsl is identical

    Edit : I have solved my Problem, bad version of sql file.
     
    Last edited by a moderator: Jun 5, 2013

Share This Page