Bug 10505 - smbtad -T fails with "Error creating database tables" using mysql driver.
smbtad -T fails with "Error creating database tables" using mysql driver.
Status: ASSIGNED
Product: smbta
Classification: Unclassified
Component: smbtad
unspecified
All Linux
: P5 normal
: ---
Assigned To: Holger Hetterich
:
Depends on: 9538
Blocks:
  Show dependency treegraph
 
Reported: 2014-03-19 11:43 UTC by itsmekeuh
Modified: 2014-04-08 12:39 UTC (History)
0 users

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description itsmekeuh 2014-03-19 11:43:47 UTC
System information:
uname -a
Linux smbta 2.6.32-431.3.1.el6.x86_64 #1 SMP Fri Jan 3 21:39:27 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
MySQL 5.1.73
smbtad-1.2.6

running an strace on the smbtad, I could figure out that MySQL returns an SQL error.
Looking at the code it is trying to  run the following query:
CREATE TABLE data (vfs_id integer,username varchar,usersid varchar,share varchar,domain varchar,timestamp timestamp,string1 varchar, length integer, result bigint, string2 varchar)

varchar fields need a max length in MySQL, 
Query is accepted if I change all the varchar's to varchar(N)