mac os x from Lion to El Capitan and Lasso 8.6.0 to 8.6.3

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

mac os x from Lion to El Capitan and Lasso 8.6.0 to 8.6.3

Tom Fortis
Howdy Lasso List,

I hope there is a kind soul or two out there willing to share a similar experience. I need to update my Mac mini servers from Lion (10.7) to El Capitan (10.11). At the same time I want to update Lasso Pro from 8.6.0 to 8.6.3. Any experiences willing to be shared would be greatly appreciated. I have found from previous discussions a general direction to follow, including a 2.4.so apache connector, but I’m not sure about the upgrade process. I really don’t want to do a clean install. Hoping I can upgrade the OS in place and the same for Lasso. I have tried a dry run on my Dev server and having trouble with mysql (5.5) coming up on restart and Lasso doesn’t want to process files. I just get the Lasso code on the web page. I have made sure that the 2.4 connector is installed and the lasso8.conf file is configured in the proper location.

/usr/local/libexec/apache2/Lasso8ConnectorforApache2.4.so

/private/etc/apache2/users/lasso8.conf

Contents of lasso8.conf:

LoadModule lasso8_module /usr/local/libexec/apache2/Lasso8ConnectorforApache2.4.so

<Location ~ "^.*\.[Ll][Aa][Ss][Ss][Oo]$">
SetHandler lasso8-handler
</Location>

<Location ~ "^.*\.[Ll][Aa][Ss][Ss][Oo][Aa][Pp][Pp]$">
SetHandler lasso8-handler
</Location>

<Location ~ "^.*\.[Hh][Tt][Mm][Ll]$">
SetHandler lasso8-handler
</Location>


Installed the Legacy runtime for Java 6.

Lasso starts with no errors. The only anomaly in the Lasso console is the server trying to connect to mysql at the wrong IP. I figure I can work that one out in time. I’m more concerned about the lasso file processing issue. Having Lasso 8.6.0 installed and then running the 8.6.3 installer produces an error at the end of installation, after the verifying packages message, that the software couldn’t be installed, but I think it completed all the heavy work. I checked the Lasso Professional 8 directory and the software seems to be in place, as well as my custom tags.

Any experiences or comments would be much appreciated. I’m looking to retire from this position in a few weeks and hoping to leave my predecessor with an updated system that will run worry free for a few more years.

Thank you all for your amazing contributions over the years. I only wish I had more to give back to the Lasso community.

Best regards,

Tom Fortis
UC Davis

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: mac os x from Lion to El Capitan and Lasso 8.6.0 to 8.6.3

Marc Vos-3
Hi Tom,
Perhaps my post about Lasso 8 here can help : http://www.lassotalk.com/Re-El-Capitan.lasso?278869

Did you install MySQL yourself, then?10.11 Server comes with MySQL, doesn't it?
- -Regards,
Marc

                _____________________________
From: Tom Fortis <[hidden email]>
Sent: zaterdag, juni 11, 2016 6:06 AM
Subject: mac os x from Lion to El Capitan and Lasso 8.6.0 to 8.6.3
To:  <[hidden email]>


Howdy Lasso List,

I hope there is a kind soul or two out there willing to share a similar experience. I need to update my Mac mini servers from Lion (10.7) to El Capitan (10.11). At the same time I want to update Lasso Pro from 8.6.0 to 8.6.3. Any experiences willing to be shared would be greatly appreciated. I have found from previous discussions a general direction to follow, including a 2.4.so apache connector, but I’m not sure about the upgrade process. I really don’t want to do a clean install. Hoping I can upgrade the OS in place and the same for Lasso. I have tried a dry run on my Dev server and having trouble with mysql (5.5) coming up on restart and Lasso doesn’t want to process files. I just get the Lasso code on the web page. I have made sure that the 2.4 connector is installed and the lasso8.conf file is configured in the proper location.

/usr/local/libexec/apache2/Lasso8ConnectorforApache2.4.so

/private/etc/apache2/users/lasso8.conf

