[quote=“Rick Urdahl, post: 39127, member: 27117”]I am getting an error when doing the install update SQL from the webpage.

[CODE]Database Schema Installer / Updater
Update/Install Failed!

The following errors occured
Update ID: 1 - 10

Database Error:

Incorrect integer value: ‘’ for column ‘uId’ at row 1
Database SQL:

INSERT INTO fog.users VALUES (‘’,‘fog’, MD5(‘password’),‘0000-00-00 00:00:00’,‘’)
Update ID: 1 - 11

Database Error:

Incorrect integer value: ‘’ for column ‘osID’ at row 1
Database SQL:

INSERT INTO fog.supportedOS VALUES (‘’,‘Windows XP’, ‘1’)
Update ID: 1 - 12

Database Error:

Incorrect integer value: ‘’ for column ‘vID’ at row 1
Database SQL:

INSERT INTO fog.schemaVersion VALUES (‘’,‘1’)
Update ID: 2 - 0

Database Error:

Incorrect integer value: ‘’ for column ‘osID’ at row 1
Database SQL:

INSERT INTO fog.supportedOS VALUES (‘’,‘Windows Vista’, ‘2’)
Update ID: 5 - 2

Database Error:

Incorrect integer value: ‘’ for column ‘osID’ at row 1
Database SQL:

INSERT INTO fog.supportedOS VALUES (‘’,‘Other’, ‘99’)
Update ID: 16 - 9

Database Error:

Field ‘ngmKey’ doesn’t have a default value
Database SQL:

INSERT INTO
fog.nfsGroupMembers
(ngmMemberName, ngmMemberDescription, ngmIsMasterNode, ngmGroupID, ngmRootPath, ngmIsEnabled, ngmHostname, ngmMaxClients, ngmUser, ngmPass)
VALUES
(‘DefaultMember’, ‘Auto generated fog nfs group member’, ‘1’, ‘1’, ‘/images/’, ‘1’, ‘192.168.1.176’, ‘10’, ‘fog’, ‘’)[/CODE]
FOG Version: v1.2.0

OS Version: openSUSE 13.1 (x86_64)

Can you provide your installation details? Yes, below is the contents of /var/log/foginstall.log

Have you checked your apache error logs? Can you provide information from these logs?
/var/log/apache2/error_log
[CODE][Sun Nov 16 17:04:00.162488 2014] [php5:error] [pid 10355] [client X.X.X.X:38018] PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /srv/www/htdocs/fog/lib/db/MySQL.class.php on line 150, referer: http://X.X.X.X/fog/commons/schemaupdater/index.php?redir=1
[/CODE]

Debian based Location (normally)
/var/log/apache2/error.log
Redhat based Location (normally)
/var/log/httpd/error_log

Have you searched the forums for your issue yet? Yes, and they have been very helpful. I
Have you checked the wiki yet? Yes, and they have been very helpful.
Kernel Issues: [url]http://fogproject.org/wiki/index.php/FAQ[/url][/quote]

You’ve ensured iptables and/or firewall and selinux is disabled?

It sounds like it’s not passing info to the database (more like the database isn’t accessible.)

[quote=“shadowfax, post: 38870, member: 26386”]We’re running FOG 1.2.0 on Ubuntu 14.10 and have had no problems whatsoever. We get in shipments of 10-20 PC’s at a time. Our imaging process is to set up the BIOS on the new PC’s to allow us to PXE boot into the FOG server, Perform Full Host Registration and Inventory and power down. Then we image them using multicast. I usually wait until the Host Registration is done and turn off the PC while it’s restarting and before it runs Windows. I didn’t know if there was a simple code modification I could make to have the PC shutdown instead of restart after the Host Registration is done.[/quote]

So you’re shutting down because there’s no way to multicast directly from the Full Registration? I could see that being a helpful feature, especially when new devices are added in bulk. Tom, after it asks if you want to image now, maybe there could be a way to choose unicast or multicast? Just a thought

SVN is where I push the changes.

[url]http://fogproject.org/wiki/index.php/Upgrade_to_trunk[/url]

