Page 1 of 1
Handclap for the MySQL options
Posted: Tue 26 May 2015 7:51 am
by nitrx
I've setup some old scripts for highcharts on my (local) pi webserver the generated databases by CX are working fine a great compliment from me to the efforts from Steve, I thought this was for future implementetion , when dataeditors are availble I switch over to MX in productionenviroment

Re: Handclap for the MySQL options
Posted: Tue 26 May 2015 7:59 am
by steve
I just fancied an interesting diversion. Doing things like the data editors is going to be long and tedious...

Re: Handclap for the MySQL options
Posted: Tue 26 May 2015 8:05 am
by nitrx
steve wrote:I just fancied an interesting diversion. Doing things like the data editors is going to be long and tedious...

Ohno thats a pitty any suggestions for the most comfortble way to do this meanwhile nano isn't quite helpfull I also miss the headers for the fields in texteditors, but I've patience.
Re: Handclap for the MySQL options
Posted: Tue 26 May 2015 8:11 am
by steve
What particular functions do you need most urgently? Some of it is easier...
Re: Handclap for the MySQL options
Posted: Tue 26 May 2015 8:24 am
by nitrx
Editing the values in the monthly files is most important for me and today.ini the last one is easy and has no priority or isn't needed at all I think an editor for the Monthy files is the most difficult to programm I don't need a realtime.txt editor wrong data are modified or deleted in myphpadmin.
Re: Handclap for the MySQL options
Posted: Tue 26 May 2015 3:55 pm
by sfws
nitrx wrote:Editing the values in the monthly files is most important for me
Ron, I'm probably misunderstanding you, but on first read you seem to be saying you feel priority for MX is to provide an editor that is not available in Cumulus 1. You talk about missing headers and that only applies to log files.
nitrx wrote:I also miss the headers for the fields in texteditors
I assumed you were suggesting priority to edit the monthly log files, but perhaps you mean editing the monthly high and low extreme values of month.ini?
I'm not using MX but I know I find the latter, i.e. ability to edit out the odd silly extremes produced by my Fine Offset (when Cumulus is in catch-up after re-starting) a useful feature in Cumulus 1. But the .ini files have a series of "parameter=value" rows that are easy to identify.
As for my few edits of monthly log files I've not found it that slow to do using a spreadsheet program (I use "Calc") inserting the header columns into the first row before editing the log and then deleting that before saving. But I believe "Cumulus Toolbox" provides an alternative approach for log files that might suit you.
Re: Handclap for the MySQL options
Posted: Tue 26 May 2015 6:02 pm
by nitrx
I mean the Month logfiles and a little less the Dayfile, ini's aren't a problem for me . I can't use Toolbox on the pi and want to run all the weather stuff on the pi only so thats why I prefer editing the values in MX. An option couldt be a samba connection to the pi but haven't succes with that atm and if so I'm not sure I can connect Toobox to the shared /data dir on the pi , maybe I can investigate that I'm thinking just right now.
Re: Handclap for the MySQL options
Posted: Tue 26 May 2015 9:37 pm
by sfws
nitrx wrote:I mean the Month logfiles
Thanks Ron for that clarification, so it is a feature not in Cumulus 1.9.4 that you want prioritised in MX.
Re: Handclap for the MySQL options
Posted: Wed 27 May 2015 8:58 am
by nitrx
sfws wrote:nitrx wrote:so it is a feature not in Cumulus 1.9.4 that you want prioritised in MX.
Yes indeed I should not ask for this atm

