RE: sql_utils

Ok Lindy, I reinstall everything again using
Net-Policy_before-major-DB-change, and look what happend now when I try to
setup db:

[root@ramon2 root]# np-setup -u root -p administrador
STORE(SNMP::MIB=HASH(0x82182a8) ipspIpHeaderFilterTable HASH(0x825f0b8)) :
write access to the MIB not implemented
DBD::mysql::db do failed: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'I can't get entry node for table ipspIpHeaderFilterTable' at li at
/usr/lib/perl5/site_perl/5.8.0/MIBtoSQL.pm line 105.
STORE(SNMP::MIB=HASH(0x82182a8) ipspIpsoHeaderFilterTable HASH(0x825f0ac)) :
write access to the MIB not implemented
DBD::mysql::db do failed: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'I can't get entry node for table ipspIpsoHeaderFilterTable' at  at
/usr/lib/perl5/site_perl/5.8.0/MIBtoSQL.pm line 105.
STORE(SNMP::MIB=HASH(0x82182a8) ipspTimeFilterTable HASH(0x81445f4)) : write
access to the MIB not implemented
DBD::mysql::db do failed: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'I can't get entry node for table ipspTimeFilterTable' at line 1 at
/usr/lib/perl5/site_perl/5.8.0/MIBtoSQL.pm line 105.
STORE(SNMP::MIB=HASH(0x82182a8) ipspCompoundFilterTable HASH(0x825f178)) :
write access to the MIB not implemented
DBD::mysql::db do failed: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'I can't get entry node for table ipspCompoundFilterTable' at li at
/usr/lib/perl5/site_perl/5.8.0/MIBtoSQL.pm line 105.
STORE(SNMP::MIB=HASH(0x82182a8) ipspSubfiltersTable HASH(0x825f1cc)) : write
access to the MIB not implemented
DBD::mysql::db do failed: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'I can't get entry node for table ipspSubfiltersTable' at line 1 at
/usr/lib/perl5/site_perl/5.8.0/MIBtoSQL.pm line 105.
STORE(SNMP::MIB=HASH(0x82182a8) ipspRuleDefinitionTable HASH(0x825f1f0)) :
write access to the MIB not implemented
DBD::mysql::db do failed: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'I can't get entry node for table ipspRuleDefinitionTable' at li at
/usr/lib/perl5/site_perl/5.8.0/MIBtoSQL.pm line 105.
STORE(SNMP::MIB=HASH(0x82182a8) ipspGroupContentsTable HASH(0x825f214)) :
write
access to the MIB not implemented
DBD::mysql::db do failed: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'I can't get entry node for table ipspGroupContentsTable' at lin at
/usr/lib/perl5/site_perl/5.8.0/MIBtoSQL.pm line 105.
STORE(SNMP::MIB=HASH(0x82182a8) ipspEndpointToGroupTable HASH(0x825f238)) :
write access to the MIB not implemented
DBD::mysql::db do failed: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'I can't get entry node for table ipspEndpointToGroupTable' at l at
/usr/lib/perl5/site_perl/5.8.0/MIBtoSQL.pm line 105.
DBD::mysql::st execute failed: Table 'netpolicy.ipspRuleDefinitionTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspGroupContentsTable'
doesn't
exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspEndpointToGroupTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table
'netpolicy.ipspSaNegotiationParametersTable' doesn't exist at
/usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table
'netpolicy.ipspSaNegotiationParametersTable' doesn't exist at
/usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIpHeaderFilterTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIpHeaderFilterTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIpHeaderFilterTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspEspTransformTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspEspTransformTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspEspTransformTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspEspTransformTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspEspTransformTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspEspTransformTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIpHeaderFilterTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table
'netpolicy.ipspSaNegotiationParametersTable' doesn't exist at
/usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionTable' doesn't
exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeProposalTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeProposalTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeProposalTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeProposalTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeProposalTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeProposalTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeProposalTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeProposalTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeProposalTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeProposalTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeProposalTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeProposalTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeActionProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIpsecTransformsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIpsecActionTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIpsecProposalsTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspCompoundActionTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspCompoundActionTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspSubactionsTable' doesn't
exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspSubactionsTable' doesn't
exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspCompoundActionTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspSubactionsTable' doesn't
exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspSubactionsTable' doesn't
exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspRuleDefinitionTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspGroupContentsTable'
doesn't
exist at /usr/local/bin/np-setupMIBtables line 456.
DBD::mysql::st execute failed: Table 'netpolicy.ipspIkeIdentityTable'
doesn't exist at /usr/local/bin/np-setupMIBtables line 456.

It looks the file np-setupMIBtables have some problems, any idea how can I
fix this?

Thanks

Ramon

-----Mensaje original-----
De: Lindy Foster [mailto:[email protected]]
Enviado el: viernes, 10 de octubre de 2003 11:35a
Para: Ramon Tarruella; net-policy-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Asunto: Re: sql_utils


Ramon, you should not be checking out the most recent
updates. You should only check out up to the database
reorganization (I believe I emailed net-policy-users about this).
In order to get back to that version, do this:

cvs co -r Net-Policy_before-major-DB-change net-policy

It won't matter if you still have the file sql_utils.pm, but should
give you versions of htmlmanager.pm, Makefile.PL, and np-setup
that will work properly for you. You may have to make clean
before you rebuild.

lindy foster
sparta, inc.
weed, ca

At 11:41 PM 10/9/2003 -0400, Ramon Tarruella wrote:
>Hello, I'am having a problem running net-policy since I add the file
>sql_utils and new cvs updates, please check what http error_log says:
>
>DBI connect('database=adminnetpolicy;host=localhost','root',...) failed:
>Access denied for user: 'root@localhost' (Using password: NO) at
>/usr/lib/perl5/site_perl/5.8.0/NetPolicy/sql_utils.pm line 214
>[Thu Oct 09 22:40:48 2003] [error] [client 192.168.0.1] !Connect not ok:
>Access denied for user: 'root@localhost' (Using password: NO)!
>
>Error message says i'am not using password, but it's really strange because
>I specify a password for mysql user and for net-policy np-setup, how can I
>fix this
>
>wait for your answer
>
>Thanks
>
>Ramon
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: SF.net Giveback Program.
>SourceForge.net hosts over 70,000 Open Source Projects.
>See the people who have HELPED US provide better services:
>Click here: http://sourceforge.net/supporters.php
>_______________________________________________
>Net-policy-users mailing list
>Net-policy-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
>https://lists.sourceforge.net/lists/listinfo/net-policy-users





-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
SourceForge.net hosts over 70,000 Open Source Projects.
See the people who have HELPED US provide better services:
Click here: http://sourceforge.net/supporters.php