Also a big thanks from Holland!
We did make a donation a couple of years ago but I think it’s time for a new donation!

We’ve been using FOG for almost 4 years now (keeping 400 pc’s up-to-date), It’s really a good product and works great!

Thanks again!
Marco

Thanks for this detailed reply, I always think that 2 VCS and 1 repo is too big, curb the developpment of Fog and is not easy to manage. I understand your position and it’s up to you to choose how you want to work so there is no good or bad solutions, I’ve created this topic in order to start a discussion about the project management and how to improve it.

Tom, for the learning of git I’ve some ressources that you can link if you choose to move to git one a day. It’s not hard as you can think you just need to forget about how svn run but after you’ve switched to git getting back to svn could be hard 🙂

Romain.

[quote=“Mentaloid, post: 37412, member: 4362”]Last I used VMware to shrink a disk, it was done via a VMware supplied tool called “vmware tools” for a windows guest. This is a guest OS application that is installed from VMware from a CD ISO image (ESXi, accessed by selecting “install vmware tools” in the host manager).

As this is a program/tool supplied by VMware, and is Host dependant, as well using private (and hidden) vmware API’s, I am quite certain that there is no linux derivative of said tool. If you have access to the VMDK file from a linux system you can manage to squeeze vcli [url]https://www.vmware.com/support/developer/vcli/[/url] onto it, I would suggest thinking about creating a new (smaller) VMDK file, and then cloning to the new VMDK. Of course this requires a fair amount of room itself (as does the hot shrink that VMware supplies for windows guests)

TL;DR; Windows guests, you need to use vmware tools. Linux guests, you need to do a lot of research, and get some 3rd party tools and install VMware tools (which likely won’t work on macos) to possibly even try with enough spare disk space to create a second copy of the VMDK.[/quote]

they do have a copy of the VMWare tools that fusion keeps updated. And it does allow folder sharing and a host of other functions but the resize doesn’t seem to work for me. I dunno maybe i’m wasting my time but I think i’ll figure out this dilemma long before I et a bigger SSD

To add on to this (while slightly outdated) we have a semi-officialized kind of bug reporting system as well. This is for us developers to keep track of features, bugs, etc… when encountered.

If a user notices a bug, it’s best right now to submit to the forums as we’re constantly on them. If you submit a bug report to the github, I believe it will only contact me, though everybody could still see the bug itself.

There is a way to fix it, but I don’t have the time to go over what to do. Maybe copy this file to your /var/www/fog/management/js/

As the forums won’t allow upload of .js, you’ll just need to rename it to fog.js.

You should no longer lose focus on the search bar.

[url=“/_imported_xf_attachments/1/1381_fog.txt?:”]fog.txt[/url]

Easiest thing?

Maybe not using CentOS 7.0?

Next bet, find out what software is ACTUALLY trying to be installed and return the proper information in the file?

In trunk/lib/redhat/config.sh you should find the package listing for the type of installation you’re attempting to perform. My guess, if my memory serves me well, is you’re attempting to to actually install MariaDB. I don’t know if the mysql-server package will actually do anything with the mariadb-server package as I’m not even sure if it installs with that name any more.

Thanks Junkhacker for the fast reply.
just figure it out. The report didn’t work because of one letter in the inventory.class.php. I’ts case sensitive (common mistake i think). All working now.
Congratulations to all devellopers in FOG for the great job!

[quote=“gwhitfield, post: 36037, member: 344”]I know it’s an old thread but I’ve looked at others and didn’t get any closer to an accurate description of the problem we’re struggling with and now may have solved for ourselves.

We have server (A) FOG 1.2 on Ubuntu 14.0.4.1 hosted by vCenter Server 5.5.0. 2CPU/4GB RAM/e1000 NIC/SCSI drive. With PIG_Z_COMP set at 3, upload speeds were no better that 500MB/min while download speeds were in the 3GB/min range. After much googles I find some references to VMWare driver issues solved by command line “(sudo) ethtool -K eth0 tso off gso off” which worked. Upload went to 4.5GB/min on 1Gb connection, download went to 5.1GB/min without a restart of FOG server. There’s also an rx-checksumming edit suggested but we didn’t implement it to get to the speeds we’re at now. Maybe we can live without it.

