Posts made by Alasdair Hatfield

Hello,

I’ve upgraded to SVN 2906 and this problem is resolved.

I now see a sensible page if I call up the login history.

Thanks
Alasdair

Dear Tom,

I can close this problem. Thanks for the support!

What I’ve done or learnt -

I’ve upgraded to svn 2906 just to be sure I have the latest and greatest.
I rechecked everything I had to patch to get it going on a SuSe platform. Although I didn’t find anything, Doing it again, I might have missed out a mistake I made last time.

I’ve found that if I enter
[QUOTE][url]http://localhost/fog/management/index.php[/url][/QUOTE]
then the redirect keeps the 'index.php
but if I enter
[QUOTE][url]http://localhost/fog/management[/url][/QUOTE]
then the redirect follows
However, this doesn’t appear to be a problem as the redirect now works and I get the page I expect.

I found that the new version needs me to enter the PHP SSL extension otherwise I get the error
[QUOTE]PHP Fatal error: Call to undefined function openssl_pkey_new() in /srv/www/htdocs/fog/lib/fog/FOGCore.class.php on line 522[/QUOTE]
in the apache error_log.

Installing this extension required me to restart the apache server.

Upon retrying, it all burst into life

Thanks again.

Onto the next challenge.
Alasdair

Hello Tom,

The mysql access log suggests to me that attempts are being made to access the db server but something seems strange. The first query
[QUOTE]SELECT vValue FROM schemaVersion LIMIT 1[/QUOTE]
(after the SET statement)
seems to assume that a db already exists with tables.

Could it be that something in my installation is broken (probably by me) whereby the build up of the db ‘jumps in’ part way through instead of at the beginning with a ‘create database …’? Strange I know but I can’t explain the first entries in the log in another way. Should I be looking in schema.php for this?

I flushed the logs and then started the installation. I then posted the entire logs above.

The firewall should be completely down but I will check this again.

Error 302 is a puzzle. I am not using redirects. The Apache installation / configuration is about as simple as it can be. This is only on a test PC, not on an active server.
I will also flush the cache of the browser to be sure it isn’t carrying anything over.
What I do see in the browser (where one types an url in) is that
[QUOTE][url]http://localhost/fog/management[/url][/QUOTE]
does move itself on to
[QUOTE]/fog/management/?node=schemaupdater[/QUOTE]

I’ll keep searching

Alasdair

BTW - yes SuSe does have selinux.

Alasdair

Dear Tom,

