![]() ![]() Get the latest source tarball of mysql-python from (Regarding the charset and collation parameters here: they may be completely unnecessary in this use case, since I'm going to delete MySQL afterwards, but since all the client connections use some charset/collation, I'm covering my bases UTF-8 -wise just in case the default charset/collation used by MySQLdb is affected by how _mysql.so is compiled - wiser men than I may want to confirm this one way or the other.) configure -prefix=/usr/local/mysql-src/ -enable-static -disable-shared -with-charset=utf8 -with-extra-charsets=ascii,binary,latin1 -with-collation=utf8_general_ci I used the following, yours might differ on other counts: Just to be sure, I included -disable-shared, though it might not be strictly necessary. configure with whatever options suit your purposes, but you will require -enable-static. Get the source tarball of MySQL from (not the platform-specific binary tarball) It's pretty simple, actually I'll record the solution here in case someone else needs it: php script in the OrcaDbAccess folder to have the right db name and password.Never mind, found out myself after a bit more digging. Depending on your setup you may have to edit the. Where username is the user of sites folder and ‘’ is replaced by your database host machine. You should now have web access to the data base via a URL like: Unzip it and copy to your ‘sites’ folder. ![]() Unzip it and copy to your ‘sites’ folder.Ĩ) download the OrcaWeb site from OrcaWeb.zip. This moves you into the private:etc folder, and then copies to php.ini in the same folder.Ħ) Go into the System Preferences > Sharing and turn on Web Sharingħ) download the iOrca php access script from OrcaDbAccess.zip. LoadModule php5_module libexec/apache2/libphp5.so Scroll down to line 114 and remove the hash sign (#) To make the database available for iORCA and web access you need to do the following: | machine_id | name | hw_address | ip_address | password | uptime | version | You should now be able to go back into the terminal window and look at the database and see an entry for your machine: You should see the following in the ORCA status log:Ġ72111 19:34:31 Created Table machines in Database orcaĠ72111 19:34:31 Created Table Runs in Database orcaĠ72111 19:34:31 Created Table Alarms in Database orcaĠ72111 19:34:31 Created Table Processes in Database orcaĠ72111 19:34:32 Created Table Experiment in Database orcaĠ72111 19:34:32 Created Table Histogram1Ds in Database orcaĠ72111 19:34:32 Created Table Histogram2Ds in Database orcaĠ72111 19:34:32 Created Table SegmentMap in Database orcaĠ72111 19:34:32 Created Table Waveforms in Database orcaĠ72111 19:34:32 Created Table StatusLog in Database orca Once the database is established you will be most likely be running ORCA on another machine and the DB Host field would reference the actual database URL.Ĭonfirm that you want to create a new database. ![]() This is just for setting up the database tables. ![]() Note that the database does NOT need to be on a machine that is normally running ORCA. Fill in the fields like this, making sure that you use ‘localHost’ as the URL, and make sure you check the Disable button for this step. ![]()
0 Comments
Leave a Reply. |