[OpenVCP] MySQL and SQLITE3

[erik pepermans]

Hi,

Apparently openvcpd does strange things when run as a daemon. If I use the
option -v it seems to work - but only after a 'make install' ? :

[root at ns daemon]# openvcpd -v
2008-04-24 19:33:30 INFO         -       OpenVCP Daemon 0.4 rc1 r613 started
2008-04-24 19:33:30 DEBUG        -       
Options:

IP Address: 192.168.6.1
Port Number: 6000
Logfile: /var/log/openvcp.log
Logfile: 0
StartXID: 7000
VServer Root: /vservers
VServer Configs: /etc/vservers
VServer Backups: /vservers/backups
VServer Images: /vservers/images
VServer Run Dir: /var/run/vservers
Vserver Cache Dir: /etc/vservers/.defaults/cachebase
Ifaces: eth0
IfbDev: ifb0
AdminEmail: peperjam at skynet.be


2008-04-24 19:33:30 DEBUG        -       Linux-VServer VCI Version: 20302
2008-04-24 19:33:30 DEBUG        -       Attaching to IFace: eth0
2008-04-24 19:33:30 DEBUG        -       SQL QUERY: INSERT OR REPLACE INTO
node_hour_traffic VALUES(4, 19, 24, 2008, 0, 0, 0)
2008-04-24 19:33:30 DEBUG        -       SQL QUERY: SELECT
"in","out","total" FROM node_traffic WHERE (day=24 and month=4 and
year=2008)
2008-04-24 19:33:30 DEBUG        -       Node Traffic Result: 24, 4, 2008, @
0, 0, 0
2008-04-24 19:33:30 DEBUG        -       SQL QUERY: INSERT OR REPLACE INTO
node_traffic VALUES(4, 24, 2008, 0, 0, 0)
2008-04-24 19:33:30 DEBUG        -       Next Refresh: [1590 s]


When starting as a daemon, apparently it tries to start two processes ?

My logfile then shows :

Options:

IP Address: 192.168.6.1
Port Number: 6000
Logfile: /var/log/openvcp.log
Logfile: 0
StartXID: 7000
VServer Root: /vservers
VServer Configs: /etc/vservers
VServer Backups: /vservers/backups
VServer Images: /vservers/images
VServer Run Dir: /var/run/vservers
Vserver Cache Dir: /etc/vservers/.defaults/cachebase
Ifaces: eth0
IfbDev: ifb0
AdminEmail: peperjam at skynet.be


2008-04-24 19:42:00 DEBUG        -       Linux-VServer VCI Version: 20302
2008-04-24 19:42:00 ERROR        -       Can't open database: (unable to
open database file)
2008-04-24 19:43:24 INFO         -       OpenVCP Daemon 0.4 rc1 r613 started
2008-04-24 19:43:24 DEBUG        -
Options:

IP Address: 192.168.6.1
Port Number: 6000
Logfile: /var/log/openvcp.log
Logfile: 0
StartXID: 7000
VServer Root: /vservers
VServer Configs: /etc/vservers
VServer Backups: /vservers/backups
VServer Images: /vservers/images
VServer Run Dir: /var/run/vservers
Vserver Cache Dir: /etc/vservers/.defaults/cachebase
Ifaces: eth0
IfbDev: ifb0
AdminEmail: peperjam at skynet.be


2008-04-24 19:43:24 DEBUG        -       Linux-VServer VCI Version: 20302
2008-04-24 19:43:24 ERROR        -       Can't open database: (unable to
open database file)

Brgds
Erik


-----Oorspronkelijk bericht-----
Van: openvcp-bounces at lists.openvcp.org
[mailto:openvcp-bounces at lists.openvcp.org] Namens Cryptronic
Verzonden: woensdag 23 april 2008 7:35
Aan: openvcp at lists.openvcp.org
Onderwerp: Re: [OpenVCP] MySQL and SQLITE3


Am Dienstag, 22. April 2008 23:03:21 schrieb erik pepermans:
> Hi,
>
> I finally installed OpenVCP on my Centos machine. The web interface 
> works fine; I can logon etc.
>
> Now the daemon returns :
>
> 2008-04-22 21:15:21 INFO         -       OpenVCP Daemon 0.4 rc1 r613
> started 2008-04-22 21:15:21 DEBUG        -
> Options:
>
> IP Address: 192.168.6.1
> Port Number: 6000
> Logfile: /var/log/openvcp.log
> Logfile: 0
> StartXID: 7000
> VServer Root: /vservers
> VServer Configs: /etc/vservers
> VServer Backups: /vservers/backups
> VServer Images: /vservers/images
> VServer Run Dir: /var/run/vservers
> Vserver Cache Dir: /etc/vservers/.defaults/cachebase
> Ifaces: eth1
> IfbDev: ifb0
> AdminEmail: peperjam at skynet.be
>
>
> 2008-04-22 21:15:21 DEBUG        -       Linux-VServer VCI Version: 20302
> 2008-04-22 21:15:21 ERROR        -       Can't open database: (unable to
> open database file)
>
> Can you please explain what 'database file' is meant here and where 
> you should specify it. I assume it's the same mysql database the 
> webinterface uses. Nevertheless I can only find traces to an sqlite3 
> database.
>
> Brgds
> Erik

This is the daemon's own database which is normaly stored 
in /usr/share/openvcpd/ and is named db.

Does this path exist?

Best regards

_______________________________________________
OpenVCP mailing list
OpenVCP at lists.openvcp.org
http://lists.openvcp.org/cgi-bin/mailman/listinfo/openvcp

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.