Blank screen with GO4.2 on Debian 7.1

Having trouble installing Group-Office? No worries. Help is on the way.

Moderator: Developers

mikerz
Posts: 17
Joined: Tue May 22, 2012 10:23 am

Blank screen with GO4.2 on Debian 7.1

Postby mikerz » Fri Jul 19, 2013 11:31 am

Hello Devs and fellow users,

I'm setting up a fresh install of GO 4.2 on a minimal Debian 7.1 installation.
After installation, when I go to the /groupoffice/ page, I get a blank screen (the GO favicon is there though).

Apache logs show nothing in particular, neither do the /home/groupoffice/log/ files.
Permissions for /home/groupoffice seem to be setup alright. A dummy script with phpinfo() shows php operating normally.
PHP is 5.4.4-14+deb7u3
MySQL is 5.5.31-0+wheezy1

However, when I do 'view source' in my browser, there is a wall of text. I'll copy the telltale part:

Code: Select all

<html>
	<head>
		<link href="/groupoffice/views/Extjs3/themes/Default/external.css" type="text/css" rel="stylesheet" />
					<link href="/groupoffice/views/Extjs3/themes/Default/images/groupoffice.ico" rel="shortcut icon" type="image/x-icon">
		<title>Group-Office</title>
		
			</head>
<body>
	<div id="container"><h1>Błąd</h1><p style="color:red">SQLSTATE[42000]: Syntax error or access violation: 1064 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 '))) 
WHERE 1 
AND `t`.`behave_as_module` = '1'
GROUP BY t.`id`' at line 8

Full SQL Query: SELECT `t`.`id`, `t`.`category_id`, `t`.`user_id`, `t`.`name`, `t`.`content`, `t`.`description`, `t`.`logo`, `t`.`public_icon`, `t`.`open_extern`, `t`.`behave_as_module` ,
`category`.`id` AS `category@id`,
`category`.`user_id` AS `category@user_id`,
`category`.`acl_id` AS `category@acl_id`,
`category`.`name` AS `category@name`
FROM `bm_bookmarks` t 
INNER JOIN `bm_categories` `category` ON (`category`.`id`=`t`.`category_id`) 
INNER JOIN go_acl ON (`category`.`acl_id` = go_acl.acl_id AND (go_acl.user_id=1 OR go_acl.group_id IN ())) 
WHERE 1 
AND `t`.`behave_as_module` = :go3
GROUP BY t.`id` 
Bind params: array (
  ':go3' => 
  array (
    0 => 1,
    1 => 2,
  ),
)

#0 /usr/share/groupoffice/go/base/db/ActiveRecord.php(1506): PDOStatement->execute()  
(...)
Using Polish translation of GO.
So, anything I missed or is Debian 7 not yet supported?

All the best and thanks in advance.
mikerz
Posts: 17
Joined: Tue May 22, 2012 10:23 am

Re: Blank screen with GO4.2 on Debian 7.1

Postby mikerz » Mon Jul 22, 2013 5:46 am

I was using the 'recommended' method btw. Added the fourtwo repo to my sources.list and let GO install mysql and such for me.
There was an error message near the very end, above the 'done' message. Said something about duplicate primary keys for id '1'. Sorry I didn't write it down.
mschering
Site Admin
Site Admin
Posts: 8355
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: Blank screen with GO4.2 on Debian 7.1

Postby mschering » Tue Jul 23, 2013 6:59 am

Do you have the /home/groupoffice/log/error.log?
Best regards,

Merijn Schering
Intermesh
mikerz
Posts: 17
Joined: Tue May 22, 2012 10:23 am

Re: Blank screen with GO4.2 on Debian 7.1

Postby mikerz » Wed Jul 24, 2013 9:36 am

Yes, like I said in the OP I did examine them but found nothing in particular and hence decided against posting it right away.
But here it is:

Code: Select all

root@debianxen:~# cat /home/groupoffice/log/error.log
[20130719 12:47:34] PHP Warning: file_put_contents(/home/groupoffice/log/debug.log): failed to open stream: No such file or directory in /usr/share/groupoffice/go/GO.php on line 812
User: notloggedin Agent: Mozilla/5.0 (Windows NT 5.1; rv:20.0) Gecko/20100101 Firefox/20.0 IP: 10.0.0.155
Query:
Backtrace:
global::file_put_contents in file /usr/share/groupoffice/go/GO.php on line 812
GO::debug in file /usr/share/groupoffice/go/GO.php on line 514
GO::init in file /usr/share/groupoffice/GO.php on line 4
global::require_once in file /usr/share/groupoffice/index.php on line 18
This situation in apache2 log:

