[abtimoteo]

hi, everybody! can somebody please help me find the error in the lines of code below.

-----

use DBI;
use HTTPD::UserAdmin ();

@SQL = (DBType => "SQL",
Host => "localhost",
Port => "80",
DB => "my_database",
User => "my_username",
Auth => "my_password",
Encrypt => "crypt",
Driver => "mysql", # the default, according to docs, is mSQL
Server => "apache",
UserTable => "www-users",
NameField => "user",
PasswordField => "password"
);

$user = new HTTPD::UserAdmin @SQL;

$user->add('user2', 'password2');

-----

when run, the above produces the following error:

DBD::mysql::st execute 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 '-users WHERE user='user'' at line 1 at /usr/lib/perl5/site_perl/5.6.0/HTTPD/UserAdmin/SQL.pm line 96.
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 '-users WHERE user='user'' at line 1 at addMListU2.pl line 82

thanks in advance!

[C-Security.org]

I think -users is being read as a command rather than a value. Remove the - and see what happens.

[Chas]

I think C-Security nailed it. You either need to enclose your table name in backticks[1] or change the table name:

Code:

 UserTable => '`www-users`',

I'm not too sure how well the backticks will work though.

~Charlie

[1] http://dev.mysql.com/doc/mysql/en/legal-names.html

[abtimoteo]

c-security.org is right. the problem is the "-" in the string. remedied the problem with back ticks, as suggested by charlie. thanks, guys!