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
MySQL Database
Re: MySQL Database
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
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
Sandro IW3RAB
- IW3HMH
- Site Admin
- Posts: 2927
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: MySQL Database
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.
Daniele Pistollato - IW3HMH