MySQL Database

[M0NEX]

Hi Guys,

I've been using Log4OM for a while now, and think it's a cracking program. However, I want to be able to use it for multiple machines and so I'm trying to set up a MySQL database.

I've got the database set up, and all machines connect correctly over the internet (it's on my VPS so I can access from my laptop anywhere). However, when I try to deploy the database, I get the following error...

String 'leighjep_m0nexUser' is too long

And then goes to mention a 16 char limit. The 'User' part isn't part of my username that i've entered and so it looks like a slight error in the coding.

This isn't a problem as such because it's only for the deploy database section - however, can anyone provide the SQL statements that the software actually provides to set up the database. That way I can set it up without having to wait for the next update to fix this.

Regards,
Leigh

[IW3RAB]

Hi,

Execute the backup of log.
Save in separate location.

The base sql is located in %APPDATA%\LogOM\log4om.sql

Copy it in other location
sobstitute on copy every ##DATABASENAME## with a value of max 12 characters

It must be executed with schema admin privilege on MySQL (eg. root)

IT DESTRY A TABLE WITH THE SOME NAME AND ALL DATA ARE LOST

In setup database do not DEPLOY

Insert in filds the values and "Check connection"
"Switch to MySQL"
The user and password are the name of adatabase plus "User" as show in window.
Import the backup and go!

You can create more database and copy data beetwen (eg REPLACE INTO miodatabase.log SELECT * FROM log4om.log

BE CAREFUL !!! ANY EXPERIMENT ON A TEST DATABASE, NOT ON ORIGINAL ONE
PAPER BACKUP OF INSTALLATION PASSWORDS OF MYSQL ARE MANDATORY

Sandro, IW3RAB

[IW3HMH]

The script used, with updated string, is also saved in the LOG folder of your settings folder, where Sandro point you in the previous message.