On 7/11/2012 10:32 PM, Thomas Eckardt wrote:
>> Is there
> something else I need to set to be able to find the problem?
Is there a different setting I need to use to be able to see database
error messages besides "DatabaseDebug"? Do I also need to turn on "debug"?
>
> - you need to know how Tie::RDBM is working
Looking at the Tie::RDBM docs, it looks like if the table is defined,
the module will use it - otherwise it will attempt to create the table
using a driver-to-command table. So if I have the table pre-defined
(properly?!), it should work?
> - you need to know Firebird specific DBD driver settings
Do I need to set something beyond the driver/database
name/username/password in ASSP?
> - you need to know the Firebird specific data types to be used with
> Tie::RDBM
My mysql tables were created with types "varbinary(254)",
"varbinary(255)", and "tinyint(4)". I've created my Firebird tables
using "varchar(254) character set octets collate octets", "varchar(254)
character set octets collate octets", and "smallint"
> - you possibly need to change (add) Firebird specific settings in the
> assp.pl (sub init)
> - you have to define the import SQL statement for Firebird in the
> assp_db_import.cfg file
>> I'm seeing ASSP errors on startup relating to illegal tokens
> ASSP uses Tie:RDBM -> used ANSI SQL
>
> Without any Firebird specific changes the following data types are used:
>
> pkey pvalue pfrozen
> varbinary(254) varbinary(255) integer
>
> $Tie::RDBM::CAN_BIND{Firebird} is undef
>
> the import definitions from assp_db_import.cfg (used in sub importDB)
> are the default ANSI-SQL:
>
> $sql_sm="ALTER TABLE $mysqlTable DROP CONSTRAINT $PK_NAME"|$sql_sm="ALTER
> TABLE $mysqlTable ADD CONSTRAINT $PK_NAME PRIMARY KEY
> (pkey)"|$sql_sm="INSERT INTO $mysqlTable SELECT
> "|$sql_sm="CONVERT($pkey_TYPE_NAME,$k),CONVERT($pvalue_TYPE_NAME,$v),CONVERT($pfrozen_TYPE_NAME,\'$f\')"|$sql_sm="UNION
> ALL SELECT "|2000
>
I've added the following to assp_db_import.cfg:
Firebird|*|$sql_sm="ALTER TABLE $mysqlTable DROP CONSTRAINT
$PK_NAME"|$sql_sm="ALTER TABLE $mysqlTable ADD CONSTRAINT $PK_NAME
PRIMARY KEY (pkey)"|$sql_sm="INSERT INTO $mysqlTable SELECT
"|$sql_sm="CONVERT($pkey_TYPE_NAME,$k),CONVERT($pvalue_TYPE_NAME,$v),CONVERT($pfrozen_TYPE_NAME,\'$f\')"|$sql_sm="UNION
ALL SELECT "|2000
--
Daniel
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Assp-test mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-test