Contents of lasso8.conf:

LoadModule lasso8_module /usr/local/libexec/apache2/Lasso8ConnectorforApache2.4.so

<Location ~ "^.*\.[Ll][Aa][Ss][Ss][Oo]$">
SetHandler lasso8-handler
</Location>

<Location ~ "^.*\.[Ll][Aa][Ss][Ss][Oo][Aa][Pp][Pp]$">
SetHandler lasso8-handler
</Location>

<Location ~ "^.*\.[Hh][Tt][Mm][Ll]$">
SetHandler lasso8-handler
</Location>


Installed the Legacy runtime for Java 6.

Lasso starts with no errors. The only anomaly in the Lasso console is the server trying to connect to mysql at the wrong IP. I figure I can work that one out in time. I’m more concerned about the lasso file processing issue. Having Lasso 8.6.0 installed and then running the 8.6.3 installer produces an error at the end of installation, after the verifying packages message, that the software couldn’t be installed, but I think it completed all the heavy work. I checked the Lasso Professional 8 directory and the software seems to be in place, as well as my custom tags.

Any experiences or comments would be much appreciated. I’m looking to retire from this position in a few weeks and hoping to leave my predecessor with an updated system that will run worry free for a few more years.

Thank you all for your amazing contributions over the years. I only wish I had more to give back to the Lasso community.

Best regards,

Tom Fortis
UC Davis

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>


       

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: mac os x from Lion to El Capitan and Lasso 8.6.0 to 8.6.3

Tom Fortis
Hi Marc,

Yes, that is the post I have been using as a guideline! Thank you for putting that one together. I found that Apache is working out of /Library/Server/Web/Config/apache2/httpd_server_app.conf, which I didn’t expect. After updating that to include lasso8.conf, there is no difference in Lasso’s behavior.

I didn’t touch the MySQL installation throughout the upgrade. That may explain why I was surprised to see it available. There must be some kind of conflict going on with it though. When Lasso tries to connect to it, there is a mismatch of IP addresses. That is the only glaring problem in the startup log that I see when I use consoleLassoservice.command.

It seems like I’m just a simple tweak away from getting Lasso to process pages. Perhaps the Lasso8ConnectorforApache2.4.so file I’m using isn’t quite right. There are a few out there that I found, do you have a feel for which one might be the best fit for El Capitan?

I need to simultaneously look at the MySQL installation to see if there is a conflict. Multi-threading now…

Thank you for your help!

Tom

On Jun 10, 2016, at 11:13 PM, [hidden email]<mailto:[hidden email]> wrote:

Hi Tom,
Perhaps my post about Lasso 8 here can help : http://www.lassotalk.com/Re-El-Capitan.lasso?278869

Did you install MySQL yourself, then?10.11 Server comes with MySQL, doesn't it?
- -Regards,
Marc

_____________________________
From: Tom Fortis <[hidden email]<mailto:[hidden email]>>
Sent: zaterdag, juni 11, 2016 6:06 AM
Subject: mac os x from Lion to El Capitan and Lasso 8.6.0 to 8.6.3
To:  <[hidden email]<mailto:[hidden email]>>


Howdy Lasso List,

I hope there is a kind soul or two out there willing to share a similar experience. I need to update my Mac mini servers from Lion (10.7) to El Capitan (10.11). At the same time I want to update Lasso Pro from 8.6.0 to 8.6.3. Any experiences willing to be shared would be greatly appreciated. I have found from previous discussions a general direction to follow, including a 2.4.so apache connector, but I’m not sure about the upgrade process. I really don’t want to do a clean install. Hoping I can upgrade the OS in place and the same for Lasso. I have tried a dry run on my Dev server and having trouble with mysql (5.5) coming up on restart and Lasso doesn’t want to process files. I just get the Lasso code on the web page. I have made sure that the 2.4 connector is installed and the lasso8.conf file is configured in the proper location.

/usr/local/libexec/apache2/Lasso8ConnectorforApache2.4.so

