vicidial.org

Hi Team,

So far my test Install is slowly progressing. I have reached in Based install guide, successfully created Database and tables (Phase 4).

I am stuck in a point, i couldnt a find a file 'first_server_install.sql' under 'astguiclient' subfolders. I am missing 'ADMIN_update_server_ip.pl' & 'ADMIN_area_code_populate.pl' as well.

Also other two files, 'MySQL_AST_CREATE_tables.sql' & 'sip-iax_phones.sql' were actually located under '/usr/src/astguiclient/extras#' path, not exactly as mentioned in base install guide.

no directory 'extras' avaiable under '/usr/src/astguiclient/agc_2.0.4#', instead this folder is restructured to '/usr/src/astguiclient/extras/'. I dunno.

I have explained all these just to know if i missed anything while installing astguiclient. Or is it a new development with 2.0.4.1 that those files are no more needed.

I am currently Stuck @ the point of changing IP address.

OS : Slackware 12.0
Asterisk : 1.2.27
zaptel:1.2.24
mysql : 5.0.51a
apache:2.0.61
astguiclient : 2.0.4.1

Any idea?

Regards

Kondela

what is the exact version of 2.0.4.1 that you downloaded?

try this:
locate -u
locate first_server_install.sql

this one should also be located inthe extras folder.

first off download version astguiclient_2.0.4.1rc2 from here : http://sourceforge.net/project/showfile ... _id=558786

/usr/src/astguiclient_2.0.4.1rc2/docs : you will find a recent copy of scratch_install.
/usr/src/astguiclient_2.0.4.1rc2/extras : all files needed
/usr/src/astguiclient_2.0.4.1rc2/bin : perl executables

( I am missing 'ADMIN_update_server_ip.pl' & 'ADMIN_area_code_populate.pl' as well.)

try downloading the the 2.0.4rc2 file again

and install again



thats rare

thats rare

Matt,

I tried that search even before i post this in the forum. Those files are not avaialable anywhere in my server.

So this proves that i have to redo it.. do you recommend going for a 2.0.4.1rc2 with asterisk 1.2.27 and mysql 5.0.51a..?

Any known issues,..?

Or else can i solve this problem with current install..?

Regards

Kondela

I would recommend 2.0.4.1rc2 Asterisk 1.2.27 and MySQL 5.0.45, I haven't tried MySQL 5.0.51a.

Hi Team,

Again i started with mysql 5.0.45, asterisk 1.2.27, slackware 12.0. finshed with the required apps, came across the same base install guide, this time downloaded and installed astguiclient, but could'nt start my sql server or client. following is the message when i tried :

root@Astkeve2:~# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (40)

when i tried "/usr/local/mysql/bin/mysql" i got the same error message. I have double checked this line (ln -s /tmp/mysql.sock /var/run/mysql/mysql.sock) while doing mysql installation. In fact, i have double checked mysql is working while i was in the final step of 'required_apps_install'... after this @ some point of other installations (i dunno what?) mysql fails and /tmp/mysql.sock dis appears.. any idea.

BTW, this is second time happening to me, so i jdid re-installation from scratch (carefully), but result is the same. I am just posting this for forum, some one might have faced the same.

Regards

Kondela

Did you have any errors when installing MySQL?

What is the exact error in the mysql error file?

nothing special, everything was very much normal. I have double checked MYSQL is running (becase of my previos experience) during the installation of REQUIRED_APPS_INSTALL. I have verified this just before the Apache installation.

This is how my Mysql error file look like :


080529 22:32:38 mysqld started
nohup: ignoring input
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
080529 22:32:38 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080529 22:32:39 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
080529 22:32:39 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080529 22:32:39 InnoDB: Started; log sequence number 0 0
080529 22:32:39 [Warning] 'user' entry 'root@Astkeve2' ignored in --skip-name-resolve mode.
080529 22:32:39 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution

Status information:

Current dir: /usr/local/mysql/var/
Running threads: 0 Stack size: 196608
Current locks:
lock: 0x89beec8:

#####some lock entries are truncated#######

Key caches:
default
Buffer_size: 402653184
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 2
not flushed: 0
w_requests: 20
writes: 19
r_requests: 20
reads: 9


handler status:
read_key: 19
read_next: 0
read_rnd 3
read_first: 21
write: 542
delete 3
update: 2

Table status:
Opened tables: 95
Open tables: 17
Open files: 36
Open files: 36
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 1
Next alarm time: 0
080530 3:24:51 [Warning] 'user' entry 'root@Astkeve2' ignored in --skip-name-resolve mode.
080531 20:29:01 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

080531 20:29:01 InnoDB: Starting shutdown...
080531 20:29:03 InnoDB: Shutdown completed; log sequence number 0 53075
080531 20:29:03 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete


Memory status:
Non-mmapped space allocated from system: 4817712
Number of free chunks: 21
Number of fastbin blocks: 0
Number of mmapped regions: 11
Space in mmapped regions: 449851392
Maximum total allocated space: 0
Space available in freed fastbin blocks: 0
Total allocated space: 4353384
Total free space: 464328
Top-most, releasable space: 140240
Estimated memory (with thread stack): 454669104

080531 20:29:03 mysqld ended

additionally, thi is what i recieved when tried to run ' ln -s /tmp/mysql.sock /var/run/mysql/mysql.sock'


ln: accessing `/var/run/mysql/mysql.sock': Too many levels of symbolic links


kondela

That's a new one, do a 'locate mysql.sock' and see what you get, and find the original one.

I have found the original one in '/var/run/mysql/mysql.sock' .. can i edit my.cnf and point the socket to this path.?

because, as u see, i am unable to create this link to /tmp/mysql.sock..

Kondela

You should try it, but you will have to restart mysql. At this point I have not heard of the problems you are having, so please let us know how it goes.

just to update on the issue of MYSQL,

1) i didn't edit my.cnf. Left as it is.
2) i just did this line again "/usr/local/mysql/bin/mysqld_safe --user=mysql --skip-name-resolve --skip-host-cache &"
3) applied this line again "/usr/local/apache2/bin/apachectl startssl"

eveything works fine. though i didn't get time to test inbound/outbound all the web pages are up, database works fine.

Regards

Kondela