Code: Select all

[Fri Jul 19 12:47:34 2013] [error] [client 10.0.0.155] PHP Warning:  file_put_contents(/home/groupoffice/log/debug.log): failed to open stream: No such file or directory in /usr/share/groupoffice/go/GO.php on line 812
Judging by the date and hour, this appeared on the very first run. Nothing else appears in the log when switching debug=false to true and vice-versa.
These errors do not appear anymore. The permissions to /home/groupoffice were setup right but I did

Code: Select all

chmod -R 777 /home/groupoffice
just in case but that did not help.
However, still, nothing but a gray screen appears when I refresh <ipaddress>/groupoffice.
I will attempt to remove groupoffice from this virtual machine and/or reinstall the virtual machine's OS altogether and retry.
mikerz
Posts: 17
Joined: Tue May 22, 2012 10:23 am

Re: Blank screen with GO4.2 on Debian 7.1

Postby mikerz » Wed Jul 24, 2013 9:48 am

Performed:
apt-get purge groupoffice-com
apt-get autoremove
apt-get install groupoffice-com
agreed to 'automatic' configuration of DB

At the very end of the installer I got

Code: Select all

Configuring Group-Office
Database connection established. Database is empty
Installing module email
Installing module tools
Installing module demodata
Installing module comments
Installing module notes
Installing module tasks
Installing module users
Installing module modules
Installing module customfields
Installing module search
Installing module files
Installing module calendar
Installing module bookmarks
Installing module groups
Installing module sieve
Installing module summary
Installing module addressbook
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'

Group-Office CLI - Copyright Intermesh BV.

Error: Could not set user with id 1 in GO_Base_Session::setCurrentUser()!

Setting cache permissions

(this line I had to translate) ln: couldn't create symlink `/var/www/public': file exists
Done!
Results: I got log/error.log to be created by switching debug to true in the config, but it only has the one error it reports while creating the log files. Nothing beyond that. Still gray screen.
Should I just go back to an older Debian?
mschering
Site Admin
Site Admin
Posts: 8355
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: Blank screen with GO4.2 on Debian 7.1

Postby mschering » Thu Jul 25, 2013 11:20 am

Can you post a dump of the db schema?
Best regards,

Merijn Schering
Intermesh
mikerz
Posts: 17
Joined: Tue May 22, 2012 10:23 am

Re: Blank screen with GO4.2 on Debian 7.1

Postby mikerz » Thu Jul 25, 2013 12:08 pm

As you wish, I'm attaching the results of mysqldump as a txt file.
Couple other possibly relevants bits of info:
Linux locale settings:

Code: Select all

LANG=pl_PL.UTF-8
LANGUAGE=
LC_CTYPE="pl_PL.UTF-8"
LC_NUMERIC="pl_PL.UTF-8"
LC_TIME="pl_PL.UTF-8"
LC_COLLATE="pl_PL.UTF-8"
LC_MONETARY="pl_PL.UTF-8"
LC_MESSAGES="pl_PL.UTF-8"
LC_PAPER="pl_PL.UTF-8"
LC_NAME="pl_PL.UTF-8"
LC_ADDRESS="pl_PL.UTF-8"
LC_TELEPHONE="pl_PL.UTF-8"
LC_MEASUREMENT="pl_PL.UTF-8"
LC_IDENTIFICATION="pl_PL.UTF-8"
LC_ALL=
My ssh connection to the virtual machine in question was via Putty with UTF-8 set as the encoding.
I tried to hunt down the Polish special characters and deleted them, re-fed the dump into an empty groupofficecom DB but that didn't help...

Thank you very much so far for your patience. I'm happy to provide any other info you need.
Attachments
go.txt
(124.75 KiB) Downloaded 412 times
mschering
Site Admin
Site Admin
Posts: 8355
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: Blank screen with GO4.2 on Debian 7.1

Postby mschering » Thu Jul 25, 2013 12:13 pm

Can you set $config['debug']=true; Then post the debug log after the install problem occurs.
Best regards,

Merijn Schering
Intermesh
mikerz
Posts: 17
Joined: Tue May 22, 2012 10:23 am

Re: Blank screen with GO4.2 on Debian 7.1

Postby mikerz » Fri Jul 26, 2013 12:19 pm

