Docs‎ > ‎Espresso Appliance‎ > ‎


The Espresso Logic Appliance virtual machine does not have an IP address after starting

After the Espresso Logic Appliance virtual machine has started the VMware Console's window will show the Appliance IP, such as or whatever DHCP address your virtual machine has received from your network like the screen shot below:

if instead you see "Unable to get a valid DHCP address, please visit"...

Then VMware was not able to provide a DHCP address to the appliance. There can be multiple reasons for this:

Log into the Espresso Logic Appliance Virtual Machine's Operating System
First try:

# sudo ifup eth0

Device eth0 does not seem to be present, delaying initialization

If you see message "Device eth0 does not seem to be present, delaying initialization" what’s happening here is that VMware applied a new MAC Address to your network interfaces but didn't update the linux configuration files to mirror these changes and so the linux kernel can’t find or start the interface that matches it’s configuration (with the old MAC Address) and it finds a new interface (the new MAC Address) that it has no configuration information for. The result is that only your networking service can only start the loopback networking interface and eth0 is dead.

So here’s how to fix it:
Remove the kernel’s networking interface rules file so that it can be regenerated

# sudo rm ‐f /etc/udev/rules.d/70‐persistent‐net.rules
# sudo reboot 

If after rebooting, the problem persists: 

VMware (Player, Workstation and Fusion) supports three different networking strategies:
 Type Behavior
Bridged Bridged mode replicates another node on the physical network and your Virtual Machine will receive it's own unique IP address if DHCP is enabled in the network.
Network Address Translation (NAT) just like your home network with a wireless router, the VM will be assigned in a separate subnet, like is your host computer, and VM is, then your Virtual Machine can access outside network like your host, but no outside access to your Virtual Machine  directly, it's protected.
Host only networking The Virtual Machine will be assigned one IP, but it's only accessible by the computer that the Virtual Machine is running on. No other computers can access it.

To change VMware network strategy:
  • Shut / power down the Espresso Logic Appliance Virtual Machine
  • In VMware Player for example
    • Click 'Player'
    • Click 'Manage'
    • Click 'Virtual Machine Settings'
    • Change 'Network Adapter' from 'NAT' to 'Bridged' (if it was already in 'Bridged' mode, try NAT)
A "Bridged" network strategy is the most flexible.

TCP/IP connection to the host database has failed 

