Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

1.33 Bugs?

Bugs
2005-02-04
2013-04-15
  • John Fairbairn
    John Fairbairn
    2005-02-04

    Well, I think I ran into a few bugs, hopefully I'm just an idiot and there's something simple I'm doing wrong. But this is clean install #3 and same errors every time...
    [Thu Feb 03 03:37:03 2005] [error] [client xx.xx.xx.xx] 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 'ssl), referer: https://xxxxx.com/cgi-bin/admin.cgi?do=add+server
    [Thu Feb 03 03:37:03 2005] [error] [client xx.xx.xx.xx] VALUES ('2','||','100','0','3096','0','0','10240','0','0', at /usr/
    lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/Mysql.pm line 167., referer: https://xxxx.com/cgi-bin/admin.cgi?do=ad
    d+server

    I also tried it without ssl and got....

    [Thu Feb 03 03:54:40 2005] [error] [client xx.xx.xx.xx] 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 'ssl='no' WHERE server='2'
    ' at line 2 at /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/Mysql.pm line 167., referer: https://xxxx.com/cgi
    -bin/admin.cgi?do=Edit+Server&id=2

    next one.....

    [Thu Feb 03 04:31:59 2005] [error] [client xx.xx.xx.xx] DBD::mysql::st execute failed: Column count doesn't match value cou
    nt at row 1 at /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/Mysql.pm line 167., referer: https://xxx.com/cgi
    -bin/admin.cgi?do=add+client

    As I said, hopefully it's my error. The first one I'm guessing is probably a missing ' somewhere and the second probably stems from leaving the po box field blank. Dunno, just a guess.
    Any help appreciated. Thanks.
    linux_terror

     
    • John Fairbairn
      John Fairbairn
      2005-02-04

      oh, just in case ya need em ....
      specs....
         MySQL-4.0.23-standard, CentOS 3.4, Perl 5.8.0

      Thanks again.

       
      • If you originally installed and created the database with 1.32 (i think you did) then make sure you run update program in admin package of 1.33 to modify the database.

         
    • I'm afraid this is where error messages get a bit strange. Since the query statements are incomplete I'll probably need to take a closer look at your setup, mainly the database.

      I guess for starters forward a dump of the database your using for administration to me via the sourceforge webpage for <a href="http://sourceforge.net/sendmessage.php?touser=77464">redragon</A>

       
    • Okay we have some mysql 4x issues to deal with here.  This will take some doing.

      It seems the term ssl is a reserved word in 4x (unlike 3x). This is easy for me to fix.

      The second problem seems to be a problem with the permissions table of 4x.  It most likely has more fields than that of 3x so I'm gonna have to figure out a compromise fix for this problem.

       
    • Okay all the issues were compatibility issues with MySQL 4x.

      I have updated the software so that you dont have any more problems (with this part at least) and MySQL 4x.

      All you need is the admin package.  Download it and replace your admin.cgi with the admin.cgi ver 1.34.

      Let me know if you run into any other issues as there may be more compatibility issues with 4x hiding in all that code somewhere.

       
    • John Fairbairn
      John Fairbairn
      2005-02-04

      Still getting ... Unknown column 'pobox' in 'field list' when I try to add a domain. The ssl bug seems to be fixed though.

      [Thu Feb 03 12:55:50 2005] [error] [client xx.xx.xx.xx] DBD::mysql::st execute failed: Unknown column 'pobox' in 'field list' at /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/Mysql.pm line 167., referer: https://xxx.com/cgi-bin/admin.cgi?do=nav

      This was off of another clean install with the 1.34 admin.cgi.

       
    • John Fairbairn
      John Fairbairn
      2005-02-04

      Ok, Just added a field named 'pobox' to the 'users' table and got  Unknown column 'address' in 'field list,' so I added a field named 'address' and now I at least have the Add Domain Account form up. Seems the table structure is wrong when the DB is created initially. I'll post what happens with the form when I add a domain.

      linux_terror

       
    • John Fairbairn
      John Fairbairn
      2005-02-04

      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] Bareword found where operator expected at  program.cfg line 2, near "/vhosts/proteus2"
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] \t(Missing operator before proteus2?)
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] Bareword found where operator expected at  program.cfg line 3, near "//proteus2"
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] \t(Missing operator before proteus2?)
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] Semicolon seems to be missing at program. cfg line 4.
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] Array found where operator expected at pr ogram.cfg line 5, at end of line
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] Bareword found where operator expected at  program.cfg line 6, near "//proteus2"
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] \t(Missing operator before proteus2?)
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] Array found where operator expected at pr ogram.cfg line 13, at end of line
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] Semicolon seems to be missing at program. cfg line 20.
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] Semicolon seems to be missing at program. cfg line 21.
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] syntax error at program.cfg line 2, near "/vhosts/proteus2"
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] Compilation failed in require at /vhosts/ proteus2.com/cgi-bin/upgrade1.33.cgi line 4.
      [Thu Feb 03 14:46:06 2005] [error] [client 192.168.0.1] Premature end of script headers: upgrade1 .33.cgi

       
    • John Fairbairn
      John Fairbairn
      2005-02-04

      This panel isn't gonna work at all with apache2 as is either, the vhost template is completely different in apache2

      Port was replaced with Listen in Apache 2.0
      Invalid command 'ResourceConfig'
      Invalid command 'AccessConfig'
      User cannot occur within <VirtualHost> section
      Group cannot occur within <VirtualHost> section

      the suexec syntax in apache2 is
      SuexecUserGroup apache apache

      I'll downgrade apache tonight and do a fresh install off of the 1.34 source and see how it goes.

      Thanks reddragon, I do really appreciate you being on top of this.

      linux_terror

       
      • I should have specified, the upgrade program is a command line program not browser.  Thats why you get errors i think.

         
    • John Fairbairn
      John Fairbairn
      2005-02-04

      yeah, i ran it out of the cgi-bin, I'm gonna downgrade apache anyway as it'll just be a nightmare to have to edit the vhost entries all the time. I'm compiling an apache 1.3.33 now and I'll post the results of the panel install when I'm done.

      See ya on the flipside.
      linux_terror