But I had CumulusToolbox so there was no need for it.
Re: Handclap for the MySQL options
Posted: Thu 28 May 2015 3:44 pm
by nitrx
I've done some investigations with WinSCP I can ad an editor to files on the pi , Windows notepad and notepad++ will do ! , I tried to ad CumulusToolbox this could work but it needs the cumulus.ini file when I can get a smb connection to my pi on a 'shared cumulusMX dir' but for some stupid reason I cant get a samba connetion to the pi I've tried diffeent thing once I saw the pi in the network has somebody succeed to make a smb from windows 7 to the pi ? If so can you post the samba.conf ? without real passwords ofcourse.
Re: Handclap for the MySQL options
Posted: Thu 28 May 2015 3:59 pm
by steve
This is what I use in my smb.conf. Low security!
[Cumulus]
path = /mnt/samsung/cumulus
public = yes
guest ok = yes
guest only = yes
guest account = nobody
browsable = yes
create mask = 0660
directory mask = 0771
read only = no
Re: Handclap for the MySQL options
Posted: Thu 28 May 2015 4:15 pm
by nitrx
Mine is complicated ..
[global]
netbios name = piserver
server string = Samba file and print server
workgroup = NEPTUNE
security = user
hosts allow = 127. 192.168.0.
interfaces = 127.0.0.1/8 192.168.0.0/24
bind interfaces only = yes
remote announce = 192.168.0.255
remote browse sync = 192.168.0.255
printcap name = cups
load printers = yes
cups options = raw
printing = cups
guest account = smbguest
log file = /var/log/samba/samba.log
max log size = 1000
null passwords = no
username level = 6
password level = 6
encrypt passwords = yes
unix password sync = yes
socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192
local master = no
domain master = no
preferred master = no
domain logons = no
os level = 33
logon drive = m:
logon home = \\%L\homes\%u
logon path = \\%L\profiles\%u
logon script = %G.bat
time server = no
name resolve order = wins lmhosts bcast
wins support = no
wins proxy = no
dns proxy = no
preserve case = yes
short preserve case = yes
client use spnego = no
client signing = no
client schannel = no
server signing = no
server schannel = no
nt pipe support = yes
nt status support = yes
allow trusted domains = no
obey pam restrictions = yes
enable spoolss = yes
client plaintext auth = no
disable netbios = no
follow symlinks = no
update encrypted = yes
pam password change = no
passwd chat timeout = 120
hostname lookups = no
username map = /etc/samba/smbusers
passdb backend = tdbsam
passwd program = /usr/bin/passwd '%u'
passwd chat = *New*password* %n\n *ReType*new*password* %n\n *passwd*changed*\n
add user script = /usr/sbin/useradd -d /dev/null -c 'Samba User Account' -s /dev/null '%u'
add user to group script = /usr/sbin/useradd -d /dev/null -c 'Samba User Account' -s /dev/null -g '%g' '%u'
add group script = /usr/sbin/groupadd '%g'
delete user script = /usr/sbin/userdel '%u'
delete user from group script = /usr/sbin/userdel '%u' '%g'
delete group script = /usr/sbin/groupdel '%g'
add machine script = /usr/sbin/useradd -d /dev/null -g sambamachines -c 'Samba Machine Account' -s /dev/null -M '%u'
machine password timeout = 120
idmap uid = 16777216-33554431
idmap gid = 16777216-33554431
template shell = /dev/null
winbind use default domain = yes
winbind separator = @
winbind cache time = 360
winbind trusted domains only = yes
winbind nested groups = no
winbind nss info = no
winbind refresh tickets = no
winbind offline logon = no
[homes]
comment = Home Directories
path = /home
read only = no
available = yes
browseable = yes
writable = yes
guest ok = no
public = no
printable = no
locking = no
strict locking = no
[netlogon]
comment = Network Logon Service
path = /home/netlogon
read only = no
available = yes
browseable = yes
writable = no
guest ok = no
public = no
printable = no
locking = no
strict locking = no
[profiles]
comment = User Profiles
path = /var/samba/profiles
read only = no
available = yes
browseable = no
writable = yes
guest ok = no
public = no
printable = no
create mode = 0600
directory mask = 0700
locking = no
strict locking = no
[printers]
comment = All Printers
path = /var/spool/samba
browseable = yes
writable = no
guest ok = no
public = no
printable = yes
locking = no
strict locking = no
[pdf-documents]
path = /home/pdf-documents
comment = Converted PDF Documents
available = yes
browseable = yes
writeable = yes
guest ok = yes
locking = no
strict locking = no
[pdf-printer]
path = /tmp
comment = PDF Printer Service
printable = yes
guest ok = yes
use client driver = yes
printing = bsd
print command = /usr/bin/gadmin-samba-pdf %s %u
lpq command =
lprm command =
Cumulus is in /home/pi/cumulus I think mine can be shorter ?
Re: Handclap for the MySQL options
Posted: Thu 28 May 2015 8:18 pm
by nitrx
pitoolbox.jpg
nitrx wrote:I've done some investigations with WinSCP I can ad an editor to files on the pi , Windows notepad and notepad++ will do ! , I tried to ad CumulusToolbox this could work but it needs the cumulus.ini [strike]file when I can get a smb connection to my pi on a 'shared cumulusMX dir' but for some stupid reason I cant get a samba connetion to the pi I've tried diffeent thing once I saw the pi in the network has somebody succeed to make a smb from windows 7 to the pi ? If so can you post the samba.conf ? without real passwords ofcourse.[/strike]
I have a samba share finally (thanks Steve) I can run now in WinSCP by rightclicking a Monthly file on the /data on the raspi by associating CumulusToolbox to that file Toolbox asks for the Cumulus.ini you kan easily browse for this file if you have set you smb browsing the dir so far so good, I openend May but...
As you can see all the data are loaded in the first cel of the date... sigh..
Maybe its because the locale on my win7 PC is Dutch , I can't find any settings what causes this I dont have a phpwebtag parsed but this is for alerts only I think will try this another time I also set WinSCP to Enlish did had no effect for me.
I hope that some users with UK or US locales are helped with my investigations probably it works fine on a windows pc with UK or US locales..