skyhighmac Posted July 8, 2008 Author Share Posted July 8, 2008 Yeah, the default install doesn't include mysql or the php module compiled with mysql support. Try beta4 through software update - tell me if it prompts you to install when you click on the mysql pane. Link to comment Share on other sites More sharing options...
Mark K Posted July 8, 2008 Share Posted July 8, 2008 Installed Beta 4 Went to MySQL pane. It stated "MySQL is not installed... would you like to install it" I clicked yes <--- I remember seeing that before, so I guess it did ask me to install it earlier. --------------------------------------------- --------------------------------------------- --------------------------------------------- Download window pops up. "Current task: Downloading MySQL Step 1 of 7" Second pop box comes up saying "Apple Script Error Can’t make file (file "OSX:Applications:servebox:support_files:downloads:mysqlprog.txt") into type file. (-1700)" --------------------------------------------- --------------------------------------------- --------------------------------------------- I tried it a few times, still got the same error. Went looking around for the mysqlprog.txt file figuring maybe deleting it would fix the problem. But I could not find it quickly. Link to comment Share on other sites More sharing options...
skyhighmac Posted July 8, 2008 Author Share Posted July 8, 2008 Ok. That file is in the servebox/support_files/downloads folder. Try opening it up and deleting everything in it. Link to comment Share on other sites More sharing options...
Mark K Posted July 8, 2008 Share Posted July 8, 2008 Ok. That file is in the servebox/support_files/downloads folder. Try opening it up and deleting everything in it. The only folder/files in support_files folder is "php5". No "downloads" folder.... unless it is hidden. Link to comment Share on other sites More sharing options...
skyhighmac Posted July 8, 2008 Author Share Posted July 8, 2008 Oh. Thats weird. It should have been added in the beta2 update. Thats why it isn't working. Download this and place it in the support_files folder. Link to comment Share on other sites More sharing options...
Mark K Posted July 8, 2008 Share Posted July 8, 2008 Installing MySQL Step 7 of 7 AppleScript Error mkdir: /Applications/servebox/services/dbdata: File exists (1) I'm about to redownload the whole app from the link you PMed me, and start over again to see if that fixes the problem. Shouldn't take too long. Link to comment Share on other sites More sharing options...
skyhighmac Posted July 8, 2008 Author Share Posted July 8, 2008 That mkdir problem is fine. Everything will work fine now. Link to comment Share on other sites More sharing options...
Mark K Posted July 8, 2008 Share Posted July 8, 2008 That mkdir problem is fine. Everything will work fine now. I figured it should. The only reason I wanted to install it again was because I was also getting a error in PHPMyAdmin saying "#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)" I tried both install phpmyadmin via the serverbox admin panel, and a downloaded version. Both give me the same error message at the login prompt. Note: this error is shown at the webpage login prompt, I also tried the username/password but it did not work. Also on the bottom of the phpmyadmin login page it says "Cannot load mcrypt extension. Please check your PHP configuration." Not too sure if mcrypt is required for phpmyadmin to work, but that error message is also showing up. Note: I was getting the above with the "old" version I had on my computer and the "new" version I just installed. I also had to re-put the download folder in the support_files folder. And another note: I did not have to install beta 2 then beta 3 then beta 4 like i said earlier, it just installed the beta 4 update. Any yes, I did reinstall mysql via the panel. Link to comment Share on other sites More sharing options...
skyhighmac Posted July 8, 2008 Author Share Posted July 8, 2008 Ok. What does it say in the config file for phpmyadmin? It should be /tmp/mysql.sock for the socket, 3306 for the port. Link to comment Share on other sites More sharing options...
Mark K Posted July 8, 2008 Share Posted July 8, 2008 Ok. What does it say in the config file for phpmyadmin? It should be /tmp/mysql.sock for the socket, 3306 for the port. yep $cfg['Servers'][$i]['port'] = '3306'; $cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock'; Can you send me your mysql.sock file? I do not have that file in my tmp directory. Link to comment Share on other sites More sharing options...
skyhighmac Posted July 8, 2008 Author Share Posted July 8, 2008 And if mysql is started, then thats weird. All the files are there, right? It seems like the downloader isn't working. Link to comment Share on other sites More sharing options...
Mark K Posted July 8, 2008 Share Posted July 8, 2008 And if mysql is started, then thats weird. All the files are there, right? It seems like the downloader isn't working. I guess all the files are there.... I'm not too sure. Link to comment Share on other sites More sharing options...
skyhighmac Posted July 8, 2008 Author Share Posted July 8, 2008 There should be at least a few dozen. Is other mysql code working? Link to comment Share on other sites More sharing options...
Mark K Posted July 8, 2008 Share Posted July 8, 2008 There are MySQL files in the folder(s). I tried to run ./mysql via the command prompt but got the same error. "No mysql.sock file" error. Link to comment Share on other sites More sharing options...
~pcwiz Posted July 8, 2008 Share Posted July 8, 2008 That mkdir problem is fine. Everything will work fine now. To fix the mkdir problem you have to use Finder to see if a file exists, if it exists, to set a variable to 1, if the variable is 1, create the folder. Remember, if you ever need any help or have questions I'd be more than happy to assist After upgrading to beta 4 and installing the downloads folder into support_files, it prompted me to install MySQL so I clicked yes. Little Snitch prompted me to allow connections, I said OK, but the installer gave me "End of file error". Then I tried a couple more times and it finally got to step 5, however, there I got another "End of file error" because of LittleSnitch and now I don't get the install MySQL dialog anymore. Is there any way to force a reinstall of MySQL? EDIT: Putting Little Snitch aside, phpMyAdmin installation went painlessly Link to comment Share on other sites More sharing options...
skyhighmac Posted July 8, 2008 Author Share Posted July 8, 2008 yeah. I've got it to delay a second, so that the progress file could be created. I can't really fix the little snitch problem without making the delay longer and then the progress indicator is a waste of time. So, is phpmyadmin working for you? Link to comment Share on other sites More sharing options...
~pcwiz Posted July 8, 2008 Share Posted July 8, 2008 I think the MySQL installation was not complete so how do I force reinstall of MySQL? phpMyAdmin was successfully installed, but when I go to: http://localhost:81/phpmyadmin All I get is a directory index. Meaning that somehow PHP is not working, because if I go to index.php all I get is the text contents of index.php. Link to comment Share on other sites More sharing options...
skyhighmac Posted July 8, 2008 Author Share Posted July 8, 2008 how many files are listed there? Like ten? Link to comment Share on other sites More sharing options...
~pcwiz Posted July 8, 2008 Share Posted July 8, 2008 Index of /phpmyadmin Parent Directory .DS_Store CREDITS ChangeLog Documentation.html Documentation.txt INSTALL LICENSE README RELEASE-DATE-2.11.7 TODO browse_foreigners.php calendar.php changelog.php chk_rel.php config.inc.php config.sample.inc.php contrib/ db_create.php db_datadict.php db_export.php db_import.php db_operations.php db_printview.php db_qbe.php db_search.php db_sql.php db_structure.php docs.css error.php export.php favicon.ico import.php index.php js/ lang/ libraries/ license.php main.php navigation.php pdf_pages.php pdf_schema.php phpinfo.php phpmyadmin.css.php pmd/ pmd_common.php pmd_display_field.php pmd_general.php pmd_help.php pmd_pdf.php pmd_relation_new.php pmd_relation_upd.php pmd_save_pos.php print.css querywindow.php readme.php scripts/ server_binlog.php server_collations.php server_databases.php server_engines.php server_export.php server_import.php server_privileges.php server_processlist.php server_sql.php server_status.php server_variables.php show_config_errors.php sql.php tbl_addfield.php tbl_alter.php tbl_change.php tbl_create.php tbl_export.php tbl_import.php tbl_indexes.php tbl_move_copy.php tbl_operations.php tbl_printview.php tbl_relation.php tbl_replace.php tbl_row_action.php tbl_select.php tbl_sql.php tbl_structure.php test/ themes.php themes/ transformation_overview.php transformation_wrapper.php translators.html user_password.php view_create.php Link to comment Share on other sites More sharing options...
skyhighmac Posted July 8, 2008 Author Share Posted July 8, 2008 Ok. That looks like all of them. So it just shows the php text? Link to comment Share on other sites More sharing options...
~pcwiz Posted July 8, 2008 Share Posted July 8, 2008 Yeah, when I go to index.php this is what it shows: <?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * forms frameset * * @version $Id: index.php 10590 2007-09-02 19:59:59Z lem9 $ * @uses $GLOBALS['strNoFrames'] * @uses $GLOBALS['cfg']['QueryHistoryDB'] * @uses $GLOBALS['cfg']['Server']['user'] * @uses $GLOBALS['cfg']['DefaultTabServer'] as src for the mainframe * @uses $GLOBALS['cfg']['DefaultTabDatabase'] as src for the mainframe * @uses $GLOBALS['cfg']['NaviWidth'] for navi frame width * @uses $GLOBALS['collation_connection'] from $_REQUEST (grab_globals.lib.php) * or common.inc.php * @uses $GLOBALS['available_languages'] from common.inc.php (select_lang.lib.php) * @uses $GLOBALS['db'] * @uses $GLOBALS['charset'] * @uses $GLOBALS['lang'] * @uses $GLOBALS['text_dir'] * @uses $_ENV['HTTP_HOST'] * @uses PMA_getRelationsParam() * @uses PMA_purgeHistory() * @uses PMA_generate_common_url() * @uses PMA_VERSION * @uses session_write_close() * @uses time() * @uses PMA_getenv() * @uses header() to send charset */ /** * Gets core libraries and defines some variables */ require_once './libraries/common.inc.php'; /** * Includes the ThemeManager if it hasn't been included yet */ require_once './libraries/relation.lib.php'; // free the session file, for the other frames to be loaded session_write_close(); // Gets the host name // loic1 - 2001/25/11: use the new globals arrays defined with php 4.1+ if (empty($HTTP_HOST)) { if (PMA_getenv('HTTP_HOST')) { $HTTP_HOST = PMA_getenv('HTTP_HOST'); } else { $HTTP_HOST = ''; } } // purge querywindow history $cfgRelation = PMA_getRelationsParam(); if ($GLOBALS['cfg']['QueryHistoryDB'] && $cfgRelation['historywork']) { PMA_purgeHistory($GLOBALS['cfg']['Server']['user']); } unset($cfgRelation); /** * pass variables to child pages */ $drops = array('lang', 'server', 'convcharset', 'collation_connection', 'db', 'table'); foreach ($drops as $each_drop) { if (! array_key_exists($each_drop, $_GET)) { unset($_GET[$each_drop]); } } unset($drops, $each_drop); if (! strlen($GLOBALS['db'])) { $main_target = $GLOBALS['cfg']['DefaultTabServer']; } elseif (! strlen($GLOBALS['table'])) { $_GET['db'] = $GLOBALS['db']; $main_target = $GLOBALS['cfg']['DefaultTabDatabase']; } else { $_GET['db'] = $GLOBALS['db']; $_GET['table'] = $GLOBALS['table']; $main_target = $GLOBALS['cfg']['DefaultTabTable']; } $url_query = PMA_generate_common_url($_GET); if (isset($GLOBALS['target']) && is_string($GLOBALS['target']) && !empty($GLOBALS['target']) && in_array($GLOBALS['target'], $goto_whitelist)) { $main_target = $GLOBALS['target']; } $main_target .= $url_query; $lang_iso_code = $GLOBALS['available_languages'][$GLOBALS['lang']][2]; // start output header('Content-Type: text/html; charset=' . $GLOBALS['charset']); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<?php echo $lang_iso_code; ?>" lang="<?php echo $lang_iso_code; ?>" dir="<?php echo $GLOBALS['text_dir']; ?>"> <head> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <title>phpMyAdmin <?php echo PMA_VERSION; ?> - <?php echo htmlspecialchars($HTTP_HOST); ?></title> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo $GLOBALS['charset']; ?>" /> <script type="text/javascript"> // <![CDATA[ // definitions used in querywindow.js var common_query = '<?php echo PMA_escapeJsString(PMA_generate_common_url('', '', '&'));?>'; var opendb_url = '<?php echo PMA_escapeJsString($GLOBALS['cfg']['DefaultTabDatabase']); ?>'; var safari_browser = <?php echo PMA_USR_BROWSER_AGENT == 'SAFARI' ? 'true' : 'false' ?>; var querywindow_height = <?php echo PMA_escapeJsString($GLOBALS['cfg']['QueryWindowHeight']); ?>; var querywindow_width = <?php echo PMA_escapeJsString($GLOBALS['cfg']['QueryWindowWidth']); ?>; var collation_connection = '<?php echo PMA_escapeJsString($GLOBALS['collation_connection']); ?>'; var lang = '<?php echo PMA_escapeJsString($GLOBALS['lang']); ?>'; var server = '<?php echo PMA_escapeJsString($GLOBALS['server']); ?>'; var table = '<?php echo PMA_escapeJsString($GLOBALS['table']); ?>'; var db = '<?php echo PMA_escapeJsString($GLOBALS['db']); ?>'; var text_dir = '<?php echo PMA_escapeJsString($GLOBALS['text_dir']); ?>'; var pma_absolute_uri = '<?php echo PMA_escapeJsString($GLOBALS['cfg']['PmaAbsoluteUri']); ?>'; // for content and navigation frames var frame_content = 0; var frame_navigation = 0; function getFrames() { <?php if ($GLOBALS['text_dir'] === 'ltr') { ?> frame_content = window.frames[1]; frame_navigation = window.frames[0]; <?php } else { ?> frame_content = window.frames[0]; frame_navigation = window.frames[1]; <?php } ?> } var onloadCnt = 0; var onLoadHandler = window.onload; window.onload = function() { if (onloadCnt == 0) { if (typeof(onLoadHandler) == "function") { onLoadHandler(); } if (typeof(getFrames) != 'undefined' && typeof(getFrames) == 'function') { getFrames(); } onloadCnt++; } }; // ]]> </script> <script src="./js/querywindow.js" type="text/javascript"></script> </head> <frameset cols="<?php if ($GLOBALS['text_dir'] === 'rtl') { echo '*,'; } echo $GLOBALS['cfg']['NaviWidth']; if ($GLOBALS['text_dir'] === 'ltr') { echo ',*'; } ?>" rows="*" id="mainFrameset"> <?php if ($GLOBALS['text_dir'] === 'ltr') { ?> <frame frameborder="0" id="frame_navigation" src="navigation.php<?php echo $url_query; ?>" name="frame_navigation" /> <?php } ?> <frame frameborder="0" id="frame_content" src="<?php echo $main_target; ?>" name="frame_content" /> <?php if ($GLOBALS['text_dir'] === 'rtl') { ?> <frame frameborder="0" id="frame_navigation" src="navigation.php<?php echo $url_query; ?>" name="frame_navigation" /> <?php } ?> <noframes> <body> <p><?php echo $GLOBALS['strNoFrames']; ?></p> </body> </noframes> </frameset> </html> AFAIK this only happens when PHP is not installed, or when its not communicating right with Apache... Link to comment Share on other sites More sharing options...
skyhighmac Posted July 8, 2008 Author Share Posted July 8, 2008 Yeah. These problems are caused by sparkle not updating the files other than the app. I am going to release a full version of beta5, today, and then I will have you guys dl it, and that will include fixes (for one reason, sparkle didn't update your httpd.conf file) Link to comment Share on other sites More sharing options...
~pcwiz Posted July 8, 2008 Share Posted July 8, 2008 Yeah. These problems are caused by sparkle not updating the files other than the app. I am going to release a full version of beta5, today, and then I will have you guys dl it, and that will include fixes (for one reason, sparkle didn't update your httpd.conf file) Did you know that Sparkle 1.5b4 is released? I think you are using b1...anyways, Sparkle 1.5 has the ability to install pkg files, so maybe put everything into an installer package using PackageMaker and then set Sparkle to install that. The size will be auto compressed by PackageMaker too, so small update sizes is another advantage. If you want, I can make an installer package for you. Just send me the files and I'll whip them up into a quick package. Also, please can you tell me how to manually force a reinstall of MySQL through servebox? My MySQL installation wasn't complete due to Little Snitch interrupting. Link to comment Share on other sites More sharing options...
skyhighmac Posted July 8, 2008 Author Share Posted July 8, 2008 I've got b4 in it. I know how to make an installer package, just don't know how to tell sparkle how to install it. Thanks for the offer. To force a reinstall, delete the dbdate folder in the services folder, and the mysql folder in the /services/Library folder. Then servebox will detect that it isn't there and prrompt you to install it. Also, Would you prefer a seperate app for managing the updates of the services (apache, php, etc.) or have it all rolled into servebox? Link to comment Share on other sites More sharing options...
~pcwiz Posted July 8, 2008 Share Posted July 8, 2008 Just roll it into servebox, much more convenient Link to comment Share on other sites More sharing options...
Recommended Posts