/private/etc/apache2/users/lasso8.conf

Contents of lasso8.conf:

LoadModule lasso8_module /usr/local/libexec/apache2/Lasso8ConnectorforApache2.4.so

<Location ~ "^.*\.[Ll][Aa][Ss][Ss][Oo]$">
SetHandler lasso8-handler
</Location>

<Location ~ "^.*\.[Ll][Aa][Ss][Ss][Oo][Aa][Pp][Pp]$">
SetHandler lasso8-handler
</Location>

<Location ~ "^.*\.[Hh][Tt][Mm][Ll]$">
SetHandler lasso8-handler
</Location>


Installed the Legacy runtime for Java 6.

Lasso starts with no errors. The only anomaly in the Lasso console is the server trying to connect to mysql at the wrong IP. I figure I can work that one out in time. I’m more concerned about the lasso file processing issue. Having Lasso 8.6.0 installed and then running the 8.6.3 installer produces an error at the end of installation, after the verifying packages message, that the software couldn’t be installed, but I think it completed all the heavy work. I checked the Lasso Professional 8 directory and the software seems to be in place, as well as my custom tags.

Any experiences or comments would be much appreciated. I’m looking to retire from this position in a few weeks and hoping to leave my predecessor with an updated system that will run worry free for a few more years.

Thank you all for your amazing contributions over the years. I only wish I had more to give back to the Lasso community.

Best regards,

Tom Fortis
UC Davis

#############################################################

This message is sent to you because you are subscribed to
 the mailing list Lasso [hidden email]<mailto:[hidden email]>
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]<mailto:[hidden email]>>
Send administrative queries to  <[hidden email]<mailto:[hidden email]>>




#############################################################

This message is sent to you because you are subscribed to
 the mailing list Lasso [hidden email]<mailto:[hidden email]>
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]<mailto:[hidden email]>>
Send administrative queries to  <[hidden email]<mailto:[hidden email]>>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: mac os x from Lion to El Capitan and Lasso 8.6.0 to 8.6.3

Marc Vos-3
Just to be sure:

1) Check if you have added 'index.lasso' to the 'DirectoryIndex' statement, probably found somewhere in 'httpd_server_app.conf'. Mine looks like this: ' DirectoryIndex index.html index.ls index.lasso index.php index.htm'

2) Open Terminal and do 'sudo apachectl configcheck'

3) I think 10.11 server has no MySQL by default. So it's probably best to install the latest version for El Capitan. And read this : https://dev.mysql.com/doc/refman/5.6/en/osx-installation-launchd.html

Also, I use this guide I made, maybe it helps you too:
--------------------------------------------------------------------------------------------------------------
Repair MySQL upgrade after running the package-installer for a new MySQL version.
This goes also BEFORE you install a new version, in that case just leave out the steps for the 5.6 version.

1) Delete installation receipts:

$ su root
$ rm -rf /var/db/receipts/com.mysql.*

2) Delete current installations, except the one which /data directory you want to keep:

$ cd /usr/local
$ ls -l
lrwxr-xr-x    1 root     wheel    27 22 feb 10:30 mysql -> mysql-5.6.29-osx10.8-x86_64
drwxr-xr-x    4 root     wheel   136 22 feb 14:08 mysql-5.1.37-osx10.5-x86
drwxr-xr-x   16 root     wheel   544 22 feb 10:30 mysql-5.6.29-osx10.8-x86_64

3) In this case, the mysql-5.1.37-osx10.5-x86 folder contains all data, i.e. my databases.
Rename this folder to something like mysql_previous:

$ ls -l
lrwxr-xr-x    1 root     wheel    27 22 feb 10:30 mysql -> mysql-5.6.29-osx10.8-x86_64
drwxr-xr-x   16 root     wheel   544 22 feb 10:30 mysql-5.6.29-osx10.8-x86_64
drwxr-xr-x    4 root     wheel   136 22 feb 14:08 mysql_previous

4) Remove the complete mysql instance and all other relevant files:

$ cd mysql-5.6.29-osx10.8-x86_64
$ rm -rf *

$ cd ..
$ rm mysql
$ rmdir mysql-5.6.29-osx10.8-x86_64

$ cd /Library/StartupItems/
$ rm -rf *MySQL*

$ cd /Library/PreferencePanes
$ rm -rf *MySQL*

$ vi /etc/hostconfig
[remove the line MYSQLCOM=….]

$ vi /Library/Receipts/InstallHistory.plist
[remove
        <dict>
                <key>date</key>
                <date>2016-02-22T09:30:17Z</date>
                <key>displayName</key>
                <string>MySQL 5.6.29-community</string>
                <key>displayVersion</key>
                <string></string>
                <key>packageIdentifiers</key>
                <array>
                        <string>com.mysql.mysql</string>
                        <string>com.mysql.prefpane</string>
                        <string>com.mysql.launchd</string>
                </array>
                <key>processName</key>
                <string>Installer</string>
        </dict>
]

$ launchctl unload -w /Library/LaunchDaemons/com.mysql.mysql.plist
$ launchctl unload -w /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
$ ps -ef | grep -i mysql
    0 20842 20833   0  8:14pm ttys000    0:00.00 grep -i mysql

$ cd /Library/LaunchDaemons/
$ ls -l *mysql*
-rw-r--r--  1 root  wheel   348 27 mei  2015 com.mysql.mysql.plist
-rw-r--r--  1 root  wheel  1370 15 jan 04:16 com.oracle.oss.mysql.mysqld.plist
$ rm -f *mysql*

$ cd /usr/local
$ vi copy_mysql_tables.sh
[change cq. add these copy commands (do not copy MySQL's own tables!):
cp -Rp mysql_previous/data/my_own_database1    mysql/data/
cp -Rp mysql_previous/data/my_own_database2    mysql/data/
cp -Rp mysql_previous/data/my_own_database3 mysql/data/
….
]
$ chmod a+x copy_mysql_tables.sh

$ cd /usr/local/lib/mysql
$ rm -rf *
$ cd ..
$ rmdir mysql

RESTART YOUR MAC

5) Download MySQL, for example the latest 5.6 and install.

6) Check if it is running via System Preferences -> MySQL (and eventually start it via this preference pane)

7) Start Navicat or MySQL Workbench and login with root without password and then set the password. Logout and login again with password.

8) Create the user lasso for Lasso 8 and Lasso 9 and set passwords for other root-users

9) Run the copy script:

$ su root
$ cd /usr/local
$ ./copy_mysql_tables.sh
$ mysqlcheck -u root -p --auto-repair --check --all-databases

10) Start Navicat or MySQL Workbench and check if all databases show in localhost.

11) Remove the previous MySQL version

$ cd /usr/local/mysql_previous
$ rm -rf *
$ cd ..
$ rmdir mysql_previous

12) Check if Lasso 8 and Lasso 9 have access
- By running localuser/[webapp], or
- By checking in SiteAdmin (L8) and/or Lux (L9).

DONE
--------------------------------------------------------------------------------------------------------------

- -
Good luck,
Marc



On 11-06-2016 16:56, "Tom Fortis" <[hidden email] on behalf of [hidden email]> wrote:

>Hi Marc,
>
>Yes, that is the post I have been using as a guideline! Thank you for putting that one together. I found that Apache is working out of /Library/Server/Web/Config/apache2/httpd_server_app.conf, which I didn’t expect. After updating that to include lasso8.conf, there is no difference in Lasso’s behavior.
>
>I didn’t touch the MySQL installation throughout the upgrade. That may explain why I was surprised to see it available. There must be some kind of conflict going on with it though. When Lasso tries to connect to it, there is a mismatch of IP addresses. That is the only glaring problem in the startup log that I see when I use consoleLassoservice.command.
>
>It seems like I’m just a simple tweak away from getting Lasso to process pages. Perhaps the Lasso8ConnectorforApache2.4.so file I’m using isn’t quite right. There are a few out there that I found, do you have a feel for which one might be the best fit for El Capitan?
>
>I need to simultaneously look at the MySQL installation to see if there is a conflict. Multi-threading now…
>
>Thank you for your help!
>
>Tom
>
>On Jun 10, 2016, at 11:13 PM, [hidden email]<mailto:[hidden email]> wrote:
>
>Hi Tom,
>Perhaps my post about Lasso 8 here can help : http://www.lassotalk.com/Re-El-Capitan.lasso?278869
>
>Did you install MySQL yourself, then?10.11 Server comes with MySQL, doesn't it?
>- -Regards,
>Marc
>
>_____________________________
>From: Tom Fortis <[hidden email]<mailto:[hidden email]>>
>Sent: zaterdag, juni 11, 2016 6:06 AM
>Subject: mac os x from Lion to El Capitan and Lasso 8.6.0 to 8.6.3
>To:  <[hidden email]<mailto:[hidden email]>>
>
>
>Howdy Lasso List,
>
>I hope there is a kind soul or two out there willing to share a similar experience. I need to update my Mac mini servers from Lion (10.7) to El Capitan (10.11). At the same time I want to update Lasso Pro from 8.6.0 to 8.6.3. Any experiences willing to be shared would be greatly appreciated. I have found from previous discussions a general direction to follow, including a 2.4.so apache connector, but I’m not sure about the upgrade process. I really don’t want to do a clean install. Hoping I can upgrade the OS in place and the same for Lasso. I have tried a dry run on my Dev server and having trouble with mysql (5.5) coming up on restart and Lasso doesn’t want to process files. I just get the Lasso code on the web page. I have made sure that the 2.4 connector is installed and the lasso8.conf file is configured in the proper location.
>
>/usr/local/libexec/apache2/Lasso8ConnectorforApache2.4.so
>
>/private/etc/apache2/users/lasso8.conf
>
>Contents of lasso8.conf:
>
>LoadModule lasso8_module /usr/local/libexec/apache2/Lasso8ConnectorforApache2.4.so
>
><Location ~ "^.*\.[Ll][Aa][Ss][Ss][Oo]$">
>SetHandler lasso8-handler
></Location>
>
><Location ~ "^.*\.[Ll][Aa][Ss][Ss][Oo][Aa][Pp][Pp]$">
>SetHandler lasso8-handler
></Location>
>
><Location ~ "^.*\.[Hh][Tt][Mm][Ll]$">
>SetHandler lasso8-handler
></Location>
>
>
>Installed the Legacy runtime for Java 6.
>
>Lasso starts with no errors. The only anomaly in the Lasso console is the server trying to connect to mysql at the wrong IP. I figure I can work that one out in time. I’m more concerned about the lasso file processing issue. Having Lasso 8.6.0 installed and then running the 8.6.3 installer produces an error at the end of installation, after the verifying packages message, that the software couldn’t be installed, but I think it completed all the heavy work. I checked the Lasso Professional 8 directory and the software seems to be in place, as well as my custom tags.
>
>Any experiences or comments would be much appreciated. I’m looking to retire from this position in a few weeks and hoping to leave my predecessor with an updated system that will run worry free for a few more years.
>
>Thank you all for your amazing contributions over the years. I only wish I had more to give back to the Lasso community.
>
>Best regards,
>
>Tom Fortis
>UC Davis
>
>#############################################################
>
>This message is sent to you because you are subscribed to
> the mailing list Lasso [hidden email]<mailto:[hidden email]>
>Official list archives available at http://www.lassotalk.com
>To unsubscribe, E-mail to: <[hidden email]<mailto:[hidden email]>>
>Send administrative queries to  <[hidden email]<mailto:[hidden email]>>
>
>
>
>
>#############################################################
>
>This message is sent to you because you are subscribed to
> the mailing list Lasso [hidden email]<mailto:[hidden email]>
>Official list archives available at http://www.lassotalk.com
>To unsubscribe, E-mail to: <[hidden email]<mailto:[hidden email]>>
>Send administrative queries to  <[hidden email]<mailto:[hidden email]>>
>
>#############################################################
>
>This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
>Official list archives available at http://www.lassotalk.com
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>



