Gestix on Mac OS X Yosemite – download this kickstarter to facilitate launching MySQL and Apache when needed

This tiny application has been created with Automator and can be inspected to see the applescript program inside it:

on run
    do shell script "/usr/local/mysql/bin/mysqld_safe > /dev/null 2>&1 &" with administrator privileges
    do shell script "apachectl restart > /dev/null 2>&1" with administrator privileges
end run

The script will try to launch MySQL by calling mysqld_safe directly, thus without the need to have the StartupItems / System Preferences components installed.

Then it will try restarting apache as well, by invoking apachectl restart.

Download link: http://gestix.com/download/Server-kickstarter-by-gestix.app.zip

Open the application, it will prompt for the computer’s password.Screen Shot 2015-05-27 at 8.47.42 PM

Then it tries launching both services and displays a confirmation message that enables  sending your feedback directly to the supporting team.

 

Screen Shot 2015-05-27 at 8.48.23 PM

 

 

 

 

Check the support page http://gestix.com/go/support

Like us on facebook http://facebook.com/gestix

How to start MySQL from the Mac OS-X Yosemite Terminal

Symptom: Gestix is working before the computer is shut down however. Once the computer is restarted, Gestix stops with the following message.

Gestix complains about the database system

Gestix complains about the database system

(It seems there is a problem with the database server. 
If the program was just working and you don’t know why this is happening, try reloading the page in a couple minutes. If the problem persists ask your system’s administrator attention to the problem.)

Although the MySQL Startup item seems to no longer work on OS-X 10.10, it’s possible to start it from the command line.

1. Open Finder | Applications | Utilities | Terminal

2. Paste this command and press Enter

sudo /usr/local/mysql/support-files/mysql.server start

3. Close the Terminal application.

If the problem persists there may be need for a remote technical intervention to the server by MySQL system specialists. Order technical support here.

Can’t remember my Gestix password – how to recover it?

If you are using Gestix Cloud or Gestix SaaS, over the Internet, then you just have to contact the technical support by email and make your request (http://gestix.com/go/contact)

Recover password on a Gestix Download installation.

Since the software is installed on your computer, the recovery has to be performed from the operating system command line.

Open Finder / Applications / Terminal and issue the following command:

/usr/local/mysql/bin/mysql -u gestix gnet_db --execute="Insert into sys_users (usr_name,usr_code,usr_pw,usr_disabled,usr_priv) VALUES ('temporario','temporario','[ana[',0,1);"

Then enter in Gestix using the following information:

Login: temporario
Password: civic

Then you should go to the Admin | Users menu and change your password. Delete the temporario user account when done.

For personal support from our engineers please check our help desk service http://gestix.pt/go/suporte/on-demand

Yosemite beta program: read before trying it…

Updating the operating system on computers running as Gestix servers can cause problems to the Gestix system, which depends on MySQL and on Mac OS-X’s built-in webserver (usually Apache) to operate correctly.

Most important, make sure you have a fresh backup copy made at Gestix Admin menu, just in case you have to install Gestix from scratch.

You may have to install the last version of MySQL compatible with the version of the operating system. Check the MySQL site for information about any issue you may find.
When MySQL is working correctly and in the same conditions as before (same users/passwords) then reinstall Gestix – instructions in http://gestix.com/go/software-update.
Check details about the Mac OS-X version you are dealing with. Check if the built-in Apache webserver support has changed and configure it manually reproducing the previous configuration:
AddHandler cgi-script .cgi

Alias /gnet "/var/lib/gestix/www"

<Directory "/var/lib/gestix/www">
 Options None
 AllowOverride None
 Order allow,deny
 Allow from all
</Directory>

#ScriptAlias /gnet/cgi-bin "/var/lib/gestix/www/cgi-bin/"

<Directory /var/lib/gestix/www/cgi-bin>
 Options ExecCGI Includes FollowSymLinks
 AllowOverride None
 Order allow,deny
 Allow from all
</Directory>
When both MySQL and the webserver Apache are operational, install Gestix again, following the instruction for installing a Gestix software update (http://gestix.com/en/software-update or http://gestix.com/pt/software-update). Open Gestix from the menu and press Cmd+R to reload the page if needed.
Generally this will fix the configuration of both MySQL and Apache, however many factors may interfere.
 mac-osx-yosemite-is-beta-use-this
For personal assistance from an engineer you may activate a support ticket with your technical support provider (check available options at http://gestix.com/go/support/on-demand when needed).
macosx-yosemite

You enjoy working with the Gestix software and have some spare time? Join us abroad!

Do you utilize or have utilized Gestix?

Do you find it different and special?

Do you have experience and skills that could help others improve their usage of technology in their businesses or non-profits?

Do you have some spare time to work with us through our cloud infrastructure, from your home or business place?

We’re looking for people like you to join our international support team and help new Gestix users in exploring the software.

You’ll find that your knowledge is valuable to others, be it about business processes and procedures for those who are exploring the software, be it about computing skills to help those installing and setting up particular configurations.

So easy and comfortable on the cloud as it is on premises: Gestix ERP CRM applications.

So easy and comfortable on the cloud as it is on premises: Gestix ERP CRM applications.

Send your resume to jobs@gestix.com, and tell us some words about your experience and skills. We’ll get back to you immediately on a follow up.

Thank you.

Gestix Software