I re-did everything from the ground up, i.e. re-installed the virtualization hypervisor xen, created all volumes, partitions, everything. Clean slate.
I was using the 'netinst' minimalistic debian version (64 bit this time though, previous was 32 bit) and installed it as my virtual machine (the one for GO).
After that I just ran the GO installer and everything went without warnings or errors. That last error about MySQL did not show up neither. An error.log was not created even with debug=true.
Groupoffice launched fine straight away...

I haven't done anything advanced yet like the mailserver or importing my old e-mails and addressbooks from the other GO machine, but it's working for now.

All in all the only major change I can think of is using a 64 bit Debian system instead of 32 bit.

Would you like me to attempt to reproduce this problem? I could try another virtual machine with the 32 bit Debian 7.1 this time.

My apologies for not saving the debug.log before nuking the whole thing.
mschering
Site Admin
Site Admin
Posts: 8355
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: Blank screen with GO4.2 on Debian 7.1

Postby mschering » Fri Jul 26, 2013 12:45 pm

I'd like to know what went wrong. But if it's too much effort I can understand.
Best regards,

Merijn Schering
Intermesh
n3v3n
Posts: 4
Joined: Mon Aug 06, 2012 8:06 am

Re: Blank screen with GO4.2 on Debian 7.1

Postby n3v3n » Mon Jul 29, 2013 11:43 am

I'm having exactly the same issue on Debian 7 and GroupOffice 4.2.1.

Main page is blank page.

Does anybody have some good idea how to resolve this issue, so I can continue with setup GO on my raspberry pi?

regards
mschering
Site Admin
Site Admin
Posts: 8355
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: Blank screen with GO4.2 on Debian 7.1

Postby mschering » Mon Jul 29, 2013 12:21 pm

Perhaps restarting from scratch helps you too?
Best regards,

Merijn Schering
Intermesh
n3v3n
Posts: 4
Joined: Mon Aug 06, 2012 8:06 am

Re: Blank screen with GO4.2 on Debian 7.1

Postby n3v3n » Mon Jul 29, 2013 1:45 pm

maybe this helps

Code: Select all

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type" />
<meta name="robots" content="noindex" />
<meta http-equiv="x-ua-compatible" content="IE=8">
<link href="/groupoffice/views/Extjs3/themes/Default/images/groupoffice.ico?" rel="shortcut icon" type="image/x-icon">
<title>Group-Office</title>
<link href="/groupoffice/index.php?r=core/compress&file=e4fe3d934fe9d6af23bc2efcc99387b5-Default-style.css&mtime=1375105404&security_token=afSnIsBjtTce8MHZVKpm" type="text/css" rel="stylesheet" />
<style><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
	<head>
		<link href="/groupoffice/views/Extjs3/themes/Default/external.css" type="text/css" rel="stylesheet" />
					<link href="/groupoffice/views/Extjs3/themes/Default/images/groupoffice.ico" rel="shortcut icon" type="image/x-icon">
		<title>Group-Office</title>
		
			</head>
<body>
	<div id="container"><h1>Error</h1><p style="color:red">SQLSTATE[42000]: Syntax error or access violation: 1064 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 '))) 
WHERE 1 
AND `t`.`behave_as_module` = '1'
GROUP BY t.`id`' at line 8</p></div>
</body>
</html>
this is from /groupoffice/index.php when I click on view Source page
mikerz
Posts: 17
Joined: Tue May 22, 2012 10:23 am

Re: Blank screen with GO4.2 on Debian 7.1

Postby mikerz » Fri Aug 02, 2013 11:59 am

Yes, I noticed 4.2.9 appeared in the repo, but the error persists when using the 32 bit build of Debian 7.1 from this link:

http://cdn.debian.net/debian/dists/Debi ... tboot/xen/
This is an official minimal install with xen support (i.e. is able to function as a xen virtual machine).

Again, right at the end of the install there is a MySQL error:

Code: Select all

Installing module addressbook
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'

Group-Office CLI - Copyright Intermesh BV.

Error: Could not set user with id 1 in GO_Base_Session::setCurrentUser()!

Setting cache permissions
The 64 bit build of debian 7.1 does NOT cause this problem to appear.

I'm attaching the error log, debug log and a list of all packages this machine has installed.
HDD space is sufficient.
Attachments
packages.txt
(41.6 KiB) Downloaded 364 times
debug.log
(6.3 KiB) Downloaded 352 times
error.log
(596 Bytes) Downloaded 358 times

Who is online

Users browsing this forum: No registered users and 3 guests

cron