Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 26th May 2009, 07:59
marciliomcm marciliomcm is offline
Junior Member
 
Join Date: May 2009
Posts: 11
Thanks: 1
Thanked 0 Times in 0 Posts
Default sql error - monitor show jobqueue

Hi,

I try monitor jobqueue and see this error at click.

Ispconfig 3.0.1.12
Monitor
show jobqueue

Error:
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 'AND sys_perm_user like '%r%') OR (sys_groupid IN (0) AND sys_perm_group like '%' at line 1


Debian 5.0.1 x64
ii mysql-client 5.0.51a-24+lenny1 MySQL database client (metapackage depending on the latest ver
ii mysql-client-5.0 5.0.51a-24+lenny1 MySQL database client binaries
ii mysql-common 5.0.51a-24+lenny1 MySQL database common files
ii mysql-server 5.0.51a-24+lenny1 MySQL database server (metapackage depending on the latest ver
ii mysql-server-5.0 5.0.51a-24+lenny1 MySQL database server binaries

thks,

Marcilio
Reply With Quote
Sponsored Links
  #2  
Old 26th May 2009, 13:37
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,951
Thanks: 825
Thanked 5,362 Times in 4,209 Posts
Default

I will check that.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 27th May 2009, 15:07
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,951
Thanks: 825
Thanked 5,362 Times in 4,209 Posts
Default

I'am not able to reproduce this on Debiab Lenny 32 Bit with the same mysql version. It looks like you either edited your admin user manually or used a manually created admin user to login to ispconfig were you did not set the default group correctly.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 11th July 2009, 10:11
virtualm virtualm is offline
Junior Member
 
Join Date: Apr 2009
Posts: 7
Thanks: 0
Thanked 1 Time in 1 Post
Default

Still don't fixed in 3.0.1.3
Also my thread here: http://www.howtoforge.com/forums/sho...sys_perm_group

After little debuging when I select Show Jobqueue the session var $_SESSION["s"]["user"]["userid"] is empty, causing the $sql var to be ((sys_userid= AND... which cause the error. Another call to getAuthSQL from login or other menus works ok, only when called from Show jobqueue have this error.

Ubuntu 9.04 64 bit, ispconfig 3.0.1.3

Regards,
VM
Reply With Quote
  #5  
Old 25th July 2009, 06:51
virtualm virtualm is offline
Junior Member
 
Join Date: Apr 2009
Posts: 7
Thanks: 0
Thanked 1 Time in 1 Post
 
Default Possible problem

Fund the problem:

In datalog_list.php when you loop through servers (foreach ($servers as $s)...) the $s variable somehow alters the session $_SESSION["s"] variable. I don't know why this is happening.. Changing the name to $temps for ex solves the problem.
Sorry for the delay but i was away for a few weeks.

Regards,
VM
Reply With Quote
The Following User Says Thank You to virtualm For This Useful Post:
till (25th July 2009)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Server Setup With Exim, MySQL, Cyrus-Imapd, Horde Webmail On Centos 5.1 - issue c0mrade HOWTO-Related Questions 25 19th April 2009 18:11
MS SQL PHP Extension? AllenQ HOWTO-Related Questions 1 17th April 2009 07:45
postfix-tls sasl2 mysql courier-authmysql gabrix Server Operation 4 12th January 2007 22:09
ISPConfig and adding an SQL Database Texaskilt General 1 7th December 2006 09:52
SQL Users nok Installation/Configuration 2 26th February 2006 11:17


All times are GMT +2. The time now is 04:34.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.