[COLOR=#000000]I hope you don’t mind me free riding on the back of this thread. You were helping me with the thread[/COLOR]
[COLOR=#000000]“[URL=‘http://fogproject.org/forum/threads/updated-from-32-to-1-1-0-to-1-1-2-to-1-2-0-user-login-hist-page-blank.11301/unread’][COLOR=#000000]Updated from .32 to 1.1.0 to 1.1.2 to 1.2.0 - User Login Hist page blank” and one proposal was to upgrade to the SVN trunk. I took this option (I can always go back if needed)[/COLOR][/URL][/COLOR]

[COLOR=#000000][URL=‘http://fogproject.org/forum/threads/updated-from-32-to-1-1-0-to-1-1-2-to-1-2-0-user-login-hist-page-blank.11301/unread’][COLOR=#000000]The problem I am currently facing is very much like Chris’s.[/COLOR][/URL][/COLOR]

For other readers, the system is openSuSe.

Following your advice in the other thread, I have upgraded to SVN 2890. The install is fresh (not on top of an old version). I have also removed the database.
I step through the install and when I get to:

[I]This can be done by opening a web browser and going to:[/I]
[I] [url]http://10.1.2.253/fog/management[/url][/I]
[I] Press [Enter] key when database is updated/installed.[/I]

I duly go there and sit and wait and look at a blank page, which remains blank.
To be clear, I understood that Chris saw something before the blank page. I do not see anything. Immediately blank.
Up to then, the install appears to go without problems.

Here are the log files:

[B]Apache error_log[/B]
AH00557: httpd2-prefork: apr_sockaddr_info_get() failed for juul
AH00558: httpd2-prefork: Could not reliably determine the server’s fully qualified domain name, using 127.0.0.1. Set the ‘ServerName’ directive globally to suppress this message
[Tue Jan 13 21:40:15.792878 2015] [ssl:warn] [pid 21334] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Tue Jan 13 21:40:15.804895 2015] [mpm_prefork:notice] [pid 21334] AH00163: Apache/2.4.6 (Linux/SUSE) OpenSSL/1.0.1j PHP/5.4.20 configured – resuming normal operations
[Tue Jan 13 21:40:15.804957 2015] [core:notice] [pid 21334] AH00094: Command line: ‘/usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -D SYSTEMD -D FOREGROUND’
[Tue Jan 13 21:42:09.841342 2015] [mpm_prefork:notice] [pid 21334] AH00170: caught SIGWINCH, shutting down gracefully
AH00557: httpd2-prefork: apr_sockaddr_info_get() failed for juul
AH00558: httpd2-prefork: Could not reliably determine the server’s fully qualified domain name, using 127.0.0.1. Set the ‘ServerName’ directive globally to suppress this message
[Tue Jan 13 21:43:35.133904 2015] [ssl:warn] [pid 22078] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Tue Jan 13 21:43:35.146543 2015] [mpm_prefork:notice] [pid 22078] AH00163: Apache/2.4.6 (Linux/SUSE) OpenSSL/1.0.1j PHP/5.4.20 configured – resuming normal operations
[Tue Jan 13 21:43:35.146630 2015] [core:notice] [pid 22078] AH00094: Command line: ‘/usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -D SYSTEMD -D FOREGROUND’
mkdir: cannot create directory ‘/opt/fog/snapins/ssl/’: No such file or directory
[Tue Jan 13 21:44:34.427524 2015] [php5:error] [pid 22099] [client 10.1.2.253:46616] PHP Fatal error: Call to undefined function openssl_pkey_get_private() in /srv/www/htdocs/fog/lib/fog/FOGCore.class.php on line 537

[B]Apache access_log[/B]
::1 - - [13/Jan/2015:21:42:09 +0100] “OPTIONS * HTTP/1.0” 200 - “-” “Apache/2.4.6 (Linux/SUSE) OpenSSL/1.0.1j PHP/5.4.20 (internal dummy connection)”
::1 - - [13/Jan/2015:21:42:09 +0100] “OPTIONS * HTTP/1.0” 200 - “-” “Apache/2.4.6 (Linux/SUSE) OpenSSL/1.0.1j PHP/5.4.20 (internal dummy connection)”
::1 - - [13/Jan/2015:21:42:09 +0100] “OPTIONS * HTTP/1.0” 200 - “-” “Apache/2.4.6 (Linux/SUSE) OpenSSL/1.0.1j PHP/5.4.20 (internal dummy connection)”
::1 - - [13/Jan/2015:21:42:09 +0100] “OPTIONS * HTTP/1.0” 200 - “-” “Apache/2.4.6 (Linux/SUSE) OpenSSL/1.0.1j PHP/5.4.20 (internal dummy connection)”
::1 - - [13/Jan/2015:21:42:09 +0100] “OPTIONS * HTTP/1.0” 200 - “-” “Apache/2.4.6 (Linux/SUSE) OpenSSL/1.0.1j PHP/5.4.20 (internal dummy connection)”
10.1.2.253 - - [13/Jan/2015:21:43:49 +0100] “GET /fog/management/ HTTP/1.1” 302 - “-” “Mozilla/5.0 (X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0”
10.1.2.253 - - [13/Jan/2015:21:44:14 +0100] “GET /fog/management/?node=schemaupdater HTTP/1.1” 500 - “-” “Mozilla/5.0 (X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0”

[B]mysql access log[/B]
/usr/sbin/mysqld, Version: 5.5.33-MariaDB-log (openSUSE package). started with:
Tcp port: 0 Unix socket: /var/run/mysql/mysql.sock
Time Id Command Argument
150113 21:44:14 1 Connect root@10.1.2.253 as anonymous on
1 Query SET NAMES utf8
1 Query SELECT vValue FROM schemaVersion LIMIT 1
1 Quit
150113 21:44:34 2 Connect root@10.1.2.253 as anonymous on
2 Query SET NAMES utf8
2 Query SELECT vValue FROM schemaVersion LIMIT 1
2 Query SELECT * FROM globalSettings WHERE settingKey = ‘FOG_SNAPINDIR’ ORDER BY settingKey ASC
2 Query SELECT * FROM globalSettings WHERE settingKey = ‘FOG_SNAPINDIR’ ORDER BY settingKey ASC
2 Quit

Do you have any ideas what is causing this blank page?

Thanks!
Alasdair[URL=‘http://fogproject.org/forum/threads/updated-from-32-to-1-1-0-to-1-1-2-to-1-2-0-user-login-hist-page-blank.11301/unread’][/URL]

Tom,

I had misunderstood you. I thought you meant the fog logs. Attached are the apache logs. I have flushed the logs and then started a fog session ([url]http://localhost/fog/management[/url]), logged in and then I went directly to the images page and tried to list the images.

the ob_gzhandler warning pops up with every transaction so I ignored that. Apart from that, I can’t see anything untoward.

Can you explain your thoughts about the link between this problem and ftp? What does fog use ftp for? I understand that tftp and nfs are used and why but not ftp.

Thanks
Alasdair

[url=“/_imported_xf_attachments/1/1591_access_log.txt?:”]access_log.txt[/url][url=“/_imported_xf_attachments/1/1592_error_log.txt?:”]error_log.txt[/url]

Here is the images table from the db if it gives any clues

[url=“/_imported_xf_attachments/1/1590_images_table.txt?:”]images_table.txt[/url]

Hello Tom,

Thanks for the fast reply.

The memory suggestions in the thread seemed unlikely to me as I am currently only dealing with two images. Correct me if this assumption is wrong.

This is what I did -
allow PC (host) to create itself as a host on the server
create an image for the host
link the image to the host
initiate a task to upload the image
NB - this does not complete - stars appear on the host but the server doesn’t end the task. So, I move the image form dev/ to images/ with the assigned name of the image. I don’t change any rights.

If I then check the image list - problem

However, if I initiate a download, all seems to run smoothly.

I have looked at the log files under /opt/fog but they don’t appear to have been touched since my last attempts a month ago.
There are 4 logs - fogscheduler, fogreplicator, groupmanager, multicast
Am I looking in the wrong place or have I managed to kill logging somewhere along the line?

Best
Alasdair

Hello,

Is there any advance on this problem?
I’m running 1.2.0 on a SuSe platform.

I haven’t discovered any problems with reports but I suffer the same problem as described above if I try to list the images or do a search.
Clicking on ‘List All Images’ results in a blank page (page source is blank too - suggests that nothing is rendered)
‘New Search’ shows a page and if I enter a random string, I get ‘0 results found’ which is to be expected. If I start to enter the name of a valid image, I get ‘Internal Server Error’ as UpACreek does.

Thanks in advance for any help.
Alasdair

Thanks for the reply.

I’ll upgrade to 1.2.0 and see if the problem disappears.

I’m not sure about moving the file as the server seem to think that the upload is still busy. (Task Management - task is still in progress)

Hopefully 1.2.0 will solve it.

Alasdair

Hello,

I’m running FOG 1.1.2 on an openSuSe 13.1 server.

I initiate an upload task and sitback and drink lots of coffee. The moment comes and the client (laptop) reports that the upload is successfully completed. I then see astrix’s appear in a vertical line as if the client is waiting for something to happen.
The server appears to still think that the upload is busy. The task manager page reports that the upload is in progress (~ 96 or 98% complete). And so it remains for many more coffees.

I see the same behaviour when trying 3 different clients.

What are the steps that I should see? Is there something I should do to complete the upload?

Thanks in advance
Alasdair

Hello,

I am suffering a similar but different problem to the previous thread. Here, I don’t get as far as starting the upload.
As it is probably a different problem, I started a new thread.

System is:
openSuSe 13.1
FOG 1.1.1
MariaDB 5.5.33

I am trying to do a registration and image upload from the client.

What works (or at least appears to) -
registration of a host via the web interface
registration of a host from the host itself

• in both cases I can see a host entry in the web interface list of all hosts.

What doesn’t work -
upload of image using web interface

• I get a red error that I should associate an image and haven’t yet cracked how to do this but that is for another tread
  registration and upload of an image from the client - this is where I am busy at the moment

I get to answer the questions about host name and image etc. When I answer ‘y’ to the question if I want to upload an image, it then seems to hang, just echoing line feeds.
I am tracking the DB accesses and this repeatedly gets requested to the database:

[CODE]

140709 14:24:44 131 Connect root@localhost as anonymous on
131 Init DB fog
131 Query SELECT vValue FROM schemaVersion LIMIT 1
131 Query SELECT * FROM plugins WHERE pName = ‘capone’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘capone’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘example’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘example’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘location’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘location’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘location’ AND pInstalled = ‘1’ AND pState = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM plugins WHERE pName = ‘location’ AND pInstalled = ‘1’ ORDER BY pName ASC
131 Query SELECT * FROM globalSettings WHERE settingKey = ‘FOG_PLUGINSYS_ENABLED’ ORDER BY settingKey ASC
131 Query SELECT * FROM modules ORDER BY name ASC
131 Query SELECT * FROM hosts WHERE hostMAC = ‘48:5b:39:7f:32:4a’ ORDER BY hostName ASC
131 Query SELECT * FROM hostMAC WHERE hmMAC = ‘48:5b:39:7f:32:4a’ ORDER BY hmID ASC
131 Query SELECT * FROM modules WHERE id=‘4’
131 Query SELECT * FROM modules WHERE id=‘7’
131 Query SELECT * FROM modules WHERE id=‘1’
131 Query SELECT * FROM modules WHERE id=‘3’
131 Query SELECT * FROM modules WHERE id=‘5’
131 Query SELECT * FROM modules WHERE id=‘8’
131 Query SELECT * FROM modules WHERE id=‘9’
131 Query SELECT * FROM modules WHERE id=‘10’
131 Query SELECT * FROM modules WHERE id=‘6’
131 Query SELECT * FROM modules WHERE id=‘11’
131 Query SELECT * FROM modules WHERE id=‘2’
131 Query SELECT * FROM modules WHERE id=‘12’
131 Query INSERT INTO hosts (hostName, hostDesc, hostCreateDate, hostCreateBy, hostMAC) VALUES (‘qwe’, ‘Created by FOG Reg on July 9, 2014, 12:24 pm’, ‘2014-07-09 12:24:44’, ‘FOGREG’, ‘48:5b:39:7f:32:4a’) ON DUPLICATE KEY UPDATE hostID = ‘’, hostName = ‘qwe’, hostDesc = ‘Created by FOG Reg on July 9, 2014, 12:24 pm’, hostIP = ‘’, hostImage = ‘’, hostBuilding = ‘’, hostLastDeploy = ‘’, hostMAC = ‘48:5b:39:7f:32:4a’, hostUseAD = ‘’, hostADDomain = ‘’, hostADOU = ‘’, hostADUser = ‘’, hostADPass = ‘’, hostPrinterLevel = ‘’, hostKernel = ‘’, hostKernelArgs = ‘’, hostDevice = ‘’, hostID = LAST_INSERT_ID(hostID)
131 Query SELECT * FROM moduleStatusByHost WHERE msHostID = ‘0’ ORDER BY msID ASC
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘4’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘4’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘7’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘7’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘1’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘1’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘3’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘3’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘5’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘5’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘8’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘8’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘9’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘9’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘10’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘10’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘6’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘6’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘11’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘11’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘2’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘2’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO moduleStatusByHost (msModuleID, msState) VALUES (‘12’, ‘1’) ON DUPLICATE KEY UPDATE msID = ‘’, msHostID = ‘0’, msModuleID = ‘12’, msState = ‘1’, msID = LAST_INSERT_ID(msID)
131 Query INSERT INTO groupMembers (``) VALUES (‘’) ON DUPLICATE KEY UPDATE gmID = ‘’, gmHostID = ‘0’, gmGroupID = ‘’, gmID = LAST_INSERT_ID(gmID)
131 Query SELECT * FROM plugins WHERE pName = ‘location’ ORDER BY pName ASC
131 Quit
[/CODE]

This pops up each time the host adds a line feed.
My guess is that the database is throwing errors for some reason but I can’t see where.
The database access could be a red herring and the problem might be somewhere else.

Database configuration is that STRICT is off as this being on threw other problems during the installation.

Any ideas or suggestions as to where I should look are appreciated.

Alasdair

ok, thank you. I’ll search further

Hello,

I’m working through installing FOG on an openSuSe machine (so please bear with me in the future). During my work, PHP threw up an error related to MySQL.class.php. - array expected.

Is this patch correct?

[CODE]
— MySQL.class.php.orig 2014-06-26 17:55:09.884848594 +0200
+++ MySQL.class.php.new 2014-06-26 17:55:29.137230586 +0200
@@ -147,7 +147,7 @@
if ($this->queryResult === false)^M
return false;^M
// Return: ‘field’ if requested and field exists in results, otherwise the raw result^M

•                  return ($field && array_key_exists($field, $this->result) ? $this->result[$field] : $this->result);^M
  

•                  return ($field && array_key_exists($field, $this->queryResult) ? $this->queryResult[$field] : $this->queryResult);^M
            }^M
            catch (Exception $e)^M
            {^M
  

[/CODE]

regards,
Alasdair