#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: mac os x from Lion to El Capitan and Lasso 8.6.0 to 8.6.3

Tom Fortis
Marc,

Thank you!

Following your guidelines we were able to successfully upgrade to El Capitan and upgrade Lasso to 8.6.3.  We decided to leave MySQL at 5.5 for now, but everything is working perfectly at this point in time.

Your help and wisdom is much appreciated!

Cheers!

Tom

> On Jun 11, 2016, at 11:13 AM, Marc Vos <[hidden email]> wrote:
>
> Just to be sure:
>
> 1) Check if you have added 'index.lasso' to the 'DirectoryIndex' statement, probably found somewhere in 'httpd_server_app.conf'. Mine looks like this: ' DirectoryIndex index.html index.ls index.lasso index.php index.htm'
>
> 2) Open Terminal and do 'sudo apachectl configcheck'
>
> 3) I think 10.11 server has no MySQL by default. So it's probably best to install the latest version for El Capitan. And read this : https://dev.mysql.com/doc/refman/5.6/en/osx-installation-launchd.html
>
> Also, I use this guide I made, maybe it helps you too:
> --------------------------------------------------------------------------------------------------------------
> Repair MySQL upgrade after running the package-installer for a new MySQL version.
> This goes also BEFORE you install a new version, in that case just leave out the steps for the 5.6 version.
>
> 1) Delete installation receipts:
>
> $ su root
> $ rm -rf /var/db/receipts/com.mysql.*
>
> 2) Delete current installations, except the one which /data directory you want to keep:
>
> $ cd /usr/local
> $ ls -l
> lrwxr-xr-x    1 root     wheel    27 22 feb 10:30 mysql -> mysql-5.6.29-osx10.8-x86_64
> drwxr-xr-x    4 root     wheel   136 22 feb 14:08 mysql-5.1.37-osx10.5-x86
> drwxr-xr-x   16 root     wheel   544 22 feb 10:30 mysql-5.6.29-osx10.8-x86_64
>
> 3) In this case, the mysql-5.1.37-osx10.5-x86 folder contains all data, i.e. my databases.
> Rename this folder to something like mysql_previous:
>
> $ ls -l
> lrwxr-xr-x    1 root     wheel    27 22 feb 10:30 mysql -> mysql-5.6.29-osx10.8-x86_64
> drwxr-xr-x   16 root     wheel   544 22 feb 10:30 mysql-5.6.29-osx10.8-x86_64
> drwxr-xr-x    4 root     wheel   136 22 feb 14:08 mysql_previous
>
> 4) Remove the complete mysql instance and all other relevant files:
>
> $ cd mysql-5.6.29-osx10.8-x86_64
> $ rm -rf *
>
> $ cd ..
> $ rm mysql
> $ rmdir mysql-5.6.29-osx10.8-x86_64
>
> $ cd /Library/StartupItems/
> $ rm -rf *MySQL*
>
> $ cd /Library/PreferencePanes
> $ rm -rf *MySQL*
>
> $ vi /etc/hostconfig
> [remove the line MYSQLCOM=….]
>
> $ vi /Library/Receipts/InstallHistory.plist
> [remove
>        <dict>
>                <key>date</key>
>                <date>2016-02-22T09:30:17Z</date>
>                <key>displayName</key>
>                <string>MySQL 5.6.29-community</string>
>                <key>displayVersion</key>
>                <string></string>
>                <key>packageIdentifiers</key>
>                <array>
>                        <string>com.mysql.mysql</string>
>                        <string>com.mysql.prefpane</string>
>                        <string>com.mysql.launchd</string>
>                </array>
>                <key>processName</key>
>                <string>Installer</string>
>        </dict>
> ]
>
> $ launchctl unload -w /Library/LaunchDaemons/com.mysql.mysql.plist
> $ launchctl unload -w /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
> $ ps -ef | grep -i mysql
>    0 20842 20833   0  8:14pm ttys000    0:00.00 grep -i mysql
>
> $ cd /Library/LaunchDaemons/
> $ ls -l *mysql*
> -rw-r--r--  1 root  wheel   348 27 mei  2015 com.mysql.mysql.plist
> -rw-r--r--  1 root  wheel  1370 15 jan 04:16 com.oracle.oss.mysql.mysqld.plist
> $ rm -f *mysql*
>
> $ cd /usr/local
> $ vi copy_mysql_tables.sh
> [change cq. add these copy commands (do not copy MySQL's own tables!):
> cp -Rp mysql_previous/data/my_own_database1    mysql/data/
> cp -Rp mysql_previous/data/my_own_database2    mysql/data/
> cp -Rp mysql_previous/data/my_own_database3 mysql/data/
> ….
> ]
> $ chmod a+x copy_mysql_tables.sh
>
> $ cd /usr/local/lib/mysql
> $ rm -rf *
> $ cd ..
> $ rmdir mysql
>
> RESTART YOUR MAC
>
> 5) Download MySQL, for example the latest 5.6 and install.
>
> 6) Check if it is running via System Preferences -> MySQL (and eventually start it via this preference pane)
>
> 7) Start Navicat or MySQL Workbench and login with root without password and then set the password. Logout and login again with password.
>
> 8) Create the user lasso for Lasso 8 and Lasso 9 and set passwords for other root-users
>
> 9) Run the copy script:
>
> $ su root
> $ cd /usr/local
> $ ./copy_mysql_tables.sh
> $ mysqlcheck -u root -p --auto-repair --check --all-databases
>
> 10) Start Navicat or MySQL Workbench and check if all databases show in localhost.
>
> 11) Remove the previous MySQL version
>
> $ cd /usr/local/mysql_previous
> $ rm -rf *
> $ cd ..
> $ rmdir mysql_previous
>
> 12) Check if Lasso 8 and Lasso 9 have access
> - By running localuser/[webapp], or
> - By checking in SiteAdmin (L8) and/or Lux (L9).
>
> DONE
> --------------------------------------------------------------------------------------------------------------
>
> - -
> Good luck,
> Marc
>
>
>
> On 11-06-2016 16:56, "Tom Fortis" <[hidden email] on behalf of [hidden email]> wrote:
>
>> Hi Marc,
>>
>> Yes, that is the post I have been using as a guideline! Thank you for putting that one together. I found that Apache is working out of /Library/Server/Web/Config/apache2/httpd_server_app.conf, which I didn’t expect. After updating that to include lasso8.conf, there is no difference in Lasso’s behavior.
>>
>> I didn’t touch the MySQL installation throughout the upgrade. That may explain why I was surprised to see it available. There must be some kind of conflict going on with it though. When Lasso tries to connect to it, there is a mismatch of IP addresses. That is the only glaring problem in the startup log that I see when I use consoleLassoservice.command.
>>
>> It seems like I’m just a simple tweak away from getting Lasso to process pages. Perhaps the Lasso8ConnectorforApache2.4.so file I’m using isn’t quite right. There are a few out there that I found, do you have a feel for which one might be the best fit for El Capitan?
>>
>> I need to simultaneously look at the MySQL installation to see if there is a conflict. Multi-threading now…
>>
>> Thank you for your help!
>>
>> Tom
>>
>> On Jun 10, 2016, at 11:13 PM, [hidden email]<mailto:[hidden email]> wrote:
>>
>> Hi Tom,
>> Perhaps my post about Lasso 8 here can help : http://www.lassotalk.com/Re-El-Capitan.lasso?278869
>>
>> Did you install MySQL yourself, then?10.11 Server comes with MySQL, doesn't it?
>> - -Regards,
>> Marc
>>
>> _____________________________
>> From: Tom Fortis <[hidden email]<mailto:[hidden email]>>
>> Sent: zaterdag, juni 11, 2016 6:06 AM
>> Subject: mac os x from Lion to El Capitan and Lasso 8.6.0 to 8.6.3
>> To:  <[hidden email]<mailto:[hidden email]>>
>>
>>
>> Howdy Lasso List,
>>
>> I hope there is a kind soul or two out there willing to share a similar experience. I need to update my Mac mini servers from Lion (10.7) to El Capitan (10.11). At the same time I want to update Lasso Pro from 8.6.0 to 8.6.3. Any experiences willing to be shared would be greatly appreciated. I have found from previous discussions a general direction to follow, including a 2.4.so apache connector, but I’m not sure about the upgrade process. I really don’t want to do a clean install. Hoping I can upgrade the OS in place and the same for Lasso. I have tried a dry run on my Dev server and having trouble with mysql (5.5) coming up on restart and Lasso doesn’t want to process files. I just get the Lasso code on the web page. I have made sure that the 2.4 connector is installed and the lasso8.conf file is configured in the proper location.
>>
>> /usr/local/libexec/apache2/Lasso8ConnectorforApache2.4.so
>>
>> /private/etc/apache2/users/lasso8.conf
>>
>> Contents of lasso8.conf:
>>
>> LoadModule lasso8_module /usr/local/libexec/apache2/Lasso8ConnectorforApache2.4.so
>>
>> <Location ~ "^.*\.[Ll][Aa][Ss][Ss][Oo]$">
>> SetHandler lasso8-handler
>> </Location>
>>
>> <Location ~ "^.*\.[Ll][Aa][Ss][Ss][Oo][Aa][Pp][Pp]$">
>> SetHandler lasso8-handler
>> </Location>
>>
>> <Location ~ "^.*\.[Hh][Tt][Mm][Ll]$">
>> SetHandler lasso8-handler
>> </Location>
>>
>>
>> Installed the Legacy runtime for Java 6.
>>
>> Lasso starts with no errors. The only anomaly in the Lasso console is the server trying to connect to mysql at the wrong IP. I figure I can work that one out in time. I’m more concerned about the lasso file processing issue. Having Lasso 8.6.0 installed and then running the 8.6.3 installer produces an error at the end of installation, after the verifying packages message, that the software couldn’t be installed, but I think it completed all the heavy work. I checked the Lasso Professional 8 directory and the software seems to be in place, as well as my custom tags.
>>
>> Any experiences or comments would be much appreciated. I’m looking to retire from this position in a few weeks and hoping to leave my predecessor with an updated system that will run worry free for a few more years.
>>
>> Thank you all for your amazing contributions over the years. I only wish I had more to give back to the Lasso community.
>>
>> Best regards,
>>
>> Tom Fortis
>> UC Davis
>>
>> #############################################################
>>
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso [hidden email]<mailto:[hidden email]>
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <[hidden email]<mailto:[hidden email]>>
>> Send administrative queries to  <[hidden email]<mailto:[hidden email]>>
>>
>>
>>
>>
>> #############################################################
>>
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso [hidden email]<mailto:[hidden email]>
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <[hidden email]<mailto:[hidden email]>>
>> Send administrative queries to  <[hidden email]<mailto:[hidden email]>>
>>
>> #############################################################
>>
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso [hidden email]
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: mac os x from Lion to El Capitan and Lasso 8.6.0 to 8.6.3

Marc Vos-3
Nice to read you got it all up and running!

- -
Marc


On 14-06-2016 01:47, "Tom Fortis" <[hidden email] on behalf of [hidden email]> wrote:

>Marc,
>
>Thank you!
>
>Following your guidelines we were able to successfully upgrade to El Capitan and upgrade Lasso to 8.6.3.  We decided to leave MySQL at 5.5 for now, but everything is working perfectly at this point in time.
>
>Your help and wisdom is much appreciated!
>
>Cheers!
>
>Tom



#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>