2010-10-19 22:32:10
ATutor cannot create some MySQL tables on FreeBSD
Hi Folks,
I've done ATutor 1.6.x Installation without any problem on CentOS/CPanel based VPS nearly 2 Years ago.
Now I have an FreeBSD VPS that managed from Terminal.
After two days I'm still struggling on and it's not possible to pass step 3 of the installation process.
As you can see in the "Copies of error messages -"
section, some tables created just fine but the creation of some of them failed with absolutely no luck, no matter how many times you're trying.
This is the procedure that I've gone to create the needed database and username in mysql-client. (I also tried root user without any significant chance.)
use mysql;
INSERT INTO user (Host,User,Password) VALUES('localhost','atuser',PASSWORD('atpassword'));
flush privileges;
grant usage on *.* to atuser@localhost identified by 'atpassword';
flush privileges;
grant all privileges on atutor.* to atuser@localhost;
flush privileges;
Operating system ATutor is installed on - FreeBSD
ATutor version - 2.0
Patch #s applied -
ATutor theme name - Default
PHP version - 5.3.2
MySQL version - 5.5.4-m3
Webserver & version - FreeBSD 8.1-RELEASE GENERIC i386
Copies of error messages -
Feedback
Database atutor created successfully.
Connected to database atutor successfully.
Table AT_feeds created successfully.
Table AT_patches created successfully.
Table AT_patches_files created successfully.
Table AT_patches_files_actions created successfully.
Table AT_myown_patches created successfully.
Table AT_myown_patches_dependent created successfully.
Table AT_myown_patches_files created successfully.
Table AT_auto_enroll created successfully.
Table AT_auto_enroll_courses created successfully.
Table AT_grade_scales created successfully.
Table AT_grade_scales_detail created successfully.
Table AT_gradebook_tests created successfully.
Table AT_gradebook_detail created successfully.
Table AT_fha_student_tools created successfully.
Table AT_social_activities created successfully.
Table AT_social_applications created successfully.
Table AT_social_application_settings created successfully.
Table AT_social_members_applications created successfully.
Table AT_social_friends created successfully.
Table AT_social_friend_requests created successfully.
Table AT_social_member_position created successfully.
Table AT_social_member_education created successfully.
Table AT_social_member_websites created successfully.
Table AT_social_member_track created successfully.
Table AT_social_member_additional_information created successfully.
Table AT_social_member_contact created successfully.
Table AT_social_member_representation created successfully.
Table AT_social_member_personal created successfully.
Table AT_social_privacy_preferences created successfully.
Table AT_social_groups created successfully.
Table AT_social_groups_activities created successfully.
Table AT_social_groups_members created successfully.
Table AT_social_groups_invitations created successfully.
Table AT_social_groups_requests created successfully.
Table AT_social_groups_types created successfully.
Table AT_social_groups_board created successfully.
Table AT_social_user_settings created successfully.
Table AT_member_login_attempt created successfully.
Table AT_pa_albums created successfully.
Table AT_pa_photos created successfully.
Table AT_pa_course_album created successfully.
Table AT_pa_album_comments created successfully.
Table AT_pa_photo_comments created successfully.
Error
Table AT_admins creation failed.
Table AT_admin_log creation failed.
Table AT_assignments creation failed.
Table AT_backups creation failed.
Table AT_blog_posts creation failed.
Table AT_blog_posts_comments creation failed.
Table AT_config creation failed.
Table AT_content creation failed.
Table AT_course_access creation failed.
Table AT_course_cats creation failed.
Table AT_content_tests_assoc creation failed.
Table AT_content_forums_assoc creation failed.
Table AT_course_enrollment creation failed.
Table AT_course_stats creation failed.
Table AT_courses creation failed.
Table AT_faq_topics creation failed.
Table AT_faq_entries creation failed.
Table AT_file_storage_groups creation failed.
Table AT_files creation failed.
Table AT_files_comments creation failed.
Table AT_folders creation failed.
Table AT_forums creation failed.
Table AT_forums_accessed creation failed.
Table AT_forums_courses creation failed.
Table AT_forums_groups creation failed.
Table AT_forums_subscriptions creation failed.
Table AT_forums_threads creation failed.
Table AT_glossary creation failed.
Table AT_groups creation failed.
Table AT_groups_members creation failed.
Table AT_groups_types creation failed.
Table AT_guests creation failed.
Table AT_handbook_notes creation failed.
Table AT_instructor_approvals creation failed.
Table AT_languages creation failed.
Table AT_links_categories creation failed.
Table AT_links creation failed.
Table AT_language_pages creation failed.
Table AT_master_list creation failed.
Table AT_members creation failed.
Table AT_member_track creation failed.
Table AT_messages creation failed.
Table AT_messages_sent creation failed.
Table AT_modules creation failed.
Table AT_news creation failed.
Table AT_polls creation failed.
Table AT_mail_queue creation failed.
Table AT_polls_members creation failed.
Table AT_related_content creation failed.
Table AT_reading_list creation failed.
Table AT_external_resources creation failed.
Table AT_tests creation failed.
Table AT_tests_answers creation failed.
Table AT_tests_groups creation failed.
Table AT_tests_questions creation failed.
Table AT_tests_questions_assoc creation failed.
Table AT_tests_questions_categories creation failed.
Table AT_tests_results creation failed.
Table AT_themes creation failed.
Table AT_users_online creation failed.
Table AT_primary_resources creation failed.
Table AT_primary_resources_types creation failed.
Table AT_resource_types creation failed.
Table AT_secondary_resources creation failed.
Table AT_secondary_resources_types creation failed.
Table AT_blog_subscription creation failed.
Table AT_content_prerequisites creation failed.
Table AT_oauth_client_servers creation failed.
Table AT_oauth_client_tokens creation failed.
Table AT_language_text creation failed.
Changes to default settings -
Web browser being used -
Mozilla/5.0 (X11; U; Linux i686; en-US) AppleWebKit/534.3 (KHTML, like Gecko) Iron/6.0.475.1 Chrome/6.0.475.1 Safari/534.3
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.9) Gecko/20101014 Gentoo Firefox/3.6.9
...and anything else relevant -
:( :( :( :( :(