<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.30.3">
</HEAD>
<BODY LINK="#0000ff">
El mar, 24-02-2015 a las 09:41 +0100, Laurent RAYSSIGUIER escribió:
<BLOCKQUOTE TYPE=CITE>
Hello,<BR>
</BLOCKQUOTE>
<BR>
Hello Laurent,<BR>
<BR>
<BLOCKQUOTE TYPE=CITE>
If I understand comments in this file : <A HREF="https://dolphin.aspl.es/svn/publico/valvula/plugins/mod-ticket/mod-ticket.c">https://dolphin.aspl.es/svn/publico/valvula/plugins/mod-ticket/mod-ticket.c</A><BR>
<BR>
I think this script can create database structure itself.<BR>
</BLOCKQUOTE>
<BR>
That's right. Every module is designed to automatically install/upgrade existing database<BR>
configuration on valvula start.<BR>
<BR>
<BLOCKQUOTE TYPE=CITE>
Is there a way to launch it with database valvula user and pass to create the tables ?<BR>
</BLOCKQUOTE>
<BR>
You only have to check that your current valvula server is able to access to the database<BR>
by running: valvulad --check-db<BR>
<BR>
After that, you only have to enable the module and start valvula to make it install/create/upgrade<BR>
the database with needed tables...<BR>
<BR>
<BLOCKQUOTE TYPE=CITE>
<BR>
I had create manually domain_ticket and ticket_plan but it seems not work.<BR>
<BR>
Perhaps I need to create others tables to valvula ?<BR>
</BLOCKQUOTE>
<BR>
These tables are never created by the user. This is something dome by the valvula server.<BR>
<BR>
Assuming you are starting valvula, and that it starts without any issue, then, the only reasons<BR>
that could cause databases aren't created are:<BR>
<BR>
1) MySQL user/passwd configured for valvula isn't able to create databases (permission problem)<BR>
or because it not properly working (valvulad --check-db).<BR>
<BR>
2) Or you didn't enable mod-ticket module. See mod-ticket.xml file is present:<BR>
<BR>
>> ls -la /etc/valvula/mods-enabled/<BR>
<BR>
<BLOCKQUOTE TYPE=CITE>
Have you a sample dump sql file to see what I must fill in database ?<BR>
</BLOCKQUOTE>
<BR>
You don't need to go through this process. It is something handled by valvula.<BR>
Let it create these tables for you..that way you not only solves this particular problem you<BR>
are having, but also you are allowing valvula to upgrade your database schema automatically<BR>
without any intervention on future releases...<BR>
<BR>
See this notes before continue,<BR>
Best Regards,<BR>
<BR>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<PRE>
--
Francis Brosnan Blázquez <<A HREF="mailto:francis.brosnan@aspl.es">francis.brosnan@aspl.es</A>>
ASPL
91 134 14 22 - 91 134 14 45 - 91 116 07 57
AVISO LEGAL
Este mensaje se dirige exclusivamente a su destinatario. Los datos
incluidos en el presente correo son confidenciales y sometidos a secreto
profesional, se prohíbe divulgarlos, en virtud de las leyes vigentes. Si
usted no lo es y lo ha recibido por error o tiene conocimiento del mismo
por cualquier motivo, le rogamos que nos lo comunique por este medio y
proceda a destruirlo o borrarlo.
En virtud de lo dispuesto en la Ley Orgánica 15/1999, de 13 de
diciembre, de Protección de Datos de Carácter Personal, le informamos de
que sus datos de carácter personal, recogidos de fuentes accesibles al
público o datos que usted nos ha facilitado previamente, proceden de
bases de datos propiedad de Advanced Software Production Line, S.L.
(ASPL). No obstante, usted puede ejercitar sus derechos de acceso,
rectificación, cancelación y oposición dispuestos en la mencionada Ley
Orgánica, notificándolo por escrito a:
ASPL - Protección Datos, C/Antonio Suárez 10 A-102, 28802, Alcalá de
Henares (Madrid).
</PRE>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>