Log into the Espresso Logic Appliance Virtual Machine's Operating System
  • Is your Domain Network Service (DNS) resolving hostnames properly?
    • ping
      should see something like this:

      ping ( 56 data bytes
      64 bytes from ( icmp_seq=1 ttl=46 time=1.33 ms

    • if this fails, try ping

    • if both fail try traceroute
      You should see something like this or see where a firewall is blocking you:

      traceroute to (, 30 hops max, 60 byte packets

       1 (  0.984 ms  2.019 ms  2.325 ms
       2 (  0.782 ms  0.800 ms (  0.865 ms
       3 (  0.773 ms (  0.933 ms (  0.998 ms
       4  * * *
       5  * * *
       6 (  2.561 ms (  4.934 ms (  16.338 ms
       7 (  3.602 ms (  5.634 ms (  0.846 ms
       8 (  0.579 ms (  0.535 ms (  0.687 ms
      9 (  1.437 ms (  11.382 ms (  2.234 ms|
      10 (  1.673 ms (  1.743 ms (  1.942 ms
      11 (  15.061 ms (  1.172 ms (  7.977 m
      12 (  1.029 ms (  1.159 ms (  1.417 ms
      13 (  0.819 ms (  0.661 ms (  0.863 ms
      14 (  0.925 ms (  0.863 ms (  0.504 ms
      15 (  0.792 ms (  1.286 ms (  0.987 ms
      16 (  1.051 ms  1.076 ms  0.935 ms
      17 (  0.924 ms  0.851 ms (  16.425 ms
      18 (  1.074 ms (  1.828 ms (  16.080 ms
      19 (  1.989 ms  3.563 ms  3.446 ms
      20 (  1.047 ms  1.821 ms  1.617 ms

  • Can you connect to the database's port? for example:
    • telnet 1433
      should see:
          Connected to
          Escape character is '^]'.

Microsoft SQL Server login failed for user ClientConnectionId


Has TCP/IP protocol been enabled from SQL Server Management Server? Make sure that TCP/IP is enabled in SQL Server Configuration Manager and that IPAll (ignore the other ports, e.g. IP1, IP2, etc...) has an assigned TCP Port (note: this is TCP Port, not TCP Dynamic Ports).

Connecting to Microsoft SQL Server


The EspressoLogic appliance is hosted on a CentOS virtual machine which means that we can not use Window's Authentication to your Microsoft SQL Server database Therefore SQL Server Authentication is a requirement. Here is a Microsoft article concerning changing SQL Server and Windows Authentication mode
Here is a Microsoft Knowledge Base article on opening Windows Firewall Ports to allow database connectivity from the Espresso Logic appliance:

No Tables, Views, Procedures, Foreign Keys nor Columns detected after successful database connection

This usually means that the "Schema Owner" specified in the Database Connection wizard is incorrect. In Microsoft SQL Server, the Schema Owner is usually "dbo", not "sa" for example.

Microsoft SQL Server 2005 hangs while reading in Foreign Keys

Under Integrate
Click Data Sources
Change Database URL from:

Isolating Database Connection and / or reading problems 

Log into the Espresso Logic Appliance Virtual Machine's Operating System

Test Connection and / or reading problems

cd  /usr/share/espresso/diagnostics

Usage ./ <url> <db user name> <password>

example ./ 'jdbc:sqlserver://;databaseName=Northwind' northwind NorthwindPassword\!
















Table types





Test by running a SQL command

[tomcat@espresso diagnostics]$ ./ 

Usage ./ <url> <db user name> <password> [sql command]

example ./ 'jdbc:sqlserver://;databaseName=Northwind' northwind NorthwindPassword\! 'select * from master..sysdatabases'

[tomcat@espresso diagnostics]$ ./ 'jdbc:sqlserver://;databaseName=Northwind' northwind NorthwindPassword\! 'select * from master..sysdatabases'

Connection successful

*****Execute SQL Command:select * from master..sysdatabases







crdate:2003-04-08 09:13:36.39, 

reserved:1900-01-01 00:00:00.0, 






I forgot my root password to mysql running on the appliance and need to reset it

sudo  su -
service mysqld stop
/usr/bin/mysqld --skip-grant-tables --user=root

mysql -u root
UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='root';

service mysqld restart

SELinux issue with mysql or httpd

ls -lZ /etc/httpd/conf.d
-rw-r--r--. root root system_u:object_r:httpd_config_t:s0 README
-rw-r--r--. root root unconfined_u:object_r:httpd_config_t:s0 ssl.conf
-rw-r--r--. root root system_u:object_r:httpd_config_t:s0 welcome.conf

 ls -lZ /var/lib/mysql
(ls is the selinux list function to detail the labels for each object.

This is the default directory and will list these objects.
drwx------. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 mysql

-rw-rw----. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 auto.cnf
drwx------. mysql mysql system_u:object_r:mysqld_db_t:s0 espresso_admin
drwx------. mysql mysql system_u:object_r:mysqld_db_t:s0 espresso_data
drwx------. mysql mysql system_u:object_r:mysqld_db_t:s0 espresso_demo
-rw-r-----. mysql root  unconfined_u:object_r:mysqld_db_t:s0 espresso.err
drwx------. mysql mysql system_u:object_r:mysqld_db_t:s0 espresso_sample
-rw-rw----. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 ibdata1
-rw-rw----. mysql mysql system_u:object_r:mysqld_db_t:s0 ib_logfile0
-rw-rw----. mysql mysql system_u:object_r:mysqld_db_t:s0 ib_logfile1
drwx--x--x. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 mysql
srwxrwxrwx. mysql mysql system_u:object_r:mysqld_var_run_t:s0 mysql.sock
drwx------. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 performance_schema
-rw-r--r--. root  root  unconfined_u:object_r:mysqld_db_t:s0 RPM_UPGRADE_HISTORY
-rw-r--r--. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 RPM_UPGRADE_MARKER-LAST
drwxr-xr-x. mysql mysql unconfined_u:object_r:mysqld_db_t:s0 test

I encountered a defect or want to update the Espresso Logic Appliance's Operating System, software and database

Log into the Espresso Logic Appliance Virtual Machine's Operating System

sudo yum -y update
sudo reboot

VMware console has grabbed cursor and keyboard focus

Default Hot-Key Combinations

You can use keyboard shortcuts to interact with Workstation and with virtual machines. Most of the available keyboard shortcuts for Workstation are listed next to their associated commands in Workstation menus.

Default Hot-Key Combinations




Grab input from the keyboard and mouse.


Release the mouse cursor.


Shut down or, depending on the guest operating system, log out of the guest operating system. This command is received solely by the virtual machine.


Shut down or, depending on the operating system, log out of the guest operating system.

On a Windows host, if you do not use the enhanced virtual keyboard feature, both the host operating system and the virtual machine receive this command, even when Workstation has control of input. Cancel the ending of the host operating system session and return to the virtual machine to log out or shut down or perform administrative tasks.


Enter full screen mode.


Send any command to the virtual machine so that Workstation does not process it. Hold down Ctrl+Alt as you press and release the spacebar, and continue to hold the Ctrl+Alt keys down as you press the next key in the combination.



(Windows hosts only) Switch among tabs.

Ctrl+Alt+right arrow

In full screen mode, switch to the next powered-on virtual machine.

Ctrl+Alt+left arrow

In full screen mode, switch to the previous powered-on virtual machine.


In Unity mode, give access to the virtual machine Start or Applications menu.

You can change the Unity hot-key combination by modifying Unity preference settings.