Funny, we have another server (B) FOG 1.2/Ubuntu 14.0.4.1 VM 2CPU/4GB RAM/e1000 NIC/SCSI drive on ESXi 5.1 that required no changes to achieve 4.3GB/min uploads on 1Gb connection.

Now to get handle on how to make this change stick after a restart, something in /etc/network/interfaces but nothing worked yet, maybe a syntax thing idk. Also trying to get mysql service starting at the right time to avoid the Database Schema issue on restart. I know it’s in here somewhere, just haven’t found it yet. When I do I’ll try to update this.[/quote]

I’ve add the ethtool -K eth0 tso off gso off command to the S99fog scripts so this should be on your systems as well. I don’t know if we should add this to the installer though, as the interface is subject to be changed.

Maybe we can get a wiki entry explaining this?

I already have check’s and balances to check the architecture as in 32 bit vs. 64 bit. If 32 bit arch is found it loads bzImage32 and init_32.xz automatically. If 64 bit, it loads the bzImage and init.xz which are 64 bit files. Hopefully that helps clarify that.

BTSync is always on the latest, automatically distributed if you want that for testing.

Hi,

Do you know how I would fix this for and additional storage device on the same server, I have it listed as a seperate storage group and it uploads properly but doesn’t move out of my area called Storage1/dev… it just has the MAC address of the machine I uploaded it from rather than the image name… Its probably a simple thing but im banging my head against a wall now.

Sorry its running Ubuntu 12.04 and fog 1.2

Thanks

Don’t feel slow over something you where unaware of. At least you made an attempt to get to the information.

Piracy,

Most of the web changes I listed were personal preference, but here is a little more detail:

[U]GroupManagementPage & HostManagementPage[/U]
I prefer the upload and or deploy and mutlicast to not be right next to each other so I moved the icons around. I also removed the edit button since you can click on the host and it takes you to the same location, along with modifying the download header to Unicast (did the same thing in the TaskManagementPage. With making some of those changes I changed the alignment of the buttons make it line up better

[U]ImageManagementPage[/U]
I added the Image ID back to this page I thought it was useful in the older versions of fog if you do a fare share of full register and deploy directly from a computer since it asks you for a image number. Granted you can find it with “?” but if you have a large list of images or a small screen it might just be easier to know what the number is. I realize this number is auto generated with mySQl and doesn’t really mean much and that is probably why it was removed.

I removed the edit button off of this screen along with Storage group due to I didn’t use it. Changing Upload to Upload date was also a personal preference.

I also removed the comment when hovering over Image name and changed it to be on the Image Id to show the description on the image instead of when it was deployed and etc. since it was already on this page.

I’m working on trying to figure out what and when to do things. iPXE itself has a method to know whether something is UEFI or PXE booting, but I have to get more details before I can just add it all in.

Hey Tom, Thanks for all your work on fog btw. I was just updating the database on my own directly through the console.[S] I’m not sure how to use the schema update. I did a quick search and didnt come up with anything.[/S]

I guess i should also ask if you are working on adding LDAP support for users to log in?

edit: So i just had a quick peek at the schemaupdater php file and realized how to use it. I’m still not clear as to why the direct database editing didnt work but i’ll take what i can get.

I don’t understand what you’re wanting.

You want to get an automated report of the user tracker, using FOG’s Report system?

The URL you’ve got get’s the all systems the userid has logged in. The userid is base64 encoded to help you out. but the “rest” of the url is actually from when you click on the PDF or CSV Icon’s. It parses the displayed information to give you the PDF or CSV file.

The host=0 does not mean all hosts the user has logged into, it’s just a “place” holder though when you do choose.

You’ll likely have better luck if you generate your own report to obtain the information you need. For example, being able to specify a group. How to export autonomously is a little more “technical” than I can think of, but a simple means, I think, would be to simply have the needed parts of the report (the table start and information within) generate on it’s own page. THen you could script htmldoc to read that page to generate the PDF.