Announcement

Collapse
No announcement yet.

7.5.5 update fails on OpenSuse 11.4

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    #16
    How do I fix my installation?

    How do I get your GD to work?

    Comment


      #17
      Run ./buildme.sh GD in a checkout of http://svn.slimdevices.com/repos/sli...nk/vendor/CPAN

      Then copy everything under build/arch to your SBS CPAN/arch directory.

      If the build script fails, please paste the error output.

      Comment


        #18
        That is what I did

        I carefully followed the instructions in http://forums.slimdevices.com/showthread.php?t=88250, as I noted in my posts. The build worked once I installed nasm and libjpeg62. But I still got the GD error. Send me your e-mail;, and I will zip it up and send it to you. See above.

        Oh, that instruction did 7.6....

        Jim
        Last edited by jarome; 2011-07-13, 23:36.

        Comment


          #19
          tried it with te 7.5 build and buildme.sh failed

          < const char* cmd, int cmd_len);
          < int mysql_manager_fetch_line(MYSQL_MANAGER* con,
          < char* res_buf,
          < int res_buf_size);
          < my_bool mysql_read_query_result(MYSQL *mysql);
          < enum enum_mysql_stmt_state
          < {
          < MYSQL_STMT_INIT_DONE= 1, MYSQL_STMT_PREPARE_DONE, MYSQL_STMT_EXECUTE_DONE,
          < MYSQL_STMT_FETCH_DONE
          < };
          < typedef struct st_mysql_bind
          < {
          < unsigned long *length;
          < my_bool *is_null;
          < void *buffer;
          < my_bool *error;
          < unsigned char *row_ptr;
          < void (*store_param_func)(NET *net, struct st_mysql_bind *param);
          < void (*fetch_result)(struct st_mysql_bind *, MYSQL_FIELD *,
          < unsigned char **row);
          < void (*skip_result)(struct st_mysql_bind *, MYSQL_FIELD *,
          < unsigned char **row);
          < unsigned long buffer_length;
          < unsigned long offset;
          < unsigned long length_value;
          < unsigned int param_number;
          < unsigned int pack_length;
          < enum enum_field_types buffer_type;
          < my_bool error_value;
          < my_bool is_unsigned;
          < my_bool long_data_used;
          < my_bool is_null_value;
          < void *extension;
          < } MYSQL_BIND;
          < typedef struct st_mysql_stmt
          < {
          < MEM_ROOT mem_root;
          < LIST list;
          < MYSQL *mysql;
          < MYSQL_BIND *params;
          < MYSQL_BIND *bind;
          < MYSQL_FIELD *fields;
          < MYSQL_DATA result;
          < MYSQL_ROWS *data_cursor;
          < int (*read_row_func)(struct st_mysql_stmt *stmt,
          < unsigned char **row);
          < my_ulonglong affected_rows;
          < my_ulonglong insert_id;
          < unsigned long stmt_id;
          < unsigned long flags;
          < unsigned long prefetch_rows;
          < unsigned int server_status;
          < unsigned int last_errno;
          < unsigned int param_count;
          < unsigned int field_count;
          < enum enum_mysql_stmt_state state;
          < char last_error[512];
          < char sqlstate[5 +1];
          < my_bool send_types_to_server;
          < my_bool bind_param_done;
          < unsigned char bind_result_done;
          < my_bool unbuffered_fetch_cancelled;
          < my_bool update_max_length;
          < void *extension;
          < } MYSQL_STMT;
          < enum enum_stmt_attr_type
          < {
          < STMT_ATTR_UPDATE_MAX_LENGTH,
          < STMT_ATTR_CURSOR_TYPE,
          < STMT_ATTR_PREFETCH_ROWS
          < };
          < typedef struct st_mysql_methods
          < {
          < my_bool (*read_query_result)(MYSQL *mysql);
          < my_bool (*advanced_command)(MYSQL *mysql,
          < enum enum_server_command command,
          < const unsigned char *header,
          < unsigned long header_length,
          < const unsigned char *arg,
          < unsigned long arg_length,
          < my_bool skip_check,
          < MYSQL_STMT *stmt);
          < MYSQL_DATA *(*read_rows)(MYSQL *mysql,MYSQL_FIELD *mysql_fields,
          < unsigned int fields);
          < MYSQL_RES * (*use_result)(MYSQL *mysql);
          < void (*fetch_lengths)(unsigned long *to,
          < MYSQL_ROW column, unsigned int field_count);
          < void (*flush_use_result)(MYSQL *mysql);
          < MYSQL_FIELD * (*list_fields)(MYSQL *mysql);
          < my_bool (*read_prepare_result)(MYSQL *mysql, MYSQL_STMT *stmt);
          < int (*stmt_execute)(MYSQL_STMT *stmt);
          < int (*read_binary_rows)(MYSQL_STMT *stmt);
          < int (*unbuffered_fetch)(MYSQL *mysql, char **row);
          < void (*free_embedded_thd)(MYSQL *mysql);
          < const char *(*read_statistics)(MYSQL *mysql);
          < my_bool (*next_result)(MYSQL *mysql);
          < int (*read_change_user_result)(MYSQL *mysql, char *buff, const char *passwd);
          < int (*read_rows_from_cursor)(MYSQL_STMT *stmt);
          < } MYSQL_METHODS;
          < MYSQL_STMT * mysql_stmt_init(MYSQL *mysql);
          < int mysql_stmt_prepare(MYSQL_STMT *stmt, const char *query,
          < unsigned long length);
          < int mysql_stmt_execute(MYSQL_STMT *stmt);
          < int mysql_stmt_fetch(MYSQL_STMT *stmt);
          < int mysql_stmt_fetch_column(MYSQL_STMT *stmt, MYSQL_BIND *bind_arg,
          < unsigned int column,
          < unsigned long offset);
          < int mysql_stmt_store_result(MYSQL_STMT *stmt);
          < unsigned long mysql_stmt_param_count(MYSQL_STMT * stmt);
          < my_bool mysql_stmt_attr_set(MYSQL_STMT *stmt,
          < enum enum_stmt_attr_type attr_type,
          < const void *attr);
          < my_bool mysql_stmt_attr_get(MYSQL_STMT *stmt,
          < enum enum_stmt_attr_type attr_type,
          < void *attr);
          < my_bool mysql_stmt_bind_param(MYSQL_STMT * stmt, MYSQL_BIND * bnd);
          < my_bool mysql_stmt_bind_result(MYSQL_STMT * stmt, MYSQL_BIND * bnd);
          < my_bool mysql_stmt_close(MYSQL_STMT * stmt);
          < my_bool mysql_stmt_reset(MYSQL_STMT * stmt);
          < my_bool mysql_stmt_free_result(MYSQL_STMT *stmt);
          < my_bool mysql_stmt_send_long_data(MYSQL_STMT *stmt,
          < unsigned int param_number,
          < const char *data,
          < unsigned long length);
          < MYSQL_RES * mysql_stmt_result_metadata(MYSQL_STMT *stmt);
          < MYSQL_RES * mysql_stmt_param_metadata(MYSQL_STMT *stmt);
          < unsigned int mysql_stmt_errno(MYSQL_STMT * stmt);
          < const char * mysql_stmt_error(MYSQL_STMT * stmt);
          < const char * mysql_stmt_sqlstate(MYSQL_STMT * stmt);
          < MYSQL_ROW_OFFSET mysql_stmt_row_seek(MYSQL_STMT *stmt,
          < MYSQL_ROW_OFFSET offset);
          < MYSQL_ROW_OFFSET mysql_stmt_row_tell(MYSQL_STMT *stmt);
          < void mysql_stmt_data_seek(MYSQL_STMT *stmt, my_ulonglong offset);
          < my_ulonglong mysql_stmt_num_rows(MYSQL_STMT *stmt);
          < my_ulonglong mysql_stmt_affected_rows(MYSQL_STMT *stmt);
          < my_ulonglong mysql_stmt_insert_id(MYSQL_STMT *stmt);
          < unsigned int mysql_stmt_field_count(MYSQL_STMT *stmt);
          < my_bool mysql_commit(MYSQL * mysql);
          < my_bool mysql_rollback(MYSQL * mysql);
          < my_bool mysql_autocommit(MYSQL * mysql, my_bool auto_mode);
          < my_bool mysql_more_results(MYSQL *mysql);
          < int mysql_next_result(MYSQL *mysql);
          < void mysql_close(MYSQL *sock);
          make[2]: *** [do_abi_check] Error 1
          make[2]: Leaving directory `/home/jar/perl/CPAN/mysql-5.1.37'
          make[1]: *** [abi_check] Error 2
          make[1]: Leaving directory `/home/jar/perl/CPAN/mysql-5.1.37'
          make: *** [all-recursive] Error 1
          make failed

          Comment


            #20
            Very strange...

            It is 7.5.5 that is running.
            I used
            wget -r -l1 --no-parent -nH --cut-dirs=5 http://svn.slimdevices.com/repos/sli...k/vendor/CPAN/
            to build it the first time. The 7.5 version does not work...

            Comment


              #21
              Try editing buildme.sh and comment out line 196:

              # build DBD::mysql

              After doing this, I was able to get everything else to build on Fedora 14.

              Comment


                #22
                That worked!

                Thanks.

                Given the lack of QA, it would be better for there to be good manual build instructions on the mysqueezebox.com site than rpms that cause grief.

                Comment


                  #23
                  Originally posted by Ron Olsen View Post
                  Try editing buildme.sh and comment out line 196:

                  # build DBD::mysql

                  After doing this, I was able to get everything else to build on Fedora 14.
                  For me it seems to be some sort of catch 22 with this. I can surely build everything if I comment out mysql build but then the server won't start because failed load of DBI::mysql module...

                  What next to do?

                  /Anders

                  Comment


                    #24
                    Originally posted by falolaf View Post
                    For me it seems to be some sort of catch 22 with this. I can surely build everything if I comment out mysql build but then the server won't start because failed load of DBI::mysql module...

                    What next to do?

                    /Anders
                    Use the DBI::mysql module from SBS 7.5.4 and see if that works.
                    Last edited by Ron Olsen; 2011-07-14, 10:16.

                    Comment


                      #25
                      Originally posted by Ron Olsen View Post
                      Use the DBI::mysql module from SBS 7.5.4 and see if that works.
                      That didn't work.

                      Comment


                        #26
                        Install the module...

                        Try
                        cpan -i DBI::mysql

                        Comment


                          #27
                          Originally posted by jarome View Post
                          Try
                          cpan -i DBI::mysql
                          In what folder?

                          Comment


                            #28
                            That installs it

                            It goes automatically where your other perl modules are. You need to be root or sudo to do it.

                            Comment


                              #29
                              Originally posted by jarome View Post
                              It goes automatically where your other perl modules are. You need to be root or sudo to do it.
                              Warning: Cannot install DBI::mysql, don't know what it is.
                              Try the command

                              i /DBI::mysql/

                              to find objects with matching identifiers.

                              Comment


                                #30
                                Can't update database

                                With the MySQL build commented out, the database does not get updated. I just asked it to delete the database and rescan everything, but nothing happens. Scanner.log has not been updated for 2 days. Server.log has:
                                [11-07-14 17:14:35.5071] Plugins::LazySearch2::Plugin::scanDoneCallback (2066) Lazifying database items not already done
                                [11-07-14 17:14:35.6989] Plugins::LazySearch2::Plugin::lazifyDatabase (2123) No database items require lazification
                                [11-07-14 17:14:36.9779] Plugins::AutoRescan::Plugin::delayedChangeCallback (314) Triggering database rescan following directory changes
                                [11-07-14 17:14:47.1417] Plugins::LazySearch2::Plugin::scanDoneCallback (2066) Lazifying database items not already done
                                [11-07-14 17:14:47.3329] Plugins::LazySearch2::Plugin::lazifyDatabase (2123) No database items require lazification
                                [11-07-14 22:22:32.9748] Plugins::LazySearch2::Plugin::scanDoneCallback (2066) Lazifying database items not already done
                                [11-07-14 22:22:33.1674] Plugins::LazySearch2::Plugin::lazifyDatabase (2123) No database items require lazification
                                [11-07-14 22:26:50.2388] Plugins::LazySearch2::Plugin::scanDoneCallback (2066) Lazifying database items not already done
                                [11-07-14 22:26:50.4327] Plugins::LazySearch2::Plugin::lazifyDatabase (2123) No database items require lazification
                                [11-07-14 22:28:22.0812] Slim::Plugin::AudioScrobbler::Plugin::_handshakeOK (348) Invalid Last.fm username or password.
                                [11-07-14 22:28:32.1520] Slim::Plugin::AudioScrobbler::Plugin::_handshakeOK (348) Invalid Last.fm username or password.
                                [11-07-14 22:30:15.5909] Plugins::LazySearch2::Plugin::scanDoneCallback (2066) Lazifying database items not already done
                                [11-07-14 22:30:15.7797] Plugins::LazySearch2::Plugin::lazifyDatabase (2123) No database items require lazification
                                [11-07-14 22:33:13.3738] Plugins::LazySearch2::Plugin::scanDoneCallback (2066) Lazifying database items not already done
                                [11-07-14 22:33:13.5634] Plugins::LazySearch2::Plugin::lazifyDatabase (2123) No database items require lazification

                                The Web interface says "Progress information from the previous scan is not available."

                                So things are still not working. We need a proper build.

                                MySQL Build log:

                                < my_bool mysql_stmt_send_long_data(MYSQL_STMT *stmt,
                                < unsigned int param_number,
                                < const char *data,
                                < unsigned long length);
                                < MYSQL_RES * mysql_stmt_result_metadata(MYSQL_STMT *stmt);
                                < MYSQL_RES * mysql_stmt_param_metadata(MYSQL_STMT *stmt);
                                < unsigned int mysql_stmt_errno(MYSQL_STMT * stmt);
                                < const char * mysql_stmt_error(MYSQL_STMT * stmt);
                                < const char * mysql_stmt_sqlstate(MYSQL_STMT * stmt);
                                < MYSQL_ROW_OFFSET mysql_stmt_row_seek(MYSQL_STMT *stmt,
                                < MYSQL_ROW_OFFSET offset);
                                < MYSQL_ROW_OFFSET mysql_stmt_row_tell(MYSQL_STMT *stmt);
                                < void mysql_stmt_data_seek(MYSQL_STMT *stmt, my_ulonglong offset);
                                < my_ulonglong mysql_stmt_num_rows(MYSQL_STMT *stmt);
                                < my_ulonglong mysql_stmt_affected_rows(MYSQL_STMT *stmt);
                                < my_ulonglong mysql_stmt_insert_id(MYSQL_STMT *stmt);
                                < unsigned int mysql_stmt_field_count(MYSQL_STMT *stmt);
                                < my_bool mysql_commit(MYSQL * mysql);
                                < my_bool mysql_rollback(MYSQL * mysql);
                                < my_bool mysql_autocommit(MYSQL * mysql, my_bool auto_mode);
                                < my_bool mysql_more_results(MYSQL *mysql);
                                < int mysql_next_result(MYSQL *mysql);
                                < void mysql_close(MYSQL *sock);
                                make[2]: *** [do_abi_check] Error 1
                                make[2]: Leaving directory `/home/jar/perl/CPAN/mysql-5.1.37'
                                make[1]: *** [abi_check] Error 2
                                make[1]: Leaving directory `/home/jar/perl/CPAN/mysql-5.1.37'
                                make: *** [all-recursive] Error 1
                                make failed
                                [1]+ Done
                                Last edited by jarome; 2011-07-15, 17:54.

                                Comment

                                Working...
                                X