Frequently Asked Questions
When I am not populating the DBGallery's database I am spreading the word about how impressed I am with this product, and with the level of support.
Antony Barrett ∙ UK
- Is there a place for a good "What is DBGallery" description?
- Is the a place which explains all the fields DBGallery supports?
- Does DBGallery work with DropBox?
- Can read-only permissions be set in DBGallery?
- What photo formats does DBGallery support?!
- Can Linux be used as the server for photos?
- Can multiple users share DBGallery's database?
- Which photo file formats does DBGallery support?
- May charitable organizations purchase DBGallery tax free?
- How can I rename a Handy Collection?
- How old a version can I upgrade from?
- Is it possible to use multiple databases?
- Isn't having a MySql database a little complex for most people?
- Why are JPG files not rotated when viewed?
- Can multiple images be rotated at once?
- Any tips for resolving client connection issues to the database?
- Can DBGallery import IPTC data from an existing MySql database?
- How do I move from a single-user to a multi-user setup?
- Can older versions run with the latest database?
- Can a port other than MySql's default 3306 be used?
- What is the resolution for Runtime Error (at 27:1728)?
- What is DBGallery's Storage Limit?
- How to add a user?
- How do I setup the web server plugin?
- Where can I find a database creation script?
- Any tips for installing DBGallery?
- How do I search within the current results?
- Can DBGallery run on a Mac?
A document was recently written to answer that question: What is DBGallery?
Yes. PhotoMetaData.org has an excellent guide: http://www.photometadata.org/META-Resources-Field-Guide-to-Metadata. DBGallery supports the standard IPTC/XMP metadata fields, hence their field descriptions match DBGallery's.
Yes. Using DropBox, or similiar such tools such as SugarSync, you can store all your images in the cloud (i.e. in your DropBox). This is a great way to share images with others using DBGallery, where everyone who shares a DropBox sees shared photos in their instance of DBGallery. Each time any person adds images or updates data on their system, it gets sync'd with the DBGallery on all other computers!
Using DropBox is a great way to use the internet as the location of DBGallery's shared photo collection.
UPDATE: There is now a DBGallery YouTube Channel video on sharing images with DBGallery and DropBox:
After posting this video it's been asked if DBGallery works with SugarSync. It does! There is basically no difference in DBGallery itself as to whether it's working with DropBox or SugarSync folders. I.e. Both work equally as well from DBGallery's perspective.
Yes! Version 5.0 now supports permissions, including the setup of users with read-only access. See more here.
The following photo formats are supported. If a format you require support for isn't here please let us know at Support@GRRSystems.com. Adding new formats is often just a matter of knowing they're required! Note the list does not include Audio and Video formats which are supported by DBGallery.
Adobe Digital NeGative (DNG)
Casio Digital Camera
Computer-aided Acquisition and Logistics Support (CALS)
Digital Picture Exchange Format (DPX)
Eastman Kodak Photo-CD
Graphics Interchange Format (GIF)
Joint Photographics Experts Group (JPEG)
Kodak Digital Camera
Kodak Professional Digital Camera
Leica Digilux 2 RAW
Microsoft HD Photo
Paint Shop Pro Image
Portable Network Graphics (PNG)
Radiance Picture File Format
SGI Image File Format
Sony Digital Camera Format (PMP)
Tagged Interchange File Format (TIFF)
X Windows Dump
Yes. The only stipulation is that the tool used to drop the photo directories onto DBGallery, such as Windows Explorer, uses backslashes ( \ ) instead of forward slashes ( / ).
Yes. DBGallery has a multi-user client/server version. This version allows the client (DBGallery), the database(MySql), and the photo files to all reside on seperate computers. This works due to DBGallery's multi-tier architecture. There is a video on this as well as more detail on the Enterprise page.
A huge number of formats are supported. This including complex file formats such as PhotoShop's PSD file, and what I believe are most, if not all, camera RAW formats. By support of a format it means a thumbnail of that format will be seen in DBGallery's window, it can be viewed, searched for, data may be keyed for it, it can be emailed, and used in the various other features of DBGallery.
The full list of format is on DBGallery's site here.
The following are supported for writing of IPTC/XMP data directly to the file. (Note: all formats can have IPTC/XMP data written to the database (for searching and all other DBGallery funcationality), but not necessarily to the image file itself.)
Most Camera RAW Formats
DNG (Digital Negative)
GIF (Graphic Interchange Format)
PNG (Portable Network Graphics)
TIFF (Tagged Image File Format)
Yes. The RegNow purchase option on the order page facilitates this. Let RegNow know you are wish to place a tax free order and they will create one for you. Your company's tax-free organization papers will be required at time of purchase. Contact GRR Systems via it's contact page if you require additional info or assistance.
1) Right-click on a Handy Collection
2) Choose Properties
3) Type the new name if the Name field
4) Press OK
Any version. Even if 1.0 is installed its ok to upgrade to the latest version.
Actually its also ok to downgrade. The database evolved by 'adding only', making it possible to move up or down versions. For example, if you upgrade to 6.0 and don't like it for some reason, you can downgrade to 5.9. Then if you want to try 6.1, you can go from 5.9 to 6.1.
Yes, if using the Enterprise version.
Using Multiple Databases
Sometimes it can be useful to run multiple databases. A personal and commercial database may be desired, for example. While doing this is currently a little awkward it is possible (it would take approx 5 mins). To use multiple databases follow these three steps...
Use the Help | Application Settings | Advanced Configuration options. On that screen simply key the name of the database you wish to access, press the Test Connection button to verify access, then press OK, at which point DBGallery will restart and use the new database.
Most people using DBGallery never have to know there is such a sophisticated database in the background. They can use DBGallery for many useful years without needing to know whats running in the background. And MySql takes up little memory and almost no resources when not being used by DBGallery.
So why such a major database system? Flexibility! When required, companies make good use of that powerful database. Photo data is an organizational asset. So there are two main reasons for the chosen database and DBGallery's architecture:
1) When keyed inside DBGallery and stored in the database, data is accessible by many other systems and applications. For example, data may be extracted by other applications and presented on the web via an organization's systems' development department.
2) Multiple people in an office environment can all access the same database and photos. In this case, the database resides on a central server with DBGallery running on everyone's machine. This is often called a client-server or multi-tiered environment.
About half of the usage of DBGallery is in these types of sophisticated setups. For more on this see the Enterprise/Office page here, or the video on this type of setup here.
But to repeat, for those wanting a simple but powerful system they never have to know this powerful database and architecture is included with DBGallery.
Only some file types (like RAWs) are auto-rotated by default. These are images which can't be rotated and saved to file.
JPG files may be set to rotate automatically. To do this add the extension(.jpg) to the "auto-rotate these file types" at the bottom of the Application Settings dialog. Neither DBGallery nor programs such as FastStone actually auto-rotate the file to disk. It's simply viewed upright. Both programs do of course rotate to file when manual rotation is chosen. So the only difference between DBG and FS is that DBG doesn't have jpgs set to auto-rotate.
Yes. Select all the thumbs to be rotated in one direction (this can be done by pressing the Ctrl key while thumbs are clicked with the left mouse button). Right click on all of the selected thumbs. Then choose one of the rotation options at the bottom of the context menu.
1) Always start by ensuring the client computer has access to the database computer. Do this by using a program such as Windows Explorer to go to the database machine. E.g. Type \\CorpDBServer into Explorer's address bar and press enter.
2) Using the same machine name or ip address used in the previous step and copy/paste it into the hostname field of the Advanced Configuration dialog in DBGallery. Copy/paste is recommend to avoid typing mistakes during these trouble moments. The \\ isn't required in the hostname, but if it's used DBGallery will strip it. Example of hostnames are CorpDBServer and 192.168.10.13
[Before moving to the next steps you will need the MySql GUI Tools. They are available at http://dev.mysql.com/downloads/gui-tools. Alternatively the MySql command line may be used for those who understand how to use that tool.]
3) Try connecting from the client to the database server using MySql Administrator. If using the default MySql install shipped with DBGallery use the following: Hostname=; Username=root; Password=dbg
4) The next logical thing to do is to ensure there are privileges in MySql for the client machine. This step is often required if using a MySql other than the one shipped with DBGallery (i.e. there was already a MySql installed). To do this use MySql Query Analyzer and do one of the following:
To grant privileges to all computers with access to the internal network, use:
GRANT ALL PRIVILEGES ON DBGallery.* TO root@'%' IDENTIFIED BY 'dbg';
[NOTE: DBGallery install defaults are used here. 'DBGallery' being the database name, 'root' being the username, and 'dbg' being the password. Change these for you environment if not using DBGallery's defaults.] To grant privileges to specific computers , use the following for each computer requiring access. This is a high security but fairly high maintenance but option each new client starting to use DBGallery will require this command to be executed:
GRANT ALL PRIVILEGES ON DBGallery.* TO root@'<machine name or ip>' IDENTIFIED BY 'dbg';
DBGallery has fairly simple table structures. A script could easily be written to copy data from your tables to DBGallery's. For example: Description is a varchar in StdAttrs. Copyright is a varchar in ImagesIPTCMetadata, as are about 30 other IPTC attributes. Any tool you might currently be using, such as MySql Administrator, would show the table structure once DBGallery was installed.
This question comes up in scenarios such as having used DBGallery on only one machine at home or the office and you're decided to add additional users.
There are two steps:
1) Perform configuration changes as detailed below. Don't be daunted by amount to text, it's really not all that difficult.
2) If not already done, purchase one additional copy of the DBGallery client for each machine it will be used on. Note that the database does not get installed on each machine.
Configuration changes required:
Below is the query to run to set things up to move to a shared database. Essentially it's just changing the database to have each image point to a network path instead of a local drive letter. This is required because a local drive such as C: doesn't mean much on other's computers, and the photos were likely initially added by dragging and dropping them from a local drive. Unless of course the photos were added from a network drive in the first place. If that is the case everything below won't be required. But if the photos were added from a local drive read on...
I've bolded the areas in the SQL below requiring change. In what's currently there win2k3-photo is the name of the computer and PhotoDisk is the a 'share' setup to provide access to photos on the network computer.
>>> These commands would be copy/pasted into the MySql Query Browser.
update images set img_loc = concat('\\\\win2k3-photo\\PhotoDisk', (select right(img_loc, (select CHAR_LENGTH(img_loc)-2)))) where (select left(img_loc, 2)) = 'C:';
update folders set folder_fullpath = concat('\\\\win2k3-photo\\PhotoDisk', (select right(folder_fullpath, (select CHAR_LENGTH(folder_fullpath)-2)))) where (select left(folder_fullpath, 2)) = 'C:';
Please backup your database before executing the query. See the Database Backup section of the User Guide here for help with that.
Two other things to note:
1. Write privileges are required for the share so IPTC/XMP data can be written to the files.
2. What might be seen on other's computers is 'Image Not Found' in the main thumbs view of DBGallery. That indicates that they don't have access to the share. There's a few options here: have users log onto the machine manually (not a great option), run DBGallery and a Net Use command from a batch file (e.g. "net use \\192.168.1.101\DriveD MyPassword /user:MyUserID", or use various other means to supply access to the share. Contact us direct via contact form if there are any issues with this.
There's also a short video on adding photos in a multi-user environment which has useful information to ensure photos added later are visible on each users' computer (watch it here). There's also a good look at a multi-user photo database setup in the video here.
Yes. Older versions of DBGallery can run on the latest version of the database. This is because the database tables are only every appended to. I.e. If there are five versions of DBGallery running around the office (or your home) which all hit the same database any one of them can be upgraded to the latest version. The others will continue to work as usual.
Yes. In the Advance Configuration options of the Enterprise version append the Database Server entry with “;port=XXXX” (without the quotes). E.g. “photoServer; Port=4306”.
This error can occur during installation when not logged into Windows as an Administrator. To resolve this, login to Windows as an Administrator to install DBGallery. Afterwards any non-Administrator or Administrator login will work to run DBGallery.
Drive Space Limit
DBGallery doesn't store the images in it's database, they're stored on your drives. So the size limit is dependent on the amount of disk space available.
Database Record Count Limit
In it's database, there is a record for each image. Hence it's the database storage limit which comes into play, and since we're using MySQL as the database, the limit is very large. A number of factors determine the maximum number, but the worse case would be in the millions.
The first storage limiting factor most customer come across with DBGallery is performance beyond some number of images. This is dependent on the process, disk and network speed. For example, a fast and new 2013 computer (I7 3rd generation, 16 GB ram) on the same kind of server, performance degradates at as you head towards 1 million images.
A User is added from the Help | Application Settings | Permissions and Connections tab. Press User Permissions followed by Add New User. Enter the basic user information and select which role the user belongs to. Note that all users are assigned a role. For full instructions, including easy to follow screenshots, see our Permissions Tutorial (PDF).
PLEASE NOTE: This plugin and its installation documentation requires technical web server knowledge.
For DBGallery 5.9: http://www.dbgallery.com/download/DBGallery_5.9_DatabaseCreation.txt (right-click and choose Save Link As, naming it with a .sql extension).
This creation script can be used for 5.9 and greater versions. Any version of DBGallery that runs after the database has been created will automatically make any required database table changes.
For an enterprise-level photo database system, DBGallery is exceptionally easy to install. Getting up an running with multiple computers connecting to the photo database usually takes less than an hour, rarely more than an hour or two. An overview of the steps are:
- Download DBGallery
- Install Step 1 of the setup program on the server
- Install Step 2 on computers connecting to the database
- On those computers, run DBGallery and enter the server name in the Database Server entry field when the Advanced Config dialog option appears.
- Finally, use either the Wizard to add photo locations which DBGallery will manage, or drag and drop those folders onto the program at any time later. Important: locations need to be a network location such as "\\server name\Photo Folders", or be a common shared drive letter, such as everyone having access to "P:\Photo Folders".
Beyond photos, also supported are videos, sound files, and PDFs.
Web server plugin
The web server plugin enables access to the DBGallery system from the internet using web browsers. Meant for those with technical webserver knowledge, download and install instructions for the plugin are here.
Installing DBGallery for personal use is extremely easy. Simply download the personal version of DBGallery and run the setup program. Then to add image folders, either use the wizard or drag and drop image folders onto DBGallery at any time.
Turn on the Advanced Query Options (Step 1 below) and then select the In checkbox (Step 2 below) after performing a search. This comes in handy in situation such as:
- Searching for images of an author(photographer) using a specific camera.
- Looking for all empty fields of all images added today.
Step 1: Turning on Advanced Query Options in DBGallery's Application Settings:
Step 2: Choose the In checkbox after performing an initial search, select another criteria and press Set Filter again.
Parrellels and VMWare Fusion can be used to run DBGallery on a Mac.
The image files and database may also reside on a Mac, or DBGallery can connect to the database and file servers running on Windows or Linux. Often there is one or two Mac users connecting the the same database as a larger number of users on Windows.
VMWare Fusion's Unity feature allows Windows applications to run on Mac desktop's. Run DBGallery as a Unity window and it appears DBGallery is running natively on a Mac! See how cleanly Unity run Windows applications in this YouTube video: http://www.youtube.com/watch?v=JIApJMzGzDQ